alert framework and bw - archive...©sap labs llc 2004, 2 agenda sap netweaver alert framework...

SAP NetWeaverTechnical Integration Aspect

Alert Framework and BW03/17/04Lothar Schubert, SAP Labs LLC, RIG

Matt Kangas, SAP Labs LLC, PMO

© SAP Labs LLC 2004, 2

Agenda

SAP NetWeaver

Alert Framework (WebAS)

Exception Handling (BW)

Case 1: BW Reporting Agent and AF

Case 2: BW Process Chains and AF

Discussion


SAP NetWeaver™ Objectives

Business objectivesIncrease our customers’agility through strategy-aligned executionIncrease our customers’ efficiency through execution excellence

Technology objectivesReduce TCO by leveraging existing and upcoming IT investmentsEnrich platform with additional openness, process management, knowledge management, collaboration, and analytic functionality

PeopleIntegration

InformationIntegration

ProcessIntegration

Existing Systems

Snap onbusinessprocess

Open, Web Services Environment

Web ServicesApplication Platform


SAP NetWeaver – Technical Integration Scenarios

Business Intelligence within the SAP NetWeaver Platform

• Publish to EP• Broadcast to EP

• BI available in EP• BI available on the go• Collaboration

with BI context

• Data Consolidation(B-Partners, Materials)

• Push into BW• Open Hub Extraction

• Common Platform• BI Java SDK• BW Query (XML) WS• BW Staging WS


Agenda

SAP NetWeaver





Discussion


Typical Scenarios

Key Customer Cancels Contract (mySAP CRM)

Delivery Problems for an Important Order (mySAP SCM)

Drastic Decline inRevenue (mySAP BI)

Insufficient System Resources, System

Administration (mySAP Technology)

Machine DamagedProduction Standing

Stock Value Goes Below Limit

Value of time-criticalinformation

Elapsed Time


What is Alert Management?

Active delivery of mission critical information in real-time:

Support for e-mail, SMS/Pager, Fax, WAP, Web Interface ...

Personalized alert deliveryGet messages via your preferred channel

Define which content is relevant for you Publish and Subscribe mechanism for alert topics

Easy-to-use definition environment for customer projects


Alert Management System

The Alert Management system is available since SAP Web AS 6.20

Alert Delivery Logic implemented by:

CRM ( Customer Relationship Management)

SCEM (Supply Chain Event Management)

APO (Advanced Planner and Optimizer)

CCMS (Computer Centric Monitoring System)

PLM (Product Lifecycle Management)

BW (Business Information Warehouse)

…


Example: System Landscape with Central Alert Server

SAP R/3 4.6C

Alert InboxEnterprise Portal

WAP Alert Inbox

SAPconnect:E-Mail, Fax, SMS, Pager, ...

Push

RFC

SAP Web AS 6.20Central Alert ServerCRM 3.1

ArbitrarySystem

Event Alert

Push

JCoXI

BusinessConnector


Different Modes for Running Alert Management

DifferentSAP Systems

SAP Web AS 6.20

Central Alert Server

ExternalAlert System

SAP System(e.g. mySAP CRM)

SAP Web AS 6.20Alert Server

DifferentSAP Systems

(e.g. mySAP CRM, mySAP PLM,

mySAP SCM, ...)

SAP Web AS 6.20Central

Alert Server

RFC

RFC

E-Mail, Fax andShort Messages

(SMS/Pager)

XML

E-Mail, Fax andShort Messages

(SMS/Pager)Multiple Communication Channels

(Unified Messaging)


Triggering an Alert

Using an event defined in the BusinessObject Repository

Define event linkage with transaction SWE2Receiver function module: SALRT_CREATE_VIA_EVENT

Triggering via PPF (allows rule-based triggering of alerts)

Direct call of a function moduleSALRT_CREATE_API

Auto-Reaction Method in CCMS (since 6.40)

Triggering as a step in a workflow


Alert Status

After Delivery Alert is in Status DELIVERED

Alert can be confirmation by e-mail, SMS, and in the alert inbox“I have received and read the message!” “Do not escalate this message any further!” “Do not show this alert in my inbox again”

After Delivery Alert is in Status CONFIRMED

If nobody confirms, Escalation procedure is possible Alert is sent again Alert is forwarded to superior or system administrator in case of missing confirmation


Summary

Speed Up Your Business with Alert Management!

Active delivery of highly important/critical informationSupport for different media including e-mail, Fax, WAP, SMS, WebPersonalized alert delivery and personalized alert contentAlert inbox for an enterprise portalTracking whether the information has been received and escalation procedureConnection and integration with third-party communication systems, such as unified messaging...


New Features in 6.40

Transaction SALRTCATDEF_SEL allows the maintenance of alert categories of a given alert classification, only these categories can be maintained

Authorization concept

Types of subsequent activities

Title for Alerts, now an alert has a title, short text (for pager/SMS only) and a long text (mail, fax only)

Alert classifications with sub-classifications (classification hierarchy)

Interaction possibilities (pass application guid when triggering an alert), application can be updated after an alert was confirmed, all alerts of a given scenario can be confirmed.

Pass roles when triggering alerts (all users in that role will get the alert)

Extended Demo applications in package SALERT_DEMO

Enabling of subscription conditions (e.g. “I wan all alerts of category SHIPPING_DELAYED but only for SHIPPING_POINT = ‘FR’.). This feature can be implemented but is not full available right now.

Container supports table and structure types


Further Information

Public Web:www.sap.com Solutions Technology

Service Marketplace:http://service.sap.comUse aliases: /alert, /communication


Agenda

SAP NetWeaver





Discussion


Exception Notification, triggered by BW

Follow-Up(BAdi)

Technical ExceptionsStaging ErrorsSystem Buffer OverflowsData Inconsistencies

MonitoringProcess Chain MonitorStaging MonitorSystem Logs

Business Exceptions•Drop in Revenue•Inventory below safety•Major order by customer

Monitoring• Exception in Query• Exception Monitor

Email/Pager

Email/Pager

Alert Inbox(BSP/EP)

EP UWL(planned)

Email/Pager

API

BWWAS

Enterprise Portal

Alert Framework (WebAS)Alert Monitor (RZ21)

Case 1Case 2

EP


Reporting Agent – Functional Areas

Alert NotificationE-mail/SMS Alert Monitor

Background Printing

Pre-Calculation of Web Templates

as completed HTML documents

Pre-calculation ofValue Sets

Managing Bookmarks

Exception Reporting

inspect data sets for exceptionstrigger follow-up actions automaticallysend Email / SMS notificationmonitor alerts

Background Printing

Execute queries in the background Print formatted results to a supported device

Pre-Calculation of Web Templatespre-calculation of data

device dependent processing of HTML output

download of web reports from ApplServer

Pre-calculation of Value SetsNew variable type: value set

Value set is generated from query output

Managing BookmarksView Bookmarks byplace

User in one centralized

Delete Bookmarks bCriteria

y Period, Author or other


Benefits of Reporting Agent

Reduce system loadMove long-running or resource-intensive queries to periods of low system loadProcess queries once and reuse data

Automate routine tasks Inspect large data sets for exceptionsMass printing of query-based documents

Improve performancePrecalculate value sets or templates

Process queries for offline usage


Reporting Agent – User Interface

Available Objects&

Reporting Agent Settings

Scheduling Packets


Agenda

SAP NetWeaver





Discussion


Definition of Alert Category (1)

Transaction codeALRTCATDEF

Overview of alert categorieson this server

Definition ofalert category



Container definition: Includes text variables, which arereplaced at runtime (BW_ALERT_TEXT has special treatment)



Short text and long text: Shorttext is sent via SMS and displayedin the alert inbox, and long text appears in the detail view of thealert inbox.



URL-based subsequent activities


Recipient Determination

Administrator defines recipients (system configuration)Users are maintained as fixed recipients for an alert categoryUser groups are maintained as recipients via user roles

Subscription: User decides what is relevant for him or herRoles are assigned to a categoryUsers that are holders of a role assigned to this category are allowed to subscribe to this category (authorization concept)User chooses what is relevant for him or her (cancel subscription also possible)

Application determines recipients

You can mix the different methods for determining recipients!


Alert Framework Configuration


BW Exception Report

Exceptions have been defined in BEx Analyzer


BW Reporting Agent (1)

Here is where you build the linkbetween BW and AF(out of the box)


BW Reporting Agent (2)

This is the place to pass container parameters to the AF. Again,BW_ALERT_TEXT is treated in a special way, and does notrequire a special assignment here.


Alert Delivery via Mail, Fax, SMS


Alert Inbox (Business Server Page)


Alert Delivery (Email)


Alternative Alert Delivery Option (EP, WAP)


Agenda

SAP NetWeaver





Discussion


Process Chain Management


Alert Category and Container


Custom Element in Process Chain

Here is where you build the linkbetween BW and AF(not out of the box)


Alert Delivery


Agenda

SAP NetWeaver





Discussion


Q&A


Copyright 2004 SAP AG. All Rights Reserved

No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. The information contained herein may be changed without prior notice.

Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors.

Microsoft®, WINDOWS®, NT®, EXCEL®, Word®, PowerPoint® and SQL Server® are registered trademarks of Microsoft Corporation.

IBM®, DB2®, DB2 Universal Database, OS/2®, Parallel Sysplex®, MVS/ESA, AIX®, S/390®, AS/400®, OS/390®, OS/400®, iSeries, pSeries, xSeries, zSeries, z/OS, AFP, Intelligent Miner, WebSphere®, Netfinity®, Tivoli®, Informix and Informix® Dynamic ServerTM are trademarks of IBM Corporation in USA and/or other countries.

ORACLE® is a registered trademark of ORACLE Corporation.

UNIX®, X/Open®, OSF/1®, and Motif® are registered trademarks of the Open Group.

Citrix®, the Citrix logo, ICA®, Program Neighborhood®, MetaFrame®, WinFrame®, VideoFrame®, MultiWin® and other Citrix product names referenced herein are trademarks of Citrix Systems, Inc.

HTML, DHTML, XML, XHTML are trademarks or registered trademarks of W3C®, World Wide Web Consortium, Massachusetts Institute of Technology.

JAVA® is a registered trademark of Sun Microsystems, Inc.

JAVASCRIPT® is a registered trademark of Sun Microsystems, Inc., used under license for technology invented and implemented by Netscape.

MarketSet and Enterprise Buyer are jointly owned trademarks of SAP AG and Commerce One.

SAP, SAP Logo, R/2, R/3, mySAP, mySAP.com and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and in several other countries all over the world. All other product and service names mentioned are trademarks of their respective companies.

alert framework and bw - archive...©sap labs llc 2004, 2 agenda sap netweaver alert framework...

Documents