Report Portal

MDX-How do you specify SCOPE For Dimension to include all members before certain member

Q: How do you specify SCOPE for a Dimension to include all members before a certain member

A: Use NULL:<ToDimMember>. Example:

SCOPE(NULL:[Date].[Calendar].[Calendar Quarter].&[2003]&[3]);
This = 100;
END SCOPE;

Tags: mdx, faq

 

2007-2015 VidasSoft Systems Inc.