sap bpc business rules

[Former Member]

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

[former_member186338]

Please read help here:

https://help.sap.com/http.svc/rc/saphelp_bpc10_nw/10.0.23.0/en-US/4c/33574835c520d4e10000000a42189b/...

Look on RATE_PERIOD property...

[Former Member]

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

[Former Member]

Hi All,

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

[Former Member]

Hi Vadim,

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

[former_member186338]

Just from the document you already read:

"The OPENING value of any rate can also be specified adding the prefix “OPE” to the rate
itself.
Examples: [OPEEND] - [END] , [OPEAVG]
These OPENING rates do not need to exist in the RATE cube. For example, if there is an
[END] rate, the currency translation will also automatically recognize a rate called [OPEEND],
which simply corresponds to the [END] rate of the OPENING period (typically last period of
last year)"

[former_member186338]

By the way, if you have PERIODIC model why do you use "Periodic Calc"?? It's for YTD model

[Former Member]

Hi Vadim,

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

[former_member186338]

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!

[former_member186338]

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%20Tran...

And compare with your settings!