SAP、Oracle和hyperion预算产品比较

1、SAP、Oracle和hyperion预算产品比较SAP、Oracle和hyperion预算产品比较 Hyperion Confidential & ProprietaryWhy Business Performance Management is necessary for ERP customers?ERP addresses only to operational efficiency BPM Bridges the gap between management strategies and operational systems like SAP BPM provides high-l

2、evel insight through analytics ERP provides operational information ONLYSeparation of BPM from ERP provides full-flexibility in analysis, modeling and planningFlexibility in point of views and dimensions (products, entities, business rules, etc.)Flexibility in accountsFlexibility in ad-hoc analysis

3、and reporting Flexibility in architecture Hyperion Confidential & ProprietaryBusinessModelingPlanningFinancialManagementTailoredApplicationsERPsDWSCMLegacyCRMBridging Management Processes Across the OrganizationBusinessPerformanceManagementSolutionsOrganizationProductsCustomersFinancesBIPlatformHype

4、rion Essbase XTDBusiness Performance Management Application FrameworkPlatform ServicesPerformance Scorecard Hyperion Confidential & ProprietaryTransaction of detailed dataOperational system on which daily businesses runOn-line transaction system on RDBMSAnalysis from high-level and strategic viewpoi

5、ntsIntroduce strategic view into operations by analysis and planning approachLeverages BI Platform with OLAP technologyERPBPMHyperion Business Performance Management Solution complements ERPBusiness Performance Management and ERP Hyperion Confidential & ProprietaryOracleOracle Financial Analyzer and

6、 Oracle Express Server Hyperion Confidential & ProprietaryGood News Oracle announced officially about migration of OFA Platform!From Oracle Express Server to Oracle 9i OLAPThere is NO nice upgrade from Express to 9iNew OFA will not get matured until 2004-2005! Hyperion Confidential & ProprietaryWhat

7、 Oracle says about Oracle Financial AnalyzerIntegration with Oracle Applications (Financials) It is beneficial only to Oracle Financials customersActually, as all meta data is loaded from Oracle Financials, there is limited flexibility in Oracle Financial Analyzer1,200 customers world-wideOracle is

8、giving-away OFA to many Oracle Financials clients, and many of them are not using OFAPowerful OLAP engineMany questions about the future, functions and quality of Oracle Express ServerHyperion Essbase is proven and market-leading OLAP engine with higher performance, more scalability and richer funct

9、ions Hyperion Confidential & ProprietaryWeaknesses of Oracle Financial AnalyzerNo process management functionality like Hyperion PlanningTop-down / bottom up target setting function is much weaker than Hyperion Planning / Hyperion PillarNo support for Line Item details like Hyperion Pillar and Plann

10、ingExpress 4GL programming is necessary even for simple customizing Planning / Pillar customization is much easier and coding is NOT necessaryMax. number of dimension is 7, and coding is necessary for maintenance(Hyperion Planning supports up to 20 dimensions, and Essbase has no limit in number of d

11、imensions)Security setting cannot be done so detailed as Hyperion PlanningIntegration with systems other than Oracle is weak Hyperion solutions can be integrated with any ERP systems using Hyperion Application Link Hyperion Confidential & ProprietaryOracle Express Server Dying product in OracleOracl

12、e released a new relational OLAP engine in Oracle 9i and announces it has not intention to enhance Express Server furtherMigration path from Oracle Express Server to 9i OLAP is not providedNew Oracle 9i OLAP only has limited functionality and its performance is poor due to its R-OLAP architectureCom

13、pare with Hyperion Essbase great performance and rich functions with much higher scalabilityEven Gartner Group recommends not to buy Oracle BI solutions at this moment unless the company is using Oracle products 100% Hyperion Confidential & ProprietaryOracle Express Server Dying product in OracleOra

14、cle Express Server was not originally developed by Oracle Purchased and was attached to Oracle RDB later. Accordingly its integration with Oracle RDB is not very tight as Oracle claimsEssbase Integration Services provides good integration with Oracle and other DBsOracle OLAP Server has NOT been upda

15、ted for more than two years since Express 6.3In the same period, Hyperion released Essbase 6.1, 6.2 and 6.5 with quarterly patch releases, and has greatly enhanced EssbaseCalculation functions are very weakExpress is much behind Essbase Essbase provides more than 150 functions and is widely recogniz

16、ed by its high performance calc engine Hyperion Confidential & ProprietaryOracle Express Server Dying product in OracleStorage Efficiency is a big issue of Oracle ExpressWith dense-sparse architecture and its storage mechanism optimized for multi-dimensional data, Essbase cubes are more compact and

17、higher-performanceLimited availability of front-ends: Only Analyzer and ObjectsHyperion Essbase adopts open policy and many front end tools are available from third parties, besides Spreadsheet add-in, Hyperion Analyzer, Hyperion Reports and Hyperion Application BuilderMaintenance heavy lots of Expr

18、ess 4GL programming is necessary for implementing Express actuallyImplementation period of Essbase is 50% less in most casesIntegration with non-Oracle RDB is very weakHyperion Essbase is open and can be integrated with DB2, SQL Server, Teradata, etc. and many third party ETL/EAI tools support Hyper

19、ion Essbase Hyperion Confidential & ProprietaryOracle Express Server What customer says“We attempted to introduce Oracle Express for years. However, we decided to switch to Hyperion Essbase, because the quality of Express Server was not good, the level of technical support was low, choice of front e

20、nd tools was limited, interoperability with other Oracle software was poor.” Hyperion Confidential & ProprietaryOracle 9i OLAP Immature and questionable product in OracleVERY newNot a proven product at all compare with EssbaseROLAPPerformance is poorNo functionalitiesCannot match with Essbase 6.5.1

21、with so rich analytic functionalities! Nothing is available todayMaintenance heavyNo migration path is available from Oracle Express ServerOracle Express customers cannot go to 9i OLAP easilySAPSEM and BIW Hyperion Confidential & ProprietarySAP SEMBuilt on SAPs “OLAP” datamart Business Information W

22、arehouseComposed of BPS (Business Planning and Simulation), CPM (Corporate Performance Monitor), BCS (Business Consolidation), BIC (Business Information Collection) and SRM (Stakeholder Relationship Management) The fact that many of Hyperion customers are SAP customers is the proof that SAP SEM is u

23、nflexible, hard to use and unreliable Hyperion Confidential & ProprietarySAP SEM WeaknessesCannot be implemented unless R/3 is running and readyHyperion BPM is flexible and open. Can be implemented in any environments“Running” Systems are only a fewHyperion BPM applications are actually used by many

24、 companies world-wide with proven ROIVERY unflexible Cube structures NEED to match with R/3 data structure (Structures of FI/CO/MM/SD are directly used)Hyperion BPM solution is very flexible, as it is independent of ERP data structureUnreliable analytic platform with poor performance - Business Info

25、rmation Warehouse (BW) Hyperion Essbase is proven and reliable OLAP engine with much higher performance (MOLAP architecture) Hyperion Confidential & ProprietarySAP SEM WeaknessesDoes not support budgeting/planning process control like Hyperion Planning Entry of final budget data onlyHyperion Plannin

26、g and Pillar fully supports the processes of budgeting/planningVery hard to integrate with non- SAP R/3 data: ABAP programming using BAPI is necessaryHyperion is not dependent on specific ERP and Hyperion BPM solutions are designed to integrate data from many sourcesNeeds very long time and huge inv

27、estment to implementAverage implementation period of Hyperion BPM solutions is three months and the investment is much less Hyperion Confidential & ProprietarySales strategies and tactics against BWGo to VITO (SAP is often a Board decision)Set the agendaPush for POCTotal cost of ownership (BW / ECCS

28、 for free)Focus on value from analytic applicationsEngage partners (ACTA, Informatica)Use industry referencesUse Global Source Hyperion Confidential & ProprietarySales strategies and tactics against BWMake the customer feel confident with his investment in Hyperion also in future (Strategic Investme

29、nt)Try to convince the customer to do his investment now and not wait when SAP BW will be readyHyperion and SAP BW is not an exclusionTry to get a POC Hyperion Confidential & ProprietarySAP BWDo NOT compete SAP BW, but look for a coexistenceSAP BW is a mandatory part of the SAP deliverySAP BW will b

30、e the only way to access SAPSAP BW for reporting on top of all SAP modulesOur Best of Breed Solution:ETL Vendor (Acta, Informatica)RDBMSHyperion Integration ServerEssbaseFront-end tools (Analyzer, Reports, Application Builder, ) Hyperion Confidential & ProprietarySAP BW IssuesSAP BW is a bundle of t

31、housands different ABAPSExtract data from SAPLoad data into RDBMSISSUEIMPACTABAPS are built for SAP-Standard InstallationEvery customer customizes the SAP-standardABAPS have to be reprogrammed to fit the customizationsMajor reason for the long implementation times (9+ months) Hyperion Confidential &

32、 ProprietarySAP BW WeaknessesUnstable BW Release 3.0B is still beta qualityHyperion Essbase is already release 6.5, with quarterly maintenance patch releasesSlow due to its R-OLAP architecture = SLOWHyperion Essbase is known as a high-performance platform thanks to its M-OLAP architectureMaintenance

33、 Heavy Hard to maintainHyperion Essbase is much easier to maintain Costly High list price, and SAP is even giving away BW but still it is costly Hyperion Essbase provides much better ROI Hyperion Confidential & ProprietarySAP BW WeaknessesFunctions are poor Cannot compare with function-rich Hyperion

34、 EssbasePoor front end (Business Explorer is very hard to use)Hyperion Essbase adopts open policy and many front end tools are available from third parties, besides Spreadsheet add-in, Hyperion Analyzer, Hyperion Reports and Hyperion Application BuilderActual deployment is VERY limited and customize

35、d VERY much (like Mitsubishi Corporation in Japan)Hyperion Essbase has literally thousands of customer base and some customers are using Essbase with more than 10,000 usersHard to integrate non SAP data (ABAP/BAPI programming)Hyperion Essbase is open and can be integrated with ERP systems with Hyper

36、ion Application Link very easily.RDBs including Oracle, DB2, SQL Server, Teradata, etc. can be very easily using EIS, and many third party ETL/EAI tools also support integration with Hyperion Essbase Hyperion Confidential & ProprietarySAPInternationalOther systemsExternal sources InternetFICOMMSDThe

37、 SAP-way Hyperion Confidential & ProprietarySAPInternationalOther SystemsExternal Data Sources/ InternetFICOMMSDHRSISEISControllingBalanced ScorecardMISHyperion The Right WayHyperion Essbase XTD Hyperion Confidential & ProprietaryAggregate revenues, quantities, and average prices by customer for 25,

38、000 customers, within customer groups, by product families, across 17 time periods (12 months, 4 quarters, year)Aggregate revenues, quantities, and average prices by customer for 25,000 customers, within customer groups, by product families, across 17 time periods (12 months, 4 quarters, year)Calcul

39、ate percent share per product and product family for 50,000 products and 500 product families by 50 market regions, by 10 distribution channelsAggregate revenues, quantities, and average prices by customer for 25,000 customers, within customer groups, by product families, across 17 time periods (12

40、months, 4 quarters, year)Calculate percent share per product and product family for 50,000 products and 500 product families by 50 market regions, by 10 distribution channelsAllocate corporate overhead expense to 3,000 cost centers as a percent of cost center headcount to total corporate while alloc

41、ating marketing admin expense to 50,000 products based on product shareAggregate revenues, quantities, and average prices by customer for 25,000 customers, within customer groups, by product families, across 17 time periods (12 months, 4 quarters, year)Calculate percent share per product and product

42、 family for 50,000 products and 500 product families by 50 market regions, by 10 distribution channelsAllocate corporate overhead expense to 3,000 cost centers as a percent of cost center headcount to total corporate while allocating marketing admin expense to 50,000 products based on product shareS

43、how customers who purchased products A and B, but not C during the past three quartersSpeed of Thought Answers = All very difficult in SAP BW! Hyperion Confidential & ProprietaryInformation at the Speed of ThoughtImmediate (MOLAP)I can be:experimentalcreativeiterativeI can afford to:try different th

44、ingsbe wrongfollow my intuitionPerformance has a great impact on the effectiveness and the productivity of the end user communityBill InmonLong Queries (ROLAP)I:Have to get right the first timeCant take chancesDo not have the luxury of being able to be wrongCant follow my intuitionCannot try experim

45、ents Hyperion Confidential & ProprietaryComments from Gartner on SAP BW8000+ tables with extremely difficult data modelNo drill down or drill acrossConsider alternatives for BW when analyzing from multiple sources and appsSAPs path of delivery is unclearEstimate of productive sites: 100Business Expl

46、orer is a bundled Excel version Hyperion Confidential & ProprietaryComments from Bill Inmon on SAP BW9000+ tables (performance and integrity)A bunch of cubes is not a DWHLack of reconcilabilityDownside of info cubes (SAP BW)Different granularityDifferent dimensionsDifferent calculations or roll ups

47、of dataDifferent volumes of dataStaging area cannot be accessed by 3rd party toolsManagement of historical data storage is a big problem in SAPAnalyze carefully what SAP claims to deliver Hyperion Confidential & ProprietaryComments in Computerwoche about SAP BWSAP BW realizes in a User-Friendly way

48、the reporting in SAP R/3 NOT MORE. For Online-Ad-Hoc-Analysis, the main task of Data Warhousing, it is less suitable.Computerwoche, 16th of june 2000 Hyperion Confidential & ProprietaryProIntegration with R/3, fast ETL-Process possible, if you leave the SAP standardClosed process, feedback to the tr

49、ansaction system R/3Predefined Business ContentsRelative fast implementation, if you leave the SAP standardPrice: For new SAP customers its already part of the license, existing customers pay $ 250,- per UserBW is analysis and planning platform for New-Dimension-Products (SEM, CRM, SCM, etc.)Comment

50、s in Computerwoche about SAP BWContraClosed system with proprietary interfacesLong and complicate process for the integration of third party systemsABAB-Knowledge required, for non-SAP-Customers the BW is more likely an optionPerformance with large amounts of data is questionableJust Microsoft Excel

51、 as presentation-tool of the SAP standardMassive growing business content makes it more and more difficult to find the right report, costs for consulting may grow therefore massivelyAnalysis-tool works as pure OLAP-Engine, performance is questionableComputerwoche, 21st of april 2000 Hyperion Confide

52、ntial & ProprietaryWhat Analysts says about SAP BWOLAP Report“SAP BW is inferior to OLAP vendors products in all aspects flexibility, openness, performance, and reliability. It is recommended to use products like Hyperion.” http:/ Hyperion Confidential & ProprietaryTrapsPriceWhen SAP realizes, that

53、Hyperion is the competition, they can be very creative!Keep telling the story of total cost of ownership! (Not only license, but also implementation costs)We are going to implement BW anyway!This is ok, use it for your standard reporting like you did it in the past with R/3. A lot of our customers a

54、re doing this (e.g. Siemens).For extended reporting, analysis, modeling and planning use Hyperion! Hyperion Confidential & ProprietaryCustomer SuccessesBell CanadaChevronPacifiCorpBayerSiemens ShellGuinnessMarconi CommunicationsNew York LifeMonsantoAustria TelecomKelloggRocheAmann & Shne Hyperion Co

55、nfidential & ProprietaryWith the Hyperion Rapid Information Warehouse we had the first sophisticated financial analysis with SAP data after 5,5 days“DI. Max Schaffer - CIO, sterreichische Post AG Austria Telecom Hyperion Confidential & ProprietarySiemensArdent DataStageIBM DB/2HyperionEssbaseWeb-Bro

56、wserLocal Hyperion Confidential & ProprietarySiemens Hyperion Confidential & ProprietaryFlexible DeploymentSupports Intranet IT StrategyVendor Provided PackageSpreadsheet use as an “Option”ScalabilitySeamless integration with SAPAddress complex allocation requirementsPowerful standardized reportingF

57、lexible ad-hoc analysisKellogg A SAP shop:Software Selection Criteria March April 2001 Hyperion Confidential & ProprietarySAP Profit Center AccountingAdaytumComshareSRCOracle Financial AnalyzerHyperion EssbaseHyperion PlanningHyperion Financial ManagementKellogg Software Evaluated April June 2001 Hy

58、perion Confidential & ProprietaryNumber of P&Ls desired would negatively impact current SAP migration to KUSARegression testing requiredInability to handle complex allocationsInability to address planning processData entryProcess managementLack of flexibility for businesses to view product groupings different from SAP Materials HierarchyWhy SAP Not Selected by Kellogg Hyperion Confidential & ProprietaryHyperion PlanningWeb EntryProcess ManagementHyperion Reports Web Reporting with user PromptingHyperion Business Rules Address Complex AllocationsHyperion Application LinkHype