Creating Measures

Base measures store the facts collected about your business. Each measure belongs to a particular cube, and thus shares particular characteristics with other measures in the cube, such as the same dimensions.

To create a measure:

1. Expand the folder for the cube that has the dimensions of the new measure.

2. Right-click Measures, then choose Create Measure from the pop-up menu.

   The Create Measure dialog box is displayed.

3. Complete all tabs of the Create Measure dialog box.

   Click Help for specific information about these choices.

4. Click Create.

   The new measure appears as an item in the Measures folder.

5. When you are done creating measures for the cube, map them to their data sources.

6. Create calculated measures and measure folders at any time.

Copyright © 2003, 2007, Oracle. All rights reserved.