Drill from Power Play to JSP Page

[djwool]

I am looking at a way to drill through from Cognos Powerplay to a JSP page. I know I can drill through to Cognos Impromptu and it will pass the paramaters that I require. However Impromptu will not allow me some functionality because I edit the SQL.

So I was wondering if there is a way, through Macros to first call a JSP page and secondly pass some parameters so I can run some SQL based on the parameters that were passed.

Any help would be appreciated.