Report Portal

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;

Tags: mdx, faq

 

2007-2015 VidasSoft Systems Inc.