I've been working as a Oracle Forms & Reports developer for many years and I thought that it would be great to have some of Oracle Forms functionality implemented here in OBIEE. Think about having two OBIEE reports. One is the master and the second is the detail. You may use departments employees or order and order items as an example. In Oracle Forms you'll have two blocks, one is master and the second is detail. When you are located in the first block row (master record) you have possibility to get detail data automatically. In other words detail records are fetched immediately when a user queries the master record.
So I want to have something like this:
Step one - building master and detail reports
Master request shows categories and detail shows top ten products ranked by amount sold for the current row master category.
Step two - building current iframe custom expression on master request including both requests using concatenated iframes and placing it in the narrative view to establish navigation in the same page between reports without losing window focus
Current iframe contains two concatenated iframes. Each iframe is build for one request and the detail request iframe is placed below the master. Each iframe has name. We use this column to place it in the narrative view of the master request because we'll show it on the dashboard to show automatically both reports (frames).
As you can see the master request column TIMES.CALENDAR_YEAR is filtered by dashboard prompt presentation variable. When the request is placed inside iframe the classic navigation with column filter set to is prompted is not working so we use presentation variable to pick up value from the dashboard prompt and place it in the master iframe request.
Place current iframe column in narrattive view:
Column product category on the master contains complex detail request navigation:
Explanation what we have done with the code above:
Step four - build the dashboard prompt and dashboard page
Show only narrative view:
Step five - the final look and test
The position is on the editable field and the detail request is automatically refreshed. You can press enter, tab or down-arrow to cross into new master row and validate detail request record for the current master. The focus is on the same page because we use iframes, so we refresh only detail iframe.
Unfortunately previous master row navigation can be established only using shift+tab or shift+enter keys.
Summer Holiday - As always at this time of the year, Siebel Essentials takes a break. It's also a time to thank You, my dear readers for granting me the privilege of actual...
1 hour ago