Send Multi Selection from Table to BI Query
is it possible to send all selected rows from a multi-selection-enabled table to a BI Query (Filter or Variable Input port)?? I have tried that several times and in several different ways, but obviously only either the first or the last selected line were transferred to the Query.
These are things (among others) I tried:
- defined a Query containing a variable defined as multi value variable. Connected the out port of the table with the Variables port of the Query.
- connected the out port of the table with the Filter port of the Query.
The only why I got this thing working was with a manually build selection screen. In that screen I can select single values and add them to the list of selected values by hitting a button. Unfortunately that solution is very slow and not what our customer was looking for.
The customer wants a table where he can select several values (best case: with checkboxes) and send these selected values directly to queries.
I also couldn't find out how the values the table sends are delimited. Maybe thats the solution to my question...