Can you create a SCOPE based on the Member property?

Answer 1

Yes you can, example below.

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

Comments

Hi
While I agree with the above answer, I would recommend not using properties here. Because of 2 reasons.

1) when multi select parameters options are used, this may fail (depending upon the OLAP client).
2) Not recommended from performance point of view.

So I would recommend converting Month of Year as attribute and define the scope as below.

SCOPE ([Date].[Calendar].[Month of Year].[January] );
Measures.[Amount] = 10;
END SCOPE;

Thanks,
Ashok Kumar Dugaputi
http://dugaputiashok.blogspot.com/