conform_dimension
Build a conformed dimension table by unioning a column from two fact sources, linking both so one slicer filters all retailers and combined totals compute.
Instructions
Cross-retailer / total-market builder. Two separate fact islands (e.g. a grocery-retailer fact and a second-retailer fact) can't be filtered by one slicer because they share no dimension. This creates a CONFORMED dimension (a calculated table of the distinct union of a column from each side) and relates it to both, so one slicer filters both retailers and combined measures ([Total Market] = [retailer A] + [retailer B]) compute correctly. Auto-materialises + recalcs. Turns two side-by-side islands into a true total-market view (the Phase-2 join).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table1 | Yes | first source table (e.g. Dim_Products) | |
| table2 | Yes | second source table (e.g. Retailer2_Sales) | |
| column1 | Yes | column on the first table to union (e.g. Brand) | |
| column2 | Yes | column on the second table to union (e.g. Brand) | |
| keyName | Yes | the key/column name on the new table (e.g. 'Brand') | |
| newTable | Yes | name for the new conformed dimension table (e.g. 'Brand (All Retailers)') | |
| sessionId | Yes |