Adding Currency Conversion - Expert Cube Development with SSAS Multidimensional Models - page 195

The data model that we're going to use is the same as in the previous scenario.
We'll also makes the same selections in the wizard until the Select Conversion Type
page, where we have to choose the Many-to-many option. The next step will be the
Define Local Currency Reference page, and after that will be the Specify Reporting
Currencies step, just the same as in the first scenario.
The MDX generated is a combination of that seen in both the previous scenarios:
SCOPE ( { Measures.[Amount]} );
SCOPE( Leaves([Date]) ,
[Reporting Currency].[USD],
Leaves([Currency]));
SCOPE( { Measures.[Amount]} );
THIS = [Reporting Currency].[Local]
* Measures.[Rate];
END SCOPE;
END SCOPE; // Leaves of time and non pivot currency