Create a Dimension Group Folder

Important

In order to create a Dimension, you will need first to create a Dimension Group Folder.

Dimension Groups have been introduced into the OLAP Manager as a way to force users to organize their Dimensions into groups for easier access later on. They don’t have any other utilities or impact, you could create only one Dimension Group for all the dimensions without affecting the functionality or usability of the Cube.

To create a Dimension 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 Dimensions.
  4. In the Navigation Bar, click on Add Folder.
  5. Enter a name for this folder and click on Save.

Create a Dimension

  1. Click on the drop-down arrow to display the Dimensions within the Dimension Group.
  2. Click on Add Dimension.

Dimension Properties

Description:
A description of the Dimension.
Field Name:
A name for the column. This name will be used to create the Field in the final Cube table.
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 Dimension Group where the Dimension is held.
Precision:
(if applicable): Size of the data type
Scale:
(for decimal data types): number of decimals.
Description:
Use for the description column of a description Cube (e.g. customer name).
Save:
Save changes to the Nectari table.
Cancel:
Cancel pending changes and goes back to the Dimensions list.

Edit a Dimension

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

Copy a Dimension

  1. Click on the drop-down arrow to display the Dimensions within the Dimension Group.
  2. Select the Dimension 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 Dimension

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