Interview Preparation mode beta
Funny Facebook Status Funny Facebook Status
Enter your email address

Can you use the Filter function in a SCOPE statement, in MDX query?

Nice?Vote!

1 Answer

Nice?Vote!
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;
answered 1 year ago by R (19,530 points)

Related questions