Skip to Content
0
Former Member
Feb 18, 2011 at 05:42 PM

Query Definition Filter Value Selection

87 Views

Hi All,

I have a query that has defined as selection criteria (for example):

> Company;

> Department;

> Employee.

Example:

COMPANY DEPARTMENT EMPLOYEE

AA AA1 Peter

AA AA1 John

BB BB1 Paul

BB BB1 Tom

BB BB2 Sara

CC CC1 Phillipe

When i execute a report, using BEx Analyzer, it appears the initial selection screen as expected and here i would like to know if its possible to have the following:

when i select Company "AA", i need, on field related with "Department" (on selection screen), that the only possible value are only "AA1" and "AA2". If i choose Company "BB", possible values for "Department" are "BB1" and "BB2" as displayed on the example above.

I already check tab "Business Explorer" on the infoobject, but for "Query Def. Filter value Selection" i have only two options: "values in master data table" and "only values in infoprovider".

I know that its possible and works after report execution. However, as explained above, i need to know if its possible have the same functionality on the selection screena, and if yes, how.

Many thanks in advance.

Kind regards,

HT