I am in SAP BI 4.0 Sp7 with patch 5. I have built a dashboard using Dashboard designer based on B.Ex query as a source. I have Characteristics "Sales Organisation" "Customer" (both are compounded) and few Key figures.
I have created query prompt selectors for the both chars in Dashboard. Intially the report displays for all the Sales organisations and the Customers but when I change to a particular sales org , then I want to filter the Customers but still I can see all Customers which I dont want. Below is an example
initial display:Sales Org Customer A John A B John B C John C
After restrcting Sales Org ASales Org Customer A John A John B John C
I dont want John B and John C should be seen in the box for when the Sales Org is A as they dont belong to it. In the B.Ex query the display option (Extended) is selected with posted values with navigation but still doent work.
I appreciate for your help on this.