using the oracle9i olap spreadsheet add-invlamiscdn.com/papers/ioug2004-presentation4.pdf · 2016....
TRANSCRIPT
©Vlamis Software Solutions, Inc.1
Using the Oracle9i OLAP Using the Oracle9i OLAP Spreadsheet AddSpreadsheet Add--InIn
IOUG Live! 2004IOUG Live! 2004
Session Q3Session Q3
Dan Vlamis
Vlamis Software Solutions, Inc.
816-781-2880
http://www.vlamis.com
Copyright © 2004, Vlamis Software Solutions, Inc.
©Vlamis Software Solutions, Inc.2
Vlamis Software Solutions, Inc.Vlamis Software Solutions, Inc.• Founded in 1992 in Kansas City, Missouri• Oracle Partner and reseller since 1995• Specializes in ORACLE-based:
q Data Warehousingq Business Intelligenceq Data Transformation (ETL)q Web development and portalsq Express-based applications
• Deliversq Design and integrate BI and DW solutionsq Training and mentoring
• Expert presenter at major Oracle conferences
©Vlamis Software Solutions, Inc.3
Why Spreadsheet AddWhy Spreadsheet Add--in for OLAP?in for OLAP?
• Limit use of OLAP as ETL tool for Excel• Allows access directly from Excel to entire
OLAP cube• Allows access to Query Editor• Allows access to Calc Builder• Presents data in familiar Excel interface• Breaks down perception OLAP data "closed"• Users love access from Excel!
©Vlamis Software Solutions, Inc.4
Installation (subject to change)Installation (subject to change)
1. Unzip files2. Start Excel3. Tools-Add-ins4. Browse…5. Point to XLS6. OK7. Add dir to path
Make sure dirdoes not have anyspaces in path
34
5
©Vlamis Software Solutions, Inc.5
What Does Spreadsheet AddWhat Does Spreadsheet Add--in Do?in Do?
• Adds OracleOLAP menu to Excel menu• New Query gets data into Excel• Edit Query changes selection in Excel• Add New Calculation calls Calculation Wizard• Allows for drilling and paging on OLAP data• Saves queries between sessions• Refresh Query refreshes queries from server• Several options to modify behavior
©Vlamis Software Solutions, Inc.
Access to All OLAP Data from ExcelAccess to All OLAP Data from Excel
OLAP API
OLAP CatalogOLAP Catalog
Database
Warehouse Builder
Enterprise Manager
AW Manager
Oracle Business Intelligence Beans
OLAP Excel Add-in
• Query Oracle OLAP directly from Excel
• Leverages BI Beans Query Builder and Calc Builder
Custom BI Applications
OLAP Excel Add-in
©Vlamis Software Solutions, Inc.7
Spreadsheet AddSpreadsheet Add--InIn
©Vlamis Software Solutions, Inc.
Business Intelligence BeansBusiness Intelligence Beans
TableTable Cross TabCross Tab GraphGraph
Query Query BuilderBuilder
Calculation Calculation BuilderBuilder
Oracle9iOracle9iOracle9i OLAP ServicesOracle9i OLAP Services
QueryQuery
Meta Data ManagerMeta Data Manager
PersistencePersistence
Beans RepositoryBeans Repository
ConnectionConnection
Excel - Addin
©Vlamis Software Solutions, Inc.9
Demonstration of Excel AddDemonstration of Excel Add--InIn
©Vlamis Software Solutions, Inc.10
Other NotesOther Notes
• Still in development• Likely released without fanfare on OTN• Watch VSS Newsletter for announcement
(sign up via [email protected])• Likely no deployment cost besides OLAP
option pricing• All information subject to change since not
released yet• First release stores queries on local machine
©Vlamis Software Solutions, Inc.11
Other Sessions of InterestOther Sessions of Interest
• Building a BI Dashboard– 2:15 today
• Developing Advanced Thin Client Applications– Tomorrow 10-12
• Discoverer 10g or BI Beans– Wed 2:15
• Managing Oracle OLAP– Thurs 8:30
©Vlamis Software Solutions, Inc.12
QUESTIONS?QUESTIONS?