Skip to Content
0
Former Member
Jun 07, 2011 at 01:26 AM

Creating queries in QaaWS from stored-procedure based universe?

37 Views

Hi,

I have created a Universe from a MySql stored procedure with 3 input parameters, one numeric and the other two DATE. When I created the universe, I also specified that I want to be prompted for a value for the parameters next time when the stored procedure is executed.

Right now I am stuck at a point where I need to create a query in QaaWS from this stored procedure based universe so that I will be able to run the query from Excelsius later. While I am in the query creation wizard, I am prompted to enter the values for the parameters. I am able to enter the value for the numeric parameters, but cannot enter any value into the fields provided for the two DATE parameters. Because of this, I am not able to proceeed with the query creation.

Does any body have any documentation or simple example of how to connect from Excelsius to a stored procedure from end to end? What did I do wrong with QaaWS? Is there a work-around?

Thanks a lot in advance.