Dashboard filtered by BEx-variable, filled via URL
I received a question about how to fill,use, a BEx variable in a dashboard. Via a dynamic web link he wanted to call the filtered dashboard.
I didn’t know exactly how to do it, but I tried this and it works. But please better ideas are certainly welcome!
Note I created it in a SAP Dashboard 4.1 Patch 4.
Step 1 >> create a bex query, have a bex variable in it (I created a simple one, optional/interval)
Step 2 >> create the dashboard, I used a accordion menu to show my simple query data (cell B1 and C1 will show the data from my query)
Step 3 Creat Flash Variable (we call it “Variable”, note that you will put it in your opendocument link)
Data >> connections >> add flash variable >> + >> Range_0 >> Variable cell A1
Step 4 Create query via Query Browser (as result I have Month (Cell B1) and a counter (Cell C1) on the last tab I set the wen value changes to cell A1
Query 1>> usage options >> trigger when value change in cell A1
Step 5 Map the prompt to your spreadsheet (cell A1)
Querybrowser >> Query 1 >> Prompts >> selected value = cell A1 (I used month in my example)
Finally create your URL
Note that I had to use the key as single value!
unfortunately this does not work in BO4.0 SP7 Patch4... it seems we'll need an update/upgrade