SQL OPENROWSET and user group authentication

Apologies for a deep tech SQL question:  but has anyone used OPENROWSET to call a stored procedure into a temp table?  And if you have, have you been able to pass the authentication parameter so it's within the context of the user running it?  

We have a custom report that returns an audit of the Tessitura reports that have been run, and it only returns the raw value of the parameters passed to the request.  I'd like to update the report so it returns the formatted values, and was hoping to use AP_GET_PARAMETER_VALUES to do the heavy lifting for me by calling it from within my custom stored procedure.  Hope that makes sense... any thoughts/suggestions welcome.  Thanks!