Using rules files, you can set the properties of individual standard and attribute dimensions or of all standard dimensions.
To set properties for individual dimensions:
Select Options, then Dimension build settings.
In the Dimension Build Settings dialog box, select the Dimension Definition tab.
Select a dimension.
If the Dimension node is empty, click Outline, and associate the rules file with an outline.
Right-click, and select Edit properties.
In the Dimension Properties dialog box, select one or more properties, and click OK.
To set properties for all standard dimensions:
Select Options, then Dimension build settings.
In the Dimension Build Settings dialog box, select the Global Settings tab.
Select dense or sparse configuration, an alias table, a dimension arrangement (automatic or hourglass), and AND or OR (to specify whether to combine selection and rejection criteria).
Note: | Some properties do not apply to aggregate storage databases. |
Click OK.
Dimension Build Settings Dialog Box, Dimension Definition Tab
“Setting Dimension and Member Properties” in the Oracle Essbase Database Administrator's Guide
“Using the Data Source to Set Member Properties” in the Oracle Essbase Database Administrator's Guide
“Dense and Sparse Selection Scenarios” in the Oracle Essbase Database Administrator's Guide
“Setting Aliases” in the Oracle Essbase Database Administrator's Guide