Following is an example of a standard menu for an OLAP Dimension.

Note

WhereScape RED supports the use of keyboard shortcuts—the underlined letter of a menu option. For example, pressing P opens the Properties window of the selected table, pressing D deletes the dimension metadata, etc. Ensure that the Windows > Control Panel > Ease of Access setting associated with keyboard shortcuts is enabled, to display keyboard shortcuts in RED. Refer to the relevant MS Windows documentation for details.


Menu Options

Description

Properties

Select this option to display the OLAP Dimension Properties dialog which includes documentation tabs.

Display Attributes

Select this option to list the attributes for the selected dimension. This is the default view when an OLAP Dimension is selected in the left pane.

Display Attribute relationships

Select this option to display the relationships between the dimensional attributes.

Add Attributes

Select this option to add a new attribute to the OLAP Dimension.

Add Attribute relationships

Select this option to add an attribute relationship for the selected OLAP Dimension.

Hierarchies

Select this option to perform one of the following:

  • Add Hierarchy - Select to add hierarchies.
  • List Hierarchies - Select to list hierarchies.
  • List Hierarchy Elements - Select to list hierarchy elements.
  • Copy Hierarchies from Source - Select to copy all hierarchies from the source table to the destination table. Source hierarchies are copied to the destination table automatically during table creation, but this feature is useful if the source table has been updated since destination table was created.
  • Add hierarchy Element - Select to add a new hierarchy element.

Version Control

A version of an OLAP Dimension is a copy of the metadata definition of the OLAP Dimension at the time of the versioning. This version information can be used to create a new OLAP Dimension 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 an OLAP Dimension.
  • Build Application - Enables you to build an application file for the OLAP Dimension.

Delete Dimension 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 Dimension in Analysis Services.

Retrofit dimension

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

Create (Alter) dimension

Select this option to create the OLAP Dimension and supporting objects in Analysis Services (including cube database and dsv) based on the definition in WhereScape RED. This option requires connection and cube database information populated in the OLAP Dimension Properties.

Create via Scheduler

Select this option to submit a create of the OLAP Dimension via the RED scheduler.

Update

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

TIp

This option requires connection and cube database information populated in the OLAP Dimension Properties.

Process Dimension via a Scheduler

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

Note

This option requires connection and cube database information populated in the OLAP Dimension Properties.

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:

Projects

Select this option to perform one of the following:

Note

Multiple objects can be selected by double-clicking the Object Group icon in the left pane and then Ctrl + clicking multiple objects in the Drop Target (middle) pane.

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 dimension. Select this option to perform one of the following:

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