Report Portal

MDX-How to use the Filter function in a SCOPE statement

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;

Tags: mdx, faq

 

2007-2015 VidasSoft Systems Inc.