Role Playing dimension among multiple fact tables RRS feed

  • Question

  • Hi,

    I am modelling cube in SSAS. Cube has around 20 dimensions and 6 fact tables. Some of the dimensions are common among the fact tables. e.g. Time dimension. Fact_PNL has 3 date columns for those we have 3 role playing dimensions in the dimension usages.Another fact table has 5 date columns for them as well we have separate role playing dimensions in dimension usage tab. We have a common dimension Company which is foreign key in all fact tables. We might need to combine the data from multiple facts to get final output.

    1. Should i create 6 role playing dimension for each of the fact table or use the same dimension for all fact tables?

    2. Role playing dimensions should be created when we have multiple columns pointing to the same dimension ?

    Wednesday, October 28, 2015 2:12 PM


All replies