Skip to Content
0
Former Member
Nov 05, 2012 at 03:25 PM

BEx mandatory variable in Dashboard

95 Views

Hi Guys..

this is very simple one, hope you can answer it easily !

(I am using dashboard designer, BO4, SP3)

I have 2 queries in dashboard, added thru Query Browser.

Query 1 has got BEx mandatory variable - Fisc Month, Query 2 has mandatory BEx variable which calculates month based on Query 1 month selection.

I want only one selection component on dashboard screen (which selects month for Query 1) and Query 2 month would be calculated inside the spreadsheet as per Query 1 month and passed to Query 2.

Query prompt selector for Query 1 month selection is good, but how to pass that value to Query 2 month ? (Excel binding is disabled for BEx mandatory variables, see screenshot).


What is the solution ?

Attachments

Query prompt.JPG (33.5 kB)