Setting Dimension Properties

Dimension properties must conform to guidelines listed in Naming Restrictions.

Table 19-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.