Cube Advisor: Cube Design Options dialog box

After selecting an appropriate folder destination to save the Intelligent Cubes, select from the following options:

• Design Intelligent Cubes with outer join properties: Select this option to enable outer joins on all Intelligent Cubes to be created. This ensures that all warehouse data is captured; however, this can potentially increase the size of the Intelligent Cubes.

• Allow Dynamic Sourcing without enabling outer join properties: Select this option to allow reports to connect to Intelligent Cubes using dynamic sourcing even when some outer join properties are not defined. However, this can cause incorrect data to be returned in certain scenarios.

Make your selections and click OK.

A task progress bar shows the progress of each Intelligent Cube creation and also shows whether the subsequent Intelligent Cube creation succeeds or fails.

Each Intelligent Cube is created in a separate folder. Each folder also contains shortcuts to all the reports that can connect to the Intelligent Cube.