TABLE_LABEL - Registry Table

Use the TABLE_LABEL registry table to specify a display name (label) for a table.

You can define labels for fact, plain and classification tables:

• Fact table labels will be displayed in the SuperSTAR clients.
• Although it is good practice to define meaningful labels for your classification tables, these will not generally appear in the clients (the field list in the clients uses the label from the fact table column rather than the label from its linked classification table). However, if you have hierarchical fields, then SuperWEB2 will use the classification table labels for the default text shown in the Select all at level drop-down list (see the example below).
• Plain tables are not included in the target database, although setting a descriptive label may help readability of the target schema.

Table Definition

Example

The labels for the two fact tables in this example would appear as follows in SuperWEB2:

SuperWEB2 uses the classification table labels in its drop-down lists:

It is also possible to change the text used in these drop-down lists by configuring SuperWEB2.