Structure - suppress zero rows

[Former Member]

Hi BW people,

I found very similar topics on this forum concerning suppressing zero rows in structures but not exaclty the same case nor an answer.

<u><b>Query</b></u>

I have a structure in the rows with several selections (S1, S2, S3) and beneath that structure a characteristic. To keep it simple: there is only one key figure in the columns.

<u><b>Aim</b></u>

I would like to have the <i>non-zero</i> key figure for all materials (M1, M2,...) for each selection in the structure.

So it should look like this:

S1   M1   50
S2   M2   100
S3   M3   90

Unfortunately I get this:

S1   M1   50
S1   M2
S1   M3
S2   M1
S2   M2   100
S2   M3
S3   M1  
S3   M2   20
S3   M3   70

So, even if the key figure for M2 and M3 (for selection S1) is zero, it is shown because these materials have a non-zero key figure elsewhere in the selection.

<u><b>Condition</b></u>

I tried about every possibility of 'conditions', but again the same problem: they are evaluated on the whole structure AND material, and not on every separate line of the report.

Anybody a solution? I would be grateful as I have tried quite a lot of work arounds.

Thanks in advance!

[Former Member]

oK better explanation :

Try in this case to apply conditions on your report this should solve your problem..

Alain

[Former Member]

Dear Alain,

I am very sorry, but conditions do not work on the structure. Have you tried this in practice?

Isn't here anybody from SAP who just can confirm whether it this is possible or not?

This issue is taking a long time... strange it does not work out.

Thanks anyway people!

[Former Member]

Hi Bart,

Alain is wrong that you can't hide structure if it has zero values. I have done this in my last project. Solution is already posted by Rob and GSM. Actually you need to do both the settings to hide zero row and columns. First goto query properties select to hide zero row and column ( Check 'Suppress Zero Columns/Rows' in your case). Then goto structure, right click and check the allow suppress zero check box. It worked well for me.

Regards,

RB