SAP BusinessObjects 4.0 - BI / DW Insider

1 SAP BusinessObjects Best BI Suite for EveryoneHunter Downey ,Solutions AdvisorSundu Venkataramani, Client Partner SAP AG 2010. All rights reserved. / Page 2 Agenda1. Easier Reporting for Self Service2. Better Visualizations3. Q&A SAP AG 2010. All rights reserved. / Page 3 Faster PerformanceConsistencyMobilityIntegrated Data ServicesBetter Self ServiceWhat were the WANTS ?Visualize SAP AG 2010. All rights reserved. / Page 4 SAP BusinessObjects Best BI Suite for EveryoneEngaging User Experience Modern styling and unified look and feel Refined interactivity with shared charting, alerting, and search options Common query design experience acrossall data sources New Semantic Layer Native multi-source support for fresh perspectives New information design tool for heterogeneous access over all sources New abstraction layer for multi-dimensionaldata sourcesSimplified, Right-Scale Deployment Enhanced scalability with virtualization andnative 64-bit support Comprehensive system diagnosis and monitoring New auditing for compliance and usage analysisKnow Your BusinessAchieve Remarkable ResultsComplete BI SuiteBI OnDemandEngaging UserExperienceTransform Your DecisionsIntegrated Tools and Efficient Workflows1 Common InfrastructureDeep Business Insights and Context SAP AG 2010.

2 All rights reserved. / Page 5 New Semantic Layer for Exposing Business Data Under a Single UmbrellaBusiness LayerBusiness LayerData Foundation Single or Multi-sourceData Foundation Single or Multi-sourceData Federation EngineData Federation EngineQuery and Calculation Engine Servicing DataQuery and Calculation Engine Servicing DataDashboardsCrystal ReportsExplorerWeb IntelligenceLive OfficeWeb ServicesWeb ServicesInformationDesign ToolInformationDesign ToolSAP BWOLAPA pplicationDatabaseCustomerDatabaseTextXM LWebServiceHighlights Consistent business user experience Trusted access to information Heterogeneous access overall sources Multi-source perspective SAP AG 2010. All rights reserved. / Page 6 The Best BI Suite for SAP CustomersDashboardsCrystal ReportsWeb IntelligenceOLAPA nalysisExplorerLeverage all of your investments - BW cubes and BEx query designTransition BEx analyzer users to next gen BI nowAdopt SAP BusinessObjects BI platform at your own paceLeverage all of your investments - BW cubes and BEx query designTransition BEx analyzer users to next gen BI nowAdopt SAP BusinessObjects BI platform at your own paceInnovation Without DisruptionBring advanced analysis to the familiar Microsoft Office experience with new Analysis toolsBoost user adoption with the SAPB usinessObjects BI suiteBring advanced analysis to the familiar Microsoft Office experience with new Analysis toolsBoost user adoption with the SAPB usinessObjects BI suiteSimpler and More IntuitiveGet Immediate response time regardless of data volumeBuild pervasive BI applicationsIntegrate with SAP monitoring, lifecycle management, search.

3 And user managementGet Immediate response time regardless of data volumeBuild pervasive BI applicationsIntegrate with SAP monitoring, lifecycle management, search, and user managementScale and Power SAP AG 2010. All rights reserved. / Page 7 Self-Service Information ConsumptionNew content navigation and searchEasier self-service access to find all available informationEnhanced filtering and search options reducing page scrollingEnhanced navigation for working with multiple documents SAP AG 2010. All rights reserved. / Page 8 Engaging New User Experience Modern styling and unified look and feel for all BI solutionsRefined user experience New charting options andribbon toolbar for all solutions Expanded interactivity Common query designexperience across all data sources SAP AG 2010. All rights reserved. / Page 9 Self-Service Access to Deep Business InsightsSAP BusinessObjects Analysis, OLAP EditionAdvancedanalytical capabilitiesAnalyze across multiple dimensions and hierarchiesUncover deep business insightsBoost user adoption and lower TCO with web-based analysisLeverage all your investments -BW cubes and BEx query design, and BI platform SAP AG 2010.

4 All rights reserved. / Page 10 Take Your Productivity to the Next LevelSAP BusinessObjects Analysis, Microsoft Office EditionEasy-to-use OLAP analysis in OfficeFamiliar and intuitive Microsoft Office user experienceUncover deep insights with powerful Excel-based analytical capabilitiesBring analyses into PowerPoint presentationsLeverage all your investments -BW cubes and BEx queries,and BI platform SAP AG 2010. All rights reserved. / Page 11 There Are More Mobile Phones Than Toothbrushes (5B vs ) 2011 SAP AG. All rights reserved. / Page 11 SAP AG 2010. All rights reserved. / Page 12 SAP BusinessObjects Mobile BIInteractive Reports & Dashboards Make informed decisions with instantaccess to personalized informationLeverage existing BI investments & skills to quicklyreach mobile usersEnsure secureaccess to information across a range of devicesReceive alerts on critical events Investigate problems and opportunities Take immediate action SAP AG 2010.

5 All rights reserved. / Page 13 SAP Business Objects Exploration Views Objects Exploration Views Empowers business users to easily create, navigate & share key business views. Highly Personalized & Dynamic Experience Leverage investments in Business Objects Enterprise, Explorer , in-memory data sources (HANA, BWA) & Semantic Layer Smart visualization with auto adapting Views on mobile Interact and analyze make informed business decisions. SAP AG 2010. All rights reserved. / Page 14 Architecture SAP AG 2010. All rights reserved. / Page 15 What s notnew?Global server side architecture is the same nGlobal server side architecture is the same nGlobal server side architecture is the same nGlobal server side architecture is the same n----tier tier tier tier architecture with :architecture with :architecture with :architecture with : web application server and BI4 webapps in frontweb application server and BI4 webapps in frontweb application server and BI4 webapps in frontweb application server and BI4 webapps in front BI4 BI4 BI4 BI4 servers in the backservers in the backservers in the backservers in the back and a BI4 repository database at the a BI4 repository database at the a BI4 repository database at the a BI4 repository database at the using CORBA for interStill using CORBA for interStill using CORBA for interStill using CORBA for inter----server is still the main central is still the main central is still the main central is still the main central server.

6 SAP AG 2010. All rights reserved. / Page 16 What s new?Installed productsInstalled productsInstalled productsInstalled products64 bits servers, but64 bits servers, but64 bits servers, but64 bits servers, third parties SAP AG 2010. All rights reserved. / Page 17 More BO products installed as default with BI4 and some new stuff on existing servicesLCMis included LCM now can use SAP transport system LCM webapp still indepedant (but in the same war than) (..8080:/BOE/LCM) BO Mobileis included BO Mobile administration now integrated in BI4 platform user right management (in CMC) mobile server administration (in CCM)Query Builderis still there ..:8080/AdminToolsPlatform Search new indexing engine (Lucenefrom Apache group) indexes ALL content (including report data) (configurable in CMC) externally integrable though OpenSearchAPI self healing search engine (automatically start/stop depending on CPU usage) SAP AG 2010. All rights reserved. / Page 18 New third parties installed with productFollowing Oracle move on Sun, MySQL is no longer the default database:Windows systems Microsoft SQLS erver 2008 Unix systems DB2 Personal Edition!

7 Bundled DB2 installer on Unix is fragile, prerequisitesTomcat was upgraded from to (release note)! Note that Tomcat with BI4 is quite long to start (>10mn)Same load time with a deployment on Tomcat probably due to the size of BI4 webapp (one single war)SAP JVM now installed with BI4 used by all backend Java servers. SAP AG 2010. All rights reserved. / Page 1964 bits serversStarting with all backend servers are 64 bits. Including all Java processes Backend servers and web application server (Tomcat)For backward compatibility reasons some are not: There is a 32 bits Connection Server And a 32 bits Crystal Reports ServerBI clients are all 32 bits, nothing new here server and client install on same machine supported (but not advised) SAP AG 2010. All rights reserved. / Page 20 Servers & ServicesThe term serveris used to describe an operating system level processhosting one or more services. For example, the Central Management Server (CMS) and Adaptive Processing Server are servers.

8 A server runs under a specific operating system account and has its own serviceis a server subsystem that performs a specific function. The service runs within the memory space of its server under the process id of the parent container (server). For example, the SAP BusinessObjects Interactive Analysis Scheduling and Publishing Service is a subsystem that runs within the Adaptive Job description of server types, services affectation per server, services types, services definition is available in the BI4 Administration Guide. CMC Demo SAP AG 2010. All rights reserved. / Page 21 AuditingPlatform auditing architecture changed in BI4 Auditing still done by the CMS ADS = Auditing Data Store (Audit database) local auditing text files are written in a local folder (path configurable) flushed to ADS by CMS auditing thread every 3mn CMC/Audit text background color gives flushing task state flush delay automatically adjusted from previous flush timeAuditing management application in CMCNo more default Universe and reports delivered with the product SAP AG 2010.

9 All rights reserved. / Page 22 Upgrading to BI4BI stands for BusinessObjects stands for Business IntelligenceCE for Crystal XI XI R2 Direct Upgrade using Upgrade Management Tool BO 5 / BO6 BOE XI CE8 / CE9 / CE10No direct Upgrade Go first to XI R2 or XI from BO 5/ 6 CE8/9/10 to XIR2 & XI3 with Import Wizard preferred SAP AG 2010. All rights reserved. / Page 23 Thank you!