Passing multiple values to a BI query

[Former Member]

Hi experts,

This question has probably been asked a few times, but I have an issue with passing multiple values to a BI query. Here's the scenario....

1) I have created a BI query. When I test the query in VC I can enter values 1000:1100 in the Infoobject Business Area and I see that the values are passed through OK

2) Then I created a form where Business Area is an Input Field

3) I linked the form to the BI query and assigned value @Business_area

3) A table is linked to the BI query to view my result ( I have set a distinct before my table to view the data by fiscal year period)

4) When running the VC model, the table show values for 1000 and 1100, but when I enter 1000:1100 and Submit it does not show both the business areas

There must be something I am missing and I thought it was that in my submit string (between the input form and the BI query) that I should fill in some values (instad of @Business_area). I tried to fill in 1000:1100, but then I get an error saying Invalid time 1000:1100.

I would really appreciate any help on this issue :-).

Regards,

Thomas

[Former Member]

Hi Thomas,

I wish to enter default values for dates onto the VC form. Ie I have a VC report to display a customer's shipped data. Ship date is a selection field/ input field on the form for the report/ output table.

At present if a user clicks submit they get all their shipped records from the beginning of time till today. How can I restrict the dates at VC level to past 3months? So if the users don't specify a ship date, they get the past 3 months data, and afterwards they can change it an retrieve all the data or past 2 years as they wish.

Thanks,

Jasmine

[Former Member]

Hi Jasmine,

Are you using a BI query as your datasource? If yes, then you can restrict the Shipped Data in the query (using a customer exit) to only display the last 3 months.

Another option would be to create From and To fields for shipping date in your input form. If you set default values in the 2 fields then the user can automatically get the last 3 months. If the user then wants to see eg. 6 monts past data, he/she will just change the From date. You could also hide the To date if you always set that to default NOW().

Regards,

Thomas

[Former Member]

Me again,

I found the reason. The reason was that I should use group instead of distinct. Now it works.....

Regards,

Thomas