Skip to Content
avatar image
Former Member

sap bpc business rules

Hi,

I used sap bpc 10 nw and periodic model.

My configuration for currency conversion such as below:

I can see conversion result from LC tobe USD at SAP BW. But, the calculation is not used my exchange rate figure. And my business rules is simple process.

Question 2:

I wanna use OPECLO formula and BPC did not give result. I have transaction data and exchange rate for 2017.MAR.

Please any advise for my above questions. Thanks

untitled.jpg (19.2 kB)
untitled-2.jpg (27.7 kB)
untitled-2.jpg (27.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Mar 27, 2017 at 02:29 PM

    Sorry, but not clear!

    What do you mean by:

    "But, the calculation is not used my exchange rate figure. And my business rules is simple process." ????

    Same for the second question!

    Please read:

    https://archive.sap.com/kmuuid2/6052a57b-8c64-2c10-b3a5-b0378ff21243/How%20to%20do%20Currency%20Translation%20for%20Financial%20Application%20using%20SAP%20BusinessObjects%20Planning%20and%20Consolidation%207.0%20for%20the%20SAP%20NetWeaver%20Platform

    And compare with your settings!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 27, 2017 at 02:38 PM

    Hi Vadim,

    Yes. I have read it before and I implemented it. I also do not know the calculation result come from.

    Add comment
    10|10000 characters needed characters exceeded

    • Then to get help you need to provide ALL settings you have done and data samples including rates in line with the mentioned document. A lot of places to make error!

  • avatar image
    Former Member
    Mar 27, 2017 at 02:51 PM

    Hi Vadim,

    How about OPECLO formula. I think that BPC will use CLO rate from previous month. Is it correct?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 28, 2017 at 01:38 AM

    Hi All,

    I need a exchange rate value from previous month, could you please inform me for Formula Keywords ?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 29, 2017 at 11:50 AM

    Hi Vadim,

    Please tell me what Formula keyword can use to get exchange rate figure from previous month? For example: I run March 2017 currency conversion. I need Feb 2017 exchange rate figure.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 29, 2017 at 03:10 PM
    Add comment
    10|10000 characters needed characters exceeded