Skip to Content
0
Former Member
Jul 18, 2008 at 09:11 AM

BI Query with Input and Variables

22 Views

Hi,

I've added a BI query to my VC model. The BI query accepts vendor number as a variable. Once executed, it produces a table of results (1 line per calendar month).

This output is rendered as a graph using the the calendar month as the axis.

However, I want the user to be able to select a range of months to display. The calendar month appears on the BI query as an input not a variable.

If I drag Input and Variable to forms. I get 2 submit buttons and the it seems to ignore the calendar month options.

If I create a new field on the form and attach 1 form to both the variable plug and the input plug on the query, it won't allow month to control the axis !

When I right click on the query and carry out a test, I can enter both the input and the varible, clicking execute brings back the values I want !

Does anyone know how to get around this ?