Universe on Stored Procedure

[Former Member]

Hello all,

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?

Thanks,

Nisha

[former_member193452]

Hi Nisha,

Take a look at kbase

https://service.sap.com/sap/support/notes/1884248

The date object with a prompt is not supported in stored procedure. Take a look at the work flow suggested.

Hope that helps!

Jacqueline