A Condition in BW Query (BW/4HANA)

[neerajnaik]

A Condition placed in BW Query (BW/4HANA) works fine in Tcode-RSRT(ABAP_BICS) option, but doesn't work well in Tcode-RSRT(Aanlysis for office) option or while running the query directly in AFO.

Any reason for this ambiguous behavior?

Helpful suggestions will be appreciated.

Thank You.

[nachtaktiv]

a simple "...doesn't work well..." is not helpful for us to understand your problem !

[neerajnaik]

Hi nachtaktiv, Thank You for your response. By "...doesn't work well...", I mean the condition even when it is active isn't suppressing the unwanted rows in AFO. But in ABAP BICS option in tcode RSRT it works like a gem.

[andrewdiaz2000]

Hello Neerajnaik,

You mean to say zero Suppression is not set by default when executed in Analysis where as its applied by default in RSRT. 

If this was your question, in AFO you could set it up from Analysis->Display->Enable Properties View. By selecting the Query name in Data Source you will be able to set the value to have zero suppression.