Error with drill down by characteristic relations
In an input ready query in IP I would like to display the relevant list of customers in the rows.
I defined in the modeler characteristic relations without derivation (type attribute) between the char. territory and the basic char. customer.
Both customer and territory are in the aggregation level, which the planning query in executed on.
The list of customers displayed after execution is of all customers in MD and not of the specific territory I restricted in the query.
I define in the query for both characteristics in the tab "Advanced" that "Access type for result values" is CR and filter value during query execution is CR.
Still the full list of cust. is shown and the relevant.
The char customer is compunded with 3 more chars that are restricted in the query.
I will appreciate your advise.
Edited by: Alona Maman on Sep 2, 2008 2:07 PM