You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register

    • currency conversion in EPCM

    in Profitability and Cost Management

    Summary:

    I’m using the following currency conversion rule to calculate data in AUD_Reporting for Input, Allocation In, and Allocation Out data. However, it takes too long to process, forcing me to terminate it manually:

    AUD_Reporting:= ([AUD], [PCM_Rule]) + ([GBP], [PCM_Rule]) * ([GBP], [PCM_NoRule], [PCM_Input], [No Entity], [No Product], [No Project], [FX Rates Average], [No Cost Centre]) + ([USD], [PCM_Rule]) * ([USD], [PCM_NoRule], [PCM_Input], [No Entity], [No Product], [No Project], [FX Rates Average], [No Cost Centre]);

    To optimize it, I used NONEMPTYTUPLES, which significantly improved performance, completing the calculation in seconds:

    AUD_Reporting:= NONEMPTYTUPLE ([AUD], [PCM_Rule]) ([AUD], [PCM_Rule]) + ([GBP], [PCM_Rule]) * ([GBP], [PCM_NoRule], [PCM_Input], [No Entity], [No Product], [No Project], [FX Rates Average], [No Cost Centre]) + ([USD], [PCM_Rule]) * ([USD], [PCM_NoRule], [PCM_Input], [No Entity], [No Product], [No Project], [FX Rates Average], [No Cost Centre]);

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!