Report Portal

MDX-How to create a SCOPE statement based on the Member property

Q: Can you create a SCOPE based on the Member property?

A: Yes you can, example 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.