Hyperion ESSBASE多维数据库.ppt

Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 1 AboutthisPresentation Audience NeworExistingCustomers PartnersSpeaker SalesExecs Sales ProductMarketingStaffObjectives TellsthefullstoryofOracleEssbaseaspartofthelargerOracleAnalytics OBIEE OBIApps storyIntendedasastand alonepresentation Length 48slidesAuthors Jos V llac s FredRichardsReleasedate November19 2009 Rev10 1 Feedback pleasesendanycommentsorsuggestionstotheauthors Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 2 INSTRUCTIONSFORUSE OracleEssbaseissoldbycustomerreferencesEssbasecanbeusedinmultipleverticalindustries acrossmultiplefunctionsUsetheEssbaseCustomerSuccesspresentationtofindcustomerexamplesrelevanttoyourcustomerandincludethesesuccessstoriesinthispresentation Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 3 ForwardLookingAnalyticswithOracleEssbase Presenter sName Presenter sTitle Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 5 DifferentQuestionsUsedforMeasuringandImprovingPerformance Ad HocQuery Analysis StandardizedReporting Future Past Forward lookingQuestions HistoricalQuestions SituationalQuestions Present Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 6 TheChallengestoAnsweringForwardLookingQuestions Time consumingManagementreportingandVarianceanalysis Userslivinginspreadsheethell Inabilitytobuildnewscenarios 3 2 1 Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 7 TheChallengestoAnsweringForwardLookingQuestions Time consumingManagementreportingandVarianceanalysis Userslivinginspreadsheethell Inabilitytobuildnewscenarios 3 2 1 Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 8 ManagementReportingisPartofaBroaderAnalyticalEcosystem Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 9 ManagementReportingisaProcess CXOsandManagersKnowledgeworkersAnalysts HelpsunderstandRisksandfutureimplicationsOfbusinessalternativesanddecisions ManyiterationsNewdatacreatedForwardlookingVariance what ifanalyses Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 10 Whyare Cubes Important OLAPDataPowersManagementReporting HighlyEfficientDataStorageVeryFastDataAccessandRetrievalDataOrganizedinDimensionalModel EasyforEnd userstoUnderstandCreatesnewInformationvia Write back toPowerWhat ifScenariosPowerfulDimensionalCalculationEngine Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 11 Forward lookingAnalyticEngineFastandSimplewithEssbase PowerfulCalculatorHundredsofbuiltinfunctionsandalgorithmsTrendingGoalseekingProceduralcalculations FinancialIntelligenceCriticalforVarianceAnalysis understandsbetter worse EssbaseunderstandsFinancialDataandCalculationsTimeBalances TimeIntelligenceTimeSeriescalculationsarehardtodoYet anextremelycommonBIrequirementEssbasemakesitveryeasyatanylevel anydimension foranytypeofcalendar Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 12 ForecastingScenariocomparisonTrendingGoalseekingProceduralcalculationsCustomCalculationsWhatiftesting EssbaseisaPowerfulCalculatorHundredsofBuilt inFunctionsandAlgorithms Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 13 IntelligentMetricsDeliverInsightTimeConsuming ComplextogetMultipleViews FormulasforsummarizingdatacanbesophisticatedNotjustSUM AVG MAXandMINDifferenttypesofaggregationsforthesameviewsofdataHowcanyouguaranteeresultswhenyou renavigating drillingthroughyourdata Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 14 FinancialIntelligenceFastandSimplewithEssbase CriticalforVarianceAnalysisEssbaseunderstandsFinancialDataandCalculationsBeyondsimpleaggregationTimeBalancesSophisticatedFunctionsCurrencyCalculations Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 15 TimeIntelligenceFastandSimplewithEssbase TimeSeriescalculationsarehardtodoYet anextremelycommonBIrequirementEssbasemakesitveryeasyatanylevel anydimension foranytypeofcalendar Totals Averages Cumulative Max Min othercalculationsfor H T D history to date Y T D year to date S T D season to date P T D period to date Q T D quarter to date M T D month to date W T D week to date D T D day to date Prior Next Otherperiodcomparisons Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 16 DynamicTimeAnalysis AnyTypeofTimeAnalysis OneOutline Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 17 EssbasePowersEPMApplicationsExtendEPMApplicationswithEssbase CapitalAssetsPlanning WorkforcePlanning Long TermFinancialPlanning FinancialDetail OperationalDetail PredictiveModeling Simulation OperationalRevenue CostModeling Planning Budgeting Forecasting FunctionalPlans ProjectPlanning MarketingPlanning Forward lookingAnalyticEngine Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 18 PowerfulProductVolumeForecastingForecastSpeedandAccuracyfor30 000Products World s6thlargestfoodcompany 15 9billioninFY09netsales Brandsmarketedinmorethan100countries morethan30 000employees Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 19 ManagementReportingRequiresFlexibilityEssbaseComplementstheDataWarehouse BIBenchmarkReport OrganizationalandperformancemetricsforBIteams 2008 www tdwi org 4 7 Howmanyweekstochangeahierarchy Howmanyweekstoaddanewdatasourcetoyourdatawarehouse 6 7 Howmanyweekstocreateadashboardwith20dimensions 12measures and6useraccessroles 7 ITBecomesaBottleneckAndExcelProliferates Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 20 AComprehensiveBusinessIntelligenceDeployment Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 21 BetterInformation BetterDecision makingComprehensiveIntelligenceAcrossOperations WalmartStores Inc isoneofthepreeminentretailersworldwidewithmorethan7000storesoperatingin14countries Servingmorethan176millioncustomersperweek Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 22 22 CreatingaMoreEfficientMonthlyCloseIntegratingFinancialAnalyticsandEssbase HumanaInc headquarteredinLouisville Kentucky isoneofthenation slargestpubliclytradedhealthandsupplementalbenefitscompanies withapproximately10 3millionmedicalmembersand6 8millionspecialtymembers Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 23 TheChallengestoAnsweringForwardLookingQuestions Time consumingManagementreportingandVarianceanalysis Userslivinginspreadsheethell Inabilitytobuildnewscenarios 3 2 1 Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 24 MostModelingisDoneHere ItisaGoodDepartmentalTool but DisconnectedDataSecurityRisksError proneDoesn tscaleNocontrols audittrails Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 25 UsersareAccustomedtoSpreadsheets SpreadsheetsareinefficientformorethantwodimensionsData Measures foreachcombinationof Row by Column E g SalesforQtr1 95 820 Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 26 ButBusinessisMorethanTwoDimensions Wetypicallylookatmorethantwodimensions multi dimensional Sowhatdowedo Addmorecolumnheaders Inourexample Total MarketBY Total Product ActualSalesforQtr1 95 820CreatesHEADACHES Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 27 Multi Dimensional Multi Sheet Addasheetforeachmarket4Markets Total 5SheetsTheproblemexacerbates Market s Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 28 Multi Sheet Nightmare HowaboutbyProductandbyMarket 5MarketsBY500Products 2500Sheets WhataboutbyIndustrytoo Welcometo SpreadsheetHell Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 29 TheSolution EradicateSpreadsheetHellEssbaseProvidestheBestofBothWorlds Usethesamefamiliartools Excel Word PowerPointAchieveSpeedofThoughtresponsetimeBenefitfromacentralizedenterprise scalesolution OracleEssbase Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 30 NoMoreSpreadsheetHellImprovedPerformanceVisibilityandServiceQuality ThirdlargestpizzachainintheUS3000locationsworldwideMorethan 1billioninsales Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 31 TheChallengestoAnsweringForwardLookingQuestions Time consumingManagementreportingandVarianceanalysis Userslivinginspreadsheethell Inabilitytobuildnewscenarios 3 2 1 Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 32 VolatilityDemandsRapidScenarioModelingCommodityPrices EnergyPrices InterestRates Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 33 ButModelsareConstantlyEvolvingDynamic IterativeProcessesDriveNewQuestions McDonalds applicationthatcollectsPOSdataevery15minutestomonitor modelcustomerservicelevels Alcoa marketingapplicationcalledSMART StrategicMarketingAnalysisandReportingTool fortrackingandmodelingproductprofitabilityacross29dimensions SouthwestAirlines applicationformodelingfuelcostsanddemand 98 forecastaccuracyafterthe9 11crisis Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 34 HundredsofSpreadsheetModelsThroughouttheOrganization WorkforceplanningImpactanalysisBenefitsmodels Customer StoreProfitabilityDemandPlanningMerchandisePlanningCustomerSat PartsManagementSupplychaincostoptimizationResourceManagementWarehouseprofitability VarianceanalysisProject initiativefundingmodelsValuationRiskManagement Howmanydoesyourorganizationhave Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 35 Forward lookingAnalyticEngineOracleEssbase Multi user writeback UninterruptedanalysesSecure shared singleversionofthetruthFastandIntuitiveDatashownhowusersseeit treestructureCentralizedFunctions calculations aggregations OracleEssbase Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 36 CentralizedComplexCalculationsEasytoDefine ValidateandMaintainforAllUsers Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 37 DrivingAutonomytotheAgencyLevelAvisFranceImprovesPerformance 1RentalcarcompanyinEurope530rentallocationsinFrancealone5000rentallocationsworldwide Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 38 PerformanceManagementandWorkforcePlanningattheU S ForestService TheForestServiceisanagencyoftheU S DepartmentofAgriculture TheForestServicemanagespubliclandsinnationalforestsandgrasslands whichencompass193millionacres Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 39 TheSolution OracleEssbaseForward lookingAnalytics Pain Time consumingManagementreporting VarianceanalysisUserslivinginspreadsheethellUnabletobuildnewscenarios UniqueValue Financial TimeIntelligenceCentralizedmulti userwritebackmodelingenvironmentCentralizedcomplexcalculations Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 40 ProvidingTopPerformanceScalabilityMarket leadingOLAPArchitecture 294 162 CompetingVendor Essbase 11 9 83 7 CompetingVendor Essbase CompetingVendor Essbase Load CalculationIdenticalHardware Minutes QueryResponse50ConcurrentUsers Seconds CPUUtilization50ConcurrentUsers 0 01 Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 41 ProvidingEnterprise classOLAPMostScalableOnlineAnalyticProcessingTechnology MultipleandcrossplatformdeploymentUnixand orWindows32 64 bitApplicationoptimizationPartitioningClusteringTuningTrickleFeed Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 42 AnalyticScalabilityEnterprise wide HumanResources Finance ExecutiveManagement Development Delivery Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 43 EssbaseDeliversForward lookingAnalytics LowersriskbyEnablingmodelingofalternativescenariosSimplifyingtheforecastingandvarianceanalysisprocess Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 44 Oracle sIntegratedAnalyticSolution Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 45 Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 45 Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 46 Appendices Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 47 KeyEnablerfortheOracleEPMSystem Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 48 MoreThan30 000Users 5 000views reportsSalesHRPurchasingFinance24x7availabilityMaximumquerytimelessthan4seconds WerealizedweneededapowerfulOLAPsystem onethatwashighlydimensionalanddetailed thatcouldprovidespeedofthoughtresponsefortensofthousandsofusers WeselectedHyperionbecauseitmetourscalabilityandperformancerequirements Copyright 2009 Oracleand oritsaffiliates Allrightsreserved 49 Essbase OracleOLAPComplementary Strategic BetterTogether Co