Forum Discussion

Arie's avatar
Arie
Icon for Advocate IV rankAdvocate IV
8 years ago
Solved

Star schema, when to create a dimension table?

Hi,    When I have one big Excel table as a datasource, is it necessary to create a dimension table for each slicer I want to use in the report? Or can I just simply take that column from the fact ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

It is not necessary to create individual dimension tables, you can just use the columns. A lot of the old rules with MDX do not apply to Tabular. That being said, you performance question is an interesting one. Here are some links that may help:

 

https://social.msdn.microsoft.com/Forums/en-US/39d1ea4c-4a54-4b2b-9135-e0fa09150cc2/ssas-tabular-performance-difference-between-degenerate-dimension-and-common-dimension?forum=sqlanalysisservices

 

https://social.technet.microsoft.com/wiki/contents/articles/18569.ssas-taking-the-tabular-journey.aspx