Collaborate 08 Oracle BI, Oracle OLAP, Essbase The .
Oracle BI, Oracle OLAP, EssbaseThe Benefits and Cost ofOpennessCollaborate 2008 paper 207April 14, 2008Dan Vlamis,President, Vlamis Software Solutions, Inc.Copyright 2008, Vlamis Software Solutions, Inc.
Agenda IntroductionPerspective on Oracle DB-centric and middle tier stacksFocus on Multi-dim DBs: Oracle OLAP and Essbase Logical structure, data storage, dimensional modelLoading dataAggregation, AllocationCalculationScalabilityWrite-back, Security, AdministrationFront endsPricingSimilaritiesHelping the client choose which OLAP solutionSpecific scenariosSuggested questionnaireConclusionsCopyright 2008, Vlamis Software Solutions, Inc.
Vlamis Software Solutions, Inc. Founded in 1992 in Kansas City, MissouriOracle Partner and reseller since 1995Specializes in ORACLE-based: Data WarehousingBusiness IntelligenceData Transformation (ETL)Web development and portalsDelivers Design and integrate BI and DW solutions Training and mentoring Expert presenter at major Oracle conferenceswww.vlamis.com (blog, papers, newsletters,services)Copyright 2008, Vlamis Software Solutions, Inc.
Vlamis Collaborate 0Sun, 9-5How to Use Oracle Business Intelligence (BI) to Solve RealWorld ProblemsDan Vlamis207Mon, 1-2Oracle BI, Oracle OLAP, Essbase: The Benefits and Cost ofOpennessDan Vlamis211Mon, 3:30-4:30Accelerate Your Oracle DW With OLAP 11gGenco,MarkThompson212Tues, 9:45-12Integrating Oracle BIEE with Oracle Analytic WorkspacesChrisClaterbos219Tues, 3:30-5:45Building Cubes and Analyzing Data Using Oracle OLAP 11gDan Vlamis221Wed, 8:30-9:30Implementing Oracle BI EE on Top of Oracle OLAP CubesMesirow,ChrisClaterbos223Wed, 9:45-10:45Achieving Complex Statistical Modeling with Fast ResultsUsing Oracle OLAPCopyright 2008, Vlamis Software Solutions, Inc.
Dan Vlamis, President,Vlamis Software Solutions Developer for IRI (former owners of Oracle OLAP)Founded Vlamis Software in 1992Wrote portions of Oracle Sales AnalyzerBeta tester and early adopter of Oracle OLAPExpert speaker and authorRecognized expert in Express and OLAP industryBringing multi-dim experience to Essbasedvlamis@vlamis.com 816-781-2880Copyright 2008, Vlamis Software Solutions, Inc.
Background 2006 - Oracle purchased Siebel For CRM market share, keep away from SAP Hidden gem: Siebel Analytics 2007 - Oracle purchased Hyperion To get into SAP customers Hidden gem: Essbase Future for all products – wins customers over Power struggle between "Traditional Oracle products" (Andy Mendelsohn) "New middleware products" (Thomas Kurian)Copyright 2008, Vlamis Software Solutions, Inc.
Server and Middle Tier StacksCategoryOracle DB CentricMiddle TierDatabaseOracle DB(varied)ETLOracle Warehouse BuilderOracle Data IntegratorReportingReports - BI PublisherAnswers / BI PublisherAd HocDiscoverer - AnswersOracle AnswersBusiness IntelligenceOracle BI SE- EE, SE OneOracle BI EE / SE OnePortal / DashboardsOracle Portal / APEXOracle DashboardsPredictiveOracle Data MiningReal Time DecisionsMulti-dimensional dataOracle OLAPEssbaseCopyright 2008, Vlamis Software Solutions, Inc.
Best Fit for Client Needs Choose best technology to fit the client needsEach client has unique needsOracle BI now has a wide array of technologiesAnalyze client needs before recommendingsolutionsCopyright 2008, Vlamis Software Solutions, Inc.
Oracle OLAP Started as Express—separate multi-dimensionaldb in 1970's Embedded into Oracle Enterprise DatabaseHas proprietary OLAP DML languageTypically access via Java OLAP API or SQLOptimized for SQL accessCopyright 2008, Vlamis Software Solutions, Inc.
Oracle OLAP 11g New Features Materialized View rewrite (transparent to app)Materialized View loading (automatic load)Views for SQL access automatically generatedCost-based aggregation optimizes aggregationMetadata integrated into Oracle dictionaryTolerant of non-dimensional SQLNew GUI to define cell-level securityCopyright 2008, Vlamis Software Solutions, Inc.
Oracle's Hyperion Essbase Started as Arbor Essbase - Hyperion - Oracle Standalone server database Two storage models: Block (BSO) andAggregate (ASO) Calc scripts to calculate data in BSO, MDX forASO Typically access via Excel addin, Smartview,and Hyperion Visual Explorer Has multiple access and manipulationlanguagesCopyright 2008, Vlamis Software Solutions, Inc.
Essbase Upcoming Features Real-time Analytics – Streaming updatesLifecycle ManagementTransaction logging, backup and recoverySupport for varying attributes, text measures,enhanced time intelligenceOracle Linux 4.0 64-bitBPEL integrationOBI EE as a data source and drill through targetXOLAP for fetch from relational dbEssbase StudioCopyright 2008, Vlamis Software Solutions, Inc.
Logical StructureOracle OLAPEssbase Storage hierarchy: Storage Hierarchy: Schema Application Analytic Workspace Database Cube(s) Hypercube Measures Cells CellsCopyright 2008, Vlamis Software Solutions, Inc.
Data StorageOracle OLAPEssbase Stored as cubes (arrays) BSO: stored as series ofblocks (arrays) in OS files(manual design) ASO: stored as array in OSfiles(automatic, but limited) Data stored as 8-bytes/cellfloating point Text lookup (new)in analytic workspace Stored as BLOB inOracle tablespaces Data can be integer,floating point, text, date,boolean, etc.Copyright 2008, Vlamis Software Solutions, Inc.
Dimensional ModelOracle OLAPEssbase Measures in cubes of All dimensions similar invarying dimensionality Handles multiplehierarchies "Shared members"would require customcodingstructure Single hypercube Multiple hierarchies via"Shared members" Data easily totaled byattributes (but only onthe-fly)Copyright 2008, Vlamis Software Solutions, Inc.
Loading DataLoading FromOracle OLAPEssbaseOracle Relational tablesMap via AWM or OWBMap via EIS, EAS, orEssbase Studio (new)Load via ODBCFlat files(delimited or columnar)Proprietary FILEREADcommand or use Externaltables and treat asrelational tableMap via Essbase Admin,create Rules filesForeign RDBMSUse gateways and treatas relational viewLoad via ODBCSAP BWCan handle via OWBLoad via SAP BAPIXMLHandle via XML DBMap via EAS or EssbaseStudioCopyright 2008, Vlamis Software Solutions, Inc.
AggregationOracle OLAPEssbase Multiple agg methods Can be set per measure New in 11g: optimizes aggregations formaximum performance Avoids double-storingsingle-parent nodes Multiple agg methodsBSO: , -, /, %, , sharedmember, formulaASO: , (all),-, /, %, (dynamic only)ASO: optimizesaggregations for maximumperformanceAvoids double-storingsingle-parent nodesCopyright 2008, Vlamis Software Solutions, Inc.
AllocationOracle OLAPEssbase Allocation built-in similar BSO: allocationto aggregation Generic set up Not widely usedfunctions ASO: code using MDXformulas Wizard-based rules Often performed withHyperion Planningwriting allocation scriptsCopyright 2008, Vlamis Software Solutions, Inc.
CalculationsOracle OLAPEssbase Full aggregation engine Formulas (10g) Expression language BSO: unary operators,(11g )member formulae, calcscripts (two-pass) ASO: unary operators,MDX expressions Calculate models with Any dimension memberequations (no GUI) Measure dimension cancan have formulahave formulaCopyright 2008, Vlamis Software Solutions, Inc.
ScalabilityOracle OLAP Multi-threaded Multi-processor Can be partitioned Multi-server viaRAC/Grid Many OS platforms Takes advantage ofOracle DatabasescalabilityEssbase Multi-threadedMulti-processorCan be partitionedMultiple cubes can bereferenced via a"capstone" cube Windows and UnixCopyright 2008, Vlamis Software Solutions, Inc.
Writeback HandlingOracle OLAPEssbase Supported in Excel add- in and BI Beans Multi-user Has session-specificdata Allows non-destructive"What If"Built into Excel addinBuilt into SmartViewBuilt into Web AnalyticsMulti-userChanges must becommitted to be visibleto userCopyright 2008, Vlamis Software Solutions, Inc.
SecurityOracle OLAPEssbase Cell-level security via Cell-level security (readPERMIT command in 9i,10g (read and write) GUI administered in 11g Authentication handledby Oracle database(can be external)and write) Catalog in Essbasecontrols access Essbase Authenticationor allows external orcustom authenticationCopyright 2008, Vlamis Software Solutions, Inc.
AdministrationOracle OLAPEssbase Administered via Oracle Designed for LoBdatabase tools and AWMfront end Submit batch jobs sameas Oracle DBmanagers (not IT) Administered viaEssbase AdministrationServices Essbase Studio (new) Jobs via MaxL scriptsCopyright 2008, Vlamis Software Solutions, Inc.
Access to dataOracle OLAP Excel Add-inDiscoverer OLAPOBI EEBI PublisherNext version of Answerswill have better interfaceAny SQL reporting toolJava OLAP APIBI BeansEssbase Excel, Word, Powerpoint SmartView Hyperion Visual Explorer OBI EE BI Publisher via OBI EE Next version of Answers will have better interfaceHyperion Ent. Perf. Mgmnt.Web AnalysisEssbase APIs (Java, C, VB,VBA)Copyright 2008, Vlamis Software Solutions, Inc.
Pricing*Oracle OLAPEssbase 400 per user (min 25) 20,000 per processor 2500 per user (min 25) 160,000 per processor(min 4)Oracle Database EE 800 per user (min 25) 40,000 per processor* Source: .html as of 2/13/2008Copyright 2008, Vlamis Software Solutions, Inc.
Oracle PositioningOracle OLAPHyperionEssbasePerformanceManagement Customer owns OracleDB DW acceleratorSQL accessBought by ITManaged by ITEssbaseOracle DatabaseOLAPEnhancedOptionData Warehousing Customer desiresopeness Financial analysis Excel and Hyperionaccess Bought by LoB Managed by LoBVlamis View: Show both and let customer decideCopyright 2008, Vlamis Software Solutions, Inc.
Why Each SystemOracle OLAPEssbase Integrated with Oracle DB Integrated security Integratedadministration Generally preferred by IT Lower price point Separate systemIndependent securityIndependentadministrationGenerally preferred by LoBFinance comfortable withExcel frontendIntegrated with HyperionEnt. Perf. Mgmnt. andHyperion PlanningCopyright 2008, Vlamis Software Solutions, Inc.
Client Scenarios Client has existing Oracle warehouse or datamart Client has heterogeneous data from multipledatabases and systems Client has existing Essbase hybrid that isperforming poorlyCopyright 2008, Vlamis Software Solutions, Inc.
Scenario #1 Already has Oracle data warehouse or data mart Needs better performance Needs analytics like time series analysis,rankings, forecasting etc. May need to use existing SQL reporting tools Well-defined needsCopyright 2008, Vlamis Software Solutions, Inc.
Scenario #1 - Our AnswerOracle OLAP is a good fit here! 11g can accelerate existing star schema data warehouses with minimal effortCan leverage existing DBA and developer skillsSQL access, even for 10g, is easy to implementand useIntegrates with Oracle securityCan use existing Oracle BI front-ends (OBIEE,Discoverer, Excel, BI Beans, Apex etc.)Copyright 2008, Vlamis Software Solutions, Inc.
Scenario #2 No data warehouse on Oracle platform Several different data sources (heterogeneous) Flat files Relational, Oracle and non-Oracle ODBC data sources SAP BW Need a simple front-end, like MS Office May not have access to highly technical staff May need financial savvy based solutionCopyright 2008, Vlamis Software Solutions, Inc.
Scenario #2 - Our AnswerOracle Essbase Essbase has better support for heterogeneous datasourcesEasier to use by non-technical business usersBetter solution for finance oriented LoBsCan be separate from company ITIntegrates tightly with Microsoft OfficeEasier integration with MS security and other nonOracle security modelsIntegrates with Hyperion Performance ManagementCopyright 2008, Vlamis Software Solutions, Inc.
Scenario #3 Already have Oracle DB and EssbaseHave or want to implement hybridLarge amount of dataWant wider range of front-end toolsNeed high performance, SQL access for someusersCopyright 2008, Vlamis Software Solutions, Inc.
Scenario # 3 - Our AnswerUse Both Together! Exposure to wider breadth of front-endsTop half in Essbase cubesBottom half in relational (sped up with Oracle OLAP)Best of both worlds, future proofed!Optimize storage within each environmentAccelerate Essbase hybrid implementationsMetadata should be integrated to avoid dualmaintenanceVlamis has found major performance improvementsCopyright 2008, Vlamis Software Solutions, Inc.
Oracle OLAP and EssbaseSimilarities Both are very capable multi-dimensionalengines Both calculate data efficientlyBoth allow for OLAP applicationsBoth efficiently handle calculationsBoth are true multi-dimensional solutions (notROLAP) Both are easily incrementally updatedCopyright 2008, Vlamis Software Solutions, Inc.
Questions to Ask Do you have an existing data warehouse or data mart? Are you having performance problems? Is it Oracle based? What are your data sources? OracleMicrosoftIBMFlat filesSpreadsheetsDo you already have a reporting solution? Oracle products? Others Do you have financial reporting requirements?Do you have planning and/or budgeting requirements?Do you have IT support?Copyright 2008, Vlamis Software Solutions, Inc.
Conclusions on Multi-dim engine Both Oracle OLAP and Essbase are go-forwardstrategies for Vlamis Software and OracleSome will prefer one over the otherLet user preference determine which is "sold"Essbase has strong history as independent choiceby Line of Business customersEssbase is "middleware solution"Oracle OLAP is integrated with Oracle DB forOracle DB-centric customersOracle OLAP as a "data warehouse accelerator"Look at both and decide: OLAP, Essbase, or BOTHLet Vlamis Software help you chooseCopyright 2008, Vlamis Software Solutions, Inc.
Conclusions on OracleDB vs Open If IT-led centralized approach, go with Oracle If Open architecture important, go with Open Pay a price for flexibility of Open approach Similar to cell phone carrier paying you for contract Oracle will continue both lines Will see additional openness in Oracle DBapproach over time Will see more emphasis on applications onmiddleware solution from Oracle (e.g. Hyperion,BI Apps)Copyright 2008, Vlamis Software Solutions, Inc.
Q U E S T I O N SA N S W E R Sdvlamis@vlamis.com 816-781-2880 www.vlamis.comSee www.vlamis.com/blogfor discussion on these topicsCopyright 2008, Vlamis Software Solutions, Inc.
Oracle BI, Oracle OLAP, EssbaseThe Benefits and Cost ofOpennessCollaborate 2008 paper 207April 14, 2008Dan Vlamis,President, Vlamis Software Solutions, Inc.Copyright 2008, Vlamis Software Solutions, Inc.
Training and mentoring . Collaborate 08 Oracle BI, Oracle OLAP, Essbase The Benefits and Cost of Openness A
Oracle e-Commerce Gateway, Oracle Business Intelligence System, Oracle Financial Analyzer, Oracle Reports, Oracle Strategic Enterprise Management, Oracle Financials, Oracle Internet Procurement, Oracle Supply Chain, Oracle Call Center, Oracle e-Commerce, Oracle Integration Products & Technologies, Oracle Marketing, Oracle Service,
Oracle is a registered trademark and Designer/2000, Developer/2000, Oracle7, Oracle8, Oracle Application Object Library, Oracle Applications, Oracle Alert, Oracle Financials, Oracle Workflow, SQL*Forms, SQL*Plus, SQL*Report, Oracle Data Browser, Oracle Forms, Oracle General Ledger, Oracle Human Resources, Oracle Manufacturing, Oracle Reports,
Collaborate Ultra: User Guide Collaborate is a web-based video conferencing system allowing participants to engage in two-way audio, multi-point video, interactive whiteboard, application and desktop sharing, file transfer, breakout rooms, and session recording. Collaborate Ultra is the new version of Blackboard Collaborate.
Blackboard Collaborate Ultra Blackboard Collaborate Ultra is a web conferencing tool that allows you to conduct online meetings and class sessions directly from your Blackboard course or organization. Collaborate is easy to use and can be customized for your instructional needs. Getting to Collaborate 1.
7 Messaging Server Oracle Oracle Communications suite Oracle 8 Mail Server Oracle Oracle Communications suite Oracle 9 IDAM Oracle Oracle Access Management Suite Plus / Oracle Identity Manager Connectors Pack / Oracle Identity Governance Suite Oracle 10 Business Intelligence
Advanced Replication Option, Database Server, Enabling the Information Age, Oracle Call Interface, Oracle EDI Gateway, Oracle Enterprise Manager, Oracle Expert, Oracle Expert Option, Oracle Forms, Oracle Parallel Server [or, Oracle7 Parallel Server], Oracle Procedural Gateway, Oracle Replication Services, Oracle Reports, Oracle
PeopleSoft Oracle JD Edwards Oracle Siebel Oracle Xtra Large Model Payroll E-Business Suite Oracle Middleware Performance Oracle Database JDE Enterprise One 9.1 Oracle VM 2.2 2,000 Users TPC-C Oracle 11g C240 M3 TPC-C Oracle DB 11g & OEL 1,244,550 OPTS/Sec C250 M2 Oracle E-Business Suite M
Oracle Database using Oracle Real Application Clusters (Oracle RAC) and Oracle Resource Management provided the first consolidation platform optimized for Oracle Database and is the MAA best practice for Oracle Database 11g. Oracle RAC enables multiple Oracle databases to be easily consolidated onto a single Oracle RAC cluster.
