cancel
Showing results for 
Search instead for 
Did you mean: 

Saving blank in input ready cell through IR Query

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

gerd_schoeffl
Advisor
Advisor
0 Kudos

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

Answers (3)

Answers (3)

gregor_kolck
Participant
0 Kudos

The modification for analysis item should do this.

com.sap.ip.bi.ReplaceDataCellWithZero

                <bi:ANALYSIS_ITEM name="ANALYSIS_ITEM_1" designwidth="400" designheight="200" >
                    <bi:DATA_PROVIDER_REF value="DP_1" />
                    <bi:MODIFICATION type="CHOICE" value="MOD_MODULE_LIST" >
                        <bi:MOD_MODULE_LIST type="ORDEREDLIST" >

                            <bi:MOD_SINGLE_MODULE type="COMPOSITE" index="1" >
                                <bi:MOD_ALIAS value="SET_COL" />
                                <bi:ACTIVE value="X" />
                                <bi:MOD_SELECT type="CHOICE" value="MOD_GENERIC_MODULE" >
                                    <bi:MOD_GENERIC_MODULE type="COMPOSITE" >
                                        <bi:MOD_REFERENCE value="com.sap.ip.bi.ReplaceDataCellWithZero" />
                                    </bi:MOD_GENERIC_MODULE>
                                </bi:MOD_SELECT>
                            </bi:MOD_SINGLE_MODULE>
                        </bi:MOD_MODULE_LIST>
                    </bi:MODIFICATION>

                </bi:ANALYSIS_ITEM>


Gregor

former_member210674
Participant
0 Kudos

Hi Shweta,

It is not possible to save blank as Zero. Also it is not logically correct as per IP delta functionality

In IR Query what we enter will remain in buffer (memory allocation area) till we save the data. So all data will be saved in database(InfoCube) through buffer only. We can not delete any data in database. Instead we can create a reversal record through buffer. But buffer surely require some value to create a reversal record.

Regards,

Gopi R

Anand71
Active Contributor
0 Kudos

Hello,

May be you can try this option:

Thanks.

With regards,

Anand Kumar

Former Member
0 Kudos

Dear Anand, this setting works only for not input ready queries. In an input ready query you will always see 0 in the input ready cell.

@ Shweta, unfortunately there is no way to make the query understand that blank = 0. I have had the same issue with blank = #. However, if you find a way, feel free to share