Managing Dimensions

Start here to learn how to manage dimensions and dimension members.

Dimensions categorize data values. These dimensions are provided with the application: Account, Entity, Scenario, Version, Period, Currency (for a multicurrency application), and Years.

Dimensions on the Dimensions page are listed in order of precedence. The order of dimensions is critical for the structure and performance of an application. The order of your dimensions determines how your data calculations will perform. Evaluation Order enables you to specify which data type prevails when a data intersection has conflicting data types. For example, if Account members are set to the Currency data type, and Product members are set to the Smart List data type, you can set whether the Currency or Smart List data type prevails at an intersection.

Note:

For a Smart List to be viewable in forms, the dimension to which the Smart List type member belongs must be first in the evaluation order. See Working with Smart Lists.

To manage dimensions:

  1. Click Application, click Overview, and then click Dimensions.
  2. Perform a task:
    • To filter the dimensions by cube, see Filtering the Dimension View by Cube.

    • To view and edit the properties of dimensions and their members, click the name of the dimension. See Editing Dimensions in the Simplified Dimension Editor.

    • To reorder the dimensions, click the up or down arrow in the Order column next to the dimension that you want to move.

    • To set a different evaluation order, click the Evaluation Order field next to the dimension that you want to update.

    • To rename a dimension, click the name of the dimension that you want to rename, and then enter a new name in the Dimension field.

    • To create a dimension, click Create. See Creating Dimensions.

    • To import metadata, click Import. See Importing Metadata.

    • To export metadata, click Export. See Exporting Metadata.