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

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!