Forum Discussion
Dynamic Dimension
Hi everyone,
I'm also very interested in this topic. I am coming from a tableau background and have developed reports where the user can define 2 separate dimensions that he/she would like to break the data out by.
I'm in transportation, so in dimension 1 the user may select something like 'Origin' and in dimension 2 the user may select 'Carrier'. They could then see whatever the measure is for the given chart broken out as follows:
Location A Carrier A Key metric
Location A Carrier B Key Metric
...
...
...
Location B Carrier A Key Metric
Location B Carrier B Key Metric
...
etc.
For each dimension I have 9 options. The book mark solution doesn't seem viable, given there would be 72 (9*8 b/c you wouldn't have the same dimension twice in one view) views that I would have to build. My data set is around 1M records. Is the cross join table solution even viable? How much do you think having a bridge table with 9M records is going to impact performance? Thats only for one dynamic dimension, if I wanted both dynamic dimensions I would presumably have to create 2 bridge tables now totaling an extra 18M records in my data model right?
I think my tableau users are going to be sad if this is the best solution I can give.
There is another solution for implementing dynamic dimension slicers optimized for performance.
Here you can add new dimensions in the DAX code quite easily and it offers a huge degree of flexibility.
Let me know if you need more informartion
Nice solution