MDX-How Can I define SCOPE in MDX for all measures in multiple measuregroups?
Q: How Can I define SCOPE in MDX for all measures in multiple measuregroups?
A: You can use multiple functions MeasureGroupMeasures() that are separated by commas. You have to enclose this into curly brackets:
Example:
SCOPE({MeasureGroupMeasures("Internet Sales"), MeasureGroupMeasures("Internet Orders"), MeasureGroupMeasures("Internet Customers") });
This = ...;
END SCOPE;