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:
|
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:
|
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:
|