I'm trying to use a stored procedure in our RPD. I've managed to be successful at doing so.
My issue is... the stored procedure's input parameters will need to be entered by the user on a dashboard. I have NOT been successful in getting this done.

I see in this person's blog post (see below link) that the input parameters can be set by using Session variables or Repository variables -- but I think I'm needing the stored procedure to accept the values of Presentation variables. Is this possible?
http://obiee101.blogspot.com/2011/01/obiee-using-mssql-stored-procedure-as_10.html

Here is the syntax I've tried without success:
EXEC TestDataMart.TDM.usp_TestSPROC @StartDate = @{vStartDate}, @EndDate = @{vEndDate}