SAP BPC 10.1 NW - Overflow converting from error

[Former Member]

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

[former_member186338]

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

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

[Former Member]

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

[former_member186338]

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

[Former Member]

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

[former_member186338]

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

[Former Member]

Hello Vadim,

Is it good way to make changes in reports using custom number formats to multiply the value by 100 in reports?

https://archive.sap.com/discussions/thread/3908630

Please suggest your views

Regards,

Ravi

[former_member186338]

"Is it good way to make changes in reports using custom number formats to multiply the value by 100 in reports?" - no, it's a wrong way! It will increase report complexity and you will be not able to create some reports.

And you can do nothing with input forms 🙂