Problem:
No results returned when executing QTD(), Rolling Sum, Rolling Functions.
Solution:
MDX Rolling Sum and Rolling Average function only supports dimension attribute type - Years, Quarters, Months, and Weeks. It does not support type - Fiscal Year, Fiscal Quarter, etc. The above example's Fiscal Quarter used attribute type as "Fiscal Quarters"; therefore, the MDX rolling function failed to return results.
Wrong data type - Fiscal Quarters
Correct data type - Quarters
0 Comments