Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
Copyright © 2006, Oracle. All rights reserved.
Oracle provides the technology foundation needed to build a complete and integrated solution for Business Intelligence and Data Warehousing. Oracle Business Intelligence is an integrated and easy-to-use query, analysis, reporting, and custom BI production and publishing solution that allows users to query both relational and multidimensional (OLAP) data structures. Oracle provides samples and tutorials to help users learn and explore various features of Oracle Business Intelligence. The instructions here will guide you through the process of installing different components of the samples: a sample data set (known as the "common schema"), workbooks, the OracleBI Beans catalog, OracleBI Spreadsheet Add-in, and OracleBI Beans samples (which include Java-client, JSP, UIX, Java servlet, and other samples).
The common schema includes both relational and multidimensional (OLAP) data structures. The data in this schema is the basis for the samples and tutorials delivered with Oracle Business Intelligence Discoverer (OracleBI Discoverer), Oracle Business Intelligence Beans (OracleBI Beans), and the Oracle Business Intelligence Spreadsheet Add-in (OracleBI Spreadsheet Add-In).
Oncce you have installed the common schema data set, you would need to install the Discoverer sample workbooks to be able to use OracleBI Discoverer to access the sample workbooks and analyze data from both relational and multidimensional (OLAP) data sources.
Oracle Business Intelligence Beans enables developers to productively build business intelligence applications that take advantage of the rich relational and multi-dimensional (OLAP) functionality in the Oracle database. OracleBI Beans includes presentation beans (graph and crosstab), data beans (query and calculation builders) and persistence services, which may be deployed in both HTML client and Java client applications. OracleBI Beans is seamlessly integrated into Oracle JDeveloper to provide the most productive development environment for building custom BI applications. The tutorials and samples provided here would help you learn how to develop business intelligence applications using BI Beans. Tutorials walk you through the entire development process, step by step, while samples explore a particular functional area in greater detail or demonstrate more complex coding situations.
The OracleBI Spreadsheet Add-In enables end-users to display and navigate Oracle OLAP data from within Microsoft Excel®. Users can treat the Oracle OLAP data as regular Excel data; for example create formulas and graphs, enabling them to combine the powerful analytic capabilities of Oracle OLAP with standard Excel functionality. The easy to use built-in Query Wizard is based on the OracleBI Beans Query Wizard, ensuring a consistent interface with other Oracle Business Intelligence Beans based applications. The Spreadsheet Add-In provides a sample workbook to help you learn how to use the product. The worksheets in the sample workbook illustrate key features that you will find useful when analyzing and reporting business data. These features include richly formatted reports and charts, advanced OLAP calculations, conditional queries, and more. The workbook also contains samples that show how you can use OLAP data with Excel functionality.
Copyright © 2006 Oracle Corporation
All Rights Reserved