Dashboard filtered by BEx-variable, filled via URL

[kohesco]

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

<opendocumentlink> &lsSVariable=<singlevalue>

Note that I had to use the key as single value!