avg mdx in sql 2012. Has it changed?
Posted on 2015-02-10
I had the following calculation in SQL 2008R2 cubes:
(([Measures].[Activity Count],[Age].[Hierarchy Adult - Child Age].[All].[Age 0-18])/AVG(Descendants([Date From Source Data].[Fiscal YQM].currentmember,[Date From Source Data].[Fiscal YQM].[Fiscal Month Name]),[Measures].[0-18])) * 1000
It doesn't seem to be working in SQL 2012, and whether the AVG is the problem or not I dont know yet. Is anybody aware that the AVG mdx function has changed in any way? It is red squiggle underlined in the mdx editor in the SSAS design time interface in SQL Server data tools. This makes me think that there is something that has changed but there are a few other elements that I need to check too.
If anyone knows anything about this any info would be gratefully received.