I want to add "Market Rate" measure in SSAS Cube as Nonadditive , please let me know the steps to be performed.
I have stated aggregate function for "Market Rate" as "None" doesn't seem that it is working.
Also there are blogs that we have to create a degenerate dimension.
I am totally clueless.
Request you to please help on this issue.
So.. Your problem is, that Non Additive Measures will show values only on the lowest granularity. For example if you had a Fact Dimension and go to the Leaf members of that dimension, than the Non Additive Measure will show you a value.
If you are above the lowest granularity, value will not be shown.
If you would like to show the Market Rate also on higher granularity levels, you have basicaly three possibilities:
I suggest you to go using the option 1., as it will give you the best performance.
answered Aug 27 '12 at 09:40 AM