Frustratingly when importing QAAWS into Xcelsius 2008, if the query uses INLIST and several values, I need to copy the dimension prompt in Data Manager for each possible value that could exist in the dimension object, example 100+ countries would mean copying the prompt 100 plus times and bind each to different cell locations on the Excel spreadsheet, not nice or practical.
The workaround I call reversing matches pattern
Via Universe Designer create a new object which can be used for MATCHES pattern in the query. The select is the table column containing the countries and create a WHERE clause on the dimension object as follows;
@variable(‘Enter Countries’) LIKE ‘%’ || my_table.country || ‘%’
Then when in Xcelsius CONCATENATE each resulting LOV’s that you want to pass into the query, but do not separate using semi colon, I concatenate each value and use ‘#’ as a separator.
Explanation of new object
Matches pattern normally in the form of;
COUNTRY LIKE ‘%ENGLA%’
Would return all values containing ENGLA aka ENGLAND
but this time round I am using a prompt which is populated from concatenated value within Xcelsius and could look like this ‘ENGLAND#SPAIN#FRANCE#BELGIUM’
The query is now
WHERE ‘ENGLAND#SPAIN#FRANCE#BELGIUM’ like ‘%’ || my_table.country || ‘%’
Hope that makes sense its early in the morning for me.
Macroman
Macroman 
(BOB member since 2002-11-13)