Load data from infocube: TSCUBE (zeros)

[Former Member]

The planning area is set to "allow zeros".

Situation: We extract from the planning area to a cube. The planning area key figures distinguish between zeros and initial. This is meaningful for macros. When the data is displayed in the cube.... there are no "initial" values. Everything must have a value or zero.

The problem seems to revolve around the infocube and PSA not distinguishing between zeros / initial. The infocube has zeros for everything and does not contain initial (blanks).

Therefore when the data is brought back into the planning area using TSCUBE; everything without a true value gets zero. Or blank if "ignore zero values" is selected.

Would like the load back into the planning area to be a value, zero or blank. Depending on what was originally extracted to the cube.

Any suggestions would be appreciated.

Thanks,

Paul

[Former Member]

Paul,

We faced the same issue. We had a KF say (KFA)in APO which accepted Zero and Null values, but

when transferred to BI both 0 and NULL will appear as 0.Here is what we did. We added another

TS KF (say KFB). We wrote a mcro to make this KFB = KFA (if KFA >=0) and KFB = -1(if KFA = NULL).

Now instead of extracting KFA we extracted KFB. In our reports we used furtehr logic to identify a "-1"

as a NULL.

See if this or a similar logic works for you.

Regards,

Abhi

[Former Member]

Hi Paul,

Abhi is correct: expect using extra key figure you cannot extract the zero/blank from the planning area to a cube.

However if you are trying to load data from a cube to the planning area it should work. APO can differentiate a "zero record " in a cube and a "no record at all" in the cube.

But you need to ensure that you do have a "no record" in your cube first...

For sure when you have more than one key figure in your cube it start to make things a bit more difficult. You might have to split your cube into multiple smaller one (virtual cube might work here, I am not sure...)

If you still have difficulties, check if the following are relevant for you:

1299609 - /SAPAPO/TSCUBE: Initial and Zero are not differenciated

1316716 - /SAPAPO/TSCUBE: Initial and Zero are not differentiated

1236995 - /SAPAPO/TSCOPY: Initial and Zero are not differenciated

Good luck, and let us know how it goes

Regards

Julien