|Oracle9i OLAP User's Guide
Release 2 (188.8.131.52)
Part Number A95295-02
To create concatenated rollup MVs for CWM cubes, use OLAP Summary Advisor.
Oracle Enterprise Manager has two distinct Summary Advisors. They generate very different types of materialized views. One Summary Advisor generates materialized views for Oracle OLAP, and the other generates materialized views for other types of applications.
The Summary Advisor that you need to use for OLAP is located within the OLAP Management tool. It generates materialized views that query rewrite will use for queries generated by the OLAP API.
Follow these steps to run the OLAP Summary Advisor wizard:
You see a popup menu.
You see the Summary Advisor Wizard Welcome page.
The Summary Advisor analyzes the cube and makes recommendations for creating materialized views for the fact table and dimension tables associated with the selected cube. When it is done, you see the Recommendations page.
The Summary Advisor generates the scripts to create the recommended materialized views. When it is done, you see the Finish page.
Choose Finish to execute the original scripts immediately. You see the Implement Recommendations page while the scripts are executing.