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

After clicking on Finish , we can see that the wizard has created a Reporting
Currency dimension, which has been added to the cube and has no relationship
with any measure group as we can see in the following screenshot:
It might seem strange that now we have two Currency dimensions. However, there
is a good reason for this: it's the way it supports the requirement to be able to allow
only some currencies to be used for reporting purposes.
If we don't need the filter on available currencies provided by the
Reporting Currency dimension, we could simplify the structure
of the cube by using the original Currency dimension instead
(although this would also require some modifications to the MDX
Script generated by the wizard).
To make the Reporting Currency dimension work, the wizard adds a section of
MDX code to the Script, similar to what's shown as follows:
// All currency conversion formulas are calculated for the
// non pivot currency and at leaf of the time dimension
SCOPE ( { Measures.[Amount]} );
SCOPE( Leaves([Date]) ,
Except(
[Reporting Currency].[Currency].[Currency].Members,
[Reporting Currency].[Currency].[Currency].[USD]));
SCOPE( { Measures.[Amount]} );
THIS = [Reporting Currency].[Currency].[USD] /
(Measures.[Rate], LinkMember(
[Reporting Currency].[Currency].CurrentMember,