mySAP BI解决方案介绍

1、mySAP BI 解决方案介绍mySAP Business Intelligence OverviewAgenda Positioning / Value Proposition Data WarehousingBI PlatformBusiness Intelligence SuiteSAP NetWeaver 04 IntegrationBusiness ContentRoadmapAgenda Positioning / Value Proposition Data WarehousingBI PlatformBusiness Intelligence SuiteSAP NetWeave

2、r 04 IntegrationBusiness ContentRoadmap SAP Business Intelligence is an enterprise-class, complete, open and integrated solution that delivers actionable insights.SAP BI The Solution at a GlanceData acquisition, data warehousing, OLAP, planning framework, BI tools, dashboards and analytical applicat

3、ions; with pre-configured content using best-practice models.Open, well documented APIs and interfaces along with full functionality to integrate structured and unstructured, heterogeneous dataScalable and reliable BI solution that is tightly integrated with SAP Netweaver, source transactional syste

4、ms and partners complementary toolsSupport decision-making requirements of the entire enterprise regardless of data sources of access methodsConvert data into information, and ensure information is delivered at the right time to the right person in the right format to support business decision makin

5、g. Pain Points, Customers without a BI SolutionNo central access: Data relelavnt for decision-making are spread in different systems across the IT landscape. Analyses are time consuming and not always consistent. Time Consuming: Often, decision makers have to spend too much time on finding relevant,

6、 timely information before they can even analyze it. Bad Performance: The response time of complex analyses in operational systems is often not acceptable. Complexity/IT-Dependency: Transactional systems often require additional programming efforts to retrieve relevant information. Employees without

7、 programming know-how are not able to run ad-hoc analyses.Missing business process support: Exceptions are not alerted to those who should know. The Value of mySAP BICompleteness: End-to-end BI solution incorporating data warehousing, OLAP, data mining, business intelligence tools and pre-defined bu

8、siness content. Openness: Allows to incorporate data from heterogeneous systems. Supports industry standards such as XML for Analysis or ODBO for reporting and analysis.Performance/Scalability : A proven solution with that generated and loaded a 5.5 Tb data warehouse.Business Orientation: Integrates

9、 business processes. Provides a centralized metadata repository with a consistent business semantic. Ready-to go templates and best-practices horizontal and vertical business content.Actionable Information: Supports decision-making requirements of every user.SAP BI Key CapabilitiesData Warehousing (

10、SAP BW Administrator Workbench)Extraction, transformation, and loading Data warehouse managementBusiness modeling BI PlatformOnline analytical processing (OLAP) Data MiningAlertingMeta Data RepositoryPlanning FrameworkBI Suite of Tools (SAP BW Business Explorer)Query Design Managed Reporting and Ana

11、lysisVisualization Web Application DesignCollaborationPre-configured Business ContentKey Areas adressed with SAP BIOpennessOpen Hub Service dissemination of informationUD Connect directly access data to relational database tables and OLAP systemsSupport of industry standards (e.g. XML, XML for Analy

12、sis, JDBC etc.)IntegrationIntegration of technology, tools and applications allowing cross-enterprise analytics and closed-loop scenariosIntegration into the Enterprise Portal as single point of entry Integration of unstructured information such as documents, files, etc.Web OfferingInteractive analy

13、sis of information via web and mobile devices Intuitive design of web applicationsAd-hoc query design via the webSAP Business IntelligenceSourcesDataWarehousingBI PlatformBI SuiteData AcquisitionAccessOpen Interface a. Web ServicesData PresentationUserSAP Business Intelligence integrates all your co

14、rporate information so you can turn information into insight, insight into action, and action into improved business operations.SAP BI ArchitectureAgenda Positioning / Value Proposition Data Warehousing - ETLBI PlatformBusiness Intelligence SuiteSAP NetWeaver 04 IntegrationBusiness ContentRoadmapExt

15、raction, Transformation and Loadingto get a complete view of your businessOpen for any sourceFlexible set of ETL capabilities Integration on application levelOpen to third-party toolsSupport of open standardsOperational Data Store and Data Warehouse layerData WarehouseNon volatileGranularIntegratedH

16、istorical foundationBuilt with ODS ObjectsOperational Data StoreOperational Reporting Near Real-Time / VolatileGranular Built with ODS ObjectsMultidimensional ModelsMultidimensional analysisAggregated viewIntegratedBuilt with InfoCubes. to provide the right information for all users BW Load Pack XML

17、 PackAppl. Spec.Extr.PackApplicationPACKsE-Business ApplicationsLegacy SystemsVSAMRDBMS (DB2)ADABASSAP R/2FileNon SAP BusinessAPISAPBWServiceAPIDevelopmentTestingProductiveBW Service API for SAPmySAPComponentsS I E B E LDB Connect/Flat FileSAPs Data Aquisition Strategy PeopleSoftOracle BW Load Pack

18、NativePlugInsComp.FlatFTPApplicationPACKsDataStage ETL ComponentsTransformation within BW data flowCondition HandlingDate ConversionCurrency ConversionConcatenation.Other functions:Skip recordAbort packageCheck initial valueUser-defined functions, that can also be re-used in other transformation rul

19、es setup via BAdI (Business Add-In), e.g. to integrate self-defined function modulesTransformation Library List of Functions Mathematical functions: add, sub, mul, div, () CEIL / FLOOR ROUND, TRUNC EXP, FRAC ABS, SIGN SQRT LOG / LOG10 DIV / MOD trigonometric functions exponentsString functions: subs

20、tring concatenate to upper case shift left / right condense (no gaps) trim left / right strlen replace left / right Logical operators: =, , , =, =, IF, AND, OR, NOTDate conversion: week_first_day (computes date (Monday) of cal. week) date_conv (converts external date format into internal format) dat

21、e_diff (days between two dates) add_to_date (adds days to date) date_weekday (computes weekday from date) date_week (computes week from date) date_month (computes month from date) date_quarter (computes quarter from date) date_year (computes year from date) date_fiscyear (computes fiscal year from d

22、ate) week_quarter (computes quarter from week) week_month (computes month from week) month_quarter (computes quarter from month) month_year (computes year from month)BW Process Chains Automating the BW administration Graphical modelling and monitoring End-to-end monitoring Openness for all kinds of

23、processes Scheduling Controlled distribution of consistent dataTarget: file or DB table Central monitoringSelect filter criteria and columnsSchedulingFull or delta modeODS ObjectsOpen Hub Service - DetailsAgenda Positioning / Value Proposition Data Warehousing - ETLBI PlatformBusiness Intelligence S

24、uiteSAP NetWeaver 04 IntegrationBusiness ContentRoadmapSAP BI Key ComponentsData AcquisitionCommon Read / Write InterfaceOpen Interface and Web Services USER InteractionAccessBusiness LogicPresentationData WarehousingBI PlatformBI SuiteSummarized, Dimensional DataBI ServicesBI Suite Granular, Volati

25、le DataODSRDBMSData PartitioningIndexingParallel QueryingMaster DataDrill-Down, Drill-Through, Drill-AcrossPivotingWhat IfSlice and DiceGallery of ready-to-use Web Templates / ItemsTable, ChartMapAlert MonitorContext MenuBusiness CalculationsPlanning and ForecastsException ScanningAlertingQuery Pre-

26、CalculationCachingBackground PrintingData MiningOLAP Business ScenariosExamples for OLAP Business ScenariosCreation of complex formulas, down to cell levelUsage of conditions and exceptions in reportsMulti-currency handlingFlexible hierarchy analysisNon-cumulative key figures to analyze data from in

27、ventory management dataElimination of internal business volumeMarket share analysisSlow moving items. . . MetadataCentral Metadata RepositoryCentral display of Metadata ObjectsGraphical viewHTML basedDownload capabilitiesXML Metadata exchanggeData MiningData Mining Methods in SAP BW 3.5Classificatio

28、nDecision TreeClusteringClusteringAssociation AnalysisApproximationScoringFurther AnalysesABC ClassificationData Mining DefinitionAnalytical approach that look for hidden data patterns and relationships in large databasesProvides insights by analyzing past data and predicts future trends and behavio

29、ursEnables prospective decision-making as opposed to pure retrospective analysisAnalysis Process DesignerAnalysis Process Designer (APD)ScenarioData (available through all SAP BW storage media) can be explored within a multilevel process, applying advanced analytical methods in order to gain new ins

30、ights from these data. The analytical results are persisted again within SAP BW.ExamplesABC-classification (e.g. customer/vendor)Determination of the frequency distribution in datasetsDevelopment of Scoring informationFeature DescriptionInteractive modeling (drag&drop) workbench for analysis process

31、esInfrastructure to link up process elements, being sources (selection of data), targets (deployment of results), pre-processing (transformation) and visualization tools as well as data analysis methods.Analysis of data at every step of the analysis processmySAP BI Planning & Simulation: BW-BPSBusin

32、ess Planning & Simulation in SAP BWPlanning & Simulation ScenariosResearch / PrognosisEstimating future situations and evaluating their impact on the enterpriseTarget SettingSetting goals and milestonesBudgetingEvaluating and allocating resources for the achievement of targetsExamplesSales Plan, Res

33、ource Plan, Cost Center Plan, Profitability PlanningBenefits of offering BW-BPS with SAP BW 3.5No installation of SAP SEM Add-On necessary for usage of planning functionalityOne software installation onlyOne support package cycle One project budget for planning and analysisBusiness Planning & Simula

34、tion: FeaturesPlanning and analysis user interfacesPlanning in ExcelPlanning in Web InterfaceDocument managementAnalysis in Business Explorer (Excel and Web)Planning FrameworkMultidimensionalBusiness StructuresDefinition of work packagesHierarchy maintenanceVersion conceptUser authorizationsVariable

35、s maintenancePlanning functionsCopy/deleteRevaluateTop-down distributionBottom-up aggregationTrend analysisWhat-if-analysisSimulationPlanning sequencesAutomatic execution of planning functionsControl and distribution of dataStatus and Tracking MonitorRetractors for distribution of data to operationa

36、l systemsBackground processing of planning functionsModeling of Planning structuresAutomatic PlanningManual PlanningProcessControlAgenda Positioning / Value Proposition Data WarehousingBI PlatformBusiness Intelligence SuiteSAP NetWeaver 04 IntegrationBusiness ContentBI Netweaver Integration / Roadma

37、pmySAP BI - For All User TypesAuthors and analysts. need advanced analysis functionality and ad-hoc data exploration capabilities. require useful, manageable tools Executives and knowledge workers . require personalized information in context via an intuitive user interface. want predefined analysis

38、 paths and the option of in-depth analysis of summary data.Information consumers . need a snapshot of a particular data set to perform their operational tasks. do not interact extensively with the data. The Business ExplorerBusiness Explorer: Query, Analysis & ReportingBEx Query, Reporting & Analysi

39、sQuick and easy design of interactive queries for analysis and reportingAnalysis & Reporting via Web or embedded into MS ExcelOnly Filter and Column Section in tabular modeReporting - Integration with Crystal Reports Out of the box presentation-quality reporting Reports and documents optimized for p

40、rinting and sharing Broad range of pre-defined crystal reports: legal, financial, etc SAP and non-SAP data in a single report Seamless portal integration Schedule and view Crystal reports in managed web environment Offline reporting and viewing of reports Interactive AnalysisAnalyze different aspect

41、s of the businessMulti-dimensional viewsGeneric navigation and interaction (slice and dice, drill-down, drill-thru, pivoting, .)Hierarchy navigationGlobal, enterprise-wide useMulti-language, multi-currencyIntelligent ServicesAlerting (traffic lights)ConditionsUser access and interactionWeb-based (PC

42、 or mobile)Windows-based via Business Explorer AnalyzerOLAP analysis in MS ExcelIntegration point for query and web application designLeverage native Excel features (i.e. office integration)Tight integration of web- and MS Excel-based analysisBusiness Explorer Web Application FrameworkBEx Analyzer /

43、Query DesignerWeb Design Tool (option)BEx Web Application DesignerWeb BrowserOLAP ProcessorBW Serverwith SAP Web ASWeb ServiceCharting EngineHTML TemplatesInfoProviderBEx Web: Design of BI Web ApplicationsBEx Web Application DesignerOffers the ability to create wide range of analytic web application

44、sBuild custom BI applicationsCockpits / Dashboards Wizard-based visualizationPublishing Device specific output generationPortal integrationAPIs for further web designWeb Application Example Download Scheduler for Offline ReportingScheduled or immediate DownloadWeb Templates, Excel SheetsExcel Sheets

45、Web TemplatesWeb Templates(optimized for PDAs)Information Deployment Personalized information and decision support for all users Share and analyze business informationAnalytics in contextCollaborative BIEmployeeCustomerCitizenBusinessPartnerSeamless Integration of BI Web Applications into the Enterp

46、rise PortalOLE DB for OLAPbased on COM as protocoldriver installation on clientsWindows platform onlyMDX as query language available since BW 1.2BOLAP BAPIsBusiness Application Programming interfacebased on RFC as protocolaccess library available on any SAP platformMDX as query languageavailable sin

47、ce BW 2.0AXML for Analysisbased on XML as exchange formatbased on HTTP/SOAP as protocolany platformMDX as query languageavailable since BW 3.0AOpen Analysis InterfacesAgenda Positioning / Value Proposition Data WarehousingBI PlatformBusiness Intelligence SuiteSAP NetWeaver 04 IntegrationBusiness Con

48、tentRoadmapd001693:Bex suite instead of .suiteSAP NetweaverTurning Enterprise Services Architecture Vision Into RealityThe open integration and application platform for TCO reductionIntegrate people, information and processes in 1 hub across technologiesand organizations.Enterprise-scale Java and AB

49、AP application platform.NET and WebSphere interoperability and extensibilityPre-configured with business contentAdapters to non-SAPSAP NetweaverComposite Application FrameworkPEOPLE INTEGRATIONMulti channel accessPortalCollaborationINFORMATION INTEGRATIONBus. IntelligenceMaster Data MgmtKnowledge Mg

50、mtPROCESS INTEGRATIONIntegration BrokerBusinessProcess MgmtAPPLICATION PLATFORMJ2EEDB and OS AbstractionABAPLife Cycle MgmtInformation Integration and BIDB and OS AbstractionSAP NetweaverInformation IntegrationPeople IntegrationKnowledge ManagementKnowledge ManagementIntegrate & unify multiple sourc

51、es of unstructured contentCommon servicesIndexing, classification, searchPublish & subscribeAuthoring, versioning, Rating, discussion forum, For use in business applications & stand-aloneWhat it means for Business Intelligence:Base decisions on hard & soft factsCommon context for reports & documents

52、Explain insights and definitions (e.g. terminology)Annotate BI data and meta-dataShare & disseminate insightsParticipate in knowledge management servicesEnterprise searchPeople Integration & Business IntelligenceDB and OS AbstractionSAP NetweaverInformation IntegrationPeople IntegrationPortalPortalS

53、implify the life of the userRole-based & personalizedUnify complex application landscapeAny source, secure & robustProvide task contextEnable new composite applicationsWhat it means for Business Intelligence:Empower more people within & beyond the enterpriseDisseminate the right information to the r

54、ight user at the right timeAlert timely and allow for immediate action BI for the massesClose the loop from insights to actionTask contextSeamless navigationCollaboration & Business IntelligenceDB and OS AbstractionSAP NetweaverInformation IntegrationPeople IntegrationCollaborationCollaborationEnabl

55、e teamsEasily share information and applications across rolesCommunicate in real-time or asynchronouslyManage team activitySAP and non-SAP collaboration technologiesWhat it means for Business Intelligence:Support the decision making processesBroadcast BI data to teams and individualsIntegrate data i

56、nto collaboration roomsSend alerts to teams & individualsSubscription services The Solution: Information Broadcasting Powered by SAP BISAP BI: Information Broadcasting Information BroadcastingBroadcasted BI data can be directly accessed by end-users as KM documentsEnd-users can choose from a broad r

57、ange of KM Services for their BI data:SubscriptionFeedbackDiscussionCollaborationRatingTREX searchNotesDownloadInformation Broadcasting Target: Collaboration RoomsBI Data can be broadcasted into Collaboration RoomsCollaboration Rooms ServicesChatApplication SharingNotesMeeting PadDiscussion ForumsIn

58、stant MessagingMy Portal ContactsWeb Application Server & Business IntelligenceDB and OS AbstractionSAP NetweaverInformation IntegrationApplication PlatformProcess IntegrationPeople IntegrationWeb Application ServerWeb Application ServerHomogeneous infrastructure for J2EE-based and ABAP-based applic

59、ationsBrings together the benefits of a proven, scalable and reliable infrastructure with the interoperability and flexibility of Web Services technologyPowerful Java platformWhat it means for Business Intelligence:Complete database and operating system portabilityConsistent user accecessCommon aler

60、t frameworkUniversal Data IntegrationUniversal Data IntegrationBI Java Connectors to provide access to any data (relational, OLAP)Based on industry standards for interoperability (JDBC, XMLA, ODBO) Universal Data Connect to integrate data into the BW platformBI Java SDK for custom built Java Applica