Skip to Content
Author's profile photo Koen Hesters

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

<opendocumentlink> &lsSVariable=<singlevalue>

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


Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Raf Boudewijns
      Raf Boudewijns

      nice one!

      unfortunately this does not work in BO4.0 SP7 Patch4... it seems we'll need an update/upgrade