Time Dimension Attribute Types

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

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.