Skip to Content
0

SAP BPC 10.1 NW - Overflow converting from error

Apr 16 at 01:35 AM

28

avatar image

Hello,

We are facing issue while loading transaction data from BW to BPC for some currencies such as JPY, VND, IDR where key figure length is flowing with more than 13 digits before decimal.

Line0 :Overflow converting from ' 15760676734944.0000000 '

Note : We are already on production and not sure what impact it will have if we modify the Model to large keyfigure.

Can you please help me best possible way apart from increasing Key Figure Length

Thanks & Regards,

Ravi

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Apr 16 at 07:52 AM
0

1. Why not to use large keyfigure? It's a supported approach!

2. You can divide figures on load using conversion file.

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

Hello Vadim,

Considering your options as suggested

1. I should follow below 2 SAP Notes for enabling large key figure. Am I correct?

1829297 - Large Key Figure support for Planning and Consolidation 10.0

1896651 - How to remove old Key Figure from BPC Model

I am only concerned in removing old key figure as we are already on Production and do not want much impact on the system. Also the note 1829297 talks about potential impact on reporting & script logic

2. I am comfortable in using conversion logic to load data Only question how should I correctly show in BPC EPM Reports?

Thanks & Regards,

Ravi

0

1. The procedure is clearly defined! For sure you have to perform full test and test script logic (switching ABAP/JS)

2. Strange question - if you divide values on load the in the reports you will have divided values: for example not JPY but 100 JPY

0

Hello Vadim,

I was thinking for few set of currencies such as IDR,VND,JPY I setup a logic in conversion file putting the formula as "VALUE * 0.01"

But if I needed to show correct values in report , what logic I need to develop to again multiply by 100

Please guide me on this

Thanks & Regards,

Ravi

0

"But if I needed to show correct values in report , what logic I need to develop to again multiply by 100"

Sorry, you can't multiply values in the cube - will get the same overflow error!

In the report you can multiply using Excel formula, but it's not a good idea!

0