Oracle商务智能精华介绍

1、1BusinessIntelligenceApplications3Thefollowing is intended to outlineour generalproductdirection.Itisintendedforinformationpurposesonly,and maynotbeincorporated intoany contract.It is nota commitmenttodeliveranymaterial, code, or functionality, andshouldnot be reliedupon in makingpurchasing decision

2、s.Thedevelopment, release, andtimingofany features or functionalitydescribed forOraclesproductsremains at thesole discretionofOracle.BIandPerformanceManagementConsistentlythe TopITandBusinessPrioritiesWorldwide“themostimportanttechnologyin2007 is Business Intelligence”FinancesTop AreaofImportanceSou

3、rces:CIOInsight,“TheFutureofI.T.:Whats on Tapfor2007andBeyond,”January16,2007;IBM Business ConsultingServices, “TheGlobal CFOStudy2005”5BusinessIntelligenceDrives IncreasedEffectiveness in every Business FunctionSalesAnalyticsMarketingAnalyticsService &ContactCenterAnalyticsConvert servicecallsintos

4、alesthrough enhanced cross-sellingImprove pipeline visibilityand forecast accuracyReal-timevisibilityinto campaign execution,results,and ROIFinancialAnalyticsHR/ WorkforceAnalyticsSupplyChainAnalyticsOptimizesuppliersourcing,supplierperformance, andinventorylevelsReal-timeviewoffinancialcondition an

5、ddrivers of costand profitabilityUnderstand whatdrives employee productivityandorg.performance6OurMissionMakingour software asource of continualcompetitiveadvantagefor ourcustomersBetterInformationBetterResults7OurApproachtoBIApplicationsPre-BuildApplications to reducecomplexity andTCOfor ourcustome

6、rsExtendApplications withBestinClassTechnologyIntegrateBIApplications withERP andCRM1238Pre-BuiltBIApplications fromOracle ReduceComplexityDELIVER BETTERINSIGHT TO CUSTOMERSMULTI-APPLICATION ENVIRONMENTSDASHBOARDS“Visible”“PLUMBING”“Underthe Surface”Mappingstomultipleapplicationsand datatransformati

7、onalltakeexpertiseand time9OraclesProduct StrategyIntegrated Business IntelligenceDatabaseBusinessIntelligence&Data MiningFunctionsIntegratedinDatabaseIntegrated Business IntelligenceToolsBest-of-Breed,Next GenerationBusinessIntelligence TechnologyPlatformIntegrated Analytic ApplicationsEnterprise W

8、ide, Industry Specific Analytic andCorporatePerformanceManagementApplicationsExploitsAnyInformationTechnologyEnvironment10To:From:Product Strategy DriversPervasive useAnalystsReal-time, predictive dataHistorical dataUnified infrastructure and prebuilt analytic solutionsAnalytic toolsInsight-driven b

9、usiness process optimizationReporting resultsUnified, enterprise viewFragmented viewEnterprise Performance Management SystemPlanning silos with limited BI11AnalyticApplicationsFamiliesAllonCommon OracleBIEETechnologyOtherOperational& Analytic SourcesOracle BI Suite EEAd-hoc AnalysisProactiveDetectio

10、nand AlertsMS OfficePlug-inReporting & PublishingInteractive DashboardsDisconnectedAnalyticsWebServicesFusionIntelligence forEBSFusionIntelligence forPeopleSoft EnterpriseOracleBIApplicationsEnhancement/ExtensionofDBIExtensionofEPM,ReplacementforBO,Cognos,MSTRSinglesource,Multi-sourceForEBS,PSFT,SEB

11、L,SAP, OtherNewNewNewVersion12OracleBISuiteEnterpriseEditionUnified Business IntelligenceInfrastructureAd-hoc AnalysisProactiveDetectionand AlertsMS OfficePlug-inReporting & PublishingInteractive DashboardsDisconnectedAnalyticsOracleBIServerOLTP & ODSSystemsData WarehouseData MartSAP, OraclePeopleSo

12、ft, Siebel,Custom AppsFilesExcelXMLBusinessProcessMultidimensional Calculation andIntegrationEngineIntelligentCaching ServicesEnterprise Business Model andAbstractionLayerIntelligentRequest Generationand OptimizedData AccessServicesWebServices13OracleBIApplicationsSingle- andmulti-sourceAnalyticApps

13、BuiltonBISuiteEEOracle BI Suite EEAd-hoc AnalysisProactiveDetectionand AlertsMS OfficePlug-inReporting & PublishingInteractive DashboardsDisconnectedAnalyticsWebServicesOracleBIApplicationsSalesService &Contact CenterMarketingOrderManagement& FulfillmentSupplyChainFinancialsHumanResourcesPackagedETL

14、MapsUniversalAdaptersIVR, ACD,CTIHyperionMSExcelOtherData SourcesBAWSchema14OracleBIApplicationsMulti-SourceAnalytics withSingle ArchitectureTravel& TransAutoComms& MediaComplexMfgConsumerSectorEnergyFinancialServicesHighTechInsurance& HealthLifeSciencesPublic SectorOtherOperational& Analytic Source

15、sOracleBISuiteEnterpriseEditionPrebuiltadapters:SalesService &Contact CenterMarketingOrderManagement& FulfillmentSupplyChainFinancialsHumanResourcesPipelineAnalysisTriangulatedForecastingSalesTeamEffectivenessUp-sell /Cross-sellCycleTimeAnalysisLeadConversionEmployeeProductivityCompensationAnalysisH

16、RComplianceReportingWorkforceProfileTurnoverTrendsReturnonHumanCapitalA/R&A/PAnalysisGL/ BalanceSheetAnalysisCustomer& ProductProfitabilityP&LAnalysisExpenseManagementCash FlowAnalysisSupplierPerformanceSpendAnalysisProcurementCycleTimesInventoryAvailabilityEmployeeExpensesBOMAnalysisOrderLinearityO

17、rdersvs.AvailableInventoryCycleTimeAnalysisBacklogAnalysisFulfillmentStatusCustomerReceivablesCampaignScorecardResponseRatesProductPropensityLoyalty andAttritionMarketBasketAnalysisCampaignROIChurnPropensityCustomerSatisfactionResolutionRatesService RepEffectivenessService CostAnalysisServiceTrends1

18、5OracleBIApplicationsMulti-SourceAnalytics withSingle ArchitectureTravel& TransAutoComms& MediaComplexMfgConsumerSectorEnergyFinancialServicesHighTechInsurance& HealthLifeSciencesPublic SectorOtherOperational& Analytic SourcesOracleBISuiteEnterpriseEditionPrebuiltadapters:SalesMarketingOrderManageme

19、nt& FulfillmentSupplyChainHumanResourcesPipelineAnalysisTriangulatedForecastingSalesTeamEffectivenessUp-sell /Cross-sellCycleTimeAnalysisLeadConversionEmployeeProductivityCompensationAnalysisHRComplianceReportingWorkforceProfileTurnoverTrendsReturnonHumanCapitalSupplierPerformanceSpendAnalysisProcur

20、ementCycleTimesInventoryAvailabilityEmployeeExpensesBOMAnalysisOrderLinearityOrdersvs.AvailableInventoryCycleTimeAnalysisBacklogAnalysisFulfillmentStatusCustomerReceivablesCampaignScorecardResponseRatesProductPropensityLoyalty andAttritionMarketBasketAnalysisCampaignROIService &Contact CenterChurn P

21、ropensityCustomer SatisfactionResolutionRatesService RepEffectivenessService CostAnalysisServiceTrendsFinancialsA/R&A/PAnalysisGL/ BalanceSheetAnalysisCustomer& ProductProfitabilityP&LAnalysisExpenseManagementCash FlowAnalysis16Pre-mapped metadata, including embedded best practice calculations and m

22、etrics for Financial, Executives and other Business Users.Presentation LayerLogical Business ModelPhysical Sources3Pre-builtETL to extractdatafrom over3,000operationaltables andload it intothe DW,sourced fromSAP,PSFT,OracleEBS andothersources.2A “best practice”library of over360 pre-builtmetrics,30I

23、ntelligentDashboards,200+ Reportsand severalalerts forCFO, FinanceController,Financial Analyst, AR/AP Managers andExecutives4Pre-built warehouse with 16 star-schemas designed for analysis and reporting on Financial Analytics1OracleFinancial AnalyticsProduct Components17Role Based DashboardsAnalyticW

24、orkflowGuidedNavigationSecurity/ VisibilityAlerts&ProactiveDeliveryLogical to Physical Abstraction LayerCalculationsand MetricsDefinitionVisibility &PersonalizationDynamic SQLGenerationHighlyParallelMultistage andCustomizableDeployment ModularityAbstracted DataModelConformedDimensionsHeterogeneous D

25、atabase supportDatabasespecificindexingOracleBIApplications ArchitectureAdministrationMetadataOracle BI Presentation ServicesDashboards by RoleReports, Analysis / Analytic WorkflowsMetrics /KPIsLogical Model /SubjectAreasPhysicalMapOracleBIServerDirectAccess to SourceDataData Warehouse /Data ModelET

26、LLoad ProcessStaging AreaExtraction ProcessDACFederatedDataSourcesSiebelOracleSAPR/3PSFTEDWOther18OracleBIApps:Selected KeyEntitiesUnified multi-sourcedata modelConformedDimensionsCustomerProductsSuppliersCost CentersProfitCentersInternalOrganizationsCustomerLocationsCustomerContactsGLAccountsEmploy

27、eeSalesRepsService RepsPartnersCampaignOffersSalesOpportunitiesQuotesPipelineOrderManagementSalesOrderLinesSalesScheduleLinesBookingsPick LinesBillingsBacklogsMarketingCampaignsResponsesMarketingCostsSupplyChainPurchaseOrderLinesPurchaseRequisitionLinesPurchaseOrderReceiptsInventoryBalanceInventoryT

28、ransactionsFinanceReceivablesPayablesGeneral LedgerCOGSCall CenterACDEventsRepActivitiesContact-RepSnapshotTargets andBenchmarkIVRNavigationHistoryServiceService RequestsActivitiesAgreementsWorkforceCompensationEmployeeProfileEmployeeEventsPharmaPrescriptionsSyndicated MarketDataFinancialsFinancialA

29、ssetsInsuranceClaimsPublicSectorBenefitsCasesIncidentsLeadsModular DW DataModelincludes:350 FactTables550 DimensionTables5,200prebuiltMetrics(2,500+ arederived metrics)15,000 DataElements19Example:AnalyticWorkflowsBusinessObjectives /IssuesGainInsightsTake ActionTargetcollectionefforts toreduceoverd

30、uebalancesDrilltoOverdue InvoiceDetailWhoare theCustomersandCollectors?Howlongistheunderlying OverdueBalance pending?IsOverdue Balancestrendingup?IsDSOontarget?MaximizeCash FlowDrilltoDueBalancesbyRegionWhat is theagingofDueBalances?ArePaymentTermsincompliance?IsDPOontarget?BusinessFunction:Receivab

31、lesRole:Director,Credits& CollectionsObjectives:1)MaximizeCash Flow2)Control RiskofReceivablesPortfolio20Example:AnalyticWorkflowsBusinessObjectives /IssuesGainInsightsTake ActionTargetcollectionefforts toreduceoverduebalancesDrilltoOverdue InvoiceDetailWhoare theCustomers?Howlongistheunderlying Ove

32、rdueBalance pending?IsOverdue Balancestrendingup?IsDSOontarget?MaximizeCash FlowDrilltoDetail21DEMONSTRATIONOracleBIApplicationsVerifySupplierPayableStatusPCSComputing:AnalyticsinActionIdentifyProblem w/ Revenue1LocateSubstituteProductSourceAdditionalParts43Execute MultichannelSalesCampaignProblem w

33、ithInvoice& Backlog210SalesFinanceMarketingContactCenterSupplyChain5IdentifyOverstockedLaptops6CreateCampaignfor Overstock7EnsureCampaignReadiness8Monitor ContactCenter Performance11Address Agent Retentionissue9Workforce23SeamlessAnalyticsAcross Multiple DataSourcesSalesFinanceMarketingContactCenter

34、SupplyChainWorkforce24Buildfrom Scratchwith Traditional BI ToolsOracleBIApplicationsPrebuiltBusinessAdaptersforOracle,PeopleSoft,Siebel, SAP,othersPrebuiltDWdesign, adaptstoyour EDWRole-based dashboardsand thousandsofpre-definedmetricsEasy to use,easytoadaptWeeksorMonthsBack-endETLandMappingDWDesign

35、DefineMetrics& DashboardsBack-endETLandMappingDWDesignDefineMetrics& DashboardsTraining/ Roll-outTraining/ RolloutMonthsorYearsOracle BI Applicationssolutions approach:Faster time to valueLower TCOAssured business valueSource: Patricia SeyboldResearch, Gartner, MerrillLynch, OracleAnalysisSpeedsTime

36、ToValueandLowers TCO25Deployed to 800 users in under 90 daysAnalytics for sales-oriented contact centerLive in 120 daysSales Analytics4 months from decision to live for 1,200 usersPharma AnalyticsLive in 100 days, 6,500 usersSales and Marketing Analytics“Icanvouchthatitcanbedeployedasrapidlyasthey c

37、laim.Itisaproduct thatreally delivers.”Deployed to 3,000+ users in 3 monthsSales AnalyticsWhat CustomersAreAchievingWith OracleBIApplications26NewBIApplications 7.9Release277.9ReleaseThemesUnified multi-sourcedata modelEnhanceduser experienceData WarehouseAdministrationConsoleExpandeddeployment opti

38、onsSupport OracleEBSv11 v11i9 andv11i10Support DB2V8onz/OS as bothsource andtargetdatabaseSupport Teradata V2R6astarget databaseFull localizationTranslationto15languages28TightIntegrationwith ApplicationsSharedsecuritywithOracleEBS andSiebelCRMEBSSecurityIntegrationFND_UsersecuritySharedresponsibili

39、tiesbetween OracleEBSand OracleBIAppsOracleSSOSiebelCRM Security IntegrationSiebelnative securitySharedresponsibilitiesbetween SiebelCRMand OracleBIAppsHot-Pluggable SecurityPre-builtsecurityrolesinBIApplicationsUsers/rolessynchronizedwithselectedsecurityenvironment29TightIntegrationwith Application

40、sActionLinksnavigatefromanalytical to operationalActionLinksDirectnavigationfrom analyticalreport to transactionaldetail while maintaining contextTake actionimmediatelywithout navigatingtoadifferentscreenOracleEBS IntegrationSiebelCRM Integration30AnalyticWorkflowsDirectedanalysishelpsinexpertusersG

41、uidedNavigationEnables users to quicklynavigateastandardpath of analyticaldiscovery specific to their function androleEnhancesusabilityand lowerslearningcurvefornew usersConditionalNavigationAppears onlywhenconditions aremetand alertsuserstopotentialout of ordinary conditionsthatrequire attentionGui

42、desuserstonextlogical stepofanalyticaldiscovery31Data WarehouseAdministrationConsole (DAC)StrongCompetitiveDifferentiatorForwarehouse developersand ETLAdministrator“ETL orchestrationtool”ApplicationConfigurationExecution&RecoveryMonitoringAllows:Pin-pointdeploymentLoad balancingReduced loadwindowsFi

43、ne-grainedfailurerecovery32PortfolioofAnalyticApplications33AnalyticApplicationsFamiliesAllonCommon OracleBIEETechnologyOtherOperational& Analytic SourcesOracle BI Suite EEAd-hoc AnalysisProactiveDetectionand AlertsMS OfficePlug-inReporting & PublishingInteractive DashboardsDisconnectedAnalyticsWebS

44、ervicesFusionIntelligence forEBSFusionIntelligence forPeopleSoft EnterpriseOracleBIApplicationsEnhancement/ExtensionofDBIExtensionofEPM,ReplacementforBO,Cognos,MSTRSinglesource,Multi-sourceForEBS,PSFT,SEBL,SAP, OtherNewNewNewVersion34DailyBusinessIntelligenceFullyIntegrated Business Intelligencefort

45、he E-BusinessSuiteSuiteofpre-built, role-basedBIApplicationsEasy-to-use,interactive, andextensible dashboardsSeamlessintegrationwith E-BusinessSuiteSinglesource of truth (nouploadtodatawarehouse)SeamlessdrilldowntotransactiontablesEasy to deployNoseparateETLtooltolearnandmaintainVery lowTCO35OracleD

46、ailyBusinessIntelligence (DBI)Easy-To-UseDashboards WithinE-Business SuiteRole Based DashboardsLeveragesEBS Infrastructure andMaterializedViewsNoData Movement RequiredDrillDirectlytoTransactionsfromSummariesImplements in DaysFastest PathtoInformationfromEBSPart of EBS“RapidInstall”NoTrainingRequired

47、36DrillThrough:Summary to ActualTransactionsSummary &TrendsDetailInformationTransactions3711i.9(DBI v6)11i.10(DBIv7+)12(DBI v8)IntelligenceReports332143775431382760362918DashboardsKPIs EBSR12:ContinuedDeliveryofPre-built AppsVPofHRLine ManagementHRManagerLine ManagerHRAnalystBenefitsManagerBenefitsA

48、nalystLearningManagerHRSpecialistLearningCoordinatorHRHelp DeskManagerCompensationManagerCompensationAnalystBenefitsManagerBenefitsAnalystHRAnalystCFOControllerTreasurerAPmanagerARManagerAssetsManagerTaxManagerCost ManagerProjectsManagerRevenue ManagerCollectionsManagerPayroll ManagerAccountantCompl

49、iance ClerkAPClerkARClerkFinancials AnalystSupplyChainVPService VPManufacturing VPMaterialManagement VPProduct ManagementVPPlanningVPPlantManagerProduction ManagerProduction LineSupervisorProduction SchedulerProduction ProcessEngineerInventoryManagerWarehouseManagerSalesContractsMgrCFOCPOVPCorporate

50、ProcurementVPBusinessUnit ProcurementVPCentral ProcurementProcurementManagerBuyerContractsManagerContractsAdministratorCommodityManagerSourcingStrategyAnalystContractsAnalystProcurementSupply ChainHuman ResourcesFinanceFusionIntelligence EBSEditionPre-PackagedRepositoryScopeOrdertoRevenueOrderFulfil

51、lmentandShippingManufacturing (Process andDiscrete)Inventory(Processand Discrete)Financials IntelligenceDBIWorkforce Activity andDeploymentDBICompensation SalarySummarizationDBILeaveand AbsencesHCMEUL Recruitment PipelineHCMEUL Recruitment VacanciesGeneral LedgerAPExpenses(GL)ARRevenue (GL)GLActivit

52、yBudgetAccountsPayableAPInvoicesAPInvoicesAging(Due &Past)APPaymentsScheduleAccountsReceivableARAdjustmentsARPaymentsScheduleARReceiptsARInvoicesARAgingReceivablesSalesCreditsComplianceSalesOpportunitySalesPipelineSalesForecastingServiceCRMIntelligenceSupplyChainIntelligenceHumanResourcesIntelligenc

53、eNotaCommitment to DeliverSubjecttoChangeProcurementManagementSupplierManagementProcurementIntelligence39Pre-PackagedSemanticObjectsPre-PackagedDashboardsPre-PackagedReportsPackagedIntegrationsIn-PlaceSchema(DBI)OracleBIApplications(former SBA)FusionIntelligenceforPeopleSoftFusionIntelligenceforOrac

54、leComponents of IntelligenceApplicationsSolutionArchitectureJDEdwardsMDW(EPM)RMW&CW(SBA)MapsModelsMetricsSolutionArchitecture40FusionIntelligence forEBS“BestofBoth Worlds!”Thisinformationisnotacommitment to deliverany material,code,orfunctionality.Thedevelopment, release, andtimingofany features or

55、functionalitydescribedremainsatthesolediscretion of OracleAfterValueProposition: Flexible,Extensible BI Platform thatisopentomultipledata sources; lowTCOofDBI41FusionIntelligence forEBSFeaturesThisinformationisnotacommitment to deliverany material,code,orfunctionality.Thedevelopment, release, andtim

56、ingofany features or functionalitydescribedremainsatthesolediscretion of OracleAfterFlexibleTime PeriodsMultipleCurrenciesKeyPerformanceIndicatorsMultipleData Widgetsfor presentingdataSummary ResultsGuidedNavigation42FusionIntelligence forEBSDetailsEnd-to-end OraclesolutionPre-packageddashboard temp

57、latesA repositorywitha business model based on underlyingDBI datamodel43Pre-IntegratedForEmbeddedBIEmbedded,In-context,reportsandgraphs to promoteaction withintransactional workflows44GuidedDrilldownActual TransactionsDetail InformationSummary & Trends45Ad-hocQueryCapabilityDBIBaseSummariesand MVsav

58、ailablefor Ad-hocanalysisNewCalculatedFieldsAvailablewithin MarketLeading BI ToolsetEasy to useChartingtoolFormattingWidgetsHighlightingMulti-language46AnalyticWorkflowsGuidedNavigationandConditionalNavigationlinksChecksfor specific conditionsand displays (ornot) adashboard section, or anavigational

59、 linktoeither areport or adashboardActionLinksDirectnavigationfrom recordtotransactional while maintaining contextGuidedNavigation& ActionLinks47Integrated SecurityLaunchOracle DBIEEdashboardfromApplicationNavigatorSharedresponsibilitiesbetween OracleEBSand OracleDBIEESign in onlyonceinEBS48ThreeCom

60、ponents of FusionIntelligenceFusionIntelligence forEBSand PeopleSoft*DBIorEPM Apps(manycustomersalreadyhave this)OracleBIEnterpriseEdition Suite LicenseEBSPSFTOLTP12349Product Roadmap50OracleBIAppsRoadmapThisinformationisnotacommitment to deliverany material,code,orfunctionality.Thedevelopment, rele