Oracle Business Intelligence Products Roadmap

Oracle Business Intelligence Products RoadmapLjiljana Perica, Oracle Business Solution Team Leader1

Oracle is the Worldwide Leaderin Business AnalyticsOracleBI ApplicationsOracleBI SuiteOracleData Warehousing#1 in Analytic Applications- IDC“One of the most comprehensive andinnovative BI platforms ”- Gartner#1 in DW Tools- IDCSources: IDC and Gartner2

Oracle BI Product SuitesRange of BI suits for different needsOracle BusinessIntelligence SE-1 ETL Oracle SE Database Access other DB & files BI Dashboards Enterprise Reporting Ad-hoc ReportingBI Pack for SMEs50 Users MaxOracle BusinessIntelligence EE PlusOracle BusinessIntelligence SE Ad-hoc Reporting & Analysisinc. interactive OLAP BI Dashboards Enterprise Reporting Desktop Integration BI DevelopmentLow costSolution Optimisedfor Oracle database environments& Power users Heterogeneous BI Server Ad-hoc Reporting & AnalysisBI DashboardsEnterprise ReportingDesktop IntegrationBI AlertingDisconnected user BIHyperion ProductsHigh-end Solution,Optimised for heterogeneousenvironments& Enterprise Wide Deployments3

Oracle BI EE Plus - Centerpiece of BI FoundationAdvantages:Advantages:9 Consolidated and standard-based9 Seamless user experience across products9 Unified metadata and shared services99999InteractiveDashboardsAd hocAnalysisProactiveDetectionand AlertsDelivers pervasive fact-based insight across multiple sourcesScales to over 1 million usersHot-Pluggable, to work with any customer environmentIntegrated with EPM System and Oracle AppsAdopted by all Apps Unlimited, GBU, and Fusion product familiesMicrosoftOfficeReporting & PublishingBI PublisherFinancial ReportingInteractive ReportingSQR Production ReportingWeb AnalysisCommon Enterprise Information ModelOracle BI ortMonitorAnalyzeOLTP & ODSSystemsDataWarehouseData MartSAP, OraclePeopleSoft, Siebel,Custom ceManagementApplicationsHyperionEssbase4

Roadmap Drivers Provide industry’s first integrated EPM SystemEnable pervasive information accessInnovate in all areasRemain standards-based and Hot PluggableEvolve to unified BI FoundationProtect, extend, evolve customers’ existinginvestments5

OBI Hyperion Integration ReleasesHyperion EPM9.3.1IR-EssbaseintegrationOracle BrandingOracle integrationOBI EE10.1.3Oracle HyperionHyperion EPMEPMS9.3.1.xFusion Edition Oracle HyperionMajor ion EditionOffice 2007OBI EE10.1.3.3.2EssbaseintegrationCalc ManagerEssbase StudioProfitability MgmtOBI EE10.1.3.4Disco MigrationWorkspace IntegrationSmartSpace IntegrationNow AvailableLocalization &PlatformReleaseOBI EE11gNextEPM/BIReleaseMajorIntegrationReleaseMajor ReleaseAnswers Action FrameworkInteractive ScorecardsAdvanced Visualization"This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features orfunctionality described remains at the sole discretion of Oracle"6

Oracle BI EE Plus ReleasesAlign, Integrate, EvolveAugust 2007OBI EE10.1.3.3August 2007OBI EE10.1.3.3.1EnhancedLocalizationOBI OBI EE10.1.3.4Disco MigrationWorkspaceIntegrationOBI EE11gMajorreleaseSmartSpaceIntegration"This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality 7described remains at the sole discretion of Oracle"

OBIEE 10.1.3.3Product Update Extended Office Add-ins Pervasive Office Integration Dashboards and Reports Multi-select SearchMetadata Dictionary IntegrationBI Publisher Flex/Flash TemplatesBI Publisher – Discoverer Integration Metadata Administration XMLA Driven Business Models Pass through DB Functions Data Source Integration Neteeza Certification8

OBIEE 10.1.3.3 – Office EnhancementsBuild Your Own DashboardsInsert BI viewsas native Officecharts,refreshableimages orFlash objectsSelect from allavailable viewsCombine BI datawith Officeformatting9

OBI EE 10.1.3.3 - Link to AnswersSingle-click Access to Complete BI FunctionalityPresentationcatalog in OfficeOracle AnswersCompound Layout10

Oracle BI EE Plus ReleasesAlign, Integrate, EvolveOBI EE10.1.3.3August 2007OBI EE10.1.3.3.1EnhancedLocalizationOBI OBI EE10.1.3.4Disco MigrationWorkspaceIntegrationOBI EE11gMajorreleaseSmartSpaceIntegration"This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality11described remains at the sole discretion of Oracle"

Oracle BI EE Plus ReleasesAlign, Integrate, EvolveAugust 2007OBI EE10.1.3.3August 2007OBI EE10.1.3.3.1EnhancedLocalizationOBI OBI EE10.1.3.4Disco MigrationWorkspaceIntegrationOBI EE11gMajorreleaseSmartSpaceIntegration"This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality12described remains at the sole discretion of Oracle"

Essbase as source to OBIEEAvailable now in OBIEE 10.1.3.3.2Ad hocAnalysisInteractiveReporting &Dashboards PublishingProactiveDetectionand AlertsMS Office& OutlookCommon Enterprise Information ModelBI Server OLTP & ODS Data Warehouse Files ExcelSystemsData MartXMLFor OBI Customer Access all data managed byEssbase Essbase data can participate inCommon Enterprise InformationModelFor Essbase Customer Essbase data and calculationsmade available to OBIEE usersEssbase"This information is not a commitment to deliver any material, code, or functionality. The development, release, andtiming of any features or functionality described remains at the sole discretion of Oracle"13

BI Server Admin Tool – EssbaseImport New Admin tool importdialog for multidimensional sources in10.1.3.3.2 Essbase metadataimport (and queries)require installation ofEssbase client API onBI Server14

BI Server Metadata for Essbase Multidimensional sources are uniquelymodeled in the BI Server metadata For Essbase, in the physicalrepository layer: Physical database corresponds to anEssbase Server instance Physical display folder corresponds toan Essbase Application Physical cube corresponds to anEssbase cube A Business Model is created simplyby dragging and dropping a cube ontothe Business Model layer. Metadata is implied by the cubestructure15

Oracle BI EE Plus ReleasesAlign, Integrate, EvolveAugust 2007OBI EE10.1.3.3August 2007OBI EE10.1.3.3.1EnhancedLocalizationOBI OBI EE10.1.3.4Disco MigrationWorkspaceIntegrationOBI EE11gMajorreleaseSmartSpaceIntegrationAvailable Now"This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality16described remains at the sole discretion of Oracle"

Discoverer – Protect, Interoperate, MigrateDiscoverer BI EE migration utility in 10.1.3.4 Protect Lifetime Support Interoperate BI Publisher integration Today BI Dashboards and DeliversIntegration in 11g Migrate EUL Migration Utility 10.1.3.4"This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features orfunctionality described remains at the sole discretion of Oracle"17

Oracle Discoverer Migration UtilityMigrate Discoverer metadata to BI EE QuickStart RPDGeneration from EULTargeted for regularstar/snowflakesSupported withmethodology and bestpractices18

SmartView for Essbase and OBIEEAvailable with EPMS Fusion editionSmartViewFor SmartView User Natively access Essbase andOBIEE data in single UICommon Enterprise Information ModelBI Server OLTP & ODS Data Warehouse Files ExcelSystemsData MartXMLEssbase"This information is not a commitment to deliver any material, code, or functionality. The development, release, andtiming of any features or functionality described remains at the sole discretion of Oracle"19

OBIEE as Source to EssbaseAvailable now (Essbase Studio in EPMS Fusion Edition)EssbaseEssbaseStudioCommon Enterprise Information ModelBI ServerOLTP & ODS Data Warehouse Files ExcelSystemsData MartXMLFor Essbase Customer Essbase can access all sourcesmapped into CommonEnterprise Information Model Essbase drill through to theOBIEE-mapped data Essbase Studio can mapOBIEE data for Essbase use Essbase can use OBI Apps asa data sourceFor OBI Customer Essbase what-if can be appliedto OBIEE-mapped data20

OBI Hyperion Integration ReleasesHyperion EPM9.3.1IR-EssbaseintegrationOracle BrandingOracle integrationOBI EE10.1.3.3Oracle HyperionHyperion EPMEPMS9.3.1.xFusion Edition Oracle HyperionMajor ion EditionOffice 2007OBI EE10.1.3.3.2EssbaseintegrationCalc ManagerEssbase StudioProfitability MgmtOBI EE10.1.3.4Disco MigrationWorkspace IntegrationSmartSpace IntegrationLocalization &PlatformReleaseOBI EE11gNextEPM/BIReleaseMajorIntegrationReleaseMajor ReleaseAnswers Action FrameworkInteractive ScorecardsAdvanced VisualizationQ2CY09"This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features orfunctionality described remains at the sole discretion of Oracle"21

OBI EE Personalized Start PageMore “Task” Oriented design. Personalization, where you’ve been.22

Answers Plus in OBIEE 11g The Next Generation of Answers Multidimensional, OLAP Analysis OLAP-style query building with member selection Calculated Members Ragged and skip-level hierarchies Hierarchical Calculations Function extensibility Custom Aggregates Uniformly applies to dimensional (OLAP) andrelational sources Optimized for Essbase23

Answers Key Features Hierarchy / Member BrowsingDimensional Columns in Pivot TablesOutline Total DrillingMember Selection (Query Steps)Calculated ItemsCustom GroupsModular Workspace24

Hierarchy/Member Browsing Hierarchies defined in metadataexposed in presentation layer andthus, in Subject Areas Multiple hierarchies available perdimension Requests can contain bothcolumnar and hierarchical data Indication of which measures andmembers are included in therequest25

Dimensional Columns New column type with unique capabilities Achieved by dragging and dropping hierarchy from Subject Areatree on to workspace Single column with expansion capabilities Asymmetrical Drilling “Drill Up”26

Member Selection Similar to Discoverer for OLAP Query Steps Allows specific selection of members for display on the request Does not impact Total member value27

Member Selection Detail Dialog to Add a new step Add / Keep / Remove functionality Simple user interface to pick desired members28

Calculated Item Create memberNo member expansionSimple AggregationCustom Formula29

Custom Groups - Results Create member specific group Results in a new group ‘Western Continents’ beingadded in the Pivot table30

Modular Workspace - CriteriaModular Workspace Tailor work area to how you work Standard design and objectpositioning Common banner and header Contextual toolbar Drag and drop interaction Collapsible / Expandable panesModular Workspace – Criteria31

Modular Workspace – ResultsModular Workspace – Results32

Modular Workspace – Pivot TableModular Workspace – Pivot Table Editor33

Modular Workspace – TableModular Workspace –Table Editor34

Geographical Map Editor35

Essbase as Performance Accelerator forOBIEE and OBI AppsAvailable with OBIEE 11gCommon Enterprise Information ModelBI ServerBI Server automatically usesaggregates or cubes for performanceESSBASE BI Server leverages summarydata whenever possible toaccelerate queries A sound aggregation strategy cantransparently improve end-userquery performance by manyorders of magnitude Aggregate Persistence in OBIEEsince 10.1.3.2 release forrelational sources Automatically defines, populatesand maps metadata to systemgenerated aggregate starschemas Extremely low TCOBI Apps or any DWor OLTP schemaNative RDBMSData Warehouse Aggregate Persistence togenerate Essbase and OracleOLAP cubes planned for OBIEE11g"This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features orfunctionality described remains at the sole discretion of Oracle"36