Universe on Stored Procedure
I am trying to create a Universe in 3.1 on stored procedures. When I insert the stored procedure in the universe it opens up a window prompting to pass parameters for "from date and to date". I first enter the format in the universe as I enter in database to exceute the Stored procedure '2014-01-01'. It gives an error and prompts to change the format. I change the format as prompted : 01/01/2014 00:0:0 and then it gives an error as :
Exception: DBD, [Microsoft Sql Server Native Client 10.0]: operand type clash: int is incompatible with date state : 22018.
I tried different formats and it still gives the same error. Any idea how i could resolve this?