31
Creating Fact Materialized Views With OLAP Summary Advisor

This chapter explains how to use OLAP Summary Advisor to create fact table materialized views in concatenated rollup form for the OLAP API.

This chapter contains the following topics:

• Using the OLAP Summary Advisor Wizard
• Partitioning, Statistics, and Indexes
• The MV CREATE Statement With Concatenated Rollup
• Sample Script for the COST Cube