Dimension Sort Order and Density Settings

The Dimension Sort Order property controls the order of dimensions in the Essbase outline that is generated by Profitability and Cost Management. The dimension sort order must be set on all dimensions within a model, except Alias and UDA.

Caution!

If the sort order for a dimension is left blank, the validation will fail.

The Dimension Sort Order property is set in Performance Management Architect, and passed on to Profitability and Cost Management during deployment for use in generating the Essbase outline. For instructions, see Setting the Dimension Sort Order.

The Dimension Sort Order settings for the model are validated in Performance Management Architect. See Validating and Deploying the Application in Performance Management Architect.

You can also set the density for dimensions from the Dimension Sort Order Settings dialog box.