What Is The Purpose Of [Reporting Currency].[Local] ?

Hello,



Below is the many to one currency conversion MDX query generated by BI wizard. I am having hard time understanding the purpose of [[Reporting Currency].[Local]. Can anyone explain, why do we need [Reporting Currency].[Local], how does it work in the conversion and where are the relationships established between [Reporting Currency].[Local] member and other measures/dimensions? Thanks.



// This is the Many to One section

// All currency conversion formulas are calculated for the pivot currency and at leaf of the time dimension

Scope

(

{ Measures.[Internet Sales Amount], Measures.[Reseller Sales Amount]} );

Scope( Leaves([Date]) ,

[Reporting Currency].[USD],

Leaves([Destination Currency]));



// Convert Local value into Pivot currency for selected Measures that must be converted with Measure rate [Average Rate]

Scope( { Measures.[Internet Sales Amount], Measures.[Reseller Sales Amount]} );



This = [Reporting Currency].[Local] * Measures.[Average Rate];

End Scope;



End Scope;



// This is the One to Many section

// All currency conversion formulas are calculated for the non pivot currency and at leaf of the time dimension

Scope

(

Leaves([Date]) ,

Except

(

[Reporting Currency].[Destination Currency Code].[Destination Currency Code].Members,

{

[Reporting Currency].[Destination Currency Code].[Destination Currency Code].[USD],

[Reporting Currency].[Destination Currency Code].[Destination Currency Code].[Local]

}

)

);



- SB.