How to create selection variable on a Key Figure

[#1]

Dear Experts,

I have a key figure 'No of Days' in the BEx Query. I need a selection variable which when the users provide the input, should give me the report output where the rows shows only those whose No of days are less or equal to the input value.

I am able to create such a selection out of a Characteristics field but I am unable to create one from a key figure.

Kindly note that we are not using the BW Portal. We are running this report in the webi from a Universe created from the BE Query.I know that it is possible to ceate such a scenario in Webi, but we want the selection coming from the BEx Query for better report performance.

Thanks,

Sai

[Former Member]

Hi,

Even if I multiply by 0 to the other variables if the condition is not met, those rows are appearing in the report output. We don't want to see those rows with zero where the conditions are not met.

We want to see only the rows where the condition is met.

Kindly Help.

Thanks,

Sai

[Former Member]

So now in query output you are seeing data with zeros for all keyfigures right?

Select suppress rows with zeros in query properties