I'm building an SSAS OLAP cube on Meteorological data. Some of this data can be totaled (eg rainfall) and some can't (like wind direction).
I want totals, but only on data sources where it makes sense. (Where the interpolation method = 3.)
I've tried adding SCOPE with this:
SCOPE ([Measures].[Total]); SUM([Data Source].[Interpolation Method].&,[Measures].[Total]); END SCOPE;
And get warnings:
Invalid query syntax. A valid MDX or DAX query was expected
One or more errors were encountered in the MDX script
What am i missing?