Oracle9i OLAP User's Guide Release 2 (9.2.0.2) Part Number A95295-02 |
|
|
View PDF |
The following statements create a measure folder called PHARMACEUTICALS
and add the measure SALES_AMOUNT
from SALES_CUBE
to it. The measure folder is at the root level.
execute folder_ID = cwm_classify.create_catalog
('PHARMACEUTICALS
', 'Pharmaceutical Sales and Planning');
execute cwm_classify.add_catalog_entity
('folder_ID', 'JSMITH', 'SALES_CUBE', 'SALES_AMOUNT');