WIXLIB

September 10-13, 2012Orlando, FloridaMigrating from Desktop Intelligence to Web IntelligenceThomas B Kuruvilla, Solution Management, SAP Business IntelligenceOlivier Duvelleroy, Solution Management, SAP Business Intelligence

Learning Points Benefits of upgrading to Web Intelligence What’s New in Web Intelligence What’s coming Desktop Intelligence feature coverage in Web Intelligence Steps to convert from Desktop Intelligence What’s coming Best Practices2

Desktop Intelligence End-of-life announced* Desktop Intelligence 3.1 is the last commercial version SAP BusinessObjects Business Intelligence 4.0 will NOT includeDesktop Intelligence Desktop Intelligence will continue to be supported on XI 3.x Mainstream maintenance: Until 2015 Priority-One support: Until 2017*3The official End-of-Life statement is available on Service Market Place

Why Decreasing interest in DesktopIntelligenceQuestion Web Intelligence coversmajority of features Web Intelligence providesbetter valueConsumeWeb Intelligencecovers the entiredecision-makingcycleShare1423Analyzeand Storytell

Top reasons to upgrade to Web Intelligence Web Intelligence has a number of feature not in DesktopIntelligence Modern User experience and New Charts and visualizations New semantic layer: Dimensional Semantic layer, Multi-Source Interoperability with best of breed exploration and analysistools Copy and Paste Tool of choice for BI Mobile Future investments will be in Web Intelligence5

Examples: User Experience and Charting New interface based on years of usability testing across difference user typesCharting6

Examples: Charting Enhancements 7Hierarchical Navigation in ChartsBetter Color ManagementZone FormattingNew Waterfall Charts

Dimensional Data Access and ReportingNavigate directly into thereport hierarchies to findroot causes8Dimensional conceptsintegrated into richreporting modelDimensionalcharting

Examples: Data Manager Provide business users a quick way to understand the data behind simplereports Enable power users to gain a deep understanding of multiple data sources Provide Desktop Intelligence users with another superior user experience9

Examples: Additional Enhancements Simplified Sorting Improved Sorting Menu Apply Sort directly to Dimension or Measure Available for Tables and Charts DHTML Query Panel 100% HTML, No download required .unv and .unx universes Allow custom styling in reports Import/Export CSS style sheet10

Examples: InteroperabilityAnalysis, Edition for OLAPSBO ExplorerWeb IntelligenceAnalysis,Edition for MS Office11

Examples: Copy and Paste Reuse report contentsacross documents (charts,tables, queries, variables) Copy/paste with simplekeyboard shortcuts or dragand drop report elements Re-purpose InteractiveAnalysis tables as editableOffice content Copy/paste with simplekeyboard shortcuts or dragand drop report elements12

Examples: More Track Data Changes Report to Report and URL Linking Wizard Input Controls Which also allows “What if” analysis Server Side Ranking and Sampling Custom sorts Query Stripping (for OLAP data sources via: BICS, OLAP universes) Improved performance by automatically removing unused objects 13Supports non-additive measuresPrompts: Optional, default values, free/constrainedComplex report filtersImproved client-side rankingImproved alertersMore ‘function’ support (e.g. interpolation)

Examples: Web Intelligence as the sourceSBO ExplorerBI WorkSpaces(composite dashboard)SBO DashboardsWeb IntelligenceReady for Mobility(BI Mobile)Web IntelligenceDaaWS14

SAP BusinessObjects Mobile: Leverage existing tools & skills Mobilize Crystal and Web Intelligence Content Platform User & content management Fast to deployEASY!15

Key outstanding Desktop Intelligence features Planned for future releases of Web Intelligence Free-hand SQLCustom groupingExcel DP in Web Intelligence AppletSchedule with export to TXTExport to HTMLSchedule with export to HTML Unplanned features Visual Basic Data-providers Export to XML Multiple VBA macros16

Steps to convert to Web Intelligence: Upgrade PathsConvert .rep on the samestackUse Upgrade Manager4.0 to move contentXIXIReport ConversionTool XIUpgrade Manager4.0Report ConversionTool 4.0BI 4Use RCT 4.0 toconvert .rep and movedirectly to 4.017

Report Conversion Tool (RCT) 4.0 Report conversion tool 4.0 allows you to connect to a XI R2 or 3.xsystem as a source and move the converted .wid reports to a BI4.0 target system Overview of the Process 18Launch RCTEnter the Source CMS Credentials (XI R2 or 3.x)Enter the Target CMS Credentials (BI 4.0)Select the Desktop Intelligence documentsSelect Options as requiredStart ConversionPublish converted Web Intelligence documents to target system

Steps to upgrade to Web Intelligence 4.0 Login ScreenSource System:XI R2BOE 3.xTarget System:SAP BI 4.019

Step 1: Select the .rep document for conversion20

Step Ia: Converting the .rep document21

Step II: Results and Auditing Results22

Step III: Publishing converted .wid documents23

Step IV: Publishing converted .wid documents24

Improvements planned for RCT Ability to convert instances of schedules DeskI reports to WebIntelligence Ability to convert local DeskI documents in an non-standalonemode25

What’s Coming Important: Desktop Intelligence is STILL End-of-Life26

Background We understand your challenges in migrating We’ve been working closely with customers in their move to BI4.0 One of the requests from customers moving is the ability tosupport their .rep content in BI 4 as they continue to convert27

Desktop Intelligence Compatibility Pack (DCP) Installed over existing DesktopIntelligence 3.1 clients Enables the DeskI clients to connect tothe BI 4.1 CMS Introduce a Light Schedulefunctionality using the windowsscheduling functionality DeskI documents will be listed ONLY inthe Central Management Console(CMC) for administrative purposesONLY Minimum deprecation of DeskI Clientfunctionality Only Client side consumption of .repcontent28DeskIXI 3.xDCPBI 4

Updates to BI 4Upgrade ManagerXI 3.xBI 4XI R2Report ConversionTool 4.029 Upgrade Manager will nowmove selected .rep documentsto BI 4 Report Conversion Tool (RCT)will now source .repdocuments from BI 4 DeskI documents displayed inCMC for administrativepurposes ONLY

Benefits DCP is a additional support provided by SAP for DeskI 3.1 users /customers who are moving their current DeskI investments to WebI4.0 or later The Benefits Reduced TCO: With this solution, DeskI documents that require additional time to convert canbe consumed from a BI 4.1 deployment using the DeskI 3.1 Client Can de-commission legacy systems earlier and consolidate on BI 4.1 Better User satisfaction: Users can leverage the latest innovations delivered in BI 4.0 or later, as theyconvert their DeskI documents Gain additional time to convert their complex DeskI reports30

REMEMBER DCP is an temporary solution to provideadditional time in your DeskI to WebI 4conversion DCP will be supported until DeskI 3.1 issupported.31

Best Practices Internal usage review of the existing .rep files in the organization Consider archiving any that haven’t been used or accessed in a long time Determine the most important reports to upgrade Education Inform Desktop Intelligence users of the intent to upgrade to WebIntelligence Begin training Desktop Intelligence on Web Intelligence usage Knowledge Accelerator provides an e-learning solution to facilitate usertraining Deploy Web Intelligence Have Desktop Intelligence users begin using Web Intelligence for all NEWreports Begin upgrade of reports, starting with most important.32

Publishing to BI 4 Document publishing is considered partial, if: Universe isn't associated with converted .wid in the target system Open and View of these documents is still possible Refresh isn't possible For this it is advisable to move the .rep dependencies to the targetsystem using Upgrade Manager before your commence yourconversion activity33

Useful references and Links Decide if moving to Web Intelligence makes sense for you Read this whitepaper for more information about the benefits ofWeb Intelligence. Begin planning the move to Web Intelligence This whitepaper explains how to plan the upgrade from DesktopIntelligence to Web Intelligence Talk to your account manager about licensing options. We wantto provide as smooth a transition as possible to our customers andare offering a license upgrade from Desktop Intelligence to theconsiderably more feature-rich Web Intelligence34

Summary Desktop Intelligence is STILL End-of-Life Maintain Maintenance: Until 2015 Priority One Support: Until 2017 Web Intelligence is the future Has Majority of Desktop Intelligence features Has modern user experience and features Continued investment and innovation Desktop Intelligence Compatibility Pack: BI 4.x will enable moving .rep to BI 4.x CMS RCT 4.x will now also use BI 4.x as source for .rep documents DCP installed over DeskI 3.1 Connects to BI 4.1 CMS Consume .rep documents on client only Conversion and Upgrade Management to support your move35

Thank you for participating.Please provide feedback on this session bycompleting a short survey via the eventmobile application.SESSION CODE: 0814Learn more year-round at www.asug.com