Analysis for Office - Integrated Planning - How not to trigger save?

[Former Member]

Hi all,

I have a simple question and I could not find an answer in the posts I found.

I want to check the data integrity of an Analysis for Office input ready report.

I have the below table:

Calmonth	01.2015
Key Figure 1 - Automatic	20
Key Figure 1 - Direct input

And if the user enters -21 and press the "Save Data" standard function, I want to cancel this action (in VBA if possible).

I am able to get the value of the kf1 and kf2 and to compare them. I just need to know if I can cancel the Save or Recalculate actions.

Is there any body who could help me?

Thanks a lot!

[Former Member · Accepted solution]

Hi Folks,

for those who would have in the future the same issue or need. I could not figure out how I could handle this.

So I used a workaround which works fine:

I implemented the VBA function in my Worksheet: Private Sub WorkSheet_Change(ByVal Target as Range)

1. This function detect the entered value and compare it to the above value
2. If the sum of both values leads to a negative error, I trigger an VBA error message, do a step backward in the IP Steps and highlight the cell in red (the functions which you could use can be found here: http://help.sap.com/businessobject/product_guides/AMS21/en/21_analysisplugin_user_en.pdf

I am keeping on searching for the function which would allow me to disable the save data button so if you have any input.. feel free.

Cyril.