Delete non cumulative key figure values from a cube

[former_member206066]

Hello Experts,

I need to Delete non cumulative key figure values from a cube.

I have done selective deletion based on plant from that cube but after deletion when I am loading again with same plant ,

that non cumulative key figure value is not showing correctly.

It is summing the new value with old value(previous selective deletion was successful ).

Please help, how non cumulative key figure value can be deleted ??

Thanks,

Ipsita

[Dominik_Graus]

Hello Ipsita,

How did you run the selective deletion? With plant only or restrictions on other characteristics like time too?

Which release and support package are you using?

See https://wiki.scn.sap.com/wiki/display/BI/NCUM%3A+Selective+Deletion

Regards,
Dominik

[FCI]

Hi Ipsita,

Are you familiar with the reference point of non cumulative cubes ? The reference point aggregates all the data at a given time. This reference point is stored in the cube with a particular date (99991231 ? can't check right now).

I guess you did a selective deletion on the "movements" and not on the reference point. This will give the behavior you described.

IMHO, the best way to delete records on non cumulative cubes is to load into the cube the opposite image of what you want to delete (+2 -2 = 0).

Regards,

Frederic

[former_member206066]

Hello Frederic,

Thanks for the information.

I have done the selective deletion on plant, now how can I permanently delete the old data for that specific plant and reload.

Please help.

Thanks,

Ipsita

[FCI]

This is suprising. If you did a selective deletion on a whole plant, everything should have been deleted (reference point included).

See note 2891757.

[john_hawk]

Hi Ipsita,

You can only selectively delete by a characteristic, not a key figure.

The only way I know would be an SQL command at the database level.

John Hawk