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;