Creating Extended Dimension Applications

Financial Consolidation and Close supports the creation of up to a total of four Custom dimensions (or three Custom dimensions and one Multi-GAAP dimension). Following are the considerations that should be taken into account while creating applications in an Extended Dimensionality environment.

You create an Extended Dimension application and other related artifacts in the same way that you create a non-Extended Dimension application. However, you must make some changes for the below-listed dimensions when operating in an Extended Dimension environment.

Custom Dimensions

  • The default members that are created in Custom dimensions are exactly the same as in a non-Extended Dimension application, except that the "Total Custom" member is now "Dynamic Calc" instead of "Never Share".

  • Any new parent members that you create in these Custom dimensions must use the Data Storage property of "Dynamic Calc". This is the only difference and change from the non-Extended Dimension application, where Custom parent dimensions are created as "Never Share".

Multi-GAAP Dimension

  • The default Multi-GAAP hierarchy that is created by the application now follows the same paradigm as the Custom dimensions. The Data Storage property for Parent members will be "Dynamic Calc".

  • Any new Multi-GAAP hierarchy that you create should follow the same paradigm.

Intercompany Dimension

The FCCS_Intercompany Entities parent member is now created as a "Dynamic Calc" member. You do not need to make any changes to this dimension.

Creating an Extended Dimensionality Application Using Artifacts from Existing Applications

Create a New Application

Create a new Extended Dimensionality application with the required features and Custom dimensions as your non-Extended Dimensionality application, and add the additional Custom dimensions. See Application Feature Descriptions.

Note:

You must create a new application using the Application Wizard. You cannot use a Migration snapshot to create the application.

During the creation of the Extended Dimension application, all of the Custom Dimension attributes and properties that you select must match the non-Extended Dimension application.

These include:

  • Application Name
  • Dimension Properties

To access the non-Extended Dimension application dimension properties, on the Home page, click the Navigator icon, then select Application, Configuration, and select Enable Features.

Metadata

From the non-Extended Dimension application, export the metadata for each of the dimension that have user-defined members (Scenario, Entity, Account, Movement, Data Source, Multi-GAAP, Custom, and Currency). If you have not modified the Scenario, Movement, Data Source, or Multi-GAAP dimensions, they do not need to be exported.

Exporting the Metadata

  1. Select the dimensions to export. On the Home page, click the Navigator icon, then select Application, and then Overview.

  2. Select the Dimension tab, and select Export, and then Create.


    Exporting Metadata sample screen
  3. Select the required dimensions and select Export.

    A zipped metadata file will start to download.

  4. Download the file and unzip the files into the directory.

Editing the Dimensions

  1. Open the Custom and Multi-GAAP files in either Microsoft Excel or a text editor and then do the following steps:

    Change the Data Storage property of each parent member to "Dynamic Calc". Make sure to do this for both "Data Storage (Default)" and "Data Storage (Consol)" columns.

  2. Open the Entity dimension file.

    Delete the column "FCH_MCH_Entity" if it exists.

Importing the Metadata

Import the metadata using the files that you exported and edited.

  1. On the Home page, click the Navigator icon, then select Application, and then Overview.

  2. Select the Dimension tab, then click Import and Create.

  3. Select the appropriate file for each dimension and click Validate.

  4. On the Home page, click the Navigator icon, then select Application, and then Overview.

  5. Select the Dimension tab, then click Import and Create.

  6. Select the appropriate file for each dimension and click Import.

  7. If you are using Intercompany Eliminations, you must load the Account dimension a second time.

  8. Refresh the database.

Import and Create new Custom Dimensions. Make sure all of the parent members are "Dynamic Calc".


Importing Metadata sample screen

Data

It is anticipated that you will want to reload your source data and include mappings in Data Management to members in the new Custom dimensions. However, if you want to use the existing data and manually modify the data to include the new Custom dimensions, then you will need to export the data from the non-Extended dimension application as follows.

  1. On the Home page, click the Navigator icon, then select Application, and then Overview.

  2. From the Actions menu, select Export Data, and then Create.

    Note:

    Set Dynamic Member to Exclude.

  3. Select the Rates cube and set the slice definition and the POV as follows:


    Sample Rates POV
  4. Select the Consol cube and set the slice definition and POV for Consol as follows.

    Note that Segments and Departments are Custom dimensions, and note that only Data Input and Other Data have been selected to export. You will need to select all members that have data under Total Input and Adjusted in the Data Source dimension. You will want to exclude Journal Input and insert your own Custom dimensions. Select other members of other dimensions as necessary for your data.


    Sample Consol POV
  5. For Override data, leave the cube set to Consol, and set the slice definition and POV for Consol as follows:

    • For Data Source: Include Journal Input if needed.

    • The only other changes from the above financial data extract is the members of the Consolidation and Currency dimension. Choose the override members in the Consolidation dimension, and all of the Input currencies in the Currency dimension.


    Sample Consolidation and Currency POV
  6. Edit the data. For all data in the Consol cube, modify the POV to include members from the new Custom dimensions.

  7. Import the data. On the Home page, click the Navigator icon, then select Application, and then Overview. From the Actions menu, select Import Data, then Create.


    Importing Data sample screen

Journals

Journals will be treated like data. You can export them out of your existing application, but will need to modify them to include new Custom dimensions. However, it is anticipated that most journals will be recreated in the new Extended Dimension application.

If Workflow for journals is enabled, you will need to change the status for a journal to Working from Posted to import the journal, since an Administrator cannot import posted journals.

To export journals:

  1. On the Home page, click Journals, then select Actions, and Export.

  2. Set the POV as appropriate. Below is an example.


    Export journals sample screen
  3. Modify the journals for the new Custom dimension members.

  4. Import the journals.

  5. Consolidate and translate as needed.

Other Artifacts

All other artifacts (forms, dashboards, reports, Smart View, valid intersections) will need to be recreated in the Extended Dimension application.