Adding or Editing User-Defined Custom Dimensions

User-defined custom dimensions must conform to guidelines listed in Naming Restrictions.

Table 19-3 Properties for User-Defined Custom Dimensions

Property Value

Dimension

Enter a name that is unique across all dimensions.

Alias

Optional: Select an alias table. Enter an alternate name for the dimension. See About Aliases.

Description

Optional: Enter a description.

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.

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.

To add or change user-defined dimensions:

  1. From the Home page, click Navigator Navigator icon, and then under Create and Manage, click Dimensions.
  2. Click Add Dimension icon or select an existing dimension and click Edit Dimension icon.
  3. Specify any of the properties listed above.
  4. Click Save.
  5. Click OK.

    Click Refresh to revert to the previous values and keep the page open.