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

When you use a Structure it always display all values even if there is no Key figures available for each value.

To avoid these lines with 0 use a filter in the query instead of Structure.

That's why this is called Structure !!

REgards

Alain

[Former Member]

Hi Alain,

Thank you for your reply.

What you are saying is that it is not possible with structures to hide every single row that has al key figures equal to zero?

What do you mean by 'filter'? If you mean the filter area in Bex Analyser, I am afraid this is not possible. I give you a simple example (not the real case) to describe the aim in more detail:

S1 has description 'cars - yellow' and is a selection of

- 0PRODUCT = "CARS"

- 0COLOR= "YELLOW"

S2 has description 'cars - others':

- 0PRODUCT= "CARS"

- 0COLOR= ]"YELLOW"[

S3 has description 'other vehicles":

- 0PRODUCT = ]"CARS"[

What I want to make some things clear:

- the selections are necessary because we want to define the description in the report of every selection ourself (not the medium text of the characteristics nor text variables)

- we can not use only filters because the filter restricts ALL data, while the restriction on color depends on the group(selection) in the structure.

I hope you know what I mean. This is really a brainbreaker.

I managed to filter the right rows in 1 selection of the structure, but the problem is that the hidden materials (M2 and M3 in the example at top of the post) are hidden in the other selections even if they are not zero in S2 and S3.

I am VERY curious if someone can solve this problem...

Thank you already for your help.

Best regards,

[EDIT]

Alain,

I was writing this post at the same moment you were sending your last reply.

Your second suggestion would be OK if the selection was only containing one characteristic to restrict on. But the selections have 3 characteristics that have to be restricted. And not all values of the characteristics are used... So just all characteristics in the rows en restricting on the desired values is not enough as he will combine them to n x m relationships for which the key figures are not zero.

[/EDIT]