How to create a universe based on stored procedures with input parameters having list of values in a prompt
I have created a universe which includes stored procedure with one input parameter called VersionId. This stored procedure fetches the data from multiple tables by filtering it with VersionId. The universe I have created got added successfully in Web Intelligence Report and while running the report it is giving me prompt to enter VersionId in the text box. Please refer the attached screen shot for the prompt window. My question is, "Can I give the drop down instead of text box as in the screen shot" i.e. when user refresh the data, he/she will able to select the VersionId from the drop down such as 68,69,70,...
JFYI:- I am keeping the VersionId in the SQL table.
Or else please let me know any other solution to achieve this task.
Immediate response will be HIGHLY APPRECIATED...