Passing parameters to stored procedure in OBIEE 12c rpd from OBIEE 12c dashboard

Question

I am trying to create an OBIEE report using stored procedures. I have created a function in SQL Developer which takes a parameter and returns refCursor as output.

I, then, set the following query as default initialization string in physical layer of rpd: Select * from table(pipelined_emp(HR_DATA.GETCURSORS(parameter)))

GETCURSORS(parameter) is my function.

For now, in place of parameter, I am passing a constant value. While, I wish to pass a value from the OBIEE dashboard, similar to a prompt, to this function in the physical layer of rpd.

Thanks!

Answer 1

Yes. Session variables in the RPD being written into by front-end request variables: https://gerardnico.com/wiki/dat/obiee/obis/request_variable