Is it possible to use Presentation variable values as input to a stored procedure in the RPD?

Chris Arnold

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}

[Deleted User]

Hi Chris,

You'll have to use request variables instead of presentation variables.

https://datacadamia.com/dat/obiee/obis/set_variable

Chris Arnold

Thank you!

[Deleted User]

Thank you for bringing up such a core functionality :) Underestimated and known far too little.