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]

Thanks for the suggestion,

But when I have the zero suppresion, I get a warning message that , the MDX syntax will not recognize the zero suppression.

Since I am calling this BEx query from a webi report, I don't think this will work.

Kindly confirm if there are other options.

Thanks,

Sai

[Former Member]

Hi ,

Post your question under webi forum.. you might get some inputs to handle "suppress records with zeros" in Webi

Regards,

Raghu

Edited by: Raghu tej harish reddy on Jun 23, 2011 11:56 AM

[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

[Former Member]

Hi Experts,

Thanks for the suggestions. I cannot use the 'Condition' since this BEx query is being called from a Webi report. MDX will not recogonize the condition.

I was able to create a Variable and use it in the calculated key figurare. The problem is , I am getting 1 where the condition is met and 0 when the condition is not met. But I want to see only the results where the condition is met. How to to avoid the rows where the result is not met.

Am I getting this because there are actually 3 other key figures along in the query in addition to the key figuare ' No of days'.

Should I add some condition to the other key figuares also.

Kindly confirm and help.

Thanks,

Sai

[Former Member]

You can multipy other key figures with 1 when condition is satisfied and zero when condition is not satisfied.

Regards,

Raghu

[former_member182470]

Hi Sainath,

You have to create a "Condition" on your KF. Select "Variable" for the value to be passed by the user.

Then when the user tries to execute the query it will ask for the value to be entered in your KF. The result will be displayed as per the condition.

Hope this helps.......

Regards,

Suman

[Former Member]

i guess you could create a condtion on the key fig......create a formula variable (input ready, you can create the variable from the conditions definition window itself) and use the less than function.

[Former Member]

I am not too sure about the WEBI part - but why not create the same as a RKF with the same selections using the variable..?