Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
Copyright © 2004, Oracle. All rights reserved.
Overview | Common Schema | Discoverer Samples | Sample Workbooks | BI Beans | Common Schema |
The Oracle Business Intelligence Spreadsheet Add-In (OracleBI 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.
Before you begin to work with the sample workbook, ensure that the following prerequisites have been met:
<sample_home>
)
on the computer where Oracle Business Intelligence is installed. <sample_home>
and unzip sample.xls
file from the <BI_ORACLE_HOME>\bi\samples\spreadsheet_addin
directory on the CD into any directory on your computer.To access the sample workbook, perform the following steps.
sample.xls
file.sample.xls
file, and click the Open button. A dialog is displayed informing you that the workbook contains macros. The query in the worksheet is now connected to the database. You can begin working with the sample worksheet.
Important: For each worksheet, you must refresh the query that it contains by selecting a cell in the query and choosing Refresh Query from the OracleOLAP menu.
The sample workbook contains several worksheets, each highlighting different product features and demonstrating how the OracleBI Spreadsheet Add-In can be used with Excel features such as formulas, charts, and macros. Each worksheet contains a description of the feature that it is demonstrating.
The following subsections describe each sample worksheet, listed by the name of the worksheet.
The Simple worksheet shows a simple query. You can use this worksheet for drilling, paging, and experimenting with a simple query that was created by simply running the OracleBI Query Wizard.
The Advanced worksheet shows a more advanced query with the following characteristics:
The Controls workbook shows how to use Excel forms controls and macro to interact with the OLAP query.
The QuickActions worksheet contains an example of how to use the applySavedSelections API call with Excel controls and macros. For more information about applySavedSelections, see the Release Notes and Installation Instructions.
The Stoplight worksheet shows how to use Excel-based conditional formatting with OLAP data.
The VLookup Demo worksheet shows how to combine OLAP data with external data using the Excel VLOOKUP function.
The VLookup Source Data worksheet contains some of the external data that is used with the VLookup demo.