Skip to Content
0
Former Member
Apr 28, 2009 at 05:19 AM

Query Requirement- Sales

16 Views

Hi,

I have the following requirements- there are 4 key figs in my query all of which are % and indicate the share of business. My requirement is-

The query should run for all customers by default (there are not many). Once the report is run the user should have the flexibility of choosing the records he wants to view- for example- top 10 customers as per KF1 and top 5 customers as per KF2 etc. the user should have the flexibility to input '10' and '5' and the query should refresh as per the input. I have tried by creating conditions with text variables but the dialogue happens before query execution- not after execution.

How can this be achieved with BEx 7.1

Regards,

Saurabh Diwakar