Create, remove, or modify dimensions dynamically
If your outline has many members, you may want to create, remove, or modify the dimensions dynamically, using a rules file and a data source:
- Create a data source file that contains the dimensions and members that are to be added to the Essbase database.
- Start Application Manager.
- Connect to OLAP Server.
- In the Application Manager desktop window, select an application and a database. The database must contain at least one dimension.
- To open a new rules file in the Data Prep Editor, select New > Data Load Rules from the File menu.
- Open the data source file in the Data Prep Editor.
- Associate the rules file with the outline.
- To ensure that Data Prep Editor displays dimension building fields, select Dimension Building Fields from the View menu.
- In the rules file, specify the names of the new dimensions.
- Specify operations, such as the build type method, that the rules file should perform on the data file before loading the data file into the database.
- Define dimension build properties for each field in the rules file.
- Validate and save the rules file.
- To update the outline, open the outline and select the File > Update Outline command.