Adding Application Cubes
You can create additional block storage cubes to store metadata and data and optimize performance.
Application cubes store metadata and data. The Cubes tab displays the Name and Type of cubes that are associated with the application. By default, there are two cubes in multi-currency applications:
- Consol - Consolidated
- Rates -Foreign Exchange Rates
If you are a Service Administrator, you can enable additional block storage cubes as needed. You can select any one or more predefined cubes (Consol Cube 2, Consol Cube 3, Consol Cube 4, and Consol Cube 5). Enabling additional cubes allows you to break up your data into unique slices to optimize performance.
Note:
This feature is only available for Dense/Sparse Optimized (DSO) applications. Adding additional cubes results in more maintenance required for the application, so it is recommended only for specific use cases.Use Cases - Recommended
- Performance Improvement
- Segmentation of data to minimize cube size
- Constant Currency analysis
- Other reporting standards (local GAAP, IFRS, etc.)
- Additional detail, for example, footnotes
- Functional improvement - additional Custom dimensions (via stacking)
- Main drivers
- The data slices should be independent
- Resources are shared
- Ideally, data movement should be minimal
Use Cases - Not Recommended
- Historical data
- Application size will still be the same
- There is no consolidation performance improvement in this configuration
- Archiving data
- Same considerations as historical data
- Logistical complication of resetting opening balances constantly
When you enable additional cubes, warning messages are displayed. The warnings depend on which other features are already enabled in your application, such as Enhanced Organization by Period and Ownership Management. Enabling Additional Cubes and other features separately ensures that the metadata changes for these features are implemented correctly.
After you enable a cube, a new cube is created with the selected cube name. Since additional cubes are only available for Dense/Sparse Optimized applications, the new cube will be configured with Period and Movement as Dense. All cubes will have the same number of dimensions and application settings. These artifacts will be created/enabled in the new cube:
- Dimensions and seeded members will be enabled.
- Seeded Forms and Rules will be created for the cube.
- You need to recreate or copy any user-created Forms and On-Demand rules in the new cube.
- From the Dimension Editor, you can enable all the non-seeded members for new cubes.
- Scenarios and Years will be enabled by default for all cubes.
Note that when you are creating metadata load files, properties that are not included in the header or metadata records are inherited from the corresponding parent’s default properties. If your application has multiple cubes enabled, the metadata that you load specifically for one cube may result in errors in other cubes. In the metadata load file, to disable members for any cube, set the column "Plan Type(Cubename)" to FALSE. For example, if you have cubes Consol2 and Consol3 enabled, but want to import metadata only for Consol3, set the PlanType(Consol3) to TRUE, and the PlanType(Consol) and PlanType(Consol2) to FALSE.
After you add a new cube, you can select it from the Cube dropdown, for example, in the consolidation process, Configurable Consolidation rules, Configurable Calculation (Insertion) rules, On-Demand rules, Translation rules, Reporting Currency translatiaon, Consolidation reports, Intercompany Matching reports, Journals and Journal reports.
To enable additional cubes:
- On the Home page, click Application, and select Configuration.
- From the Configure screen, click Enable
Features.
Note:
Make sure Enhanced Organization by Period is enabled before selecting Enable Additional Cubes. - From Enable Additional Cubes, select any one or more predefined cubes (Consol Cube 2, Consol Cube 3, Consol Cube 4, and Consol Cube 5) and then click Enable.A new cube is created with the selected cube name.
Planning the Content of a Cube
Before configuring an additional cube, identify the data and processing that it will support. Plan the dimension members, forms, and rules needed for that purpose. For example, you can use a cube for constant currency analysis or for additional disclosure detail.
All consolidation cubes use the application’s dimensions and settings. An additional cube does not provide a separate set of application features. For example, an application with four Custom dimensions has those same dimensions in each consolidation cube. You can enable user-defined members for the cubes in which they are required.
For constant currency analysis, identify the analysis scenarios and the base data to be compared using fixed exchange rates. Prepare the data and rules for the analysis cube, and consolidate and translate the analysis data in that cube. Use the results to assess the effect of exchange rate changes on reported performance.
For disclosure detail, identify the accounts, movements, and Custom dimension members required for the additional breakdown. Plan separately which values must be included in the main consolidation cube and how those values will be transferred.
Preparing a Cube for Use
After enabling an additional cube:
- In the Dimension Editor, enable the required user-defined members for that cube. Review membership for each applicable dimension rather than assuming that every member is enabled in the new cube.
- Recreate or copy the user-created forms and On-Demand rules needed for the cube. Review references to dimension members before using these artifacts.
- After completing metadata changes, refresh the database. See Refreshing the Database.
- Load or copy the required data, then run consolidation and translation for the selected cube. See Copying Data, Consolidating Data, and Translating Data.
When importing metadata, explicitly specify cube membership in the import file for members that must be excluded from other cubes.
Example of Independent Cube Configuration
An administrator selects Consol2, creates an opening balance override, disables Calculate Movements, and disables ratios for Forecast. After saving, the administrator selects Consol. The Consol page shows its own overrides and enabled settings. The changes made for Consol2 have not changed those settings for Consol.
If the administrator then opens Options and changes Custom dimension Top Member processing, that change applies to all enabled cubes. This shared setting is the exception to the cube-specific configuration described earlier.