When you have a valid dimension build rules file, you can create and update dimensions dynamically from Outline Editor. The outline must have at least one dimension defined before you can do a dynamic dimension build.
To create new dimensions, you must define them in the rules file.
Note: | This feature does not apply to aggregate storage outlines. |
To update an outline using a rules file:
Select Outline, then Update outline to open the Update Outline dialog box.
Select a data source type:
To select a data file, select Data files, and then click Find Data File.
To select a SQL database, select SQL, and then supply the user name and password for the database.
Click Find Rules File to find and select the dimension build rules file.
Specify an option for error handling.
Click OK.
Essbase adds the dimensions in the data source to the outline.