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