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

  • Greetings to my namesake!

    The links are enough help, so please do not say sorry.

    The first one was not exactly my case, I implemented a many-to-one and not a one-to-many currency conversion.

    The second one was the key to rewrite my code:

    SCOPE ([Measures].[OOHB Net Sales Value EUR]);

    SCOPE ([Time].[Date].Members, [Currencies].[ISO Code].[ISO Code]);

    this = [Measures].[OOH Bookings Net Value]* ValidMeasure([Measures].[Exchange Rate To Euro]);

    END SCOPE;

    END SCOPE;

    Then I do not feel like the Captain Caveman for a few hours.

    Regards,

    Paul Hernández