Create Measure Group Folder

Measure Groups have been introduced into the OLAP Manager as a way to force users to organize their measures into groups for easier access later on.

They don’t have any other utilities or impact, you could create only one Global Measure for all the global elements without affecting the functionality and usability of the Cube, but the good practice would be to organize properly your Measures by group (e.g. values, quantities, etc.).

To create a Measure Group Folder:

1. In the Cubes list, click on one Cube.
2. Untick the In Production checkbox and click on Save.
3. In the Navigation Bar, click on Navigation and select Measures.
4. In the Navigation Bar, click on Add Folder.
5. Enter a name for this folder and click on Save.
   

Create a Measure

1. Click on the drop-down arrow to display the Measures within the Measure Group.
   
   
2. Click on Add Measure.
   
   

 

Measure Properties

Description:

A description of the Measure.

Field name:

The name of the column in the Cube.

Use only capital letters, and avoid SQL keywords.

Data Type:

Choose a .net data type that is the closest to the data type in the data source.

Folder:

Choose the Measure Groupwhere the Measure is held. Change it to change the Measure to a new Measure Group.

Precision:

(if applicable): Size of the data type

Scale:

(decimals), number of decimals.

Summarizable:

When this option is checked, a sum of the value at the Cube aggregation level is performed. When using Measures (ex: Quantity, Amount, Margin, Cost, etc.), the Cube will perform a calculation of the aggregations to display their sum. If unchecked, the Measures will remain at 0.

Save:

Save changes to the SEI table.

Cancel:

Cancel pending changes and goes back to the Measures list.

Edit a Measure

1. Click on the drop-down arrow to display the Measures within the Measure Group.
   
2. Select the Measure you want to edit and change its properties.
3. Click on Save to finish.

Copy a Measure

1. Click on the drop-down arrow to display the Measures within the Measure Group.
   
2. Select the Measure you want to copy and click on Copy to finish.
   Note

   A COPY mention will be added to the Description and Field Name fields.

Delete a Measure

1. Click on the drop-down arrow to display the Measures within the Measure Group.
   
2. Select the Measure you want to delete and click on Delete .
3. In the Confirmation window, tick the checkbox and click on Yes.