Unique Key
Override Base Table
The base table for these overrides is the Tranche 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 Tranche table with the following structure.
Where:
- Override Parameter: The parameters to determine where to apply this override.
- Tranche Table Field: The field in the Tranche 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 Tranche Table.
These fields form an intermediate table containing the Override’s base store fields and will be merged back into the Override base table: Tranche.