Default Metadata Dimension Member Properties

When you first import a dimension in the Planning Admin Extension, a predefined set of dimension metadata member properties is displayed by default. Use the Member Selection dialog box to add other metadata member properties to the grid.

The sections below list the default member properties for the Planning dimensions.

For information on using the Member Selection dialog box in Oracle Smart View for Office to add other member properties to the grid, see "Selecting Members from the Member Selector" in Oracle Smart View for Office User's Guide.

Account Dimension

Parent Member
Default Data Storage
Data Type
Consol op. for all Cubes
Account Type
Variance Reporting
Time Balance
Default Alias Table
Default Formula

Entity Dimension

Parent Member
Default Data Storage
Data Type
Consol op. for all Cubes
Base Currency
Default Alias Table

Custom Dimensions

Parent Member
Default Data Storage
Data Type
Consol op. for all Cubes
Default Alias Table

Scenario Dimension

Parent Member
Default Data Storage
Data Type
Consol op. for all Cubes
Start Yr.
End Yr.
Start Period
End Period
Default Alias Table
Default Formula

Version Dimension

Parent Member
Default Data Storage
Data Type
Consol op. for all Cubes
Type
Default Alias Table
Default Formula

Period and Years Dimensions

Leave as is or limit to Parent Member
Default Data Storage – Note that for the Time Period dimension, Data Storage is the only editable property
Data Type
Default Alias Table

Currency Dimension

Parent Member
Default Data Storage
Data Type
Symbol
Predefined Symbol
Scale
Precision
Triangulation Currency
Reporting Currency
Thousands Separator
Decimal Separator
Negative Sign
Negative Color
Default Alias Table
Default Formula

HSP_View Dimensions (Sandbox dimensions)

Parent Member
Default Data Storage
Data Type
Consol op. for all Cubes
Default Alias Table