Use Multiple Multi-select tables as BI Query Variable input

[Former Member]

Hi Guys, I'm new to VC and can't work out how to do the following:

Table A is a multi-select table fed from a BI query with all Stores

Table B is a multi-select table fed from a BI query with all Sales Codes

I wish to use the selection(s) from Table A and Table B as variable input to a BI query with Stores and Sales Code as variables, which the results will be displayed in Table C.

Regards,

Rohan.

[Former Member]

Hi

Follow the steps -

1. Create variables in your BI query for Stores & Sales codes.(variables type should be multiple single options & optional)

2. Take that query 3 times in your model.

3. Drag the input form from first data service also drag first table & select 'Store' column.

4. Join table one to another data service & drag table 2 with column 'Sales Code'.

5. Join this to third data service & show the third field.

6. Also make sure that you have selected multiple selctions in the properties of table.

7. This model will allow you to select the values as you want.

If you have any doubt please let me know.

Regards

Sandeep

[Former Member]

II have a similar situation where i i have model linked with multiple queries. I wanted one input form to be given ie. company code and fiscal year and the data should be displayed for my multiple charts. How to arrive this. when i use input form linked with first query data source only that chart alone is retricted for my selection. Others doesn't . Please guide.