Running BIP Reports in BIEE with prompts
By Tim Dexter-Oracle on Oct 30, 2008
I have been working on a lot of BIP/BIEE integrations lately. One thing that has come up which the Oracle by Example for BIEE/BIP training does not cover is the case where I want my BIP report to be driven by parameters from within a BIEE dashboard page.
Something like this:
Its a simple report requiring just a single parameter but how do I get a BIEE prompt to be passed through to the BIP server?
It's pretty simple really, first off you need to create the BIP report with the parameters defined, no need for LOVs, unless you want to run the report from the BIP interface too. Once you have the report defined it's then a case of setting up the dashboard page prompts.
The trick is to create a presentation variable associated with the prompt that exactly matches the BIP report parameter name, in this example its p_student_id.
You can create as many prompts as you have BIP parameters and of course you can create cascading values for the dashboard prompt list of values.
Now when the report renders you will have dashboard prompts for your users to select from and then hit Go to refresh the report data.