I have have started working on SSAS recently. And was reading about semi - additive measure. And the most important point that struck me was
all semi additive use the selected function for the aggregation with time dimensions and sum with all others.
So i decided to test it by building a very small cube with two dimensions i.e. Period and Product. Period dimension has single hierachy with two attributes i.e. year and month. where as my
product dimension contains only one attribute hierarchy i.e. product. I have defined a measure called closing stock with aggregate function being set to
Note: My period dimension is of Type Time
I process the cube and start browsing it using cube browser. I first drag period hierarchy on my rows and measure in data area and it properly shows lastnonempty for that particular year. I remove period
hierarchy and drag product attribute on rows but rather than summing it up it still shows lastnonempty for all products.
Is there something i am missing?
Please let me know.
View Complete Post