|Oracle9i OLAP Services Concepts and Administration Guide
Release 1 (9.0.1)
Part Number A88755-01
Configuring Your Data Warehouse, 9 of 11
Measure folders provide a means of grouping measures related to a particular business activity, such as finance or sales. These measures will typically be used together in applications tailored to the needs of a particular user group, such as marketing managers or financial advisors. Applications restrict their view of the database to a particular measure folder rather than a particular database schema. The measures in a folder can be associated with any number of different schemas.
Measure folders exist exclusively in the metadata. There are no corresponding objects in the data warehouse. They do not belong to any schema, so anyone can view them. However, only the creator of a measure folder (or those with administrative privileges) can modify or delete it.
To create a measure folder, follow these steps:
If you want to create a measure folder with many of the same measures as an existing one, then right-click on the existing folder and choose Create Like.
You see the measure folder property sheet. If you chose Create Like, then the measures from the original folder will already be listed.
The following figure shows the measure folder property sheet.
Search for the following topics in Oracle Enterprise Manager Help for further information about measure folders: