EN_BO_Solution_Overv iew_5

Introducing ‘SAP BusinessObjects Explorer’ Technical Considerations : 

Introducing ‘SAP BusinessObjects Explorer’ Technical Considerations Ty Miller, Technical Director – Market Development Technology Solution Management, SAP BusinessObjects

Agenda : 

Agenda

ExplorerFunctionality Background : 

ExplorerFunctionality Background

Everyone Uses Search : 

To instantly find facts Weather Stock Prices © SAP 2008 / Page 4 Everyone Uses Search Finding and analyzing corporate information should be this easy To investigate or do research Ticket prices, hotels Curiosity about a subject To access information not readily available New York city traffic map Restaurant reviews

Data Exploration Is Search Against BI… : 

© SAP 2008 / Page 5 Data Exploration Is 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 BW Accelerator accessible sources

…and Then It’s Exploration Of the Results : 

© SAP 2008 / Page 6 …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

ExplorerMarketing Background : 

ExplorerMarketing Background

What Are These Names? : 

© SAP 2007 / Page 8 What Are These Names? Polestar vs Explorer Polestar in the Cloud vs Polestar OnDemand vs Explorer in the Cloud Explorer Accelerated BIA vs BWA NetWeaver BI vs NetWeaver BW

Some History... : 

© SAP 2007 / Page 9 Some History... “SAP BusinessObjects Polestar” 1st full release: BusinessObjects Polestar XI R2 (Dec 2007) 2nd full release: SAP BusinessObjects Polestar XI 3.1 (Dec 2008) “SAP BusinessObjects Explorer” New core name for all variations of Polestar after 11MAY09 Also the name for the standalone (aka Universe based) version of Explorer “SAP BusinessObjects Explorer, accelerated version for SAP NetWeaver Business Warehouse (SAP NetWeaver BW)”… aka SAP BusinessObjects Explorer blade edition 1.0…yes it’s a mouthful Ty’s abbreviation rule: “Explorer Accelerated” Explorer OnDemand Started as Labs project Now officially part of OnDemand SAP NetWeaver BW New umbrella name for all NetWeaver based BI capabilities SAP NetWeaver BI is now SAP NetWeaver BW SAP NetWeaver BI Accelerator is now SAP NetWeaver BW Accelerator

ExplorerProduct Background : 

ExplorerProduct Background

What Is SAP BusinessObjects Explorer? : 

© SAP 2008 / Page 11 What Is SAP BusinessObjects Explorer? Business Intelligence for All Users Built on SAP BusinessObjects XI 3.1 platform Search and Exploration tool with the power of BI Search across corporate data and display results by relevancy Visual and relevant data exploration

What Is SAP BusinessObjects Explorer Accelerated? : 

© SAP 2007 / Page 12 What Is SAP BusinessObjects Explorer Accelerated? All of the above…directly against SAP NetWeaver BW Accelerator SAP BusinessObjects Explorer blade edition 1.0 SAP BusinessObjects Explorer SAP BusinessObjects Enterprise(w/ MySQL, Tomcat) SAP Integration Kit SAP NetWeaver BW Accelerator 7.0 Deployment Reference Platform: Out-of-the box deployment Pre-installed by h/w vendor Custom project for integration intoexisting BOE/app server landscape Note: Export to WebI available in wave 2 of Explorer Accelerated bladeedition BWA Explorer BOE App Servers

What Is Explorer OnDemand? : 

© SAP 2007 / Page 13 What Is Explorer OnDemand? Explorer OnDemand against Excel Use Explorer as a quick data exploration tool on top of Excel Nothing to install Nothing to administer Explorer OnDemand benefits Self-service BI for the masses Ability to answer quick questions Further reduce IT and report author backlog Ability to get fast facts Understand new data User community driven tool adoption

How Are the Different Versions Delivered? : 

© SAP 2007 / Page 14 How Are the Different Versions Delivered? Explorer Available with SAP BusinessObjects BI Package and SAP BusinessObjects Edge Release vehicle: SP1 for Explorer XI 3.1 Don’t let the fact that it is an SP fool you – SP should stand for “Super Powerful” Explorer Accelerated Available on optimized blades just like BWA Release vehicles: Explorer Blade Edition 1.0 Convenient package of Explorer, BOE and BOBJ Integration for SAP all running on blades Requires Revision 50 for BWA EhP1 SP2 or greater for BW Optional BOE can be either on the same blade server or it can be an existing deployment SAP IK Explorer OnDemand In the cloud

Availability : 

© SAP 2008 / Page 15 Availability Explorer XI 3.1 available mid to end of January 2009 All Tier 1 languages OS: Windows App Server: Tomcat, WebSphere, WebLogic Explorer XI 3.1 SP1 available June 2009 OS: Windows, AIX, SuSE Linux App Servers: Tomcat, WebSphere, WebLogic, Netweaver Application Server Explorer Blade Edition 1.0 available June 2009 OS: SuSE Linux Explorer OnDemand available June 2009

SAP BusinessObjects ExplorerNew features in this release (1/2) : 

© SAP 2007 / Page 16 SAP BusinessObjects ExplorerNew features in this release (1/2) Accelerated access to SAP NetWeaver BW InfoCubes Opens search and visual data exploration experience to SAP NetWeaver BW Infocubes Improved deployability Support of IBM AIX and Linux SUSE in addition to Windows Additional application servers Additional database servers Supported Platforms documentation available at: http://sdn.sap.com/irj/boc/articles Increased security and system availability Support of reverse proxies, SSL, Load Balancers Improved servers clustering – full servers redundancy Integrated user access via Single Sign-On Support of industry standard third-party technologies, including Kerberos, Vintela and SiteMinder

SAP BusinessObjects ExplorerNew features in this release (2/2) : 

© SAP 2007 / Page 17 SAP BusinessObjects ExplorerNew features in this release (2/2) Improved Information Spaces management Ability to duplicate existing Information Spaces Enhanced navigation and interactivity Improved on-chart interactivity Better exposure of the Collaboration functionalities Lifecycle management Ability to Information Spaces transfer between systems with the Import Wizard application

Explorer andExplorer AcceleratedRoadmaps : 

Explorer andExplorer AcceleratedRoadmaps

What Did We Announce at SAPPHIRE? : 

© SAP 2007 / Page 19 What Did We Announce at SAPPHIRE? SAP BusinessObjects Explorer XI 3.1 SP1 Simple, easy information access and analysis for Business Objects customers (that have Universes and BOE) SAP BusinessObjects Explorer, accelerated version for SAP NetWeaver Business Warehouse As the name implies, this is Explorer for NetWeaver customers providing all the benefits of Explorer PLUS: Massive data volume and concurrent user handling through integration with Business Warehouse Accelerator Blade Center deployment for optimized performance Support for SAP BW Authorizations and specific SAP BW metadata concepts (characteristics, key figures, multiproviders*, and more coming…)

Explorer Roadmap: Where We Are Going : 

Explorer Roadmap: Where We Are Going © SAP 2008 / Page 20 Explorer v1 (Q2 2009) – Two Solutions – One Version Solution 1: SAP BusinessObjects Explorer: heterogeneous data source connectivity using Universe Supports: Small heterogeneous data sets Solution 2: SAP BusinessObjects Explorer, accelerated version First release of connectivity between Explorer and BWA Theme: Explore your business at the speed of thought Supports: InfoCubes indexed in BWA SAP authorizations Limited multi-provider support Explore NW characteristics and simple key figures H1 2009 H2 2009 H2 2010 Explorer v2 and v3 (Late 2009 through 2010) New functionality for BW customers: Multi-provider support Support common business user hierarchies Restricted key figure support Calculated key figure support Export to Web Intelligence New functionality for all customers: Open Accelerator: load in-memory engine with non-BW data Support for Universe row level security 2nd dimension charting (view Country AND City in same chart) Explore Excel spreadsheets Simple API to enable exploration of any 3rd party data Improved record view Simple calculation support H1 2010

Explorer Accelerated Roadmap : 

Explorer Accelerated Roadmap Explorer BWA SAP BW Explorer+ BWA+ Explorer++ BWA++ Any Source Wave 1 (SAPPHIRE) Wave 2 (Q4 09) Wave 3 (H1 10) Explorer BW Accelerator Explorer+ Open Accelerator DI(1) Explorer++ Open Accelerator DW Appliance Data Services BW Any Source Any DW DI Any App Non-SAP sources Suite Data Services Current Plan © SAP 2008 / Page 21

ExplorerDeeper Dive : 

ExplorerDeeper Dive

Power of Search : 

© SAP 2008 / Page 23 Power of Search 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 – including SAP BW Integrated with SAP Business Objects Intelligent Search Universes on multiple systems

Power of BI : 

© SAP 2008 / Page 24 Power of BI 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

Even More Insights for Casual Users : 

© SAP 2008 / Page 25 Even More Insights for Casual Users Improved smart visualization Suggest the best charts for the data you’re working with New chart types – including trend analysis

Even More Insights for Casual Users : 

© SAP 2008 / Page 26 Even More Insights for Casual Users Chart up to three measures simultaneously For example, view sales, margin and quantity sold

Even More Insights for Casual Users : 

© SAP 2008 / Page 27 Even More Insights for Casual Users New interactions on charts and legend panel Lasso and zoom on chart Multi-sort by dimension or measure values in legend controlling the chart layout Select and drill

From Casual Explorer to Analyst Guru : 

© SAP 2008 / Page 28 From Casual Explorer to Analyst Guru Export newly discovered data to Web Intelligence Analyze data further: add calculations, custom charts, sections, formulas, alerts… Combine with personal data files and other Universes Format, publish, schedule and share Link back to Explorer automatically created Note: export to WebI will be available later in 2009 for Explorer Accelerated

From Casual Explorer to „Spreadhead“ : 

© SAP 2008 / Page 29 Export newly discovered data to CSV Allows you to take information you find in Explorer to any 3rd party application that support data import from CSV From Casual Explorer to „Spreadhead“

From Casual Explorer to Boardroom Superstar : 

© SAP 2008 / Page 30 Export newly created data visualization as an image From Casual Explorer to Boardroom Superstar

Inherits Platform Capabilities… : 

© SAP 2008 / Page 31 Inherits Platform Capabilities… Built for SAP BusinessObjects XI 3.1 Leverages existing features of the SAP BusinessObjects Enterprise platform Application in the CMC User, group and application rights Data source connectivity Smart server support Distributed servers Authentication Leverages new Universe features Mandatory and optional prompts Multiple contexts Object level security Interoperability with other BI tools Drill from Xcelsius, Crystal Reports and Web Intelligence Export to Web Intelligence Search from Intelligent Search

…And Adds Its Own : 

© SAP 2008 / Page 32 …And Adds Its Own Independent UI Control sort order at index time Specify facet sort order for dates, text and measures A to Z, 1 To N, or Explorer Best Guess See all Information Spaces from root folder Drop downs instead of control click to choose multiple measures Multiple context sensitive, Flash driven help videos

ExplorerDeployable in Minutes : 

© SAP 2008 / Page 33 Go to Explorer Manage Spaces Page ExplorerDeployable in Minutes 1 2 DONE! Install Explorer on BOE deployment [run the setup file] Select a Universe and Create Information Spaces [just queries] 3

Explorer AcceleratedDeeper Dive : 

Explorer AcceleratedDeeper Dive

SAP NetWeaver BW Accelerator and SAP BusinessObjects Explorer Integration : 

© SAP 2007 / Page 35 SAP NetWeaver BW Accelerator and SAP BusinessObjects Explorer Integration SAP NetWeaver BW BusinessWarehouse Calculation SAP BusinessObjectsEnterprise XI 3.1 Web Intelligence Crystal Reports Xcelsius Universe Flavor SAP BusinessObjects Explorer

Proposed SAP/BO System LandscapeOne Transport Tool for Multiple Content Types : 

Proposed SAP/BO System LandscapeOne Transport Tool for Multiple Content Types Enhanced CTS (under discussion) ApplicationServer XI/PI System SAP NetWeaverAS ABAP XI/PI System SAP NetWeaverAS ABAP BOE MetaData SAP NetWeaverAS Java SAP NetWeaverAS ABAP One centralTransport Tool DatabaseInstance Linux/AIX/Windows (32-Bit) DB (Oracle, DB2, MSSQL) ... ... ... ... SAP Int. Kit PAM almost in sync, MCOD possible, UC/NUC handling like Java, instead of Tomcat deployment Frontend Layer (Portal, Business Client, BO XI 3.1, CE 7.11) MDX / OLAP Java UI (CMS)   SAP JCo

Explorer AcceleratedPrerequisites/Setup of Systems : 

© SAP 2009 / Page 37 Explorer AcceleratedPrerequisites/Setup of Systems BW Accelerator (TREX thin client) communicates with the Explorer via TCP/IP on a TREX proprietary protocol. The Explorer API (BW Accelerator driver) encapsulates the Explorer calls and maps them to TREX. For details on the network setup see attachment “MasterGuideExplorer27409.pdf” of SAP note 1260558 or on https://cw.sdn.sap.com/docs/DOC-48609.

Slide 38: 

© SAP 2007 / Page 38 NetWeaver Stack Enhancement Package 1 for SAP NetWeaver BW 7.0 – support package 2 or higher SAP NetWeaver BW Accelerator 7.0 – Revision 50 or higher See SAP note 1260558 for installation info’s during beta BusinessObjects Enterprise Stack BusinessObjects Enterprise XI 3.1 (on any platform) AIX, HP-UX, Linux (RedHat and SuSE), Solaris, Windows BusinessObjects Explorer (Blade Server with SuSE Linux) SAP NetWeaver BWA (Blade Server with SuSE Linux) See SAP note 1267070 for installation during beta SAP Integration Kit Technically not required Necessary for central authentication No installation on the client necessary BusinessObjects Enterprise XI 3.1 onAny Platform SAP NetWeaver 7.0 SAP NetWeaverBI Accelerator 7.0 EnhancementPackage 1 (SP2) Revision 50 Blade Edition Explorer Explorer AcceleratedDeployable in Days

Typical Project Plan : 

Typical Project Plan

Explorer AcceleratedFeatures and Limitations : 

Explorer AcceleratedFeatures and Limitations

BWA Indexes for Explorer AcceleratedFeatures (1) : 

© SAP 2009 / Page 41 BWA Indexes for Explorer AcceleratedFeatures (1) BWA Index for SAP BusinessObjects Explorer Contains ‘standard’ BWA index Provides additional information: texts, conversion factors, security A SAP BusinessObjects Explorer-enabled index can also be used to accelerate BW queries Note: converting a standard index to a SAP BusinessObjects Explorer-enabled index requires re-indexing (due to new layout and additional fields) Texts Text support in one language (one language for all SAP BusinessObjects Explorer-enabled BWA indexes) One text type per InfoObject (e.g. short text, according to InfoObject/RSD1 setting) For time-dependent texts, we assume the current time of initial(!) indexing time is chosen for all time-dependent texts Note: re-indexing is required after new text loads into SAP NetWeaver BW Texts for new master data SIDs are indexed in a delta mode, but updating existing texts needs re-indexing BWA Index for Explorer Accelerated BWA Index Texts ConversionFactors Security

BWA Indexes for Explorer AcceleratedFeatures (2) : 

© SAP 2009 / Page 42 BWA Index for SAP BusinessObjects Explorer (cntd.) Unit/Currency Conversion Conversion factor is defined before indexing Support for simple unit conversions (e.g. gkg) Support of one key date for currency conversion Security Support of one single SAP NetWeaver BW analysis authorization per user (user does not need to be a SAP NetWeaver BW user) This simplified security approach has been chosen to ensure consistent (across drill-down) and understandable values Indexing of authorizations must be scheduled User exit variable will be executed during indexing (possibly re-index frequently) Note: SAP BusinessObjects Explorer authorizations automatically filter to the authorized values (join) BWA Indexes for Explorer AcceleratedFeatures (2)

BWA Indexes for Explorer AcceleratedFeatures (3) : 

© SAP 2009 / Page 43 Characteristics/Dimensions Time-dependent master data is always displayed for the current date (query keydate = current day) Display attributes are not supported Support for simple conversion/format routines for external keys at design time E.g. standard conversions (e.g. date format) Complex conversions (e.g. user-specific date formats) are not supported BWA Indexes for Explorer AcceleratedFeatures (3)

There Never Really Is a Silver Bullet... : 

There Never Really Is a Silver Bullet... Functionality Gaps MultiProviders Calculated and Restricted key figures Hierarchies Currencies / Units Installation As of today, there is no unified installation package, i.e. partners/customers need to upgrade/update the components separately. With wave 1 GA, preconfigured blades should be defined (BOE, Explorer, BWA in one box) – discussions ongoing. Supportability Supportability not yet guaranteed in the following areas, e.g. no user-specific tracing possible: Explorer servers BOE Servers E2E Trace will not be possible (and not committed for BOE XI 4.0) Other components like BWA and the NetWeaver system provide sufficient supportability capabilities

Wave 1 Limitations and Mitigation : 

Wave 1 Limitations and Mitigation © SAP 2007 / Page 45

MultiProviders and Explorer AcceleratedMitigation Strategies : 

MultiProviders and Explorer AcceleratedMitigation Strategies SAP NetWeaver BW MultiProviders will not be natively supported by SAP BusinessObjects Explorer Accelerated until wave 2 (data union capabilities over indexed PartProviders) Only individual InfoCubes can currently be indexed for use in SAP BusinessObjects Explorer InfoSpaces A large percentage of customer BW deployments are based on MultiProviders Customers are typically hesitant to remodel and replace their existing MultiProviders into InfoCubes due to the impact on their existing queries and data loads

MultiProviders and Explorer AcceleratedSnapshot Solution 1 : 

MultiProviders and Explorer AcceleratedSnapshot Solution 1 Generate a snapshot of the MultiProvider directly into a BWA index Delivered by SAP development via SAP Note 1332090 Solution creates a mirror of MultiProvider definition as a BWA index, extracts and transfers snapshot of data into BWA Solution is based on purpose build ABAP Use case: Customers who have large volumes of data in MultiProviders and short data BWA load windows Customers who only want minimal remodeling capabilities during data extraction/indexing Limited delta handling possible

MultiProviders and Explorer Accelerated Snapshot Solution 2 : 

MultiProviders and Explorer Accelerated Snapshot Solution 2 Generate a snapshot of the MultiProvider into an InfoCube Delivered by SAP NetWeaver RIG via a downloadable “How-to” guide and “object generation” ABAP Solution loads an intermediate InfoCube which becomes the basis for a BWA index and InfoSpace Solution uses standard BW objects and processes familiar to customer Use case: Customer have less complex MultiProviders (# dimensions and InfoObjects) Customers with smaller data volumes or longer BWA load windows Customers who want to remodel to include calculated and restricted key figures in InfoSpaces Limited delta handling supported (same as standard virtual InfoProviders)

Which MultiProvider Solution Should You Consider? : 

Which MultiProvider Solution Should You Consider?

Explorer andExplorer AcceleratedSizing Considerations : 

Explorer andExplorer AcceleratedSizing Considerations

ExplorerSizing : 

© SAP 2009 / Page 51 ExplorerSizing Heavily dependent on data volumes 1 million rows per Information Space: 5 active users/core Note: possibility of significant performance degradation over 2M records 100K rows: 15 active users/core 10K rows: 25 active users/core Scenario 1000 named users: 1 active user = roughly 10 named users 10% access regularly access 1M row spaces 60% of users regularly access 100K row spaces 30% regularly access 10K row spaces Formula = [(100*.1)/5]+[(100*.6)/15]+[(100*.3)/25] = 2+4+1 = 7 cores Servers customer is deploying contain 8 cores each so one 8-core server would be needed for this scenario See SAP Note 1339507: Sizing Explorer and Explorer Accelerated for more detail

Explorer AcceleratedSizing Overview : 

© SAP 2009 / Page 52 Explorer AcceleratedSizing Overview Explorer Blades 30 active users/core regardless of the number of records being explored At an even higher level, assuming various levels of concurrency and active usage, you can safely assume that an 8 core blade will support 500 named users BWA Blades (aka “Data Blades”) Compression ratio for BW data to BWA indexes is roughly 10:1 Very high level: 100 GBs of data in BW equals 10GBs RAM in BWA See the following SAP Notes for more detail SAP Note 1339507: Sizing Explorer and Explorer Accelerated SAP Note 1338863: Sizing BWA for Explorer Accelerated SAP Note 1323934: Central Note for SAP BO Explorer, accelerated version for SAP NW BW Master Guide Consolidated guide on sizing resources for partners available on request

Explorer AcceleratedBWA Sizing Detail (1) – QuickSizer : 

© SAP 2009 / Page 53 Explorer AcceleratedBWA Sizing Detail (1) – QuickSizer BWA Sizing integrated in SAP QuickSizer QuickSizer access: http://service.sap.com/quicksizer Create Project and select SAP NetWeaver BI Create a new QuickSizer project, otherwise the BWA options will not appear. Most of the data captured is the same as for SAP NetWeaver BI sizing. If you have already performed a BI sizing, you can Copy & Paste the values for the BWA sizing. If you already have a BI system (loaded with data), then the program and method described in SAP note 917803 is recommended Report computes memory requirements and disk space (also runs on SAP BW 3.x) Using the BWA will take load off of the SAP NetWeaver BI system. As this load reduction depends on several detailed factors (such as share of query time spent in analytic engine, size of result set, number of users etc.), this reduction has not been captured in the SAP NetWeaver BI sizing. Refer to Thread on SDN for additional info https://forums.sdn.sap.com/thread.jspa?threadID=776332&tstart=0

Explorer AcceleratedBWA Sizing Detail (2) – QuickSizer Cont. : 

© SAP 2009 / Page 54 Hardware sizing Hardware partner translates the results of SAP QuickSizer into optimal configuration of hardware High availability setup:Extra blade(s) required as backup for automatic failover Valid for production and test system Possibly less rigid performance requirements for test systems  optional sharing of resources (see ‘BWA in non-production environments’) Important note: sizing has to be adjusted once new InfoCubes are indexed by BWA that haven’t been taken into account for the original sizing Explorer AcceleratedBWA Sizing Detail (2) – QuickSizer Cont.

Explorer AcceleratedBWA Sizing Detail (3) - Memory : 

© SAP 2009 / Page 55 Which memory setup is supported for BWA blades? See matrix for release status of blade generation and memory. 32 GB Harpertown (quad-core) blades are currently in certification process. See SAP note 1161765 for release status per hardware partner. For mid-size customers, the HW partners offer one XS configuration consisting of 8GB blades. This offering provides best value at reasonable hardware and license costs. Any combination of blade generations can be used in the same BWA system. See SAP note 1163149 for more details. Explorer AcceleratedBWA Sizing Detail (3) - Memory

Explorer andExplorer AcceleratedDownloads and Documentation : 

Explorer andExplorer AcceleratedDownloads and Documentation

Where To Download Explorer „Standalone“ from SMPhttp://service.sap.com/patches  SBO Explorer : 

Where To Download Explorer „Standalone“ from SMPhttp://service.sap.com/patches  SBO Explorer

Where To Download Explorer Accelerated from SMPhttp://service.sap.com/swdc  SBO Explorer Blade Edition : 

Where To Download Explorer Accelerated from SMPhttp://service.sap.com/swdc  SBO Explorer Blade Edition

Where to Download Explorer Accelerated from SMP http://service.sap.com/patches  BWA : 

Where to Download Explorer Accelerated from SMP http://service.sap.com/patches  BWA

Where To Find Documentation on SMPhttp://service.sap.com/instguides : 

Where To Find Documentation on SMPhttp://service.sap.com/instguides

Where To Find Documentation on SDNhttp://cw.sdn.sap.com/community/docupedia : 

Where To Find Documentation on SDNhttp://cw.sdn.sap.com/community/docupedia

Slide 62: 

Thank you!

Appendix : 

Appendix © SAP 2007 / Page 63

Explorer AcceleratedSetup of Systems (NetWeaver) : 

Explorer AcceleratedSetup of Systems (NetWeaver)

Checking the Prerequisites for SSO on ABAP : 

Checking the Prerequisites for SSO on ABAP See the SAP Help Portal http://help.sap.com for more details http://help.sap.com/saphelp_nw04/helpdata/en/e1/8e51341a06084de10000009b38f83b/frameset.htm  Architecture of the SAP WAS http://help.sap.com/saphelp_erp2005/helpdata/en/e3/e86878c8204acc856d8d5da4a54fa4/frameset.htm  Administration When Using Logon Tickets Set the parameter SECUDIR=/usr/sap/<SID>/<instance>/sec for the user <SID>adm Download the SSO libraries from the SAP Marketplace http://service.sap.com/swdc or http://service.sap.com/tcs Check the SSO configuration with transaction STRUSTSSO2 System PSE and Certification List Go to Menu  Environment  Display SSF Version Go to Menu  Environment  SAP Logon Ticket  check with RFC destination NONE

Creating/Checking the SSL Tickets with STRUSTSSO2 : 

Creating/Checking the SSL Tickets with STRUSTSSO2

Import the transports from the SAP IK CD(for NetWeaver 7.0 use the UC transports) : 

Import the transports from the SAP IK CD(for NetWeaver 7.0 use the UC transports) Available withEhP1 Stack5 Without Installation

The settings in table RSCR_URLPARAMS can be called via Transaction /CRYSTAL/RPTADMIN : 

The settings in table RSCR_URLPARAMS can be called via Transaction /CRYSTAL/RPTADMIN

The settings in table IRTEST_URL can be called via Report RSCR_CHECK_INSTALLATION_PARAMS : 

The settings in table IRTEST_URL can be called via Report RSCR_CHECK_INSTALLATION_PARAMS

Explorer AcceleratedPrerequisites/Setup of Systems/Checklist (1) : 

© SAP 2009 / Page 70 Explorer AcceleratedPrerequisites/Setup of Systems/Checklist (1) SAP NetWeaver BW: Decide for the Explorer use cases InfoCubes Key Figures All relevant hardware components: Decide for the best deployment architecture Landscape Network All relevant software components: Software installation/upgrade of all components Scenarios SAP BW Accelerator: Verify settings Enable TREX index server for the Explorer Activate TREX cache SAP NetWeaver BW: Define users and security User Administration Analysis Authorization (Data slices)

Explorer AcceleratedPrerequisites/Setup of Systems/Checklist (2) : 

© SAP 2009 / Page 71 Explorer AcceleratedPrerequisites/Setup of Systems/Checklist (2) SAP BusinessObjects Central Management Console: Enable SAP Authentication SAP credentials SAP BusinessObjects Central Management Console: Users and Groups Assign security SAP BusinessObjects Central Management Console: Enter settings of BW Acc. driver in the Explorer properties SAP NetWeaver BW: Enable Explorer SAP NetWeaver BW: Check currency and unit conversions SAP NetWeaver BW: Create BW Acc. Indexes for Explorer SAP BusinessObjects Explorer: Check application Create information spaces Explore the data and check security

SAP NetWeaver BW Explorer WizardInitial Enablement on Abap Backend : 

© SAP 2009 / Page 72 SAP NetWeaver BW Explorer WizardInitial Enablement on Abap Backend How to enable a BW System for the Explorer (Table RSDDTREXADMIN) Execute program RSDDTREX_ADMIN_MAINTAIN in transaction SE38 Set the Parameter POLESTAR_SYSTEM to X via this program General setting of language and conversion exits (date format etc.) for the Explorer has to be done during the first start of the wizard (Domain XUDATFM)

SAP NetWeaver BW Explorer WizardTransactions RSDDV or RSDDTPS : 

© SAP 2009 / Page 73 SAP NetWeaver BW Explorer WizardTransactions RSDDV or RSDDTPS

SAP NetWeaver BW Explorer Wizard Program RSDDTPS_MPRO_MAINTAIN : 

SAP NetWeaver BW Explorer Wizard Program RSDDTPS_MPRO_MAINTAIN

Explorer AcceleratedSetup of Systems (BOE) : 

Explorer AcceleratedSetup of Systems (BOE)

SAP BusinessObjects CMC Creation of Users and Security – SAP Authentication : 

SAP BusinessObjects CMC Creation of Users and Security – SAP Authentication Prerequisite: SAP BusinessObjects XI Integration for SAP Solutions SAP Authentication enables SAP users to log on using their SAP user names and passwords without storing theses passwords in SAP BusinessObjects Enterprise with the option to automatically import users or dynamically with first log on For the setup a user with defined authorization is needed Enter parameters in file default.settings.properties D:\Program Files (x86)\BusinessObjects\Tomcat55\webapps\polestar\WEB-INF\classes\ Example © SAP 2009 / Page 76

SAP BusinessObjects CMC Creation of Users and Security – SAP Authentication : 

SAP BusinessObjects CMC Creation of Users and Security – SAP Authentication In order to make the role import for SAP authentication work, execute the following steps Fetch the following files from the SAP service marketplace: http://service.sap.com/connectors -> JCo 2.1.8 32-bit (Windows version as example only) sapjcorfc.dll librfc32.dll Copy these files into directory C:\WINDOWS\system32 and C:\WINDOWS\SysWOW64 Copy the file sapjco.jar to the following directories: D:\Business Objects\Tomcat55\common\lib D:\Business Objects\Tomcat55\server\lib © SAP 2009 / Page 77

SAP BusinessObjects CMCCheck of Configuration  CMC  Polestar  Properties : 

© SAP 2009 / Page 78 SAP BusinessObjects CMCCheck of Configuration  CMC  Polestar  Properties

SAP BusinessObjects CMCCheck of Configuration  Index Server Host and Port : 

© SAP 2009 / Page 79 SAP BusinessObjects CMCCheck of Configuration  Index Server Host and Port TREX host in general: Host where the active name server is situated. But any other TREX host is possible as well (during the first Explorer call the TREX thin client fetches the list of all index servers and calls them round robin no matter where the relevant BW Accelerator Index is situated). Port: Index server port <3><instance number><16>

SAP BusinessObjects CMCCheck of Configuration  Index Server Host and Port/Backup : 

© SAP 2009 / Page 80 SAP BusinessObjects CMCCheck of Configuration  Index Server Host and Port/Backup Backup server for “higher” availability: It is possible to specify one or more additional TREX index servers to make the BW Accelerator connection “higher” available. In the BW Accelerator configuration this should be a blade that has the role of a backup blade (otherwise with a regular blade defined as additional blade, queries would fail anyhow).

SAP BusinessObjects CMCCheck of Configuration  Restart of Explorer Servers : 

© SAP 2009 / Page 81 SAP BusinessObjects CMCCheck of Configuration  Restart of Explorer Servers Restart Explorer Servers  Servers  Servers List: After the configuration of the BW Accelerator driver restart the Explorer servers.

ExplorerCreation of an Information Space and Search : 

ExplorerCreation of an Information Space and Search © SAP 2009 / Page 82 1. Logon to the Explorer  Choose Manage Spaces 2. Choose SAP BW Accelerator  Create New 3. Enter Properties and Objects 4. Choose Index Now (Metadata for “portal” search is indexed on the Explorer)

Additional Notes for SBO Explorer Accelerated MP Pilot after Support Stack 3 : 

Additional Notes for SBO Explorer Accelerated MP Pilot after Support Stack 3 Note 1275853 - Explorer for BWA: composite note for Support Package 4 Note 1255625 - Explorer: Collective correction for wizard for SP4 Note 1322464 - Explorer for BWA: BW composite note for Support Package 5 Note 1325184 - BWA Revision with Explorer Compatibility with BI SP Additional MultiProvider Support available with EhP1 Stack 5 (Q3/2009)  These Notes require a lot a of manual steps, so clarify the Pilot Status first Note 1332090 - MultiProvider Snapshot for Business Objects Explorer Note 1332392 - Polestar/Explorer on a MultiProvider Snapshot Beside that some additional Notes have to be considered  Some of these Notes might selected automatically 1228465 - Method _PARALIZE_START; prerequisite for note 1332090 1338216 - Performance Optimization MultiProvider for BO Explorer Note 1326576 - SAP NetWeaver Systems Containing SAP ERP Software Components Note 1248905 - SP Equivalence for update/upgrade to EHP 1 for SAP NW 7.0

MultiProviders : 

MultiProviders Description The current implementation of BWA indexes InfoCubes. MultiProviders are a metadata concept added by the SAP BW OLAP engine, which is outside BWA. As a consequence, customers in wave 1 will not be able to use MultiProviders. Affected customer scenarios BW customers make extensive use of MultiProviders to a) partition large InfoCubes according to regions (semantic partioning), b) partition InfoCubes according to time (data agining), c) combine InfoCubes from different business areas (cross topic reporting), d) combine InfoCubes with other InfoProviders (e.g. with DSOs for eal time reporting), or e) simply to abstract the an InfoCube from a query in order to be able to replace/rebuild the cube without impacting reports (1 to 1). Reason for limitation The initial implementation focuses on delivering the Explorer user experience on top of BWA indexes. Today, BWA does not support the concept of MultiProvides, as it is handled by the SAP BW OLAP engine. Implementing support for MultiProviders in BWA requires significant investments into the TREX engine, which exceeded the volume of possible investments for the targeted release date. Planned actions In Wave 2 it is planned to transfer the MultiProvider metadata to BWA, enabling the TREX engine to provide calculations on part providers. The support for MultiProviders continues to be a very large investment. It is planned to implement MPs in a phased approach: Wave 2 will see support for „homogenous“ MultiProviders, where part providers are structurly identical InfoCubes. All other MPs will continue to require MP snapshots Wave 3 is planned to provide support for „heterogenous“ MultiProviders, where part providers are any InfoCubes. For all other MPs, it is technically more feasable to continue with MP snapshots © SAP 2007 / Page 84

Calculated Key Figures : 

Calculated Key Figures Description Calculated key figures are calculated by the SAP BW OLAP engine which is not part of BWA and therefore not available to Explorer in wave 1. Affected customer scenarios Customers use calculated key figures in order to deal with a) complex business definitions for KPIs and b) mathematical requirements to calculate key figures on the fly (e.g. Salesprice per unit -> sum(salesprice)/sum(units) ). Reason for limitation BWA has no metadata about defined key figures and no capabilities to execute such calculations. There is a broad range of calculations supported by BW including exceptional aggregations that will require significant efforts when being transfered to BWA for execution in memory. The investment was not possible in wave 1. Planned actions In wave 2 it is planned to provide support for calculated key figures defined in BW InfoCubes, so that Explorer customers can leverage these key figures without any additional effort. It is also planned for wave 2 to provide basic calculation capabilities inside Explorer (add, substract, multiply, divide, percentage) to define calculated key figures for execution in BWA. Support for non-additive (stock) figures is under discussion. Depending on customer feedback and Explorer product definition, further calculation capabilities may be added over time. © SAP 2007 / Page 85

Restricted Key Figures : 

Restricted Key Figures Description Restricted key figures are calculated by the SAP BW OLAP engine which is not part of BWA and therefore not available to Explorer in wave 1. Affected customer scenarios Customers make frequent use of restricted key figures. The most prominent scenarios involve a) value type/value pairs where the value type indicates what KPI is stored in the value (very helpful if new key figures get added on a regular basis), b) actual versus plan reporting where multiple versions are available for each key figure (actuals, plan 1, plan 2, plan n), c) user rolebased restrictions on key figures, and d) time based restrictions (sales this year, YTD). In advanced scenarios a combination of restricted and calculated key figures is very common (ratio between sales this year and last year). Reason for limitation BWA has no metadata about restricted key figures and no calculation capabilities to execute. There is a significant investment required to support restricted key figures in BWA. The investment was not possible in wave 1. Planned actions In wave 2 it is planned to provide support for the most prominent use-cases for restricted key figures. The implementation needs to be aligned between Explorer and BWA in order to ensure a sound product strategy for the customer facing front-end. The degree of support for restricted key figures is intended to be driven by what Explorer PM regards as viable for the business user. Restricted key figures are a common concept in OLAP type analysis, but results may be hard to understand for casual users as they are targeted by Explorer. Wave 3 is planned to provide support that is suitable for OLAP clients such as Pioneer. © SAP 2007 / Page 86

External Hierarchies : 

External Hierarchies Description The current implementation of BWA does not index hiearchy data. The SAP BW OLAP engines adds hierarchy information to results from BWA. Explorer has no concept for parent/child hierarchies. Affected customer scenarios BW supports different types of hierarchies. Hierarchies may be implemented as attributes for characteristics, or they may be stored as external hierarchies. The restriction is on external hierarchies. Typical scenarios involve a) hierarchies that frequently change over time, or b) hierarchies being defined by regional teams individually. Reason for limitation External hierarchies are stored in a seperate table by BW that is currently not being indexed in BWA. Enabling the indexing of hierarchy tables requires changes in the NetWeaver code. In addition there is no concept in Explorer for dealing with parent/child hierarchies (as they are typically used in external hiearchies, e.g. Cost center or material). Planned actions It is planned for wave 2 to include the hierarchy data in BWA indexes. There needs to be a change in the BW indexing process, and there need to be changes in the Explorer front-end to support these hierarchies. The solution in wave 2 will address the most prominent cases but will leave more advanced scenarios untouched (inter company elimination) where metadata is not available to BWA. However, these scenarios are understood by solution management as being typical OLAP scenarios and not typical Explorer scenarios. Wave 3 is planned toprovide support that is suitable for OLAP clients such as Pioneer. © SAP 2007 / Page 87

Currency and Unit Conversion : 

Currency and Unit Conversion Description Currency and unit conversions are handled by the SAP BW OLAP engine, which is not part of BWA and therefore not available to Explorer in wave 1. Affected customer scenarios Any scenario that involves key figures using currencies or units such as Coke delivering its products in bottles and cans (summaries need to be in HL). Reason for limitation Currency and unit conversion requires metadata and data (conversion rates) that is not indexed in BWA at this moment in time. During the load process, data is converted into one currency or unit chosen by the administrator. In wave 1 BWA also has no calculation capabilities to do the calculations. Planned actions In wave 2 BWA will get the calculation capabilities that would be needed to convert currencies and units. Due to resource constraints it is not planned to actually support conversions outside the initial load job. © SAP 2007 / Page 88

Language Support : 

Language Support Description Handling translations of metadata and data is managed by SAP BW OLAP Engine, which is not part of BWA and therefore not available in wave 1. Affected customer scenarios The typical use case for multilanguage analyis can be found in bi-lingual countries such as Canada or Switzerland. In Canada any information needs to be available in English and French. Customers want to be able to easily switch between languages at any time. Reason for limitation BWA indexed only fact tables in the past. Texts for master data and lables were added by the BW OLAP engine as any query would pass through this processor anyhow. With Explorer accessing indexes directly, the texts for masterdata and metadata had to be written to BWA. In wave 1 an extension to indexes has been added that currently can only store one version of the text. In wave 1 the version / language of this text is defined at indexing time by the administrator . Planned actions It is under discussion to support multiple languages in one index in wave 2. Specifications have not yet been finalized. © SAP 2007 / Page 89

Useful Resources on SDN and SMP : 

Useful Resources on SDN and SMP TechEd 2008 Berlin - Upgrade to SAP NetWeaver BI 7.0 with new innovative Toolshttps://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/80a866bf-d18b-2b10-3b89-a0509e7e7f62 Lower your TCO and Time Efforts by Managing your Upgrade with Innovative Tools https://www.sdn.sap.com/irj/sdn/nw-bi?rid=/webcontent/uuid/b039ebc5-304f-2b10-499e-97dabda45e48 SAP Enhancement Package 1 for SAP NetWeaver 7.0 https://www.sdn.sap.com/irj/sdn/nw-70ehp1 SAP Enhancement Package Installer (SAPehpi) for SAP NetWeaver 7.0 http://service.sap.com/irj/sdn/ehp-inst Services for SAP NetWeaver BW Accelerator ( free of charge with enterprise support) https://www.sdn.sap.com/irj/sdn/bia#section12 "SAP Safeguarding Services" for Implementation and Upgradehttp://service.sap.com/SAFEGUARDING

Useful URLs for Explorer Systems : 

© SAP 2008 / Page 91 Useful URLs for Explorer Systems Explorer Microfinance http://microfinance.sap.com/ivt/formula1.html Explorer OnDemand http://explorer.ondemand.com (no registration – no data persistence) Explorer OnDemand http://goexplore.ondemand.com (registration required – data persisted) Bookmark (Example)http://idespolestar.wdf.sap.corp:8080/polestar/index.jsp?application=portal&documentId=09bfdbe1-db13-41dc-848c-8cdfb6fcfacf&bookmarkId=8e262137-83c4-45aa-89e7-c79cbd87e609http://microfinance.sap.com/polestar/index.jsp?application=explorer&documentId=3e9c3f5a-1a48-4f45-b48f-1a3622897e83&bookmarkId=ec5c7ca4-560e-4b37-b05a-bbd5bbaa3a10