OLAP Dimensions are associated automatically with a cube when a cube is created in WhereScape RED based on the underlying star schema. OLAP Dimensions that are associated with a cube can be displayed, or additional OLAP Dimensions can be manually added from the list of OLAP Dimensions defined in WhereScape RED.

Once an OLAP Dimension is associated with a cube a relationship is created with the relevant Measure Groups within the cube—these relationships are defined automatically with WhereScape RED, and they can also be added. The properties of an OLAP Dimension associated with a cube are shown by right clicking the cube dimensions listed in the middle pane and selecting Properties. The properties are shown below:

Fields

Description

Internal Dimension Name

A read only field displaying the name of the OLAP Dimension in WhereScape RED.

OLAP Dimension Name

Specifies the name of the OLAP Dimension as a Dimension in Analysis Services.

Cube Dimension Name

Specifies the exposed name of the Dimension when associated with a cube (this can be different from the OLAP Dimension Name).

Update Buttons

The Update Buttons: Update <- and Update -> are used to move from the current OLAP Dimension to the previous and next OLAP Dimension respectively for the current OLAP Cube. The alternative is to exit the OLAP Dimension and choose the next OLAP Dimension Properties screen.

Dimension Description

A description of the dimension when associated with the cube.

Order Number

The order number.

Process Cube Dimension With Cube

Use this check box to enable the dimension to be processed with the OLAP Cube.

Visible

Determines whether or not the dimension is visible to client applications.

All member Aggregation Usage

Specifies how aggregations will be designed by the BIDS Storage Design Wizard if it is used to design cube aggregations.

Hierarchy Unique Name Style

Indicates whether the dimension name is included in the name of the hierarchies. If set to Default, then the system applies a default behavior and will include the dimension name, in cases where there is more than one usage of the same dimension.

Member Unique Name Style

Indicates how member unique names is formed. Other Read Only fields that are displayed in this window are configurable against the OLAP Dimensions' properties and cannot be changed in this window, including:

  • Source Table Type
  • Source Table
  • Source Table Key
  • Processing Mode
  • All caption
  • OLAP Dimension Type
  • Unknown Member Action
  • Unknown Member Name

To View Cube Dimensions

To view the list of Dimensions associated with a cube, right-click the OLAP Cube in the left pane and then select Display Dimensions.

To Add a Cube Dimension

To add an existing OLAP Dimension, right-click the OLAP Cube in the left pane and then select Add Dimension. This can also be achieved by displaying Dimensions in the middle pane, right-clicking and then selecting Add Dimension. Fill out the window with the relevant details.

To Remove a Cube Dimension

Display the Cube Dimensions in the middle pane, select the Dimension to remove, right-click and select Remove Dimension from Cube. This action removes the association of the OLAP Dimension from the OLAP Cube.

  • No labels