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]

Hi,

Try this...

If you have only one keyfigure I mean if your problem exactly how you have described then

Goto Query Properties->Display Tab->Suppress Zeros section

Choose Suppression = Active and Effect On = Rows then it should give you

S1 M1 50

S2 M2 100

S3 M3 90

GSM.

[Former Member]

Hi Rob and GSM,

Thank you for your help.

Rob, I already tried your solutions but it didn't work.

GSM, also your solution did not bring a solution as far as I was able to test it: what do you mean with 'Suppression=Active' and 'Effect On = Rows'? Are you working with BW3.5? I tried the 'Number Format' section: 'Suppress Zeros' in the drop down and checked 'Suppress Zero Columns/Rows'. I tried both (checked/unchecked), but without a good result.

I hope somebody can help me. Very important as a lot of Materials with zero's are shown.

Tank you

[Former Member]

Hi,

On query properties screen, Below Number Format section there is a section called 'Suppress Zeros'. In this section it has two dropdowns 1, for suppression and 2, effect on.

Choose suppression value = active

Choose Effect on value = Rows.

First consider this,

Currently for 0 value records system is not showing 0 values rather it is showing blank values. User might be willing to keep all the records if the record shows zero values than blank values on keyfigures.

For this you can create a new formula keyfigure in the structure by giving a condition.

(KF1 > 0) * KF1 and use this keyfigure in your query output. It displays 0 in place of blanks.

After you create this formula keyfigure, then test your query against

Choose suppression value = active

Choose Effect on value = Rows.

Make sure you have only one keyfigure in the result view.

GSM.

[Former Member]

Hi Sri

I read this post however;using (KF1 > 0) * KF1 still gives me blank and doesnt give me 0 value.

can you please guide me through exact steps and properties for it.

thanks

Bill