SSAS FAQ MDX FAQ MDX-How to use the Filter function in a SCOPE statement
MDX-How to use the Filter function in a SCOPE statement
User Rating: / 1
PoorBest 
Written by Vidas Matelis   
Wednesday, 28 March 2007 17:52

Q: Can you use the Filter function in a SCOPE statement?

A: Yes you can. Filter function is allowed inside SCOPE function. Example of how you can use FILTER function inside SCOPE function provided below:

SCOPE ( Filter([Date].[Calendar].[Month].MEMBERS, [Date].[Calendar].Properties("Month of Year") = "January") );
Measures.[Amount] = 10;
END SCOPE;

< Prev   Next >
 
Strategy Companion