CVC deletion in Cube

[Former Member]

My client has requested me to develop a custom program where he can delete the CVC from a APO cube which has zero sales.

I thought of going thru selective deletion but this is risky as there might be a case where the same CVC might have some sales in it.

Is there is any report available in APO where I can delete only CVC with 0 sales without affecting the same CVC which has sales in it.

Need your inputs.

[Former Member · Accepted solution]

Hi,

You may need to write a custom program which will add the data by considering all CVC's level and if sum is 0, delete that records.

Regards,

Sachin

[Former Member · Accepted solution]

Thank you for your inputs.

Darpan.

[Former Member]

Hi,

Another solution could be to build a DSO (or cube) which is fed from the sales cube. Within the transformation rules, you can stop records from entering the new DSO (or cube) using some ABAP logic.

This way you can then create CVCs from the new DSO (or cube) without removing the original records from the sales cube.

Regards,

Ali

[Former Member]

Thank you for your inputs.

Darpan.