Report Portal

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

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

A: Use <FromDimMember>:NULL. Example:

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

Tags: mdx, faq

 

2007-2015 VidasSoft Systems Inc.