Inteligencia de negocios
Mark Rittman, Director, Rittman Mead Consulting Oracle Open World 2008, San Francisco. Session #S300202
T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com W: www.rittmanmead.com
Who Am I?
• Oracle BI&W Architecture and Development Specialist • Co-Founder of Rittman Mead Consulting ‣ Oracle BI&W Project Delivery Specialists • 10+ yearswith Discoverer, OWB etc • Oracle ACE Director, ACE of the Year 2005 • Writer for OTN and Oracle Magazine • Longest-running Oracle blog ‣ http://www.rittmanmead.com/blog • Chair of UKOUG BIRT SIG • Co-Chair of ODTUG BI&DW SIG • Speaker at IOUG and BIWA events
T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com W: www.rittmanmead.com
Rittman Mead Consulting
• Oracle BI&DW ProjectSpecialists • Consulting, Training, Support • Works with you to ensure OBIEE and Oracle BI Applications project success • Small, focused team • OWB, Oracle BI, DW technical specialists • Clients in the UK, Europe, USA
T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com W: www.rittmanmead.com
What is this Presentation About?
• For performance and data integration reasons, most mature OBIEEsystems source their data from one (or more) data warehouses • For initial implementations though, data is often initially accessed directly • OBIEE has some powerful features for creating integrated “virtual” logical models ‣ For bringing together data from disparate systems (“federation”) ‣ For integrating historic and real-time data (“fragmentation”) ‣ For creating calculations and derivations ‣ Forhandling multi-valued dimensions • OBIEE also requires that any normalized data is converted into a “star schema” • These data modeling techniques, coupled with more formal data warehouses, can allow you to deploy very flexible, agile data models to support your reporting • This presentation will take you through some of these data modeling techniques and will discuss how these initial models aremigrated to a more formal data warehouse
T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com W: www.rittmanmead.com
Oracle Business Intelligence Enterprise Edition
T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com W: www.rittmanmead.com
OBIEE 10.1.3.2 Architecture
Web Server (IIS, Tomcat, Websphere, iPlanet)
SAW Bridge (J2EE/ISAPI) XML, HTML, XLS, PDF, TXT over HTTP/HTTPSWeb Browser
Javascript for Usability & Interactivity
Oracle BI Publisher
Delivery Server Layout Interfaces XSL Data Logic
Oracle BI Presentation Services
SOAP Web Services, XML and URL Interface Oracle Interactive Dashboards Oracle Answers
TCP/IP (SSL) Web Catalog Service XML Framework
User Profiling, Security and Session Mngmt Cache Services (Web) & Connection Mngmt
HTML, SOAPover HTTP/HTTPS
External Applications and Portals
ODBC over TCP/IP (SSL)
Oracle Delivers Server
Scheduling/Event Services Agent Execution Logic Device Adaptive Content
TCP/IP (SSL)
Oracle BI Server
Logical SQL ODBC/JDBC (Logical Business Model)
Session Management Intelligent Request Generation
Metadata Interchange
Load Balancer
Oracle BI Cluster Controller
LogicalRequest Generation Cache Services Navigator Multi-Pass / Sub-Request Logic Fragmentation Optimization Aggregate Navigator Optimized Query Rewrites Execution Engine
Oracle BI Administration
Metadata Management Services Multi-User Development Services Metadata Documentation Services Server Management Services
Externalized Authentication LDAP DB Authentication Custom Authenticator
DataSource Adapters
ODBC, CLI, OCI, XML, MDX Analytical and Operational Data Sources
T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com W: www.rittmanmead.com
System / Perf Monitoring
Security Services Security Services
Query Govern. Query Govern.
Data Access
• Reporting data may be sourced from multiple databases, applications ‣ Oracle Database (including Oracle OLAP) ‣ IBM DB2 ‣...
Regístrate para leer el documento completo.