Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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

  • Create four dimension tables, one for each of your slicers.