Dashboard doesnt filter out the values of Dimension(B.Ex Char) by changing Other Dimension(B.Ex Char) values

[suresh_reddy27]

Hi

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 A

Sales 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.

Thanks,

Suresh

[suresh_reddy27]

Hi All,

Is any one done the Dashboard using Query prompt selectors a scomponents for prompts. If any one know please explain the way to refresh the values in the Query prompt selecters when other object changes.

[Former Member]

Hi Suresh,

Do you have a  Variable built on Sales Org and Customer in BEx Query ?

If so, then You need to map variable from prompts to Query Prompt selector to refresh the Query.

Query Prompt selector fetches data from BW based on the selection, But if you want to do it locally inside the dashboard then you can use Filter component.

Thanks

Jethendra

[suresh_reddy27]

Hi Ravi,

It dont think it matters whether you use variable from B.Ex or use filter and prompt in Query browser, should work.

Thanks,

Suresh

[Former Member]

Have you setup a trigger cell to refresh the query after your selection is made?

[suresh_reddy27]

Hi Durga,

I am not sure what is trigger cell. I am not reading the data from spread sheet, this from B.Ex query. Can you please eloberate on which object should I do. please give me steps. If you dont mind just leave me your number, I will call you as it is urgent for me.

Kind Regards,

Suresh

[Former Member]

Basically trigger cells are used to refresh the query with the new selection when the selection changes. you can set this up in the last page while setting up the your Bex query. Just search on google you will get excellent blogs detailing the process of setting this up..

[suresh_reddy27]

As I said , the Query promt selectors are purely from B.Ex hence trigger cell doesnt work here. When I click trigger cell it prompts to spread sheet.