Skip to Content

Analysis for office - disaggregation not possible

Feb 07 at 12:26 PM


avatar image
Former Member

Hi experts,

we have follwing error in workbook in Analysis for office (S4/HANA):

"Disaggregation not possible. No reference data found."

It happened when user tpyed in amount for overall result, then deleted it and typed it in single line.

Does the analysis for affice has some cache to store this overal figure for allocation?

Steps to replicate the error:

1. amount was typed in yellow area for overall result (not saved)

2. amount was deleted from yellow area

3. new amount was typed in green area

4. value was saved by the VBA code and button "calculate and save".

5. error pop-up.

error.jpg (57.4 kB)
workbook.jpg (23.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers