The context menu for Dimensions is shown below:

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 displays data, 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.


The bulk of the menu options are the same as for Load tables.


Menu Options

Description

Source Mappings

Source mapping objects are created when there is a requirement to have more than one set of source tables to populate the target table and provide for the generation of an update and custom procedure for each source mapping object. Select this option to perform one of the following:

  • Add Source Mapping - Select to add a source mapping.
  • List Source Mappings - Select to list a source mapping.
    Refer to Multi Source Processing for details.

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 the destination table was created.
    Refer to Dimension Hierarchies for details.

Relationships

Select this option to perform one of the following:  

  • Add Relationship - Select to add relationships.
  • List Relationships - Select to list relationships.
  • Generate Relationships - Select to generate relationships.
    Refer to Relationship Maintenance for details.

Execute Update Procedure

Select this option to execute the procedure defined as the 'update procedure' for the table. The procedure is executed interactively and locks the screen until completed. This menu option is only intended for use when working with small/prototype data volumes, and no index handling is performed.

Execute Custom Procedure

Select this option to execute the procedure defined as the 'custom procedure' for the table. As with the update procedure, the custom procedure is executed interactively.

Process Table via Scheduler

Select this option to process the selected table via the WhereScapeRED scheduler. Refer to Scheduler for details.

Execute Custom Procedure via Scheduler

Select this option to execute the procedure defined as the 'custom procedure' for the table via the WhereScape RED scheduler. Refer to Scheduler for details.

Code

Select this option to view a procedure attached to a table or to rebuild the table's update procedure; and to view or rebuild the Get Key function on the Dimension/Dimension View.

The Get Key function is not available for dimension objects that are stored in custom database targets.

Select this option to perform one of the following:

  • View update_dim_customer
  • View custom_dim_customer
  • View get_dim_customer_key
  • Rebuild update_dim_customer
  • Regenerate update_dim_customer
  • Rebuild custom_dim_customer
  • Regenerate custom_dim_customer
  • Rebuild get_dim_customer_key

Only tables with one or more defined procedures have the Code option.


Build

Select this option to build a Scheduler job or an application based on the Dimension table(s) selected from the middle pane. Refer to Building Scheduler Jobs from Object Groups and Building Applications from Object Groups for details. This option is available from the context menu of Dimension tables listed in the middle pane.


  • No labels