OLAP Cubes Objects

Properties

Select this option to display the Properties window that defines cube creation options and access to documentation tabs.

Display Measure Groups

Select this option to display the details of the measure groups associated with the cube in the Drop Target (middle) pane.

Display Measures

Select this option to list the measures associated with the measure groups in the cube. This is the default view in the Drop Target (middle) pane when a cube is selected in the left pane with a single click.

Display Calculations

Select this option to list all the calculated members defined in the cube

Display KPIs

Select this option to list all the Key Performance Indicators defined in the cube

Display Actions

Select this option to list all the actions defined in the cube.

Display Partitions

Select this option to list all the partitions defined against the related measure groups within the cube.

Display Dimensions

Select this option to list all the dimensions defined in the cube.

Display Measure Group Dimensions

Select this option to display a cross tab report in the Drop Target (middle) pane showing cube dimensions relating cube measure groups.

Add Measure Group

Select this option to add a new measure group to the cube.

Add Measure

Select this option to add another measure to the cube.

Add Calculation

Select this option to add a new calculated member to the cube.

Add KPI

Select this option to add a new KPI to the cube.

Add Action

Select this option to add a new action to the cube.

Add Partition

Select this option to add a new partition to a measure group in the cube.

Add Dimension

Select this option to add an existing OLAP Dimension to the cube.

Version Control

A version of an OLAP cube is a copy of the metadata definition of the cube at the time of the versioning. This version information can be used to create a new OLAP cube or can simply be left as a backup and reference point. Select this option to perform one of the following:

• New Version - Enables you to create a new version of the OLAP cube.
• Build Application - Enables you to build an application file for the OLAP cube.

Create (Alter) Cube

Select this option to create the cube and supporting objects in Analysis Services (including cube database, data source view (DSV) and dimensions) based on the definition in WhereScape RED.

Create via Scheduler

Select this option to submit a create of the OLAP Cube via the Scheduler.

Delete Cube Metadata

Deletes the meta data of the selected OLAP cube, including all related information. A version of the object's metadata is normally auto created (depends on the settings in Tools > Options > Metadata Versioning).

Drop Analysis Services object

Select this option to drop an object associated with the OLAP cube in Analysis Services.

Retrofit Cube

Select this option to retrofit the OLAP cube from Analysis Services.

Update

Select this option to process the cube in Analysis Services interactively from the WhereScape RED interface.

Process Cube via Scheduler

Select this option to generate a WhereScape RED scheduler job to process the cube in Analysis Services.

Query via Excel

Documentation

Select this option to generate (or read if already generated) the WhereScape RED HTML documentation for the selected object. Select this option to perform one of the following:

• Display the documentation available for the selected object. Refer to Reading the Documentation for details.
• Create the documentation for the selected object. Refer to Creating Documentation for details.

Projects

Check Out

Select this option to check out the object for editing and prevent any other users from being able to modify, update or delete any of their associated objects while you are making changes. Refer to Object Check-Outs and Check-Ins for details.

Impact

Select this option to produce a Track Back diagram on the OLAP cube. Select this option to perform one of the following:

• Track Back Report
• Track Forward Report
• Track Back Diagram
• Track Forward Diagram
• Dependent Jobs Report