version 10.2
I imported stored procedure into the Framework Manager and it uses two parameters: @from and @to dates
(PROCEDURE up_get_data( :@From IN date, :@to IN date );
Then for definition entering value I put #$pDateFrom{prompt('pDateFrom','Date')}# for start date and #$pDateTo{prompt('pDateTo','Date')}# for end date.
I validated query subject and it said that the parameter values are null.
I clicked on test and entered the values 2000-01-01 and 2014-04-10 click ok and nothing came back from the database.
When I looked at the query information
It was showing CALL "tps_reporting"."aaa"."up_get_data" ( null, null ) for values for native query.
when tracing from database server it is passing the parameter properly. The database is sql server 2008.
Can someone help with this mater, it is urgent.
Thank you very much for your time and support
What do you see if you use ?pDateFrom? as the Start Date value and ?pDateTo? as the End Date value?
MF.
Please take a look at the screenshots attached.
Inside Cognos it does not update any parameters, generating and showing null values in query information window, but in the database with tracing log it shows the date passing.
Thank you for your reply, it did work when I entered simply ?pFromDate? and ?pDateTo?
Many thanks, it works now!!!
Simple solutions are often the best :)
Glad it works!
MF.
Yes, I agree, instead of using complex macros!!!
Much appreciated!!!