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.
Comments (2)
Is there any way to pass multiple values from a dashboard prompt, As dashboard prompt with multi select control does not support presentation variable. In that case how would i pass user selected values to BIP Report?
Thanks
Posted by Madan | January 28, 2009 9:35 PM
Posted on January 28, 2009 21:35
Presentation variables are single value, though. What if we want the user to be able to use a multi-select? Or even a between?
Posted by Kurt Wolff | March 20, 2009 12:34 PM
Posted on March 20, 2009 12:34