Oracle9i OLAP User's Guide Release 2 (9.2) Part Number A95295-01 |
|
Creating Dimension Materialized Views , 2 of 5
You can use OLAP Summary Advisor or the DBMS_ODM
PL/SQL package to create dimension materialized views. When you use OLAP Summary Advisor, the dimension materialized views are automatically created along with the fact materialized views for a CWM
cube. When you use the DBMS_ODM
package, you must call the CREATEDIMMV_GS
procedure to create dimension materialized views.
The syntax of the CREATE MATERIALIZED VIEW
statement is the same whether generated by OLAP Summary Advisor or the DBMS_ODM
package.
|
Copyright © 2001, 2002 Oracle Corporation. All Rights Reserved. |
|