SSAS Calculated measure with SCOPE.

2 votes

2 answers

4988 views

ssas mdx ssas-2016

                          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

and: 

> One or more errors were encountered in the MDX script

What am i missing?

Asked by Sir Swears-a-lot (3253 rep)

Nov 2, 2016, 12:14 AM
Last activity: Nov 2, 2016, 10:43 AM

SSAS Calculated measure with SCOPE.

Related Questions