Cube Properties

Name

Input field for creating a new Cube 

Description

Input field for description of a new Cube.

Cube Type

This is an optional setting that creates tags for different types of Cubes which may be used to separate and capture types of data without affecting other Cubes. This is used in order to have different settings for Default and Constraint settings that apply to certain Dimensions and can vary by Cube Type, such as Entity. The Cube Type names are arbitrary and do not have functional differences but are there to represent different kinds of Cubes that may be created.

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

Assign the Time Dimension Profile created for the Cube. If this Cube uses January as the start year, select Standard. See Time Profiles earlier for more details on this feature.

Security

Access Group

A user can see the object and read its contents.

Maintenance Group

A user can see the object, create new objects in groups, edit, and delete them.

NOTE: Click   in order 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. Click and begin typing 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.

Workflow

Is Top Level Cube for Workflow

If additional Cubes are used that roll their data into the main Cube via 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 is active only for Cubes that have Is Top Level Cube for Workflow set to True. There is one setting for each of the Scenarios 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 all Scenario Types will follow the exact same Workflow Profile structure.  

For example, in order 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.

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 to not be a descendent of the entity.

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 also checks the Percent Consolidation for every relationship down the hierarchy. If a Percent Consolidation is zero, the IC member is determined to not be a descendent of the Entity.

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 provides the ability to use a custom Business Rule to specify different FX Rates for any data cell intersection.

Custom

The translation will be run entirely through Business Rules assigned to the Cube. It is assumed that 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 (i.e., 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 that have no data. However, if part of the calculation is to pull data from another Scenario or prior Time Period, then the setting needs to 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.

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 About the Financial Model to see the calculation order of Member formulas vs. Business Rules attached to each Cube.

BusinessRule1…BusinessRule8

These settings are limited to attaching the Finance Business Rules only.

NOTE: Click   in order 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 from the first day to the last day of the month.

Opening Rate

The currency rate at the beginning of the period.

Closing Rate

The currency exchange rate at the end of a period. 

Historical Rate

The currency rate to be used for a specific historical Account calculation open for a specific special transaction to be valued 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.

Periodic 

Calculate periodic value translation method. This method considers the translation rates for prior time periods and calculates a form of average.

NOTE: Click   in order 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.