Saving blank in input ready cell through IR Query

[Former Member]

Hi,

My Question is regarding saving blank values in an input ready cell.

I have built an input ready Query, which works fine, so upon saving value for example KF1 = 30 for Customer = 12345 it does save this value.

Now, when i try to delete this value by selecting and backspace and try to save, the value (30) reappears.

At the same time, when i plan a value zero (0) instead this works fine.

I understand that logically a blank cannot be saved for a Key figure that is why when we delete or wipe off the key figure value it does not save, is there any backend settings where we can specify that when the value is deleted (i.e. if the KF is left blank) this value should be treated as zero?

Thanks,

Shweta Salpe

[gerd_schoeffl · Accepted solution]

Dear All,

You stumbled accross a quite unknown feature in BW-IP in BEx Web...

If you are in BEx Analyzer or Analysis for Office and hit the backspace then Excel makes sure that the value is cleared and a zero is transmitted to the IP backend. As a result the value is deleted in IP.

Now when you are in BEx Web we have a special behavior. If you hit the backspace or the delete button and press transfer values/refresh/save etc. then the system will display the last value the cell had when there was no error in the frontend (and in your case this is just the old value).

If you want to delete a value in BEx Web you have to enter '0' or use a planning function.

Now why is this the case? One example: You have a query that uses the automatic disaggregation:

Charval1     10

Charval2     20

Total            30

Now you change ALL three values. If a value has been changed IP fixes it and calculates the other values leaving the changed on untouched. So as a consequence we are in a deadlock situation as all cells are fixed. If you now try to change one of the cells back top the old value you do not get out of the situation as the other cells remain touched (and thus fixed). How do you get out of this situation? You just go ahead and use backspace on one of the cells...

One other situation is that you might have change a plan value, entered some wrong number but cannot remember the original one. Then you can just go back to the original number by using the backspace (or delete) key.

One remark: If you want to get out of a deadlock as described above and want to go back to the last error free client state in Analysis for Office you can use the menu entry behind the back button in the planning group of the Analysis ribbon.

Second remark: blank = # for characteristic values is a different story. This is actually the correct behavior as '#' is just the external representation of the internal value ' '.

Best regards