Defining Measure Folders

Organizing data

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.

Procedure: Creating measure folders

To create a measure folder, follow these steps:

1. Start Oracle Enterprise Manager and access OLAP management, as described in "Procedure: Accessing OLAP management".

2. Right-click on Measure Folders, then choose Create.

   or

   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.

3. Choose Help if you need additional information.

Figure: Measure folder property sheet

The following figure shows the measure folder property sheet.

Related information

Search for the following topics in Oracle Enterprise Manager Help for further information about measure folders:

"Creating Measure Folders"

"Measure Folder Management"

"Measure Folder Property Sheet"

"What Is a Measure Folder?"