Presenting SAP NetWeaver Business Intelligence Content

Presenting

SAP NetWeaver Business

Intelligence Content

Product Management NetWeaver BI Jie Deng

SAP AG

Agenda

1 SAP BW Business Content 2

3 Activation of SAP BW Business Content

Info sources to SAP BW Business Content BW Business Content as Add-On

4

Agenda

1 SAP BW Business Content

SAP BW Business Content

Analytical Application

Technical Content

Demo Content

Business Trends

Globalization

Decentralization Smaller margins

Faster reaction to market

Increasing importance of service

Business Drivers and Challenges

z Utilize your information assets z Empower your employees

z Speed, speed, speed

20% 20% ^{„ „ Casual} Decision Support

„ Transactional

„ Professional z Avoid information overload z Master complexity & change

80% 80%

Consequences for Information Systems

Immediate, single-point access to all relevant information regardless of the source

Coverage of entire business processes

High quality of information

Sophisticated decision support

Shorter implementation time with

fewer resources

Roles, Processes, Key Figures

z Different kind of information required by different employees z Planning, execution and control of the processes

Roles

Key Figures Processes

z Strategically and operational z Processes are linked with

each other

z Different systems and data sources

z Which key figures are important?

SAP BW Business Content: Definition

Business Content Definition Business Content Definition

¾ SAP BW Business Content delivers predefined, role-based and task-oriented information models within BW.

¾ SAP BW Business Content‘s objective is to make

relevant information available to specific roles

within an enterprise so as to provide these users

with exactly the information they need to fulfill their

daily tasks within their business.

SAP BW Business Content: Definition

Business Content Definition Business Content Definition

¾ SAP BW Business Content expanses

z Horizontally across systems, applications and processes (source-system independent)

z Vertically into different industry sectors

¾ SAP BW Business Content supports z Measuring,

z Analyzing, z Planning,

z Monitoring and Controlling

SAP BW Business Content: Definition

Business Content Definition Business Content Definition

¾ SAP BW Business Content is predicated on centralized, consistent

Common Metadata

SAP BW Business Content: Definition

“Two-Fold Approach of SAP BW”

Data Warehousing Functions Business Content Objects* Business Content Objects*

Information Deployment Data Presentation

Data Analysis

Data Warehouse Management Data Extraction & Staging

¾ Roles, Tasks

¾ Global Views, Workbooks

¾ Queries, Webtemplates

¾ InfoProviders

¾ Extractors & Infosources

SAP BW Business Content: Definition

Extractors = Extractors =

Predefined Data Models incl. InfoObjects, ODS

and InfoCubes Predefined Data Models

incl. InfoObjects, ODS and InfoCubes

Delivered Queries, Webtemplates up to complete Analytical Applications

Delivered Queries,

Webtemplates

up to complete

Analytical Applications

SAP BW Business Content Usability

Business Content can be used as:

‰ a complete / partial solution for information models

‰ a repository of standard requirements and modeling ideas (example and templates)

‰ Guideline during implementation of a solution

‰ powerful learning tool

Business Content Usability Scale

Transfer Rules

InfoObject Customer Customer Order quantity Order quantity

Ind ivi du ali za tion

St an da rd iza tio n

Role

Ap pli ca tio n v iew

Us er vi ew

Extractor

Web Reports Workbook Query

InfoSource

ODS

MultiProvider

Users of Information Systems

high

Analytical power required

Consumer Author

Analyst

z Definition of reports z Ad hoc reporting

z Multi-dimensional analysis

z Self-explanatory,

predefined navigation methods

z Predefined data collection

z Static reports

Business Content Usability Pyramid*

Standard Customizing

User-specific

Corporate-specific

Industry-specific

Generic Custom

SAP

Business Content Benefits

Immediate access to interpreted information

z Ready-to-go reports, data models, extractors, transformations z Significant cut down of implementation time and costs

Consistency of operational processes with management processes

z For business professionals at all levels across all functions z Easily extensible

z Automatic improvements to the information model z Data consistency and integrity

Validated and comparable information

z Rich set of standard key performance indicators

z Best practice models from > 6000 installations (02/2003)

Cross-system/cross-application information

z Integration of e-Business and ERP systems

z Tight integration with mySAP Applications

NetWeaver2004s BI Business Content Add-On 2:

Pre-Configured Information Models

+18,260 InfoObjects

+809 ODS Objects

+854 InfoCubes

+254 MultiProviders

+ 4400 Queries

+ 3500 Webtemplates

+ 1200 Roles

Agenda

1 SAP BW Business Content

SAP BW Business Content

Analytical Application

Technical Content

Demo Content

Analytical Applications Definition

Pre-packaged applications that support your individual business processes

z Process support

z Applications for specific task groups z Integrated data basis

z Across systems and applications z External data

z Interfaces to operational systems z Implementation of analysis results z Closed loop

z Optimization in feedback loop

Optimize

Optimize Analyze Analyze Measure

Measure

Better Decision Making, improved process efficiency &

continuous optimization

Challenges in building Analytical Applications

z Information has become the key strategic asset for forward-thinking enterprises in today's Internet economy

z The speed and effectiveness with which businesses capitalize on their information stores will separate the winners from the losers.

z Yet generating real value from information requires more than just an understanding of key functional processes

z In this age of the virtual enterprise, value comes from uniting centers of information to gain both functional and cross-functional views of your business

z It also comes from being able to more effectively assess your operational effectiveness, optimize customer relationships, optimize e-business and empower the supply chain.

An Analytical Application should solve a business question regardless of system boundaries, department

boundaries and company boundaries.

From Business Content to Analytical Applications

c BW from the beginning had Business Content

z > 600 Cubes and ODS-objects

z > 2800 Queries

z > 10.000 InfoObjects

z Covering all areas of a Business (FI, CO, HR, Sales, Procurement, ...)

d Identify the need to group Business Content to sets for specific tasks

e Develop Analytical Applications by

z Grouping Business Content

z Adding closed-loop-capabilities

z Adding planning and data mining models

z Building Cockpits ...

The SAP BW Business Content was the ideal starting

point for creating analytical applications.

Analytical Applications Architecture

Process support

Separation of function

Portal Integrated Analytical Applications

Starting with release BW 3.0A (SP7), BW’s Analytical Applications have been integrated into the Enterprise Portal 5.0 as Business Packages.

z Business Packages

A collection of worksets for a specific business or generic task

z WorkSets

All content that is required to support a set of coherent tasks that share one or more related goals

z Cockpits

Our business packages for SAP BW are

divided into an Overview Page (Cockpit)

and additional task-oriented WorkSets

Anatomy of a business package

Role

workset 3 workset 3

iView 1 iView 2

workset 1

workset 1 workset 2 workset 2

workset 2.1

workset 2.1 workset 2.2 workset 2.2

iView 1 iView 2 iView 3

iView 1 iView 2

iView 1 iView 2

Role

For each role, one or more business packages may contain relevant

content

Worksets

Within each business package, worksets group related tasks

iViews

Each workset contains iViews that provide access to applications, reports, services, and information—

whatever is needed to complete the task

Bus. Package 1 Bus. Package 2

The Enterprise Portal provides a role-based user interface,

How are business packages delivered?

Browse and download content

Information for vendors

Log on to SDN

SAP Developer NetWork – Portal Content Portfolio

Search for a

particular

content package

Business Package for Customer Credit Management

Business benefit

Provides the ability to monitor and control cash flow between companies and their customers

Users can:

„ Identify individual overdue items with large receivable amounts

„ React quickly to late payments

„ Revise specific credit lines in accordance with payment history

Roles

„ Credit managers

„ Account receivable

Business Package for Sales Analysis

Business benefit

Provides ability to evaluate strategic customer relationships, based on critical indicators

Users can:

„ Monitor sales figures

„ Find out why sales are increasing/decreasing

„ Evaluate performance of individual departments or employees

„ Evaluate vendor performance

„ Analyze trends

Roles

„ Sales managers

„ Authorized sales employees

Business Package for Market Exploration

Business benefit

Provides decision support for targeting new customers by

integrating market data from Dun

& Bradstreet with your sales data

Users can:

„ Analyze market position

„ Predict opportunities for growth

„ Identify key prospects

„ Identify existing customers that represent the greatest sales opportunities

„ Identify cross selling opportunities

Roles

„ Market Analyst

„ Sales professionals

„ Marketing professionals

0 20 40 60 80 100

1st Qtr

2nd Qtr

3rd Qtr

4th Qtr

East

West

North

Business Package for Campaign Management

Business benefit

Provides the ability to monitor and evaluate the effectiveness of

current and finished campaigns and provides decision support for optimizing the success of future marketing campaigns

Users can:

„ Identify deviations from planned success figures

„ Be alerted to negative trends of marketing campaigns

„ Quantify the different success dimensions of completed

marketing campaigns

Roles

„ Campaign Manager

„ Market research professionals

Business Package for e-Analytics

Business benefit

Provides e-analytics for continually analyzing and optimizing an organization’s on-line presence

Users can:

„ Get transaction information (which products looked at, placed in shopping basket, purchased, etc.)

„ Identify and correct

problems with your web site

„ Analyze visitor behavior

Roles:

„ Web Administrator

„ Webshop Manager

Business Package for Production Analysis

Business benefit

Provides for the analytical demands of modern supply chain planning and execution systems

Users can:

„ Reduce overall material waste relative to its cost

„ Improve quantity reliability

„ Maximize machine capacity usage

„ Improve on-time delivery rates

Roles

„ Production directors

„ Production planners

„ Production supervisors

Business Package for Inventory Analysis

Business benefit

Provides decision support for both inbound and outbound goods, to optimize, monitor, and control turnover

Users can:

„ Track materials movement

„ Identify trends in inventory turnover

„ Limit capital lockup to a minimum

„ React to increased stock value

„ Accelerate capital flow by increasing inventory turnover

Roles

„ Material requirements experts

„ Inventory managers

„ Logistics controllers

Business Package for Procurement Analysis

Business benefit

Provides decision support for cutting procurement costs and building close relationships with important suppliers

Users can:

„ Consolidate procurement activities

„ Increase leverage with vendors for pricing and terms

„ Optimize supplier base

„ Support relationship building with strategic vendors

Roles

„ Buyers

„ Procurement managers

Benefits

360° view on your e-Business processes 9 Packaged Analytical Applications for business processes

9 Predefined Business Packages for easy implementation

9 Closed loop scenarios with interactive steps enabling informed solution and decision support

9 Comprehensive construction set with pre-assembled Business Content

9 Powerful development environment for building custom

Analytical Applications

Agenda

1 SAP BW Business Content

SAP BW Business Content

Analytical Application

Technical Content

Demo Content

BI Administration Cockpit - Motivation

Easy administration for complex

Enterprise Data Warehouses using the BI Administration Cockpit which is delivered with

NetWeaver2004s BI Content Add-On 2

Easy administration for complex

Enterprise Data Warehouses using the BI Administration Cockpit which is delivered with

NetWeaver2004s BI Content

Add-On 2

BI Administration Cockpit - Scope

…including context-specific

„ Drill-down to details

„ Processing options

„ Exceptions (optional)

…using proven technology

„ BI Queries

„ BI Web Applications

„ SAP NetWeaver Portal

…to make administration easier and faster

…and thus to lower the TCO Support the BI administrator in

„ Status tracking

„ Performance optimization

„ Strategic administration

…in the areas of

„ Enterprise Data Warehousing

„ Enterprise Query, Reporting and Analysis

„ Business Planning and Analytical Services

…by providing a central point of entry with cockpits

„ Real-time monitors

„ Runtime Statistics

BI Administration Cockpit - Overview

Central access to most important BI monitoring information

Monitoring of multiple BI systems

in one view

Flexible filtering of

Context menu for access to more detailed information

or BI Transaction

Exception definition for

intuitive display of critical

monitoring data (optional)

BI Administration Cockpit – Architecture

Business Package „BI Administration 1.0“ from the Portal Content

Portfolio. BI Administration Cockpit can run in a

central or in a local portal.

SAP NetWeaver Portal

BI Suite BI

Platform Data

Warehousing

Queries

BI Web Applications

InfoProviders / MultiProviders

Query Runtime Statistics Data Load

Statistics

Data Load Status

DataSources

iViews iViews Portal

Pages iViews

Technical Content for SAP NetWeaver BI (software component BI_CONT, release 7.0.2), The Technical Content is

entirely based on SAP BW 3.x functionality not

requiring BI_JAVA.

SAP NetWeaver 2004s BI technology

(software component

SAP_BW)

BI Administration Cockpit – Main building blocks

BI Data BI

Queries

BI Web Applications

InfoProviders / MultiProviders

Query Runtime Statistics Data Load

Statistics

Data Load Status

DataSources

iViews iViews SAP NetWeaver Portal

Portal

Pages iViews

BI Statistics

„ Detailed Runtime Statistics Data collection for various BI

Objects in Data Warehousing, Enterprise Reporting and Planning Technical Content (InfoProviders and DataSources)

„ Central Data Basis for BI Administration Cockpit and BI system load transaction ST03

„ Persistent Data Storage and Remote Access to BI Statistics Information

Technical Content (Web Application and Queries)

„ Flexible analysis of statistics data and sophisticated presentation of information (graphs, charts, tables)

BI Administration Cockpit (Business Package)

„ Single point of entry and integration with other (non BI related) portal content (example: Universal Work List)

B ui lt- In M an da tor y R ec om

m ende

d

BI Administration Cockpit - Configuration

SAP NetWeaver BI

SAP NetWeaver Portal Configuration steps

7. Set Up Call to BI Administration Cockpit

6. Install Business Package 'BI Administration 1.0‘

5. Connect BI System and Portal

4. Schedule Technical Content Process Chains 3. Check Updating of Statistics

2. Assign the BI Administrator Role

1. Activate the new technical content in SAP NetWeaver BI

BI Statistics Technical Content for SAP

NetWeaver BI Business Package

“BI Administration 1.0”

Æ Available with installation or upgrade to SAP NetWeaver 2004s BI

Further Information

„ Please read carefully SAP Service Marketplace note 934848

“Collective note: (FAQ) BI Administration Cockpit”

„ Implementation Guide in SAP NetWeaver BI (transaction SPRO) and

SAP NetWeaver Administration and BI

Alert Management System (ALM)

Alert Management System (ALM)

Computing Center Management System

(CCMS) Central Performance History (CPH)

Process Chains (RSPC) Technical

Content

SAP NetWeaver Portal

SAP NetWeaver Administrator

SAP Solution Manager

Web AS ABAP & Java BI

Administration Cockpit

SAP NetWeaver BI

BI Checks (RSRV) BI Suite, BI

Platform & Data Warehousing

Universal Work List

BI Content for CCMS

Computing Center Management System

(CCMS) BI Content Web

Application for

CCMS

New BI Statistics and Technical Content

Main enhancements

„ New Technical Content for new and enhanced BI Statistics

‹ New Query Runtime Statistics

‹ Process Chain and DTP Statistics

‹ BI Object Request and Process Status

„ Technical Content for direct access and analysis on persistent data

‹ Per default, queries from the Technical Content filter on reading from persistent InfoProviders only

‹ Reading from Virtual Providers can be enabled on query level by customers

„ Technical Content on detailed and aggregated level

‹ For Query Runtime Statistics

„ New maintenance for statistics data collection

‹ Enabling statistics and selection of detail level for statistics

Analysis of BI Statistics data in SAP NetWeaver 2004s

BI Administration Cockpit

Statistics tables (RSSDSTAT*)

ST03 – BW System Load*

New: System Load analysis for BI based on Technical Content

New and enhanced Technical Content New: Persistent

data storage and direct access

Expert mode “profiling”

New: Ad hoc

analysis of

statistics data

Analysis of Query Runtime Statistics: Query Monitor

In the Query Monitor (transaction RSRT) detailed query runtime statistics can be displayed:

Front-End and OLAP:

detailed list of all (sequential) events

Data Manager: Runtime of all (parallel) “sub” queries:

• InfoProvider (<InfoProvider>)

• BI Accelerator ($<InfoCube>)

• Aggregate (1xxxxx)

Analysis of Query Runtime Statistics: Profiling

In the (new) BEx Web, experts / administrators can display query runtime statistics of the current user session using the expert mode ‚profiling‘.

&profiling=X

Maintenance of the statistic data collection (1)

For Queries, InfoProviders, Web Templates, Workbooks

and DTPs

Switch Statistics data collection on or off

Set the statistic detail level

‚0‘ = Aggregated data only

‚1‘ = No detail on data manager

‚2‘ = Detail on all levels

Scheduled deletion of statistics data (on time basis) also: automatic deletion during delta load

…accessible from the Data Warehousing Workbench Æ Tools

Maintenance of the statistic data collection (2)

Default settings for statistic data collection

„ (Delivered) System Default:

„ D = ‘X’ = On, Statistic Detail level: D = ‘2’ = All details

„ System Default for all queries can be customized

„ Extras Æ Change Default

„ InfoProvider Default for queries can be customized

„ All new queries of this InfoProvider will inherit the new setting

Statistic Data Management

„ Please review the (delivered) system default and disable statistic data collection where performance monitoring is not necessary

„ Example: InfoProviders with low data volume

„ Setting Statistic Detail Level ‘2’ for all queries will result in large amounts of data in statistic data collection tables (rule of thumb: ~ 30 - 40 records per query navigation step)

„ Frequent transfer to Technical Content InfoProviders recommended

Query Runtime Statistics in SAP NetWeaver 2004s

Front end / OLAP Statistics and Data Manager Statistics …

„ Splitting the BW 3.x OLAP statistics into Frontend / OLAP statistics and Data Manager statistics

„ Serial execution (Front-End/OLAP) vs. parallel execution (Data Manager, mostly)

„ Many different events (FE/OLAP) vs. small number of events (DM)

Statistic detail levels

„ Introducing statistic detail levels on query level

„ Customize the level of detail of statistic data collection for a certain object

Event Concept

„ Introducing the concept of the Event ID (characteristic)

„ Flexible and extensible framework

Enhanced coverage of BI functionality

„ Enhanced: BEx Web, Planning

„ New: BI Accelerator

BI Statistics framework – new event concept

Event ID

„ At many different events in processing, runtime information gets collected

„ Common concept used in query runtime, planning and warehouse management statistics

„ Guarantees flexibility for further extensions

„ Is the basis for end to end runtime monitoring of processing in SAP NetWeaver BI

„ Depending on the event, the time is

measured from start to end point or

only at end point (time since last end

point)

Query Runtime Statistics - Overview (example)

BI Web Application containing two web

items

Query 1 Query 2

InfoCube 1 DS Object 3 InfoCube 2

Frontend

OLAP

Data Manager

Query Runtime Statistics - Overview (example)

User Session (SESSIONUID)

User Step 1 (STEPUID)

Query 1 Query 2

Step 2

Data Manager (DMUID)

InfoCube 2, HPA Index

Web Items, Web Application

InfoCube 1, Aggregate 1 DS Object 3

Front end / OLAP statistics (RSDDSTAT_OLAP)

Data Manager statistics (RSDDSTAT_DM) Waiting time

OLAP, Cache, Master Data

∑ = total runtime of the

navigation step in your

BI web application, your

workbook or your front

end

New Technical Content for Query Runtime Statistics (1)

0TCT_C01 0TCT_VC01 0TCT_MC01

0TCT_DS01

0TCT_C02

0TCT_DS02

0TCT_VC02

RSDDSTAT_OLAP (database view)

0TCT_MC02

0TCT_C03

0TCT_DS03

0TCT_VC03 0TCT_MC03

RSDDSTAT_DM (database view)

Front-End and OLAP Front-End and OLAP Data Manager Statistics

New Technical Content for Query Runtime Statistics (2)

Technical content queries for analyzing the runtime of …

„ Queries

„ BI Web Applications

… each with various key figures (excerpt) …

„ Ø Frontend-time

„ Ø OLAP-time

„ Ø DM-time

„ Ø Planning time

… being calculated as …

„ Averages, Deviations, Rankings

…and displayed in different time intervals:

„ Hours per day, Days per month, Weeks per quarter

Technical Content for Query Runtime Statistics: Migration

Migration mandatory

„ 3.x InfoCube 0BWTC_C02 will not receive any new data as source table RSDDSTAT is not used for statistics data collection anymore No migration: Technical content 3.x still valid

„ With SAP NetWeaver 2004s, table RSDDSTATAGGRDEF has been enhanced. The technical content 3.x is currently not reflecting this update but can still be used

0BWTC_C02 BW Statistics - OLAP

0TCT_C01

Front-End and OLAP Statistics

0BWTC_C03

BW Statistics - OLAP, Detail Navigation

0TCT_C02 0TCT_C03

Data Manager Statistics

Administration Cockpit: Query Runtime Statistics

Data Load Statistics in SAP NetWeaver 2004s

Detailed Statistics data for new data flow Statistics data for SAP BW 3.x

data flow technology

Statistics data on process chains

DataSource

Source system

InfoProvider

Transformation InfoSource

InfoPackage

Transformation

DataSource 3.x

InfoSource 3.x Transfer Rules

Update Rules

InfoPackage InfoProvider

InfoPackage

InfoPackage

DTP

Process Chain Statistics DTP

DTP statistics

All other warehouse management

processes

InfoPackage Source system

NEW down ^Drill NEW

New Technical Content for Data Load Statistics (1)

0TCT_C11

0TCT_DS11

0TCT_VC11

RSPCLOGCHAIN 0TCT_MC11

RSPCPROCESSLOG

0TCT_C12

0TCT_DS12

0TCT_VC12

RSBKREQUEST 0TCT_MC12

0TCT_C23

0TCT_DS23

0TCT_VC23 0TCT_MC23

RSDDSTATDTP RSDDSTATWHM

New Technical Content for Data Load Statistics (2)

Technical content queries for analyzing…

…performance details of process chains

„ Ø Total runtime

„ Run-times data load, data update, activation, compression, aggregation, attribute change

…performance details of Data Transfer Processes

„ Ø Total runtime, Ø Number of records, Ø Amount of data

„ Run-times of each step type

…performance details of InfoPackages

„ Ø Total runtime , Ø Number of records, Ø Amount of data

„ Run-times of each action type

Technical Content for Data Load Statistics: Migration

Migration recommended

„ 3.x InfoCube will still contain data, migration recommended as of new data model and new InfoObjects used

No migration: Technical content 3.x still valid

0BWTC_C05 BW Statistics - WHM

0TCT_C23

InfoPackage Statistics

0BWTC_C04

BW Statistics - Aggregates

0BWTC_C05

BW Statistics: Deleting Data from InfoCubes 0BWTC_C06

BW Statistics: Condensing InfoCubes

New Technical Content for Data Load Status (1)

0TCT_DS11 0TCT_VC11

RSMDATASTATE RSMDATASTATE_EXT

0TCT_MC11 0TCT_MC12

0TCT_VC12

0TCT_DS12

RSPCPROCESSLOG RSPCLOGCHAIN

BI Object Request Status Process Status

New Technical Content for Data Load Status (2)

Technical content queries for analyzing…

… status details of

„ InfoCubes, DataStore objects, Master data (only flexible update)

„ PSA tables

… with various key figures and characteristics …

„ Total numbers of requests, Last request, Time-stamp of last change

… each for the several criteria

„ All requests

„ Qualitatively not OK (ranking criterion, not for PSA)

„ Technically not OK (filter criterion)

„ Not activated (only for DataStore objects)

„ Not compressed (only for InfoCubes)

„ Not aggregated (only for InfoCubes)

New Technical Content for Data Load Status (3)

Technical content queries for analyzing…

… status details of …

„ Process Chains, Data Transfer Processes, InfoPackages, DataStore object activations, InfoCube compressions, Hierarchy and Attribute change runs and various other processes

… with the following status information …

„ Status (red, yellow, green) (ranking criterion)

„ Ended with error

„ Still running

„ Ended successfully

„ Not yet started

Technical Content for Data Load Status: Migration

Migration recommended

„ 3.x InfoCubes will still contain data, migration recommended as of new data model and direct access capabilities

0BWTC_C06

BW Data Slice 0TCT_C11

BI Object Request Status 0BWTC_C07

Requests in the InfoCube

Administration Cockpit: Data Load Status

Agenda

1 SAP BW Business Content

SAP BW Business Content

Analytical Application

Technical Content

Demo Content

SAP Demo Content

SAP DemoContent delivers sample data and demonstration scenarios alongside Business Content Metadata.

z Activation in a few steps

z Quick demonstration scenarios from different business areas z First insights around the Business Information Warehouse

DemoContent objects all have technical names beginning with "0D_“, for separating this Content area form company’s Business Content.

SAP Demo Content is not designed for productive use. But the objects can be

used as templates for structuring Content at a later date.

SAP Demo Content

Î Available SAP Demo Content Areas:

I. SAP Demo Sales and Distribution: Overview II. SAP Demo Sales and Distribution

III. SAP Demo Purchasing

IV. SAP Demo Profitability Analysis V. SAP Demo Financial Accounting

z Accounts Receivable Accounting z Accounts Payable Accounting VI. SAP Demo Installed Base

z SAP Demo Installed Base – Licenses z SAP Demo Installed Base – Sales

9 InfoSources 9 InfoCubes 9 Queries

9 Web-Templates

SAP Demo Content

Î Examples:

SAP Demo Content

Î Examples:

Agenda

1 SAP BW Business Content

SAP BW Business Content

Analytical Application

Technical Content

Demo Content

Agenda

1 SAP BW Business Content 2

3 Activation of SAP BW Business Content

Info sources to SAP BW Business Content BW Business Content as Add-On

4

Status until SAP BW 3.1 Content

‰ SAP BW Content and SAP BW Technology was always delivered together with SAP BW

‰ “Pure” Business Content releases (SAP BW 2.1C, SAP BW 3.1 Content) required a full upgrade of the BW System at the customer site

‰ Business Content was often released in Support Packages, e.g. for 3.0B in SP 2

‰ BW Support Package included BW Technology corrections

and Content object corrections

New Situation

From SAP BW 3.1 Content onward, SAP BW Business Content will be delivered as a separate Software Component “BI Content Add-On”.

‰ Separate Support Packages for SAP BW Business Content corrections

‰ Approx. 3 Add-Ons between technology BW Releases are

planned

Benefits of Business Content as an Add-On

‰ Always use of the newest content.

‰ The duration of the upgrade is reduced to one to two hours, as the Add-On includes only content-relevant parts.

‰ Starting with the BI Content 3.2 Add-On, a technical upgrade of BW systems is no longer necessary as only content-relevant objects are imported.

‰ SAP BW Business Content developments and enhancements are available at shorter intervals.

‰ Changes in the Support Package procedures – separation of Support Packages for the SAP BW Technology and SAP BW Content – permit independent imports and tests of Support Packages.

‰ The Add-On release will be available for download from the SAP

Service Marketplace, which eliminates time for delivery and

customs duties.

NetWeaver2004s BI Content Add-On 2 / 3 – Released for mass shipment

As of 30.10.2004, SAP NetWeaver 2004s, BI Content Add-On 2 is released for ramp-up customers. With mass shipment of

NetWeaver2004s, most actual BI Content Add-On (NetWeaver2004s BI Content Add-On 3) is shipped to customer as the separate DVD within the NetWeaver2004s software package.

We recommend you to Install the most actual Content

Upgrade scenarios to SAP BW 3.5

SAP BW 3.1 Content

Including:

BI Content 3.2 ADD-On or BI Content 3.3 ADD-On

SAP BW 3.0B SAP BW 2.1C SAP BW 2.0B

BI_Cont 351 SAP_BW 350 Components:

Full Release Upgrade

BI_Cont 352 BI_Cont 353

or

or

Upgrade scenarios within SAP BW 3.5

Components:

BI_Cont 352 SAP_BW 350 Components:

BI_Cont 351 SAP_BW 350 Components:

BI_Cont 353 SAP_BW 350

Add-On Delta Upgrade

Add-On Delta Upgrade

Add-On

Delta

Upgrade

Upgrade scenarios to NetWeaver2004s BI Content Add-On 2

SAP BW 3.5 Content Including:

BI Content 3.5.1 ADD-On, BI Content 3.5.2 ADD-On or BI Content 3.5.3 Add-On SAP BW 3.1 Content

Including:

BI Content 3.2 ADD-On or BI Content 3.3 ADD-On SAP BW 3.0B

SAP_BW 70 Components:

Full Release Upgrade

BI_Cont 702 BI_Cont 703

or

SAP BW 2.0B SAP BW 2.1C

Full

Release

Upgrade

Prerequisite for upgrade to NetWeaver2004s BI Content Add-Ons

ƒ If you want to upgrade to NetWeaver2004s BI Content Add-On Release, we generally recommend you to install the latest SAP_BW Support Packages.

ƒ NetWeaver2004s stack 5 is the prerequisite for installing NetWeaver2004s BI Content Add-On 2 support package 1.

ƒ NetWeaver2004s stack 7 is the prerequisite for installing

NetWeaver2004s BI Content Add-On 3 support package 1.

Ordering of Add-On Software

Three possible channels for ordering the Add-On Software:

1. The upgrade Software for BI Content Add-Ons will be available for download from the SAP Service Marketplace

-> alias: swdc Æ Installations and Upgrades Æ SAP NetWeaver Æ SAP NETWEAVER Æ SAP NETWEAVER2004S

2. The upgrade Software for BI Content Add-Ons can be ordered via OSS

-> component: xx-ser-swft-ship

3. The upgrade Software for BI Content Add-Ons can be ordered via Software catalogue

-> alias: swcat

Support Packages

ƒ Split into two separate support packages: BI Content Add-On support packages and BI Technology support packages.

ƒ There is no automatic dependency between BI Content Add-On support packages and BI Technology support packages.

ƒ For each new BI Content Add-On version we recommend that you install the latest BI Technology support package.

ƒ Future dependencies are communicated together with the

relevant support packages.

Maintenance Strategy (Example BW 3.5)

SAP BW 3.5

BI Content 3.5.2 Add-On

BI Content 3.5.3 Add-On BI Content

3.5.1 Add-On BW Technology

BW Business Content

For detailed release and maintenance strategy, please refer to note 153967.

Last BI Content Add-On Release will be maintained as long as the underlying technology release!

Only within the

Ramp-Up period Approx. 1 year

June 2005 Mar. 2013

Sep. 2004

Agenda

1 SAP BW Business Content 2

3 Activation of SAP BW Business Content

Info sources to SAP BW Business Content BW Business Content as Add-On

4

SAP BW Business Content Activation

Î Before SAP BW Business Content can be used productively, it

has to be “activated” !!!

SAP Business Content Delivery - Version

Objects of the Business Information Warehouse are run in versions to be able to edit, execute and deliver different characteristics for an object in parallel.

The objects of the Business Content are delivered in version D(elivery) Changes are store in M(odified) version; Data is stored in A(ctive) objects An upgrade of the Business Content does not affect the objects which are in productive use!

1 1 1 Version

M(odified) A(ctive)

D(elivery) 1 1

1 1 1 1

1

Business Content Objects Particularity

Most of the delivered Content Objects dispose of:

A -Version = active D -Version = delivered M -Version = modified Exceptions:

z Transferstructures do not have D-versions, they have shadow tables z Roles do not have D-Versions

A-version = SAP_BWC_* (only for customer systems relevant) D-version = SAP_BW_* (will be delivered)

Only A version objects are exported from the development system

These objects are imported into the target system into either the A-Version or M-Version, depending on the object type. The M -Version objects are activated after import. Examples are:

A -Version : Currency translation type, InfoObject Catalog

SAP Business Content Delivery - Upgrade

An Upgrade to take advantage of the new features:

z Improved or enhanced information model z New information model

Upgrading BW Business Content corresponds to a functional upgrade:

z No effect on the complete Business Content with all information models

z Can be performed selectively (see step-by-step …)

How to activate a new Version of BW BCT ?

Two Transfer Methods

The customer can compare the new content with the active customer version and either “install” the new version or “merge” it with the customer version.

Install = The SAP BW Business Content in the A -Version will be overwritten completely

(a copy of the new Version is inserted), changes/modification which were done

to the prior SAP BW Business Content will be lost completely.

How to activate a new Version of BW BCT ?

1. Installation of BW BCT

Version M

delivery from SAP

1 1 (odified)

A(ctive) D(elivery)

2 2 2 2

3 3

2nd delivery from SAP install BC

(copy) 1 1

1 1 1 1

1 1 1 1

2nd install BC (copy)

2 2 3 3

3 3 3 3

3 3 3 3 2 2

2 2

1 1

modify BC

How to activate a new Version of BW BCT ?

Match = Changes/modification will be kept and merged with the new SAP BW Business Content version

Customizing settings to SAP BW Business Content is dominant in case, “matching”

is not possible !

Not all objects support merging !

The possible transfer method is dependent on the type of the

delivered Business Content !

How to activate a new Version of BW BCT ?

2. Match of BW BCT

Version M

delivery from SAP

1 1 (odified)

A(ctive) D(elivery)

2 2 2 2

3 3

2nd delivery from SAP install BC

(copy) 1 1

1 1 1 1

1 1 1 1

2nd match BC 2 2 4 4

4 4 4 4

3 3 3 3 2 2

2 2

1 1

modify BC

How to activate a new Version of BW BCT ?

Business Content Objects with „match“ functionality:

z RRI InfoCube Receiver z RRI Query Receiver z DataSource/FileSource z InfoCube

z InfoObject

z InfoObject Catalog z Miningmodell

z Modellsource z Multiprovider z ODS Object z Process Chain z Transferrules

For these Business Content Objects automatically the checkbox „Match (X)“

appears, when collecting

Business Content for

activation !

How to activate a new Version of BW BCT ?

Business Content Objects with pure „install“ functionality:

z Aggregate z Application

z Crystal Reports Workbooks z Query Elements (Report)

Query, structure, restricted and calculated key figures, variables

z Update rule z InfoArea

z InfoPackage

z InfoPackageGroup z InfoSet

z

z InfoSource z Sourcesystem z QueryView

z Report Agent Package z Report Agent Setting z Role

z Currency Translation Type z Web Item

z Web Template

z Workbook

Customizing of SAP BW Business Content

…. SAP BW Business Content doesn’t fit to the requirements ?

…. What happens when SAP BW Business Content has to be adjusted ?

…. Will adjustments to standard delivered BW Business Content influence future update facilities of BW Business Content ?

…. What has to be considered when planning customizing to BW

Business Content ?

Customizing of SAP BW Business Content

c An upgrade of the Business Content does not affect the objects which are in productive use ! To benefit from a new version of SAP BW Business Content, the meta data have to be reactivated with the new version of Business Content.

d SAP BW Business Content is easily extensible to adapt it to own requirements !

e Customizing of SAP BW Business Content has, except some exceptions, no influence on future update facilities !

f Exception: BW Business Content Objects with no “match”

functionality: copy the relevant Business Content Objects into a new namespace before customizing !

g Business Content versioning is an ongoing maintenance

consideration with each new SAP BW release

BW Business Content Step-by-Step Activation

z Activation in the Administrator Workbench via the Business Content Tab in three steps

z Content Wizard provides end-to-end solution

z Activation is possible for only specific objects or for entire dataflow from DataSource to Role

z Relevant objects from all components can be collected automatically and activated in one step

z Upon activation, entire scenario can be utilized

Business Content Activation

Object is active Object is active,

but there is a newer D-Version

Object not active

Business Content Installation in Three Steps

1. Select one or several objects

2. Drag & Drop objects (or use context menu)

3. Start

installation on- line or in batch

A description of the tool can be displayed in a separate window

Start via Easy Access or

transaction code (RSA1

or RSOR)

Step 1: Available Objects

InfoProvider InfoObjects InfoSources 1. Select available

objects by several trees

Step 1: Available Objects

1. Select available

objects by several trees

By Types By Patches

Roles InfoPackages

Step 2: Start Collecting Objects

2. Drag & Drop objects (or use context menu)

Required objects are collected

and displayed in the central frame

Step 3: Start Installation of Business Content

3. Start installation on-line (or in batch)

Objects already activated and identical to the delivered ones are indicated by green LED Objects not active jet or

outdated are installed by default

InfoCubes, InfoObjects, ... can be matched with activated version (default)

outdated content is marked by

a date icon

Installation BC: User-Specific Options

Personalized list of

objects

Collected objects can include required ones only or objects in the data-flow

User specific frame sizes

Collect

immediately after drag&drop or start manually

Objects can be searched in the tree

Access protocols of BC installation on DB

Select default source

systems for collecting

SAP Business Content Release

The “Content release” field indicates the release in which the object was delivered within the framework …

2.0/01 = 2.0A

2.0/02 = 2.0B

2.1/01 = 2.1C

3.0/01 = 3.0A

3.0/02 = 3.0B

3.1/01 = 3.1 Content

SAP Business Content Release

…check for a newer version for this object.

2.0/01 = 2.0A 2.0/02 = 2.0B 2.1/01 = 2.1C 3.0/01 = 3.0A 3.0/02 = 3.0B

“new version”

available !

Agenda

1 SAP BW Business Content 2

3 Activation of SAP BW Business Content

Info sources to SAP BW Business Content BW Business Content as Add-On

4

SAP Service Marketplace

http://service.sap.com/bi

SAP Service Marketplace

“NW2004s BI Content Add-On 2”

Information about the NetWeaver BI Business Content Add-on

Release

z Availability

z Upgrade Information

z Business Content List

SAP Service Marketplace

“Documentation”

Latest news and links

for NetWeaver BI documentation:

z NetWeaver2004s BI

Content Add-On 2 HTML format

z BI Documentation Enhancements

z Release Information

z Alternatively direct access

http://help.sap.com/

SAP Service Marketplace

“BI Newsmails and Subscriptionslist”

z PM BI Product Newslette

z PM BI Product Newsflash

z PM BI Product Newsalert

SAP Service Marketplace

“BI Content”

z An own alias for BI Business Content exists -> BI Content

z “One single point of entry” for SAP NetWeaver BI Business Content Solutions

Ö Detailed information on Business Content Solutions

Ö Links to up-to-date online documentation

for each BW Business Content Solution

Ö General Information

BI Business Content in Metadata Repository

Business Content or Activated Objects within a BW system can be

viewed online in the Metadata Repository.

Metadata Repository Available Off-Line (1)

Via “Business Content” or “Metadata Repository” tabs, menu path

Extras Î HTML Export Î Create HTML…

Metadata Repository Available Off-Line (2)

1. Click on the

required information

2. Select the

relevant object