UNDERLYING_DESCRIPTION_OVERRIDES

The UNDERLYING_DESCRIPTION_OVERRIDES table contains the Override definitions for the Underlying Descriptions.

Unique Key

Override Base Table

The base table for these overrides is the Underlying Description table. To define Overrides you must add facts to the base table. For details on why this is required, see Overrides With DirectQuery.

Inject Base Table

For each override, you must generate multiple entries in the Underlying Description table with the following structure.

Where:

• Override Parameter: The parameters to determine where to apply this override.
• Underlying Description Table Field: The field in the Underlying Description base table for this override.

Create Base Store Tuples

See the Create Override Tuples section for an example of how to create the override tuples for the following override fields. These are the fields we want to override in the base override table, in this case the Underlying Description Table.

These fields form an intermediate table containing the Override’s base store fields and will be merged back into the Override base table: Underlying Description.

Map Override Fields to Base Table Fields

Once you create your tuples for each override field, you can then map the tuples back to the base store using the following relationship: