Time Dimension Attribute Types

No results returned when executing QTD(), Rolling Sum, Rolling Functions.

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


Please sign in to leave a comment.