In SSAS 2000, I have 2 time dimensions;
- Financial Period (Time type) = Year --> Month (with no "All Member")
- General Period (Time type) = Month (with "All Member" being captioned as "Year Total")
YTD Actual = SUM(YTD(), Measures.Actual)
The idea is to have all years on row and all general months on column for YTD measures. The above YTD calculation is only working for
Financial Period and not for General Period .
Pretty easy to do it in SSAS2008 with scoping but how do I do this in SSAS2000 environment?
Can you please help?
Thasnks in advance.
View Complete Post