Skip to Content
0
Jan 08, 2018 at 03:34 PM

SAP Analysis for Mircosoft Office Value was either too large or too small for a decimal

469 Views

Value was either too large or too small for a decimal

I have encountered the same problem as in

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

and I also read Note

1798805 - Datacell with a very large value

https://launchpad.support.sap.com/#/notes/1798805/E

and the problem should be solved

but with Analysis 2.2.2.55076 on

BEX Query BW 7.4 SP 09

we have the same problem with really big numbers.

RSRT/ Bex Analyzer is working but with Analysis for Office I get

Value was either too large or too small for a decimal

cusersmz10520analysis-error.jpg

When I devide the big numbers within Query Designer in order to get them smaller everything is fine.

Does anybody has a solution?

Thank you very mucch

Best regards

Michael Wecker