store once, read anywhere - using oracle olap data in...
TRANSCRIPT
![Page 1: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/1.jpg)
Store once, read anywhere - using Oracle
OLAP data in multiple BI clients
Simba and Vlamis Webcast
February 5, 2013
Dan Vlamis www.vlamis.com
Cathy Dumas www.simba.com
Copyright © 2013, Vlamis Software Solutions, Inc.
![Page 2: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/2.jpg)
Oracle OLAP Data in Multiple BI Clients
Agenda
• SAP Business Objects with Oracle OLAP • Introductions
• Quick demo of solution
• Architecture
• What is Oracle OLAP and why do I care?
• Connectivity to Oracle OLAP – Simba provider
• Customer Story
• Demo including showing building new report
• Q&A if time allows
• IBM Cognos with Oracle OLAP • Same as above
• Microsoft Excel with Oracle OLAP • Same as above
Copyright © 2013, Vlamis Software Solutions, Inc.
![Page 3: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/3.jpg)
Vlamis Software Solutions
• Vlamis Software founded in 1992 in Kansas City, Missouri
• Developed more than 200 Oracle BI systems
• Specializes in ORACLE-based:
• Data Warehousing
• Business Intelligence
• Design and integrated BI and DW solutions
• Training and mentoring
• Expert presenters at major Oracle conferences
• www.vlamis.com (blog, papers, newsletters, services)
• Developer for IRI (former owners of Oracle OLAP)
• Co-authors of book “Oracle Essbase & Oracle OLAP”
• Reseller for Simba
• HOL Coordinator for BIWA Summit 2013
Copyright © 2013, Vlamis Software Solutions, Inc.
![Page 4: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/4.jpg)
About Simba
• 20 years doing data connectivity solutions
• Work with leading BI and data warehousing companies like Microsoft, Oracle, Teradata and SAP
• Worked on ODBC, OLE DB for OLAP (ODBO) and MDX specs with Microsoft
• SAP’s Excel solution for its BW warehouse product is built on Simba’s technology
• The independent expert on direct BI/OLAP connectivity to Microsoft Excel
![Page 5: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/5.jpg)
Quick Demo
Copyright © 2013, Vlamis Software Solutions, Inc.
![Page 6: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/6.jpg)
XMLA architecture
![Page 7: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/7.jpg)
Oracle OLAP
![Page 8: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/8.jpg)
• Single RDBMS-MDBMS
process
• Single data storage
• Single security model
• Single administration facility
• Grid-enabled
• Accessible by any SQL-based
tool
• Embedded BI metadata
• Connects to all related Oracle
data
Copyright © 2013, Vlamis Software Solutions, Inc.
Oracle OLAP Leveraging Core Database Infrastructure
Oracle Database
Data Warehousing
Oracle Spatial
OLAP
Data Mining
![Page 9: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/9.jpg)
OLAP Is Fast For Dimensional Queries
• Dimensions are natural indexes to data
• Dimensions are natural way to look at data
• By, across, over, down – prepositions are often dimensions
• Handles multiple levels easily – embedded total
hierarchies
• Inter-row calcs are easy
• Yr/yr or prior period comparison
• Share, index
• Movingtotal
• Can replace mid-tier cubes
Copyright © 2013, Vlamis Software Solutions, Inc.
Time
Category
Hotel
Expenses Lunch
Food
Q1 Q2 Q3 SF
West
Northeast
Market
![Page 10: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/10.jpg)
XMLA architecture
![Page 11: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/11.jpg)
XMLA – a frequently used protocol
![Page 12: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/12.jpg)
XMLA data flow
![Page 13: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/13.jpg)
XMLA Server software
![Page 14: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/14.jpg)
Two Excel connectivity options
![Page 15: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/15.jpg)
Demo: Airline data
Copyright © 2013, Vlamis Software Solutions, Inc.
On time
flights
Origin
Destination
Airline / Flight
Time
• Flight information from FAA
• Determine the number of on-time flights
by airline and location
![Page 16: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/16.jpg)
Key Takeaways
• Oracle OLAP scales with the Oracle Database
• Simba XML/A provider for Oracle OLAP enables
real-time data access to Oracle data warehouse
• Available now
• Works with existing BI software
• Contact Vlamis to arrange a demonstration or to try
software
• +1-816-781-2880
Copyright © 2013, Vlamis Software Solutions, Inc.
![Page 17: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/17.jpg)
Resources
More information on:
• Vlamis Software: www.vlamis.com, [email protected]
• Simba: www.simba.com
• To evaluate Simba’s XMLA Provider for Oracle OLAP, visit
http://www.simba.com/evaluate-XMLA-Provider-for-Oracle-
OLAP.htm
• Oracle Test Drive: www.vlamis.com/testdrive-registration/
Copyright © 2013, Vlamis Software Solutions, Inc.
![Page 18: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/18.jpg)
Oracle Test Drive
• Free to try out Oracle OLAP and Excel
• Go to www.vlamis.com/testdrive-registration/
• Runs off of Amazon AWS
• Hands-on Labs based on Collaborate 2012 HOLs
• Have test drives for:
• Oracle BI
• BI Publisher
• Microsoft Excel against Oracle OLAP
• Oracle Data Mining
• Once sign up, you have private instance for 5 hours
• Available now
Copyright © 2013, Vlamis Software Solutions, Inc.
![Page 19: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/19.jpg)
Store once, read anywhere - using Oracle
OLAP data in multiple BI clients
Simba and Vlamis Webcast
February 5, 2013
Dan Vlamis www.vlamis.com
Cathy Dumas www.simba.com
Copyright © 2013, Vlamis Software Solutions, Inc.
![Page 20: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/20.jpg)
Oracle OLAP Data in Multiple BI Clients
Agenda
• SAP Business Objects with Oracle OLAP
• Same as below
• IBM Cognos with Oracle OLAP
• Introductions
• Quick demo of solution
• Architecture
• What is Oracle OLAP and why do I care?
• Connectivity to Oracle OLAP – Simba provider
• Customer Story
• Demo including showing building new report
• Q&A if time allows
• Microsoft Excel with Oracle OLAP
Copyright © 2013, Vlamis Software Solutions, Inc.
![Page 21: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/21.jpg)
Vlamis Software Solutions
• Vlamis Software founded in 1992 in Kansas City, Missouri
• Developed more than 200 Oracle BI systems
• Specializes in ORACLE-based:
• Data Warehousing
• Business Intelligence
• Design and integrated BI and DW solutions
• Training and mentoring
• Expert presenters at major Oracle conferences
• www.vlamis.com (blog, papers, newsletters, services)
• Developer for IRI (former owners of Oracle OLAP)
• Co-authors of book “Oracle Essbase & Oracle OLAP”
• Reseller for Simba
• HOL Coordinator for BIWA Summit 2013
Copyright © 2013, Vlamis Software Solutions, Inc.
![Page 22: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/22.jpg)
About Simba
• 20 years doing data connectivity solutions
• Work with leading BI and data warehousing companies like Microsoft, Oracle, Teradata and SAP
• Worked on ODBC, OLE DB for OLAP (ODBO) and MDX specs with Microsoft
• SAP’s Excel solution for its BW warehouse product is built on Simba’s technology
• The independent expert on direct BI/OLAP connectivity to Microsoft Excel
![Page 23: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/23.jpg)
Quick Demo
Copyright © 2013, Vlamis Software Solutions, Inc.
![Page 24: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/24.jpg)
XMLA architecture
![Page 25: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/25.jpg)
Oracle OLAP
![Page 26: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/26.jpg)
• Single RDBMS-MDBMS
process
• Single data storage
• Single security model
• Single administration facility
• Grid-enabled
• Accessible by any SQL-based
tool
• Embedded BI metadata
• Connects to all related Oracle
data
Copyright © 2013, Vlamis Software Solutions, Inc.
Oracle OLAP Leveraging Core Database Infrastructure
Oracle Database
Data Warehousing
Oracle Spatial
OLAP
Data Mining
![Page 27: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/27.jpg)
OLAP Is Fast For Dimensional Queries
• Dimensions are natural indexes to data
• Dimensions are natural way to look at data
• By, across, over, down – prepositions are often dimensions
• Handles multiple levels easily – embedded total
hierarchies
• Inter-row calcs are easy
• Yr/yr or prior period comparison
• Share, index
• Movingtotal
• Can replace mid-tier cubes
Copyright © 2013, Vlamis Software Solutions, Inc.
Time
Category
Hotel
Expenses Lunch
Food
Q1 Q2 Q3 SF
West
Northeast
Market
![Page 28: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/28.jpg)
XMLA architecture
![Page 29: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/29.jpg)
XMLA – a frequently used protocol
![Page 30: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/30.jpg)
XMLA data flow
![Page 31: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/31.jpg)
XMLA Server software
![Page 32: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/32.jpg)
Two Excel connectivity options
![Page 33: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/33.jpg)
Customer: telecommunications
The technical problem:
Existing Cognos cubes are slow and hard to
configure. Needed to keep Cognos front end
but build high performance back end.
The solution:
IBM Cognos + Simba XMLA Provider for
Oracle OLAP + Oracle OLAP cubes on
Exadata data warehouse
The result:
Time spent to configure cubes in Cognos
reduced to under 5 minutes. Operational and
analytic reports on subscriber data migrated
to Oracle OLAP.
![Page 34: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/34.jpg)
Demo: Airline data
Copyright © 2013, Vlamis Software Solutions, Inc.
On time
flights
Origin
Destination
Airline / Flight
Time
• Flight information from FAA
• Determine the number of on-time flights
by airline and location
![Page 35: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/35.jpg)
Key Takeaways
• Oracle OLAP scales with the Oracle Database
• Simba XML/A provider for Oracle OLAP enables
real-time data access to Oracle data warehouse
• Available now
• Works with existing BI software
• Contact Vlamis to arrange a demonstration or to try
software
• +1-816-781-2880
Copyright © 2013, Vlamis Software Solutions, Inc.
![Page 36: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/36.jpg)
Resources
More information on:
• Vlamis Software: www.vlamis.com, [email protected]
• Simba: www.simba.com
• To evaluate Simba’s XMLA Provider for Oracle OLAP, visit
http://www.simba.com/evaluate-XMLA-Provider-for-Oracle-
OLAP.htm
• Oracle Test Drive: www.vlamis.com/testdrive-registration/
Copyright © 2013, Vlamis Software Solutions, Inc.
![Page 37: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/37.jpg)
Oracle Test Drive
• Free to try out Oracle OLAP and Excel
• Go to www.vlamis.com/testdrive-registration/
• Runs off of Amazon AWS
• Hands-on Labs based on Collaborate 2012 HOLs
• Have test drives for:
• Oracle BI
• BI Publisher
• Microsoft Excel against Oracle OLAP
• Oracle Data Mining
• Once sign up, you have private instance for 5 hours
• Available now
Copyright © 2013, Vlamis Software Solutions, Inc.
![Page 38: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/38.jpg)
Store once, read anywhere - using Oracle
OLAP data in multiple BI clients
Simba and Vlamis Webcast
February 5, 2013
Dan Vlamis www.vlamis.com
Cathy Dumas www.simba.com
Copyright © 2013, Vlamis Software Solutions, Inc.
![Page 39: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/39.jpg)
Oracle OLAP Data in Multiple BI Clients
Agenda
• SAP Business Objects with Oracle OLAP • Same as below
• IBM Cognos with Oracle OLAP • Same as below
• Microsoft Excel with Oracle OLAP • Introductions
• Quick demo of solution
• Architecture
• What is Oracle OLAP and why do I care?
• Connectivity to Oracle OLAP – Simba provider
• Customer Story
• Demo including showing building new report
• Q&A if time allows
Copyright © 2013, Vlamis Software Solutions, Inc.
![Page 40: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/40.jpg)
Vlamis Software Solutions
• Vlamis Software founded in 1992 in Kansas City, Missouri
• Developed more than 200 Oracle BI systems
• Specializes in ORACLE-based:
• Data Warehousing
• Business Intelligence
• Design and integrated BI and DW solutions
• Training and mentoring
• Expert presenters at major Oracle conferences
• www.vlamis.com (blog, papers, newsletters, services)
• Developer for IRI (former owners of Oracle OLAP)
• Co-authors of book “Oracle Essbase & Oracle OLAP”
• Reseller for Simba
• HOL Coordinator for BIWA Summit 2013
Copyright © 2013, Vlamis Software Solutions, Inc.
![Page 41: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/41.jpg)
About Simba
• 20 years doing data connectivity solutions
• Work with leading BI and data warehousing companies like Microsoft, Oracle, Teradata and SAP
• Worked on ODBC, OLE DB for OLAP (ODBO) and MDX specs with Microsoft
• SAP’s Excel solution for its BW warehouse product is built on Simba’s technology
• The independent expert on direct BI/OLAP connectivity to Microsoft Excel
![Page 42: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/42.jpg)
Quick Demo
Copyright © 2013, Vlamis Software Solutions, Inc.
![Page 43: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/43.jpg)
Copyright © 2013, Vlamis Software Solutions, Inc.
Simba’s MDX Provider architecture
BI client
![Page 44: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/44.jpg)
Copyright © 2013, Vlamis Software Solutions, Inc.
Oracle OLAP
BI client
![Page 45: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/45.jpg)
• Single RDBMS-MDBMS
process
• Single data storage
• Single security model
• Single administration facility
• Grid-enabled
• Accessible by any SQL-based
tool
• Embedded BI metadata
• Connects to all related Oracle
data
Copyright © 2013, Vlamis Software Solutions, Inc.
Oracle OLAP Leveraging Core Database Infrastructure
Oracle Database
Data Warehousing
Oracle Spatial
OLAP
Data Mining
![Page 46: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/46.jpg)
OLAP Is Fast For Dimensional Queries
• Dimensions are natural indexes to data
• Dimensions are natural way to look at data
• By, across, over, down – prepositions are often dimensions
• Handles multiple levels easily – embedded total
hierarchies
• Inter-row calcs are easy
• Yr/yr or prior period comparison
• Share, index
• Movingtotal
• Can replace mid-tier cubes
Copyright © 2013, Vlamis Software Solutions, Inc.
Time
Category
Hotel
Expenses Lunch
Food
Q1 Q2 Q3 SF
West
Northeast
Market
![Page 47: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/47.jpg)
Oracle OLAP – replaces mid-tier cubes
• XMLA clients typically connect to mid-tier cubes such as:
• Microsoft SQL Server Analysis Services
• BusinessObjects Microcubes
• Cognos Power Cubes
• Microstrategy Intelligent Cubes
• Drawbacks of mid-tier cubes:
• Not scalable
• Requires data load from Oracle to cube
• Performance can be an issue
• Needs additional security layer
• Oracle OLAP with XMLA provides same BI client
functionality without the performance and scale problems
![Page 48: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/48.jpg)
Copyright © 2013, Vlamis Software Solutions, Inc.
Simba MDX Provider for Oracle OLAP
BI client
![Page 49: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/49.jpg)
ODBO – a frequently used protocol
![Page 50: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/50.jpg)
Client software installation
![Page 51: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/51.jpg)
52 © 2012 Rovi Corporation. Company confidential.
Rovi Entertainment Store (RES) and SIMBA MDX
![Page 52: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/52.jpg)
RES Usage of SIMBA MDX for Oracle OLAP with Excel
• How has Simba's MDX Provider helped RES’ operations overall?
– Helps RES fulfill weekly reporting requirements to our customers and content partners
• How is Simba used in day-to-day operations? – Sense check Oracle OBIEE data
• What is RES’ primary use of MDX Provider?
– Forecasting
– Essential tool for weekly/monthly/quarterly reporting and transaction/promotion analysis
– Report Development via pivot table formulas
• In what areas has it proved to be most helpful?
– Report prototyping and development
– Essential tool for weekly/monthly/quarterly reporting and transaction/promotion analysis
– Enables graphic representation of data via Excel, which OBIEE is unable to do
• What has it enabled you to do that you could not do before?
– Allows for rapid report prototyping and requirements analysis
– Reduces cycle time for ad-hoc analysis in building reports
– Allows end user analysts to build reports and communicate requirements to geeks
© 2012 Rovi Corporation. Company confidential. 53
![Page 53: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/53.jpg)
Thank you.
![Page 54: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/54.jpg)
Demo: Airline data
Copyright © 2013, Vlamis Software Solutions, Inc.
On time
flights
Origin
Destination
Airline / Flight
Time
• Flight information from FAA
• Determine the number of on-time flights
by airline and location
![Page 55: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/55.jpg)
Key Takeaways
• Oracle OLAP scales with the Oracle Database
• Simba XML/A provider for Oracle OLAP enables
real-time data access to Oracle data warehouse
• Available now
• Works with existing BI software
• Contact Vlamis to arrange a demonstration or to try
software
• +1-816-781-2880
Copyright © 2013, Vlamis Software Solutions, Inc.
![Page 56: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/56.jpg)
Resources
More information on:
• Vlamis Software: www.vlamis.com, [email protected]
• Simba: www.simba.com
• To evaluate Simba’s XMLA Provider for Oracle OLAP, visit
http://www.simba.com/evaluate-XMLA-Provider-for-Oracle-
OLAP.htm
• Oracle Test Drive: www.vlamis.com/testdrive-registration/
Copyright © 2013, Vlamis Software Solutions, Inc.
![Page 57: Store once, read anywhere - using Oracle OLAP data in ...vlamiscdn.com/papers/Simba+OLAP+webinar+-+Feb+4+draft.pdf · Microsoft, Oracle, Teradata and SAP •Worked on ODBC, OLE DB](https://reader031.vdocuments.us/reader031/viewer/2022022505/5aba10ee7f8b9ad5338eab02/html5/thumbnails/57.jpg)
Oracle Test Drive
• Free to try out Oracle OLAP and Excel
• Go to www.vlamis.com/testdrive-registration/
• Runs off of Amazon AWS
• Hands-on Labs based on Collaborate 2012 HOLs
• Have test drives for:
• Oracle BI
• BI Publisher
• Microsoft Excel against Oracle OLAP
• Oracle Data Mining
• Once sign up, you have private instance for 5 hours
• Available now
Copyright © 2013, Vlamis Software Solutions, Inc.