In the Incremental Load page of the Cube Deployment Wizard, you select specific dimensions or members to update.
To set member load update options:
In the Incremental Load page of the Cube Deployment Wizard, under Dimension Build Update, choose an option:
Update or rebuild selected—When this option is selected, all hierarchy selections are cleared. You then select a hierarchy, and then choose one of the following operations to perform on the hierarchy:
Update—Add any new members to the hierarchy; do not delete existing members.
This option should be used to add new members without changing the hierarchy's structure, or to add shared members. During Update, an existing hierarchy is updated without removing the existing members.
When you select Update, an icon is displayed next to each member in the hierarchy signifying that these members are marked for Update. The check boxes next to each member are not yet selected. You must manually select them.
Rebuild—Clear all the members of the hierarchy and add back all members, including shared members. If necessary, restructure the hierarchy.
This option is particularly useful if you have removed members from a hierarchy. Then the members that still exist, plus any new ones, are added back into the hierarchy and, if necessary, the hierarchy is restructured.
When you select Rebuild, an icon is displayed next to each member in the hierarchy signifying that these members are marked for Rebuild. The check boxes next to each member are not yet selected. You must manually select them.
Clear—Use the Clear button to clear any selections you have made during the current session. If you had marked a hierarchy in error, and then selected the check boxes for that hierarchy, click Clear to clear these selections.
Note:
The Clear button only works on hierarchies where the check box next to each of its members is selected.
To set the parameters for restructuring the database during member build, select a Preserve option:
All Existing Data—This is the default. Preserves all existing data that applies to the changed outline when restructuring occurs.
Input data—Preserves only blocks containing data that is loaded. Many applications contain data that is entered at parent levels. Selecting this option prevents deletion of any blocks that are created by data load, whether they are non-level zero or level zero (leaf node) blocks.
Level 0 Data—Preserves data only for level zero members. This is the optimal restructure option if you change the source database and must recalculate the data and if all data required for the calculation is in level zero members. Selecting this option deletes all upper-level blocks before restructuring, reducing the disk space for restructuring and improving calculation time when the database is recalculated. The upper-level blocks are recreated when you calculate the database.
No Data—Clears all data from the database.
Click Finish to deploy the cube.
The Deployment Succeeded dialog box is displayed for successful deployments, containing details about the deployment.
Deployed cubes are displayed in the Metadata Navigator as children of the Essbase model from which they were deployed.
You can now launch Administration Services Console to view and edit the outline. You can also query the cube using Smart View or Essbase Spreadsheet Add-in.
If you want to save the deployment as a MaxL load script, click Next and complete the tasks in Setting Deployment Options.