- Administering Planning
- Accessing More Administrative Tasks
- Administering Dimensions
- Adding or Editing User-Defined Custom Dimensions
- Setting Dimension Properties
Setting Dimension Properties
Dimension properties must conform to guidelines listed in Naming Restrictions.
Table 24-4 Dimensions Properties
Property | Value |
---|---|
Dimension |
Enter a name that is unique across all dimensions. |
Description |
Optional: Enter a description. |
Alias Table and Alias |
Optional: Select an alias table. Enter an alternate name for the dimension. See Administering Alias Tables. |
Valid for Cubes |
Select cubes for which the dimension is valid. Clearing this option makes all members of the dimension invalid for the deselected cube. |
Two Pass Calculation |
Recalculate values of members based on values of parent members or other members. Available for Account and Entity members with Dynamic Calc or Dynamic Calc and Store properties. |
Apply Security |
Allow security to be set on the dimension members; must be selected before assigning access rights to dimension members. Otherwise, dimensions have no security and users can access members without restriction. |
Data Storage |
Select a data storage option. The default is Never Share. |
Display Option |
Set application default display options for the Member Selection dialog box. Select Member Name or Alias to display members or aliases. Member Name:Alias displays members on the left and aliases on the right. Alias:Member Name displays aliases on the left and members on the right. |