Home Forums Data Warehousing Analysis Services Values in refence currency calculation - Performance problem RE: Values in refence currency calculation - Performance problem

  • Hi yayomayn,

    thanks so much for your useful answer.

    Both references were very hepful. At the end I implemented something like this and it works correctly:

    CREATE MEMBER CURRENTCUBE.[Measures].[Gross Sales Euro] AS [Measures].[Gross Sales Local Currency]*[Measures].[Exchange Rate To Euro];

    SCOPE

    (MeasureGroupMeasures("Sales"), Leaves([Time]), [Currencies].[ISO Code].[ISO Code]);

    [Measures].[Gross Sales Euro] = [Measures].[Gross Sales Euro]* ValidMeasure([Measures].[Exchange Rate To Euro]);

    END SCOPE;

    That is just an adaptation from Mosha´s article.

    I tried also to implement a measure expression as Crhis Webb proposed, but my data model is not exactly the same one. My Sales measure group is not directly related to the same Time dimension as the exchange rates, instead I am using the linkmember function inside a calculated measure. I've read in the book "Expert Cube Development with SSAS Multidimensional Models" that "The MeasureExpression expression is evaluated before the calculations in the MDX Script are evaluated".

    Kind Regards,

    Paul Hernández