Hi All,
Is there a possibility to create a value prompt with multiple selection option but the values should not be displayed as dropdown or multiple select rather I need to show multiple values in single row.
For Example : A value prompt with months should be shown as below instead of simple dropdown.
Select Month :
Jan Feb Mar Apr
May Jun Jul Aug
Sep Oct Nov Dec
Any help or suggestions in this regard with be highly appreciated. Thanks in Advance.
I assume you mean that you by choosing a row, you select four months.
What is your source?
If it is dimensional, you can make static choice with member sets, and a token prompt parameter to receive it.
If relational, I guess you could make staic choice as well, and then use #csv(array('jan', 'feb', 'mar', 'apr'))#
I haven't got #csv(array(....)# to work my self, but if it works for you, please prost the correct syntax.
Thanks, Deep. For finding the time to reply.
To provide more information on this, the above example which I have taken is just for illustration.
Actually I'm having 5-6 different dimensions where the no. of records are more and the values in that prompt needs to be from database instead of static choices.
Please revert if above text provide more detailed requirement. Thanks.
It isn't my main expertise, but maybe you could make a mapping table in the database, calling the groups of periods