Cube Properties

Name: Input field for creating a new Cube.

Description: Input field for description of a new Cube.

Cube Type: This optional setting creates tags, such as group Cubes, for different types of Cubes which can be used to separate and capture types of data without affecting other Cubes.  This is used to have different settings for Default and Constraint settings that apply to specific Dimensions and vary by Cube Type, such as Entity. The Cube Type names are random that do not have functional differences but represent different kinds of Cubes that may be created. Below are all Cube Type properties:

  • Standard: Cube used for normal Consolidation.

  • Tax: Cube specifically used for Tax.

  • Treasury: Cube specifically used by Treasury.

  • Supplemental: Cube specifically used to capture supplemental data.

  • What If: Cube specifically used to capture various What If Scenarios.

  • Cube Type 1…Cube Type 8: Custom Cube Types.

Time Dimension Profile: The default Time Dimension profile is Standard.   See Time Profiles for more details on this feature.

Security

Access Group: You can view the object and read its contents.

Maintenance Group: You can view the object, create new objects in groups, edit, and delete them.

Use Parent Security for Relationship Consolidation: You can change the security model for the read or write relationship for the Consolidation Dimension Members based on the security rights to the immediate Parent-level Entity.

NOTE: Click  to navigate to the Security screen.  This is useful when changes need to be made to a Security User or Group before assigning it to a Cube. 

NOTE: Click and type the name of the Security Group in the blank field.  As the first few letters are typed, the Groups are filtered making it easier to find and select the desired Group.  Once the Group is selected, click CTRL and Double Click. This will enter the correct name into the appropriate field or you can select the Group and click OK.

Workflow

Is Top Level Cube for Workflow: If additional Cubes are used that roll their data into the main Cube through Extensible Dimensionality, other Cubes should be set to False.  Each Cube listed as True for this setting can be set as a (top level) Cube Root Profile for Workflow Profiles, meaning that Cube can have different Workflows than the others.

Suffix for varying Workflow by Scenario Type: This property is used to restrict the Scenarios available to your users in the Workflow for the particular Cube. This is active only for Cubes with Top Level Cube for Workflow set to True. There is one setting for each of the Scenario Types.  A suffix is expected to be added onto a Cube Root Profile when Workflow Profiles begin to be built which means by default there is no suffix, so that all Scenario Types will follow the same Workflow Profile structure.  

Example: To have Budget, Plan and Forecast Scenario Types follow a different Workflow Profile structure than any other Scenario Types, add a suffix such as plan to these three Scenario Types. When the Workflow Profiles are built, there will be two Cube Root Profiles.  If the main Cube is called GolfStream, and there is a suffix of Plan for the three Scenarios Types listed above, and no suffix for the other Scenarios Types, two Cube Root Profiles will be created called GolfStream and GolfStream_Plan.

Calculation

Consolidation Algorithm Type

Standard (Calc-on-the-fly Share and Hierarchy Elimination): This is the default Consolidation algorithm. Amounts for the Share Consolidation Member are calculated dynamically and amounts for the Elimination Consolidation Member are calculated using built-in algorithms and stored in the Data Record Tables.

Stored Share (Stored Share and Hierarchy Elimination): This is similar to Standard, but it stores the values for the Share Member instead of calculating them dynamically. It only considers the position in the Entity hierarchy tree.

Org-By-Period Elimination (Calc-on-the-fly Share and Org-By-Period Elimination): When determining if the data cell's IC member is a descendant of the Entity being consolidated, this option considers the position in the Entity hierarchy and also checks the Percent Consolidation for every relationship down the hierarchy. If a Percent Consolidation is zero, the IC member is determined not to be a descendent of the entity. This setting is required when Entities have different parents depending on the time period.

Stored Share And Org-By-Period Elimination: Stores the values for the Share Member instead of calculating them dynamically. When determining if the data cell's IC member is a descendant of the Entity being consolidated, this option considers the position in the Entity hierarchy and verifies the Percent Consolidation for every relationship down the hierarchy. If a Percent Consolidation is zero, the IC member is determined not to be an Entity descendent.

Custom: The Consolidation will utilize custom Business Rules to calculate amounts for the Share and Elimination Consolidation Members using the Finance Function Types of Consolidate Share and Consolidate Elimination.

Translation Algorithm Type

Standard: This is the default Translation algorithm. Amounts for a foreign currency Consolidation Member are generated from the Local Consolidation Member using the FX rate tables.

Standard Using Business Rules for FX Rates: This is similar to the Standard Translation algorithm. However, it enables a custom Business Rule to specify different FX Rates for any data cell intersection.

Custom: The translation will run entirely through Business Rules assigned to the Cube. The Business Rule will calculate translated amounts from data in the Local Consolidation Member.

No Data Calculation Rules: These settings specify whether the calculation engine will execute Member Formulas and Business Rules for the specified Consolidation Member even if there is currently no data stored in the Data Unit such as the data for a specific Entity, Parent, Consolidation, Scenario, and Time. There is a potential performance benefit of using False to skip the formulas for Data Units with no data. However, if part of the calculation pulls data from another Scenario or prior Time Period, the setting must be True. Otherwise, the calculation will not run for an empty Data Unit, so the data will never be pulled from another Scenario or Time Period. Below are all No Data Calculation properties:

  • Calculate None Cons Member If No Data

  • Calculate Local Currency If No Data

  • Calculate Translated Currencies If No Data

  • Calculate OwnerPreAdj If No Data

  • Calculate Share Cons Member If No Data

  • Calculate Elimination Cons Member If No Data

  • Calculate OwnerPostAdj If No Data

Business Rules

Custom Business Rules can be attached to a Cube. Eight different Business Rules can be defined. See Business Rules in Application Tools for more details.  This method of definition allows for extreme flexibility to share or not share certain Business Rules between Cubes.  See Consolidation in Financial Model Guides for calculation order of Member formulas or Business Rules attached to each Cube.

BusinessRule1…BusinessRule8: These settings are limited to attaching the Finance Business Rules only.

NOTE: Click   to navigate to the Business Rules screen. This is useful when changes need to be made to a specific Business Rule before assigning it to a Cube.

FX Rates

Default Currency: This setting is the default reporting currency for the Cube. This is used for FX rate triangulation if the Cube currency is the common currency. This is also used for Intercompany Matching’s reporting currency.

Rate Type for Revenues and Expenses & Rate Type for Assets and Liabilities: Note that these are the default settings for this Cube and can be overridden at the Scenario-level with the same settings.

Average Rate: The average currency rate of a period starting from the first through to the last day of a period such as a range from the first to last day of the month.

Opening Rate:The currency rate at the beginning of the period such as the first day of the month.

Closing Rate: The currency exchange rate at the end of a period such as the last day of the month.

Historical Rate: The currency rate used for translating certain balance sheet items that are needed to be held at a constant, past rate. This rate is used when accounts are translated at a specific rate on a specific date.

Rule Type for Revenues and Expenses & Rule Type for Assets and Liabilities: Note that these are the default settings for this Cube and can be overridden at the Scenario-level with the same settings.

Direct: Calculate direct with current value and current rate. Current Period’s Translated Value = Current Period’s Local Value * Current Period’s FX Rate.

Periodic: Calculate periodic value translation method. This method considers the translation rates for prior time periods and calculates a form of average. Current Period’s Translated Value = Prior Period’s Translated Value + [(Current Period’s Local Value – Prior Period’s Local Value) * Current Period’s FX Rate].

NOTE: Click   to navigate to the FX Rates screen. This is useful when changes need to be made to FX Rates before assigning them to a Cube.