Reading ZERO values in BPS

[Former Member]

Hi everybody,

There's some way to read a register with all key figures equals to zero with bps, without adding one "dummy" key figure?

Thanks,

Marcel Will

[Former Member]

Marcel,

Zero values in BPS could be one of 2 things:

1. lack of record / value against this specific combination.

2. sum of the values for the KF is zero. If you delete a record, it does not actually delete it but create the offset to bring it to zero. If you compress it with zero elimination, then that record would be removed.

Basically, there is no easy way to do it and if you use a dummy key figure such as being used for UPX_MNTN, it would create the record but the KF may eventually be populated and BPS would not kept track of that.

Hope this helps,

Mary

[former_member195980]

I'm not sure wheter data with zero values out of the InfoCube is shown. But you could try to set the layout (enhanced options in the first step) to show all combinations instead of existing data out of the cube.

Regards,

Beat Stoller