displaying list of values in a free hand SQL, dynamically

[binboy77]

Hi,
Is it possible to display a list of values in a prompt as a selection of some values from a table column and not by hardcoding the list of values in the @prompt syntax.

Syntax:
@prompt('prompt','data type',{'value','value', etc.},mono/
multi,free/constrained)

Can i make the {'value','value', etc.} section dynamic by selecting the values in a table and not hardcoding them in the above syntax?

Thanks
Bin

 

[PruSQLer]

Sure, you just make that column a dimension and then you put it in your prompt as 'Dimensions\Values', substituting 'Values' for what you want to call it, e.g. "End Dates".

 

[binboy77]

Hi,
Thanks for the reply. But i want to use the above in a Free Hand SQL, which is a data provider itself. So can i accomplish the above in a free hand SQL data provider?

Thanks
Bin

 

[skrandel]

What you are asking is not possible using Free Hand SQL.

What you can do is build a universe-based query and then modify the SQL. THen you'll be OK.

Steve Krandel
Knightsbridge Solutions
formerly BASE Consulting Group

http://www.knightsbridge.com

 

[Sridharan]

You need to create a dummy universe and then use that and change the SQL to get the required stuff. Otherwise one needs to be contend with adding the LOV's as Hard Coded Values.

Sri