BEx report controlled based on Key figure value

[Former Member]

Hi Experts,

I have a requirement where the User needs to control the BEx report output based on the key figure value.

For e.g. Initially once the report is executed, it should display the following:

PO Document	Amount
xxxx	0
yyyy	5
zzzz	0.01
aaaa	2
bbbb	-0.1

User should have the flexibility to select Amount <= 0.01, then the report should display:

PO Document	Amount
zzzz	0.01
bbbb	-0.1

User should also have the flexibility to select Amount >= 0.01, then the report should display:

PO Document	Amount
yyyy	5
aaaa	2

Thanks,

Vasanthi

[former_member206568 · Accepted solution]

Hi Vasanthi,

You requirements can be met by using conditions in BEx. Please see following documentation for details:

https://help.sap.com/saphelp_nw70/helpdata/en/43/2695d2fd2f0d23e10000000a1553f7/content.htm

Thanks!

[Former Member · Accepted solution]

Thank you Sumit for the response.

However, in this case the user wants to have the control of the conditions. They should be able to toggle between the 2 conditions mentioned after the report is executed.

I tried creating 2 conditions in BEx and executed the report, apparently it does not work.

Thanks,

Vasanthi

[kohesco · Accepted solution]

Sumit is right, you can check http://scn.sap.com/docs/DOC-54844 if you want to give the opportunity to run via prompts

[former_member206568 · Accepted solution]

Hi Vasanthi,

You can create and deactivate both the conditions and activate the one you want to use at run time. In this way you can create multiple conditions and choose one you want to use by activating it. Alternately, user can create a required condition at run time.

Please see section "Using Several Conditions in a Single View" in the following link to understand the behavior of multiple active conditions of the query output.

Using Conditions - Business Intelligence - SAP Library

Thanks!