Skip to Content
0
Former Member
Mar 24, 2009 at 02:58 PM

Variables to a BI Query from input form and chart?

26 Views

Hi,

I have a query (QUERY A) to which I connected an input form to define the variables. The output is a chart which tells us a status overview.

Now I want to use the input form as well for entering the variables for QUERY B. This is no problem as the variables are passed through correctly. However, I also wanna filter on status by selecting the status in the chart. This does not work unfortunately.

Situation:

INPUT FORM ----------> QUERY A ---------------> CHART----------------------------
                                  |                                             |
                                  |                                             |                              
                                  |                                             |
                                  ----->QUERY B <--------------------------------
                                              |
                                              |
                                              ----------->OUTPUT (VARIABLES FROM INPUT FORM AND CHART}

Is this possible at all?

Best regards,

Jan Laros