Frequently the requirment pops up to provide results from more than one subject area, using a single dashboard prompt.
OBI EE doesn't handle this situation directly, so the 'mid-request' concept can be used.
The steps briefly are...
- Create dashboard prompt using subject area 1, including required columns.
- Create a 2nd (mid) request listing columns and data returned from the prompt in Step 1.
- Filter columns using 'Is Prompted' option.
- Create the 3rd and 4th requests, from subject areas 1 and 2 respectively, then make sure these requests are based on the results of the request in Step 2.
A worked example in a future post...
