Transaction Data query

[Former Member]

Hi Experts,

I have following questions related transactional data which I want to know :

1. If someone entered the wrong data then rather than deleting in cube by RSA1 what is the other method by which Particular entry can be deleted?

What end user can do to revert the wrong data?

2. I deleted the BW cube data which is empty but still when I open an Input form I can see data in that and if I refresh it shows no data but whenever I open the form it shows data in it. So how to resolve this .

3. In BPC ,script logic do we need to use any CLEAR statement to remove unwanted data ?

Please guide me on this how we can do .

Thanks

Natasha

[andrewdiaz2000]

Hi Natasha,

In BPC there is nothing like deleting records if we have to look at it from end user.

he can only zero the signeddata value. so it all depends on how conveniently you would like to give your customer to zerorize the records. it can be either through script logic or BADI or through report or clear package or any other better option you can think of.

Regards,

Andrew.

[Former Member]

Hi Natasha,

Please find my answers to your questions:

1. In lot of customer projects, the authorization to execute the clear package is not with the end users. If this is the case in your project, then the end users need to use the input form to make the necessary changes in the data.

2. Not very clear with the problem. Please explain.

3. There is no keyword for doing it. However, you can use *REC statement to post a value of 0. This is similar to clearing.

Please note that any clear mechanism will post the negative value, as Bishwajit has explained. And you will need to optimize. However, there are certain things to remember:

1. Optimization doesn't not remove the 0 records, unless you have the zero elimination checked in your process chain.

2. Zero elimination cannot be done if you have compressed the cube in BW.

Hope this helps.

[bishwajit_das]

1. To delete any entry from BPC cube, there is a standard CLEAR package to use.

2. Even after deleting the data from the cube, if you find the input forms showing data.

    Refresh the input form which will show no data -> SAVE the input form once again so that when ever     you open next time, it will show no data.

3.  No, in BPC script logic there is nothing called CLEAR statement.

Thanks

Bishwajit Das

[Former Member]

Ok Can you Please help me in understanding that suppose I have already loaded some etnries which is in BW backend of BPC and if I run agian the clear package would those entries get deleted? Is there any way that I can delete particular entries from my cube?

Please guide

natasha

[bishwajit_das]

Say for example you have one entry in BW backend of BPC as

Dimension1     Dimension2      .....     Signeddata

    A1                    B1                           10

Now you run CLEAR package for the record then an entry will be added and the result would be zero...

Dimension1     Dimension2      .....     Signeddata

    A1                    B1                           10

    A1                    B1                          -10

So it will show as zero value when see in BPC..

Still if you want to completely remove these entries, you have to optimize you cube or you may delete from the BW backend(delete option is not preferred).

So this is what happens...wish you got your answer.

Regards,

Bishwajit