How do I compress an Infocube Using ABAP?

[former_member381836]

I load information to an infocube using Function Module RSDRI_CUBE_WRITE_PACKAGE. Part of my requirement is that the program may be executed again later on, and that some records that were previously inserted are no longer necessary and will be deleted

I see one out of two solutions:

1) Overwrite the record that I want to delete with a 0 value and compressing the cube

Problem: I haven't found a function Module that would allow me to compress the cube.

2) Deleting the record altogether:

Problem: I haven't found a Function Module that allows for the deletion of records.

My system is Netweaver 7.5 and BW 7.5 on Hana.

Does anyone know a program or class or anything that could help me?

Thank you.

[FCI · Accepted solution]

The function module RSCDS_CONDENSE_CUBE can be used to compress a cube, the RSDRD_SEL_DELETION to do a selective deletion on a cube.

Regards,

Frederic

[erdempekcan]

Hi,

Instead of running the program directly, you may run it within a process chain.
Then you can use the standard compress variants.

[matt]

And you can trigger the chain to run from ABAP.

[raymond_giuseppi]

You could also look at class CL_RSCDS_COMPR.