Zero suppression doesn't work

[former_member199630]

Hi,

We are having an issue with the zero suppression.

We have done a simple query with Material and Price in Columns, and Calmonth in rows.

We want to suppress the zeros, but it is not working if we let the Material in columns (example 1).

If we change the drill down for Material, and we put in rows, the zero suppression is working fine (example 2)

EXAMPLE 1
		Price
Material	A123	A432	B564
Calmonth	
10.2010		0	15	55

EXAMPLE 2

Calmonth	Material 	Price
10.2010		A432		15
		B564		55

The suppression is configured in query designer for rows, columns and structures.

This is happening in Analyzer and thru RSRT, but if we execute the query thru the web (portal) it works as expected.

What do you think it could be happening?

Thanks in advance, Federico

[Former Member · Accepted solution]

Drill down the material first and then price and then check as shown below.

ensure column suppression switched on in QUERY designer.

Material A123 A432 B564

Price Price Price

Calmonth

10.2010 0 15 55

[former_member199630 · Accepted solution]

Hi,

Thanks for your answer. I have tested both ways and the column with zero is still being showed.

Any other idea? Could a condition break the zero suppression?

Regards, Federico

[former_member189638 · Accepted solution]

Did you try creating a Condition in the query? You can create it as below and check if it works.

Key Figure = Price

Operator = greater than

Value 0

[former_member199630 · Accepted solution]

Hi Rakesh,

I already have a condition for a hide column with KF. Could it be the reason why it is not suppresing the column? Because if I see the overall resul there is a number, for other month there is money for Material A124, but the condition (that works perfect) makes the month doesn't show. Anyway if I put the material in rows the suppression works, but not in columns.

EXAMPLE 1
		Price
Material	A123	A432	B564
Calmonth	
10.2010		0	15	55
Overall		10	25	55		
 
EXAMPLE 2
 
Calmonth	Material 	Price
10.2010		A432		15
		B564		55

Regards, Federico

[former_member199630]

Resolved for me. I use structure on rows.

Regards, Federico