Dear friends
in my previous post i was told that analysis services 2005 does not suport "custom roll up" and hence misrcosoft had introduced 2 new functions "last non empty and first non empty" for semi additive measures. But whenever im trying to bring the semi additive measure in the browser window of my cube, the cube gets hung and i have to finally close it w/o getting any analysis....please help
To clarify u can take the example of the measure "closing stock" where u want that across time dimesnion it should alwaz return the last member at the year,half year,quarter,month and day level while across other dimensions like product,customer etc it should be the normal aggregation.