Skip to Content
0

sap bpc business rules

Mar 27, 2017 at 01:59 PM

138

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

6 Answers

Vadim Kalinin Mar 27, 2017 at 02:29 PM
0

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!

Share
10 |10000 characters needed characters left characters exceeded
Wang Men Chun Mar 27, 2017 at 02:38 PM
0

Hi Vadim,

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

Show 1 Share
10 |10000 characters needed characters left 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!

0
Wang Men Chun Mar 27, 2017 at 02:51 PM
0

Hi Vadim,

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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)"

0

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

0
Wang Men Chun Mar 28, 2017 at 01:38 AM
0

Hi All,

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

Share
10 |10000 characters needed characters left characters exceeded
Wang Men Chun Mar 29, 2017 at 11:50 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Mar 29, 2017 at 03:10 PM
0
Share
10 |10000 characters needed characters left characters exceeded