Demonstrations of an application created with Oracle BI Beans 10g
The Executive Insight Dashboard Application
This is a feature demonstration of the capabilities of Oracle Business Intelligence Beans 10g. The first viewlet walks through the Executive Insight Dashboard, explaining how the application provides users with powerful insight into the overall performance of their organization. The other viewlets will to help demonstrate many of the the key development benefits and features of Oracle JDeveloper/BI Beans 10g, including Ad-hoc and What-if analysis. These features make Oracle JDeveloper/BI Beans one of the most powerful and productive development tools for Business Intelligence applications. The viewlets listed below walk you through the entire development process, step by step. This series of viewlets are supported by other viewlets and samples that can be downloaded from the BI Beans section of the Oracle Technology Network web site. These explain the technical highlights of the Executive Insight sample and also demonstrate how to build the various pages that comprise the demo.
Descriptions of Viewlets
Executive Insight Application demo
The full demonstration of the Executive Insight application viewlet can be viewed here. This is a feature demonstration of the capabilities of Oracle Business Intelligence Beans 10g. The viewlet walks through the Executive Insight Dashboard explaining how the application provides users with powerful insight into the overall performance of their organization.
How to Build the Executive Insight Application
The samples aim to highlight the key features of JDeveloper/BI Beans 10g, such as:
- Visual Design Editors for all deployment environments (Java Client/JSP/UIX)
- Live data environments
- Declaritive wizard driven application development
- Enhanced and expanded new JSP tag libraries
- Extensive J2EE environment
White papers and technical documents are available from the BI Beans section of OTN that explore these concepts in more detail. The following viewlets use the Executive Insight application to demonstrate these new enhancements:
| Sample | Description |
|---|---|
| Part 1 - Building the Environment | |
| Creating the Workspace and Project and BIDesigner | This viewlet demonstrates how to use JDeveloper 10g to create the Executive Insight Application workspace and project. To manage the connection to the database and the BI Beans catalog a new BIDesigner is added to the project |
| Downloading and viewing the presentations | This viewlet demonstrates how to download the Executive Insight presentations from the BI Beans catalog to the local JDeveloper catalog. |
| Creating the JSP Pages | This viewlet demonstrates how to quickly and easily build the JSP Pages that will be used to create the Executive Insight application. In this demonstration the empty JSP pages will be added to the project. Subsequent demonstrations will show how to add content to each of these JSP pages |
| Part 2 - Building the Home Page | |
| Running the Home Page | This viewlet demonstrates running the finished Executive Insight Home Page. The viewlet highlights the key features of that form the basis of the development viewlets. |
| Creating the Page Header | This viewlet demonstrates how to quickly and easily add a page header to the home page. The layout and format of the header area is consistent across all the other JSP pages that form the Executive Insight application |
| Adding the Presentations | This viewlet demonstrates how to quickly and easily add a BI Beans Presentations to the home page. The presentations are added to the Home page within an HTML |
| Adding the Report Buttons | This viewlet demonstrates how to quickly and easily add a application navigation buttons to the home page. These navigation buttons provides shortcut links to the other pages int the Executive Insight application. |
| Part 3 - Building the Product Insight Page | |
| Running the Product Insight Page | This viewlet demonstrates running the finished Product Insight Page. The viewlet highlights the key features of that form the basis of the development viewlets. |
| Creating the page header | This viewlet demonstrates how to quickly and easily add a page header to the Product Insight page. The header uses one of the new BI Beans JSP tags, Page List tag, to provide page-to-page navigation in the form of a briefing book |
| Adding the presentations | This viewlet demonstrates how to quickly and easily add the six BI Beans Presentations to the main Product KPIs. The presentations are added to the page within an HTML table. |
| Adding the Product Category Query Buttons | This viewlet demonstrates how to quickly and easily add the Product Category query buttons to the Product Insight page. The buttons control access to individual members of the Product dimension. Each button updates each of the six presentations added to the page in the previous viewlet |
| Part 4 - Building the Customer Insight Page | |
| Running the Customer Insight Page | This viewlet demonstrates running the finished Customer Insight Page. The viewlet highlights the key features of that form the basis of the development viewlets. |
| Creating the page header | This viewlet demonstrates how to quickly and easily add a page header to the Customer Insight page. The header uses one of the new BI Beans JSP tags, Page tag, to provide page-to-page navigation in the form of a briefing book. The tag re-uses the Page List created by the Product Insight page |
| Adding the presentations | This viewlet demonstrates how to quickly and easily add the six BI Beans Presentations for the main Customer KPIs. The presentations are added to the page within an HTML table. |
| Adding the Customer Region Query Buttons | This viewlet demonstrates how to quickly and easily add the Customer Region query buttons to the Customer Insight page. The buttons control access to individual members of the Customer dimension. Each button updates each of the six presentations added to the page in the previous viewlet |
| Part 5 - Building the Sales Analysis Page | |
| Running the Sales Analysis Page | This viewlet demonstrates running the finished Sales Analysis Page. The viewlet highlights the key features of that form the basis of the development viewlets. |
| Creating the page header | This viewlet demonstrates how to quickly and easily add a page header to the Sales Analysis page. The header uses one of the new BI Beans JSP tags, Page tag, to provide page-to-page navigation in the form of a briefing book. The tag re-uses the Page List created by the Product Insight page |
| Adding the presentations | This viewlet demonstrates how to quickly and easily add the two BI Beans Presentations to the Sales Analysis page. The presentations are added to the page within an HTML table. |
| Adding the Product Category Query Buttons | This viewlet demonstrates how to quickly and easily add the Product Category query buttons to the Sales Analysis page. The buttons control access to individual members of the Product dimension. Each button only updates the first graph added to the page in the previous viewlet |
| Adding measure selection checkboxes | This viewlet demonstrates how to quickly and easily add the Measure query buttons to the Sales Analysis page. The buttons control access to individual measures. Each measure updates the Forecast line graph added to the page in the previous viewlet |
| Extending the JSP page using the BI Beans API | This viewlet demonstrates how to quickly and easily extend the Sales Analysis JSP Page by providing even greater user interaction. The viewlet shows how to add radio buttons that control the bubble graph and how to select a bubble that updates the Forecast line graph. |
| Part 6 - Building the What If Page | |
| Running the What If Page | This viewlet demonstrates running the finished What If Page. The viewlet highlights the key features of that form the basis of the development viewlets. |
| Creating the page header | This viewlet demonstrates how to quickly and easily add a page header to the Product Insight page. The header uses one of the new BI Beans JSP tags, Page List tag, to provide page-to-page navigation in the form of a briefing book |
| Adding the presentations | This viewlet demonstrates how to quickly and easily add the BI Bean Data Modelling Presentation to the What If page. The presentation is added to the page within an HTML table. |
| Addng the data modelling options | This viewlet demonstrates how to quickly and easily add the BI Bean Data Modelling Presentation to the What If page. The presentation is added to the page within an HTML table. |
| Adding controls to execute OLAP DML | This viewlet demonstrates how to quickly and easily add the controls to execute OLAP DML models that can be executed to update the What If presentation. |
| Adding the Product Category Query Buttons | This viewlet demonstrates how to quickly and easily add the Product Category query buttons to the Product Insight page. The buttons control access to individual members of the Product dimension. Each button updates each of the six presentations added to the page in the previous viewlet |
| Part 7 - Building the Adhoc Analysis Page | |
| Running the Adhoc Page | This viewlet demonstrates running the finished Adhoc Page. The viewlet highlights the key features of that form the basis of the development viewlets. |
| Creating the page header | This viewlet demonstrates how to quickly and easily add a page header to the Adhoc page. The header uses one of the new BI Beans JSP tags, Page List tag, to provide page-to-page navigation in the form of a briefing book. In this demonstration a header/banner area will be created in the currently empty JSP page. Subsequent demonstrations will show how to add more content to this JSP page. |
| Addin Presentations | This viewlet demonstrates how to quickly and easily add a BI Beans Presentations to the Adhoc page. The presentations are added to the Adhoc page within an HTML table. Subsequent demonstrations will show how to add more content to the application navigation buttons to the JSP page |
| Adding the presentation toolbars | This viewlet demonstrates how to quickly and easily add presentation toolbars |
| Part 8 - Deploying the Executive Insight Application | |
| Creating the deployment connection | This viewlet demonstrates how to quickly and easily create an Application Server connection that can be used the deploy the Executive Insight application. Subsequent demonstrations will show how to build a deployment profile and how to deploy the completed application using JDeveloper wizards. |
| Creating a deployment profile | This viewlet demonstrates how to use the JDeveloper deployment wizard to build a deployment profile |
| Running the deployment process | This viewlet demonstrates how to run the deployment process |