locked
SSAS 2012 Tabular Shared Dimension RRS feed

  • Question

  • Date dimension for example. On the fact table 20+ fields have a foreign key to a date dimension. But I notice after building tabular and browsing through excel there is only one date dimension. In multidimensional there woudl have been 20+ date dimensions to drill the data down. How can I configure tabular similarly , for each foreign key on date dimension there would be one dimension or anything that would let people use excel and browse through many date dimensions.

    Thank you


    Gokhan Varol

    Tuesday, August 6, 2013 9:48 PM

Answers

  • Tabular models do not currently have the concept of role playing dimensions - you would have to create multiple date tables, importing the data multiple times

    http://darren.gosbell.com - please mark correct answers

    • Marked as answer by Elvis Long Thursday, August 15, 2013 1:59 PM
    Wednesday, August 7, 2013 3:02 AM

All replies

  • Date was a sample. I have many other role playing dimension s I need to configure

    Gokhan Varol

    Tuesday, August 6, 2013 10:16 PM
  • Tabular models do not currently have the concept of role playing dimensions - you would have to create multiple date tables, importing the data multiple times

    http://darren.gosbell.com - please mark correct answers

    • Marked as answer by Elvis Long Thursday, August 15, 2013 1:59 PM
    Wednesday, August 7, 2013 3:02 AM
  • So your take away from the last message is there will be one table (date table) in the source but multiple date tables (calendar, financial) in the model depending on how many you create

    Please vote as helpful or mark as answer, if it helps
    Cheers, Raunak | t: @raunakjhawar | My Blog

    Wednesday, August 7, 2013 10:36 AM