Zero supression at the cube level

[Former Member]

Hello,

We are looking for an option to delete the zero rows from the cubes, but with no compression of the cube.

Is there a way to perform this task?

Selective deletion is based on characteristics, not on keyfigures, and I could not find any function module to do it.

Does anyone has experience on this topic?

Thanks.

Kind regards

Begonia

[former_member186775 · Accepted solution]

Hi,

for START routine for update rules u can write ABAP code,or

elseIt is not "Deleting cube contents with update rules" It is

only possible to avoid that some content is updated into

the InfoCube using the start routine. Loop at all the

records and delete the record that has the condition. "If

the open order quantity was 0" You have to think also in

before and after images in case of a delta upload. In that

case you may delete the change record and keep the old and

after the change the wrong information

regards,

manjula

[Former Member · Accepted solution]

Hello,

Thanks very much for your help.

Our case in a BCS cube, and we would like to delete the zero row contents. So we would need to change the cube to loading procedure. If we are running this once, with full load it would be enough.

I would say is OK, but would like to confirm with you if your solution also applies to real time cubes.

Thanks again.

Kind regards

Begonia