Remove zero value from Query analyzer out put.

[former_member223861]

Dear experts,

I have vendor ageing query in this i have 6 keyfigures

Total,   overdue,   1-30,    31-60,     61-90,       >90

0            0              0          -100       100             0

25           5             0              0          5              0

if you see my first record the total and overdue is zero. records with Total keyfigure  zero should be eliminated.

Kindly guide me on this.

Regards,

Naveen

[Former Member · Accepted solution]

hi Naveen,

put 1-30,    31-60,     61-90,       >90 in a Calculated keyfigure:

add the condition:

((Total AND Overdue > 0 ) * 1-30 )

then if you supress 0 values, it won't be displayed.

rgrds,

Mathijs

[former_member183519]

Hello Naveen,

way1 : Go to query properties:--Value display-  --> Zero value display-- --> then select Zero as space.

way 2 : write a VB macro code at query outlevel level (BEx Analyzer).

Regards,

Hitesh

[former_member223861]

Dear Experts,

For your reference Below I am giving screen shot of my query out put. the Red marked records I don't want to show to Users. Those records should be eliminated.

Regards,

Naveen

[Former Member]

Hi Naveen,

Suppress the zero values is Analyzer level or Keep the condition like 'show the Total values where <> 0 in Query designer.

[Former Member]

Did you read my post? 

[Former Member]

Hi,

Like another user said, create a 'Condition' on 'Total' in query designer.

[former_member223861]

Dear Mathijs,

I have read your post and I am working on your Inputs. Every Solution from experts are important for me. only  for reference I have posted my output screen shot.

Regards,

Naveen

[Loed]

Hi,

In addition to what Mathijs said, you should also do this for suppression to work..Click your structure then UNCHECK the box below..

Regards,

Loed

[KodandaPani_KV]

Hi,

in cube level elimination recrods will work for only inventory cube

but report level it is not possible elimination the vlaues.

any way report is giving 0 values.

Thanks,

Phani.