Report Portal

MDX-How Can I define SCOPE statement for all but one measures in one measure group

Q: How Can I define SCOPE in MDX for all but one measures in one measure group?

A: You can use function MeasureGroupMeasures() and subtract set of measures that should be excluded.

Example:

SCOPE(MeasureGroupMeasures("Internet Sales") - {[Measures].[Internet Tax Amount]});
This = ...;
END SCOPE;

Tags: mdx, faq

 

2007-2015 VidasSoft Systems Inc.