This content has been marked as final. Show 2 replies
2 should be good one
If Cashdesk -> workstation -> location truly represents a single dimension, then you should not split this into multiple dimensions.
You'll create a single dimension with two logical table sources. First table source will go to a dimension table that includes all three levels, set it's content level to "Cashdesk". Second LTS will go to a table that includes only the workstation and location level info. If no such table exists, you can create it in the physical layer using a view (select distinct workstation attributes and location attributes, but no cashdesk attributes)
Then I would create TWO fact tables - one for the actuals, one for plan. In theory you could smash it all into a single fact table...but I prefer to have different facts when the underlying data is at different grains. Make sure you set the content level properly for the facts - the "Actuals" fact will be at the cashdesk level, the "Plan" fact will be at the workstation level.
This is really easy to show, but hard to describe. Send me an email at SPowell@columbus.rr.com if you need additional info.