Restructure Cubes

When you add a dimensions and members to an outline, and save the outline, it triggers a cube restructure. You specify how data values will be handled during the restructure. If you added or deleted a dimension, you are prompted to indicate data association changes.

1. In the outline editor, add a dimension to the outline.
2. Add members as children of the new dimension.
3. Click Verify.
4. Click Save.
5. In the Restructure Database Options dialog box, specify how data values will be handled during the restructure by selecting one of the following options:
   • All Data - All data values are preserved.
   • Discard all Data - All data values are cleared.
   • Level 0 Data - Only level 0 values are preserved. If all data required for calculation resides in level 0 members, you should select this option. If the option is selected, all upper level blocks are deleted before the cube is restructured. Therefore, the disk space required for restructuring is reduced, and calculation time is improved. When the cube is recalculated, the upper-level blocks are re-created.
   • Input Data - Only the blocks that contain the data that is being loaded are preserved. However, all blocks (both upper-and lower-level) that contain loaded data are preserved.
6. Still in the Restructure Database Options dialog box, if prompted, select the member from the added dimension with which you want the existing data to be associated, or (if you have deleted a dimension) select the member from the deleted dimension for which you want to keep the data.
7. Click OK.