BusinessObjects Board

IDT - Using Parameter for tablename

building semantic layer
#1

I have a universe in which the tables are derived tables that have @prompt in them.
for example something like this:

SELECT * FROM TABLE@Prompt('Company Group:','K',{'123','124','145','156','167','168'},mono,constrained )

Each table end refers to a different table with the same structure but different data.
I want to stop using the @prompt, and switch to a parameter, that can easily be maintained (when there’s a new table ending, I need to add it to the @Prompt manually in 30 tables).
But I haven’t seen the K option, and when I use the parameter in the syntax - it doesn’t parse properly.

Has anyone managed to get something like this to work or knows of a workaround?

#2

Had never heard of K before either, but did find it referenced in the help:

‘K’ for keyword. This type is also an alphanumeric string, however the responses to the prompt will be not be surrounded by quotes in the query script at run time.

Sometimes things don’t parse properly but will still work? Maybe give it a try in your test environment and see what happens.