Forum Discussion
Help with Data Model supporting 3 fact tables sliced by 13 column values
Thank you in advance for your help. I am looking for a data-model design or other methods to address this scenario.
In the scenario there are three fact tables, workItems, workItemETA, and workItemBlocker. In addition to other columns unique to the individual table, each table has thirteen columns by which the data is sliced in visuals. An example of the columns are; Location, Division, workGroup, workTeam, leader-2, leader-3, all the way to leader-8, workItemGroup and workItemName.
The slicers should be groups of columns, to reduce the number of slicers on a page and each slicer filters one or more of the fact tables used in the visuals on that page. Roughly the slicer groupings are:
Slicer-1: Location & Division;
Slicer-2: workGroup, WorkTeam,
Slicer-3: Leader-2, through Leader-8; and
Slicer-4: workItemGroup and workItemName.
I tried separate dimTables for each column Item (i.e. dim_Location; dim_Division, dim_workGroup and so on), with one-many relationships from each dimTable to the fact tables. However, that data model design does not support the desired slicer groupings. What are suggestions for addressing this scenario?
Create four dimension tables, one for each of your slicers.
1 Reply
- lbendlin
Super User
Create four dimension tables, one for each of your slicers.