SAP-COMERIT_BOBJ_for_2009_v4
Werbung
What to Do With BOBJ in 2009 Tanner Spaulding, SAP Labs Dr. Bjarne Berg, COMERIT The Business Intelligence Experts Introductions You can request a copy of today’s presentation by sending an email request to [email protected] The Business Intelligence Experts 2 Agenda The SAP BOBJ Roadmap Current development status by tool Software rampup plans Training plans What can be done now What are others doing Key points take away Questions and Answers The Business Intelligence Experts 3 Product Directions for BI Solutions Richest Offering for All Business Users And Much More… Dashboards, Visualization Web App Designer Xcelsius Polestar Enterprise Reporting Report Designer Crystal Reports Ad-hoc Query & Reporting BI Widgets Web Intelligence Advanced Analysis Mobile BI SAP BEx Analyzer Voyager Predictive Enterprise Data Warehousing & BI Platform Web Services SAP NetWeaver BW and BWA © SAP 2008 / Page 4 BusinessObjects Enterprise Product Directions for BI Solutions SAP BusinessObjects BI Solutions And Much More… Dashboards, Visualization Web App Designer Xcelsius Polestar Enterprise Reporting Report Designer Crystal Reports Ad-hoc Query & Reporting BI Widgets Web Intelligence Advanced Analysis Mobile BI Pioneer (OLAP Analysis) Predictive Enterprise Data Warehousing & BI Platform Web Services SAP NetWeaver BW and BWA © SAP 2008 / Page 5 BusinessObjects Enterprise How Business Objects Tools Expand the Scope of BI Pioneer Web Intelligence Xcelsius Advanced Analytics Crystal DashDashboards boards Enterprise Enterprise Reporting Reporting Ad-hoc Reporting Polestar Ad-hoc BI Search Functional Scope of the SAP BusinessObjects Tools Suite © SAP 2009 / 6 How Business Objects Tools Expand the Scope of BI Pioneer Xcelsius Web Intelligence Polestar Crystal Dashboards Fast BI Search for Polestar masses of casual users Enterprise Reporting Each tool in the suite has its specific strengths and is tailored to a specific purpose . Which tools and combinations to use depends on customer needs & strategy © SAP 2009 / 7 How Business Objects Tools Expand the Scope of BI Pioneer Xcelsius Crystal Dashboards WebIntelligence Web AdHoc Reporting for Intelligence Business users - Adhoc report design - Merge personal & corporate data - Same online & Offline experience Polestar Enterprise Reporting Each tool in the suite has its specific strengths and is tailored to a specific purpose . Which tools and combinations to use depends on customer needs & strategy © SAP 2009 / 8 How Business Objects Tools Expand the Scope of BI Pioneer Pioneer Advanced Analytics for Business Analysts Xcelsius Crystal Web Intelligence - AdHoc OLAP - Packaged OLAP Content Dashboards Polestar Enterprise Reporting Each tool in the suite has its specific strengths and is tailored to a specific purpose . Which tools and combinations to use depends on customer needs & strategy © SAP 2009 / 9 How Business Objects Tools Expand the Scope of BI Xcelsius Pioneer Dashboards for information consumers Xcelsius - Packaged BI dashboards - Dashboard design for professional users Crystal Dashboards Web Intelligence Polestar Enterprise Reporting Each tool in the suite has its specific strengths and is tailored to a specific purpose . Which tools and combinations to use depends on customer needs & strategy © SAP 2009 / 10 How Business Objects Tools Expand the Scope of BI Pioneer Xcelsius Web Intelligence Crystal Packaged formatted Dashreports for the entire boards Crystal enterprise -- easy to consume Enterprise -- pixel exact & print optimized Reporting Polestar Each tool in the suite has its specific strengths and is tailored to a specific purpose . Which tools and combinations to use depends on customer needs & strategy © SAP 2009 / 11 Agenda The SAP BOBJ Roadmap Current development status by tool Software rampup plans Training plans What can be done now What are others doing Key points take away Questions and Answers The Business Intelligence Experts 12 Overview: Options for Universe-Based Access to BW 7.0 Xcelsius WebI QT QaaWS Universes SQL Access MDX Access Data Federator RDBMS © SAP 2009 / 13 ODA XMLA BW BIA OLAP BAPI Analytic Engine ODBO Overview: Options for Universe-Based Access to BW 7.01 Xcelsius WebI QT QaaWS Universes SQL Access MDX Access Data Federator RDBMS BW XMLA DF Fascade OLAP BAPI Analytic Engine BWA changes and additions in red © SAP 2009 / 14 ODA ODBO Comparison BW Server Feature MDX BW Hierarchies Restricted and Calculated Key Figures Security BW Variables Currency and Unit Conversion Exceptions, Conditions SUM, MIN, MAX Aggregations AVG, COUNT, COUNT DISTINCT, … Aggregations OLAP Cache Navigational Attributes Mass Data Enabled Federation (e.g. BW – RDBMS, BW – BW) = fully supported = limited support / workaround © SAP 2007 / Page 15 SQL WebI – BW Interoperability via ODA (MDX) Architectural Overview Adapt MDX and Flattening to new Format ODA Optimization of the exchange protocoal (binary XML) and format (rowsets; internal API) RFC Dataset BAPIs Rowset APIs Metadata BAPIs Query execution controller Parser Execution instance Function library MDX engine Analytic Engine BIA or RDBMS © SAP 2007 / Page 16 Optimization of memory consumption Implementation of Unorder() function for optimizing Sorting WebI – BW Interoperability via ODA (MDX) Details Improvements 1. Avoid unnecessary sorting MDX standard imposes results to be sorted However, those sorts are typically ignored or not required by WebI sorting can be avoided by using a new UNORDER() function in SAP's MDX 2. Leaner memory consumption during flattening optimized flattening algorithm non-standard result structure 3. Leaner communication ODA – OLAP BAPI use compressed data exchange via binary XML Availability SAP NetWeaver BW 7.01 SP 3 Business Objects Enterprise XI3.0/XI3.1 XI3.0 :Fix Pack 2 w/ LAFix2.1 XI3.1 :Fix Pack 1.2 SAP Integration Kit Fix Pack 2 w/LAFix2.1 © SAP 2007 / Page 17 Advanced OLAP Analysis Product Integration Roadmap STANDARD PREMIUM 2008 OLAP Analysis Voyager 2009 Voyager 2010 Pioneer BEx Web Analyzer BEx Web Analyzer BEx Web Analyzer BEx Analyzer (Excel) BEx Analyzer (Excel) BEx Analyzer (Excel) BEx Web App Designer* BEx Web App Designer* BEx Web App Designer* Pioneer (code name for 2010 release) provides a superset of capabilities from SAP Business Explorer (BEx) Analyzer (Excel), SAP BEx Analyzer (Web), and SAP BusinessObjects Voyager Migration from Voyager workspaces to Pioneer Web and from BEx Analyzer workbooks to Pioneer Office *Embedding of web apps built with BEx Web Application Designer into Pioneer Web by 2010 with a later migration to the Pioneer Design SDK © SAP 2008 / Page 18 Option for BW Customers: Embedding BEx Web Templates with Long-Term Migration Strategy future planned 2010 InfoView /SAP NetWeaver Portal InfoView /SAP NetWeaver Portal Pioneer Web Client Pioneer Web Client Workspace Workspace PIO Web Tab BEx Web Tab … PIO Web Tab BEx Web Tab … SAP BOE Platform SAP BOE Platform Pioneer Designer/ SDK Pioneer Web Server Pioneer Web Server BI Consumer Services BI Consumer Services BEx Queries/ InfoProviders BEx Web Templates SAP NetWeaver BW © SAP 2007 / Page 19 BEx Web App Designer BEx Queries/ InfoProviders SAP NW BW Migration BEx Web BEx Web App options via Templates Pioneer Designer SDK What Is Polestar? It’s Search Against BI… Use familiar key-word search to find business information Answers “on-the-fly” and investigative questions Searches directly on pre-indexed data No previous reports or metrics need exist Provides fast search and exploration Searches across all data sources Any universe accessible source Any BW Accelerator accessible source Note: BI Accelerator is now called BW Accelerator © SAP 2008 / Page 20 …and Then It’s Exploration Of the Results Intuitively explore on data No data model or data knowledge required Automated relevancy of results Most relevant information is displayed first Best chart type auto generated Share insights with others Export to Web Intelligence, CSV or image Save it locally as a browser bookmark One-click to send a link to the results by email © SAP 2008 / Page 21 SAP NetWeaver BW Accelerator and SAP BusinessObjects Polestar Integration Agenda The SAP BOBJ Roadmap Current development status by tool Software rampup plans Training plans What can be done now What are others doing Key points take away Questions and Answers The Business Intelligence Experts 23 Ramp-Up Availability Some Observations…. Agenda The SAP BOBJ Roadmap Current development status by tool Software rampup plans Training plans What can be done now What are others doing Key points take away Questions and Answers The Business Intelligence Experts 25 SAPBO SAP Business Objects for SAP NetWeaver BW future New 2 day course offering from SAP Education for training on Business Objects integration with SAP NetWeaver BW Two dates are currently scheduled in June for virtual course delivery June 1 – 2, 2009 June 25 – 26, 2009 See the following link to the Course Description for more detailed information on the content covered SAPBO Course Description Agenda The SAP BOBJ Roadmap Current development status by tool Software rampup plans Training plans What can be done now What are others doing Key points take away Questions and Answers The Business Intelligence Experts 27 What can be Done in 2009- Implementations Suggestion Candidates for Implementations in 2009 Tool Visual Composer Web Intelligence BI Widgets / BO Universe Crystal Report BPC BI Accellerator Purpose Visualization Ad-hoc Desktop Intelligence Formatted reports Consolidation & Planning In memory performance Visual Composer BI Accellerator Web Intelligence (webi) Widgets Source: SAP, 2009 The Business Intelligence Experts The two types of Universes There are currently 2 ways to get at the SAP BI data. If you implement this year, you need to make concious decisions about which method you select. There are pros and cons of each The Business Intelligence Experts 29 What can be Done in 2009- Take a Look at… Xcelsius Polestar is an interesting technology that companies may start a prototype with and see how it can help them access BI data from a variety of sources (NW and others) Suggestion Polestar Worth a Prototype Xcelcius Polestar Purpose Dashboards Search engine Keep an Eye on, but wait until the new release Pioneer BEx web & Excel The Business Intelligence Experts Tool What can be Done in 2009- Prototype Consider building a Xcelsius Prototype to get used to really interactive dashboards and what-if analysis. Xcelsius Source: Adobe, 2009 Suggestion Worth a Prototype Xcelcius Polestar Purpose Dashboards Search engine Keep an Eye on, but wait until the new release Pioneer BEx web & Excel The Business Intelligence Experts Tool What can be Done in 2009- Keep doing… There are many classical SAP NetWeaver tools that should still be used by companies that are planning go-lives in 2009. Integrated planning is still supported. Pioneer is still 12 months away WAD will continue to be the development environment for 2009. Suggestion Tool Web Application Designer BEx Web Keep doing for a while longer BEx Excel Analysis Process Designer Integrated Planning The Business Intelligence Experts Purpose Web development Web reporting Excel reporting Structured Analysis Planning Stop As soon as possible If you need Formatted Reports in 2009, you should seriously consider Crystal Reports. The current roadmap calls for moving Report Designer into regular maintenaice at the end of 2009, and stop further development of this tool. Looking forward to Xcelsius and Pioneer, it may be advisable to limit futher custom development in JSP unless it is not intended to be migrated at a future date. Suggestion Stop when possible The Business Intelligence Experts Tool Report Designer Custom JSP pages Purpose Formatted reports Custom applications Agenda The SAP BOBJ Roadmap Current development status by tool Software rampup plans Training plans What can be done now What are others doing Key points take away Questions and Answers The Business Intelligence Experts 34 What are Others Doing – Example 1 Many are starting to develop and prototype on the SAP BOBJ toolset. Area BI version Company A Mfg. 7.0 Casual users 209 Power users 15 This company is planning to rollout webi and their new ad-hoc query environment to a limited set of users in 2009. Dashboards - System size 3 Tb Live since 2001 The project team is small and the development will also serve as a proofof-concept for future cokpit development in 2010. Team size The Business Intelligence Experts 2009 Initiatives Webi and Crystal Reports go live in October 3.5 What are Others Doing – Example 2 This company wants to start tooling up their development team and have decided to start an Xelcius prototype effort for 2009. They also plan of migrating some of their current custom web dashboards into Visual Composer for a go-live this fall. Area BI version Casual users 713 Power users 30 Dashboards 28 System size 800 Gb Live since The Business Intelligence Experts 2000 2009 Initiatives Prototype with Xcelcius and VC dashboard deployment in September 2009 Team size Their initial team size is relativly small, with one consultant and a couple of employees. Company B Insurance 7.0 2.5 What are Others Doing – Example 3 This company is rolling out formatted reporting to their core financial team and have decided not to use Report Designer. Instead they are rolling out Crystal as their core platform for pixel controlled formatted reports. Area BI version Casual users 806 Power users 50 Dashboards 42 System size 4.6 Tb Live since 2009 Initiatives Team size They also want to start the team transition to Xcelsius and is therefore also developing some prototypes on this technology. The Business Intelligence Experts Company C Utility 7.0 2004 Crystal rollout October and Xcelsius Prototype 5 What are Others Doing – Example 4 This company rolled out Crystal reports on SAP BI in 2006 and is starting in 2009 with a project effort to migrate to Xcelsius for web rendering and cockpits. They have also started to develop visual composer cokpits that they plan on integrating into Xcelsius later in spring 2010. The Business Intelligence Experts Area BI version Company D Mfg. 7.0 Casual users 1012 Power users 18 Dashboards 22 System size 2.1 Tb Live since 2009 Initiatives Team size 2003 Visual composer and Xcelsius integration of existing crystal reports, go-live Nov. 2009 6 Agenda The SAP BOBJ Roadmap Current development status by tool Software rampup plans Training plans What can be done now What are others doing Key points take away Questions and Answers The Business Intelligence Experts 39 Summary – Ideas for SAP BOBJ in 2009 Suggestion Candidates for Implementations in 2009 Worth a Prototype Keep an Eye on, but wait until the new release Tool Visual Composer Web Intelligence BI Widgets / BO Universe Crystal Report BPC BI Accellerator Xcelcius Polestar Purpose Visualization Ad-hoc Desktop Intelligence Formatted reports Consolidation & Planning In memory performance Dashboards Search engine Pioneer BEx web & Excel Web Application Designer BEx Web Keep doing for a while longer BEx Excel Analysis Process Designer Integrated Planning Report Designer Stop when possible Custom JSP pages The Business Intelligence Experts Web development Web reporting Excel reporting Structured Analysis Planning Formatted reports Custom applications 40 The total BOBJ toolset - Advanced Analytics While we covered the core BOBJ tools that relates directly to SAP BI, there are many other tools available: Source: SAP March, 2009 This Bonus Material Include all SAP BOBJ tools, not just tools for the traditional SAP ERP market The Business Intelligence Experts 41 The total BOBJ toolset –Dashboards & Visualization This Bonus Material Include all SAP BOBJ tools, not just tools for the traditional SAP ERP market The Business Intelligence Experts Source: SAP March, 2009 42 The total BOBJ toolset – BI Best-of-Breed tools This Bonus Material Include all SAP BOBJ tools, not just tools for the traditional SAP ERP market The Business Intelligence Experts Source: SAP March, 2009 43 The total BOBJ toolset – Data Integration This Bonus Material Include all SAP BOBJ tools, not just tools for the traditional SAP ERP market Source: SAP March, 2009 The Business Intelligence Experts 44 The total BOBJ toolset – Masterdata Management This Bonus Material Include all SAP BOBJ tools, not just tools for the traditional SAP ERP market The Business Intelligence Experts Source: SAP March, 2009 45 Agenda The SAP BOBJ Roadmap Current development status by tool Software rampup plans Training plans What can be done now What are others doing Key points take away Questions and Answers The Business Intelligence Experts 46 Questions and Answers The Business Intelligence Experts 47 Resources On –line Material, Presentations and Downloads www.Comerit.net Help @ SAP http://help.sap.com > ‘BusinessObjects’ top level navigation tab SAP BusinessObjects Developer Community on SDN http://boc.sdn.sap.com ‘BusinessObjects version of SDN’ Communities, Beta Product downloads, Webinar information, E-Books, Developer Conference 2007 slides, Free Trial downloads, more!... Check out the blogs and forums – there is already some great content posted Ingo Hilgefort’s bolg:https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/u/251909211 SAP NetWeaver Business Warehouse Roadmap and Roadmap FAQ https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b00a1a 75-c49d-2b10-0ebb-ecc80ab88994 https://www.sdn.sap.com/irj/boc/business-objects-for-sap-faq The Business Intelligence Experts 48 New SAP Press Book New SAP Press book by Ingo Hilgefort to be released in May 2009 Great resource for technical installation, implementation, and integration information http://sappress.com/product.cfm?account= &product=H3034 The Business Intelligence Experts 49 confidential How to contact us: Dr. Bjarne Berg [email protected] The Business Intelligence Experts Tanner Spaulding [email protected] 50
