introducing sap businessobjects explorer technical considerations n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Introducing ‘SAP BusinessObjects Explorer’ Technical Considerations PowerPoint Presentation
Download Presentation
Introducing ‘SAP BusinessObjects Explorer’ Technical Considerations

Loading in 2 Seconds...

play fullscreen
1 / 91

Introducing ‘SAP BusinessObjects Explorer’ Technical Considerations - PowerPoint PPT Presentation


  • 359 Views
  • Uploaded on

Introducing ‘SAP BusinessObjects Explorer’ Technical Considerations. Ty Miller, Technical Director – Market Development Technology Solution Management, SAP BusinessObjects. Agenda. Explorer Functionality Background. Everyone Uses Search. To instantly find facts Weather Stock Prices.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Introducing ‘SAP BusinessObjects Explorer’ Technical Considerations' - Audrey


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
introducing sap businessobjects explorer technical considerations

Introducing ‘SAP BusinessObjects Explorer’ Technical Considerations

Ty Miller, Technical Director – Market Development Technology Solution Management, SAP BusinessObjects

everyone uses search
Everyone Uses Search
  • To instantly find facts
    • Weather
    • Stock Prices
  • To access information not readily available
    • New York city traffic map
    • Restaurant reviews
  • To investigate or do research
    • Ticket prices, hotels
    • Curiosity about a subject

Finding and analyzing corporate information should be this easy

data exploration is search against bi
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
…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
what are these names
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
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
what is sap businessobjects explorer
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
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

App Servers

BOE

Explorer

BWA

© SAP 2007 / Page 12

what is explorer ondemand
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
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
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 explorer new features in this release 1 2
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 2007 / Page 16

sap businessobjects explorer new features in this release 2 2
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

© SAP 2007 / Page 17

what did we announce at sapphire
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…)

© SAP 2007 / Page 19

explorer roadmap where we are going

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

Explorer Roadmap: Where We Are Going

H1 2009

H2 2009

H2 2010

H1 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
explorer accelerated roadmap
Explorer Accelerated Roadmap

Wave 1

(SAPPHIRE)

Wave 2

(Q4 09)

Wave 3

(H1 10)

Explorer

Explorer+

Explorer++

BWA

BWA+

Current Plan

BWA++

DI

SAP

BW

Any

Source

Any

DW

Any

App

BW

Data Services

Suite

Any Source

Explorer

BW Accelerator

Explorer+

Open Accelerator

DI(1)

Explorer++

Open Accelerator

DW Appliance

Data Services

Non-SAP sources

© SAP 2008 / Page 21

power of search
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
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
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 users1
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 users2
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
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
From Casual Explorer to „Spreadhead“
  • 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 boardroom superstar
From Casual Explorer to Boardroom Superstar
  • Export newly created data visualization as an image
inherits platform capabilities
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
…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
explorer deployable in minutes
ExplorerDeployable in Minutes

1

Install Explorer on BOE deployment

[run the setup file]

2

Go to Explorer

Manage Spaces Page

3

Select a Universe and Create Information Spaces

[just queries]

DONE!

sap netweaver bw accelerator and sap businessobjects explorer integration
SAP NetWeaver BW Accelerator and SAP BusinessObjects Explorer Integration

SAP BusinessObjects Explorer

Universe Flavor

Accelerated Version

SAP BusinessObjectsEnterprise XI 3.1

Web Intelligence

Crystal Reports

MultiProviderQueries

Directly search and explore indexed InfoCubes

Xcelsius

  • Quickly find relevant information
  • Explore and gain new insights
  • Simple, fast, scalable

SAP NetWeaver BW

Calculation

BWA

BusinessWarehouse

© SAP 2007 / Page 35

proposed sap bo system landscape one transport tool for multiple content types
Proposed SAP/BO System LandscapeOne Transport Tool for Multiple Content Types

Frontend Layer (Portal, Business Client, BO XI 3.1, CE 7.11)

Linux/AIX/Windows (32-Bit)

ApplicationServer

...

MDX / OLAP

SAP JCo

SAP Int. Kit

Java UI (CMS)

DB (Oracle, DB2, MSSQL)

...

SAP NetWeaverAS ABAP

XI/PI System

...

SAP NetWeaverAS ABAP

XI/PI System

...

SAP NetWeaverAS ABAP

SAP NetWeaverAS Java

BOE

MetaData

DatabaseInstance

One centralTransport Tool

Enhanced CTS (under discussion)

PAM almost in sync, MCOD possible, UC/NUC handling like Java, instead of Tomcat deployment

explorer accelerated prerequisites setup of systems
Explorer AcceleratedPrerequisites/Setup of Systems

Explorer XI

BWA

BWA

BWA

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.

© SAP 2009 / Page 37

slide38

Explorer AcceleratedDeployable in Days

  • 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

SAP NetWeaver 7.0

EnhancementPackage 1 (SP2)

SAP NetWeaverBI Accelerator 7.0

Revision 50

BusinessObjects

Enterprise

Blade Edition

Explorer

XI 3.1 onAny Platform

© SAP 2007 / Page 38

bwa indexes for explorer accelerated features 1
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 accelerated features 2
BWA Indexes for Explorer AcceleratedFeatures (2)
  • 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 accelerated features 3
BWA Indexes for Explorer AcceleratedFeatures (3)
  • 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
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

multiproviders and explorer accelerated mitigation strategies

BWA Index

MultiProvider

PartProviders

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

SAP NetWeaver BW Accelerator

SAP NetWeaver BW

multiproviders and explorer accelerated snapshot solution 1

BWA Index

MultiProvider

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

SAP NetWeaver BW Accelerator

SAP NetWeaver BW

Snapshot extractor

multiproviders and explorer accelerated snapshot solution 2

BWA Index

MultiProvider

InfoCube

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)

SAP NetWeaver BW Accelerator

Standard IndexProcess

SAP NetWeaver BW

DTP

VirtualProvider

Objects Generated by ABAP

explorer sizing
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 accelerated sizing overview
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 accelerated bwa sizing detail 1 quicksizer
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 accelerated bwa sizing detail 2 quicksizer cont
Explorer AcceleratedBWA Sizing Detail (2) – QuickSizer Cont.
  • 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’)

Importantnote:sizinghastobeadjustedoncenewInfoCubesareindexedbyBWAthathaven’tbeentakenintoaccountfortheoriginalsizing

explorer accelerated bwa sizing detail 3 memory
Explorer AcceleratedBWA Sizing Detail (3) - Memory

WhichmemorysetupissupportedforBWAblades?

  • 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.
  • Formid-size customers,theHWpartnersofferoneXSconfigurationconsistingof8GBblades. This offering provides best value at reasonable hardware and license costs.
  • Anycombinationofblade generations canbeusedinthesameBWAsystem. See SAP note 1163149 for more details.
where to download explorer standalone from smp http service sap com patches sbo explorer
Where To Download Explorer „Standalone“ from SMPhttp://service.sap.com/patches SBO Explorer
slide58
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 smp http service sap com instguides
Where To Find Documentation on SMPhttp://service.sap.com/instguides
where to find documentation on sdn http cw sdn sap com community docupedia
Where To Find Documentation on SDNhttp://cw.sdn.sap.com/community/docupedia
slide62

W. Ty Miller

Technical Director

Technology Solution ManagementPhone +1.604.974.2157

Mobile +1.604.961.4060

ty.miller@sap.comhttp://www.sap.com

Thank you!

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
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

explorer accelerated prerequisites setup of systems checklist 1
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)

© SAP 2009 / Page 70

explorer accelerated prerequisites setup of systems checklist 2
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 2009 / Page 71

sap netweaver bw explorer wizard initial enablement on abap backend
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 2009 / Page 72

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 authentication1
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 cmc check of configuration cmc polestar properties
SAP BusinessObjects CMCCheck of Configuration  CMC  Polestar  Properties

© SAP 2009 / Page 78

sap businessobjects cmc check of configuration index server host and port
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 2009 / Page 79

sap businessobjects cmc check of configuration index server host and port backup
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 2009 / Page 80

sap businessobjects cmc check of configuration restart of explorer servers
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.

© SAP 2009 / Page 81

explorer creation of an information space and search
ExplorerCreation of anInformation Space and Search

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)

© SAP 2009 / Page 82

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
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