• No results found

Implement SAP BW Faster With SAP Best Practices for Business Intelligence

N/A
N/A
Protected

Academic year: 2021

Share "Implement SAP BW Faster With SAP Best Practices for Business Intelligence"

Copied!
39
0
0

Loading.... (view fulltext now)

Full text

(1)

Marian Maravilla, SAP AG

Geoff Vines, Integrity Media

Steve Woyicki, IDS Scheer

Implement SAP BW

Faster with SAP Best

Practices

(2)

© SAP Labs / SAP Theater Session 9199, ASUG 2004 / Marian Maravilla / 2

Introductions

Marian Maravilla,

„

Business Unit for Small and Midsize Business – SAP Labs

Geoff Vines

„

Information Technology – Integrity Media

Steve Woyicki

(3)

SAP’s Small & Midsize Business Team – Who are we?

SAP’s Global Team for Small & Midsize Business (SMB)

„

Development team formed in Jan 2002 to address small and midsize

business needs

„

Work with regional SAP subsidiaries and SAP’s SMB Reseller

Partners, to meet the needs of our Small & Midsize customers

„

Product suite includes:

‹

SAP Best Practices - Industry, Horizontal (mySAP CRM, SCM & SAP

NetWeaver based)

‹

Preconfigured solutions/templates or guides for SAP products to reduce

cost of implementation or development

(4)

What is Business Intelligence and what is BI’s

relevance to companies of all sizes?

mySAP Business Intelligence Solution Overview

SAP Best Practice for Business Intelligence

Where to learn more about SAP Best Practices

Customer experience with Integrity Media

(5)

What is Business Intelligence?

Business intelligence (BI) is a broad category of applications and

technologies for gathering, storing, analyzing, and providing access to

data to help enterprise users make better business decisions.

BI applications include the activities of:

„

Decision support systems

„

Query and reporting

„

Online analytical processing (

OLAP

)

„

Statistical analysis

„

Forecasting

„

Data mining

Business intelligence applications can be:

„

Mission-critical and integral to an enterprise's operations or occasional to

meet a special requirement

„

Enterprise-wide or local to one division, department, or project

(6)

© SAP Labs / SAP Theater Session 9199, ASUG 2004 / Marian Maravilla / 6

Companies of all sizes are adopting BI:

„

“..a critical finding is the emergence of BI, analytics and, among upper midmarkets,

CPM as the feature/function registering highest interest during the next two years.

This underscores the fact that (small & midsize companies) SMBs want more than a

unified transactional system to manage their operations; they also want ERP to be

intelligent enough to alert them to what they need to know to run their business

better.”*

Even small & midsize companies need to implement Integrated Analytics solutions

„

“SMBs are seeking stronger enterprise performance information and business analytics

that are tightly integrated with their ERP systems. BI and analytical software

particularly appeals to strapped SMBs operating under greater than usual cost

constraints and tighter planning needs.”

*

„

“SMB CIOs should expect significant pressure to do so from their CFOs and auditors to

shore up weak reporting systems, and poor application integration. Along these lines,

it would behoove SMBs to begin to consider stepping up investment in business

intelligence applications and supporting back-end infrastructure to meet the new

demands of the auditors and regulators.”**

BI is relevant to companies of all sizes

*Source: Robert Anderson, Gartner Group“North American SMBs Identify Enterprise Resource Planning Preferences” October 2002 **Source: M. Yamamoto Krammer, Gartner Group“SMB Technology Spending to be Lethargic in 2003”, August 2002

(7)

What is Business Intelligence and what is BI’s

relevance to companies of all sizes?

mySAP Business Intelligence Solution Overview

SAP Best Practice for Business Intelligence

Where to learn more about SAP Best Practices

Customer experience with Integrity Media

(8)

© SAP Labs / SAP Theater Session 9199, ASUG 2004 / Marian Maravilla / 8

mySAP BI – Where does it fit?

mySAP SCM

mySAP PLM

mySAP

SRM

mySAP

CRM

mySAP ERP

Financials Human Resources Corporate Services Operations

Maintenance & Quality

Inventory & Production

Sa les O rder & Di stribution Man a g e m e nt Pu rc hase Ord e r M a na ge ment

SAP NetWeaver

(9)

SAP Mobile Infrastructure

„

Tight coupling and alignment

with SAP business solutions

SAP Enterprise Portal

„

Business packages

„

Collaboration

SAP Business Information Warehouse

„

Business content

„

Tight integration to SAP

„

Open architecture (Crystal,Ascential)

Master Data Management

„

Coming in 2003

SAP Exchange Infrastructure

„

Proxy generation and mapping tools

„

Integration directory

„

SAP’s ability to execute

SAP Web Application Server

„

Proven, scalable, comprehensive toolsets

„

Leverage existing infrastructure/skillets

DB and OS Abstraction

People Integration

Com posite Ap plic ation Fram ew ork

Process Integration

Integration Broker Business Process Management

Information Integration

Business Intelligence Knowledge Management Lif e C yc le Ma nagem en t Portal Collaboration J2EE ABAP

Application Platform

Multi-Channel Access

SAP NetWeaver

SAP NetWeaver

DB and OS Abstraction Master Data Management

SAP NetWeaver in Detail (SAP Internal View)

Integration Broker Business Process Management Business Intelligence Knowledge Management Portal Collaboration J2EE ABAP Multi-Channel Access DB and OS Abstraction Master Data Management

(10)

© SAP Labs / SAP Theater Session 9199, ASUG 2004 / Marian Maravilla / 10

mySAP Business

Intelligence

is an enterprise-class,

complete,

open and integrated

solution that

delivers

actionable

insights.

mySAP BI – The Solution at a Glance

Data acquisition, data warehousing, OLAP,

planning framework, BI tools, dashboards and

analytical applications; with pre-configured

content using best-practice models.

Open, well documented

APIs and interfaces along

with full functionality to

integrate structured and

unstructured,

heterogeneous data

Scalable and reliable BI

solution that is tightly

integrated with SAP

NetWeaver, source

transactional systems and

partner’s complementary tools

Support decision-making requirements

of the entire enterprise regardless of

data sources of access methods

Convert data into information, and

ensure information is delivered at

the right time to the right person in

the right format to support

business decision making.

(11)

mySAP Business Intelligence Solution: Goals

Integrate and merge all transactional data

Make information actionable

Empower better, faster decisions

Complete Insight

Convert data into information

Delight and retain customers

Empower employees, suppliers and partners

Collaborate using consistent information

Right information, at the right time, to the right person to make the

right decision in the right amount of time

(12)

What is Business Intelligence and what is BI’s

relevance to companies of all sizes?

mySAP Business Intelligence Solution Overview

SAP Best Practice for Business Intelligence

Where to learn more about SAP Best Practices

Customer experience with Integrity Media

(13)

SAP Best Practices for BI: Value Proposition

„

Provides

step-by-step instructions on connecting and

activating popular reporting scenarios through standard

SAP Business Content

„

Supports

activation at the scenario level; activate only

the reporting/analytic content that is needed

„

Allows

faster implementation timeline

„

Reduces

implementation risk

„

Enables

the expansion of analytics capability as the

business grows

SAP Best Practices for BI allows SMB

customers to quickly implement reporting

and analytics capability to support them in

the operation and management of their

businesses.

We deliver SAP Best Practices as a

documentation CD, or as a downloadable file

– at no additional cost

(14)

© SAP Labs / SAP Theater Session 9199, ASUG 2004 / Marian Maravilla / 14

SAP Best Practices for BI:

Configure your SAP BW content by scenario

Enterprise Resource Planning:

SAP R/3-based scenarios

„ Accounts Receivable Analysis

„ Accounts Payable Analysis

„ General Ledger Analysis

„ Asset Accounting Analysis

„ Cost Center Accounting Analysis

„ Product Cost Controlling Analysis

„ Profit Center Analysis

„ CO-PA Analysis

„ Sales Analysis

„ Cross-Functional Analysis: Financial and Sales Data

„ Purchasing Analysis

„ Manufacturing Analysis

„ Inventory Analysis

„ Billing Booking Backlog Analysis

mySAP HCM analytics

„ Cross-Application Time Sheet

„ Time Management - Time and Labor

„ Personnel Development -Qualifications

„ Travel Management - Travel Expenses

Supply Chain Management

„ Demand Planning Analysis

„ APO Resource and Operation Data Analysis

Customer Relationship Management

„ CRM Lead Analysis

„ CRM Activities Analysis

„ CRM Customer Interaction Center (CIC) Analysis

Supplier Relationship Management

„ SRM Analysis

Product Lifecycle Management

(15)
(16)

© SAP Labs / SAP Theater Session 9199, ASUG 2004 / Marian Maravilla / 16

(17)

How can you improve ROI on BI projects?

With SAP Best Practices for BI, you can…

„

Decrease cost of implementation

„

Speed up implementation go-live for quicker time to benefit

„

Take advantage of additional functionality

No trial runs

start straight off with a fully documented, convincing kernel that

works and is reusable

(18)

What is Business Intelligence and what is BI’s

relevance to companies of all sizes?

mySAP Business Intelligence Solution Overview

SAP Best Practice for Business Intelligence

Where to learn more about SAP Best Practices

(19)

Overview of Integrity Media

Key business drivers

SAP solution implemented

Key benefits and lessons learned

Moving forward – Next steps

(20)

© SAP Labs / SAP Theater Session 9199, ASUG 2004 / Marian Maravilla / 20

Overview of Company

„

Established in 1987

„

Integrity Media, Inc. is a media/communications company that produces,

publishes and distributes Christian music, books and related products.

„

Integrity’s products are sold primarily through retail stores and direct to

consumers throughout the United States and in 167 other countries.

„

The Company is headquartered in Mobile, Alabama, and its common stock is

listed on The Nasdaq National Market under the symbol “ITGR.”

„

Founded primarily as a direct-to-consumer music club in 1987, the company,

then known as Integrity Music, grew into one of Christian music’s biggest

success stories.

„

By 1995, the company had become Integrity Incorporated and had established

itself as a leading producer of praise and worship music with life-to-date sales

of over 80 million units of its CDs, cassettes, songbooks, tracks, etc.

„

Today, in addition to the Integrity Publishers and INO offices in Tennessee,

Integrity Media includes subsidiary offices in the United Kingdom, Australia,

Singapore and South Africa along with a Latin American sales division located

at its headquarters in Mobile, Alabama

(21)

Key Business Drivers

„

Integrity Media intends to be able to provide better customer service

‹

By combining SD and FI/AR transactions on a single report showing

customer's balances and payment histories.

„

Integrity Media intends to utilize BI to analyze accounting information

based on criteria that is not easily available in R/3.

‹

For example: P&L information by multiple material attributes.

„

Large volume of historic data from legacy systems

Why did Integrity need a BI solution?

„

Integration with R/3

„

Already owned as part of the SAP Business Suite

„

Availability of Best Practices for Business Warehouse

(22)

© SAP Labs / SAP Theater Session 9199, ASUG 2004 / Marian Maravilla / 22

SAP Solution Implemented

„

Using scenarios from SAP Best Practices for BI.

„

Integrity Media is currently implementing the following scenarios:

‹

A/R – Line Items, Transactions and Payment History

‹

Sales Analysis with historical data

‹

Cross-functional SD/FI

‹

Purchasing (planning stages)

mySAP BI Implemented

„

Current Status:

‹

A/R is active in Production

‹

Business is reviewing the Sales analysis for historical purposes in

Development

‹

Plans are to implement Cross functional SD/FI in the coming weeks

‹

Plans are to implement Purchasing in the coming weeks

(23)

Key Benefits and Lessons Learned

„

Ability to report seamlessly across SAP and Legacy data

„

Integrity Media has a very large customer database

Æ easier to report against

„

Moving sales and accounting analysis to the Business Warehouse server will

improve R/3 system performance.

„

Improved reporting performance vs R/3 and custom tools

„

Can load data from SAP, Flat Files and 3

rd

party interfaces (to non-SAP

systems)

Benefits

„

The technical landscape can be the biggest challenge.

„

Having a Basis person who is familiar with the issues that

may arise is crucial to maintaining a project schedule.

(24)

© SAP Labs / SAP Theater Session 9199, ASUG 2004 / Marian Maravilla / 24

Moving Forward

Next Steps

„

Currently working on implementing additional SAP Best Practices

for Business Intelligence scenarios

(25)

IDS Scheer Portfolio

Formerly Plaut Consulting, Plaut Sigma, Plaut Optimum Canada

International Consulting & Software

Market Leader in Business Process Solutions

„ ARIS® Collaborative Suite

„ NEWARIS for SAP NetWeaver (Business Process Mgmt)

SAP Solutions

„ Full cycle R/3 Implementations

„ SAP NetWeaver, including Business Intelligence (BI)

„ Supply Chain Management (SCM)

„ Customer Relationship Management (CRM) „ Human Capital Management (HCM)

„ Advanced Planner and Optimizer (APO)

„ Application Support Center (ASC – Help Desk) „ Upgrades

„ Market Leader in Business Process Solutions

Exclusive SAP Reseller in Southeast US (GA, FL, AL, MS, TN, AK, LA) and Eastern

Canada & Northeast US (New England, upstate NY)

Vertical Solution Provider for:

„ Consumer Products – Food „ Consumer Products – Cosmetics „ Mgmt Consulting

Winner of SAP Customer Satisfaction Award 2001, 2002, 2003, 2004

„ Computer Reseller „ ASP/ISP

(26)

© SAP Labs / SAP Theater Session 9199, ASUG 2004 / Marian Maravilla / 26

What IDS Scheer customers are saying about BW. . .

„

“Very easy to use.”

„

Having immediate access to data to allow for analysis like this is the

data warehouse’s main objective. THIS EMPOWERMENT IS AWESOME!”

„

This enables us to get the information we want from SAP when we want

it and to the level of detail we need.”

(27)

BW Best Practices (1)

Project Preparation

„

Clearly define scope, focus on Reporting “Pains”

„

Realistic understanding of project conflicts (i.e. parallel implementations)

„

Identify Team Roles

„

Data Extraction

„

Front End

„

Data Architect

„

Application Specialist

„

Basis/Security

„

Heavily engage user community early!

„

Work as part of the project team during implementation

„

Augment project team

(28)

© SAP Labs / SAP Theater Session 9199, ASUG 2004 / Marian Maravilla / 28

BW Best Practices (2)

Blueprint

„

Define Approach – Top Down or Bottom Up

„

Define Reporting Requirements – Strategic, Tactical, Operational

‹

Set Expectations about what type of information BW will and will not

deliver!!!

„

Leverage Business Content

„

Joint Application Development Sessions with Key Users to

develop/sign off on Data Models

„

Establish Naming Conventions

(29)

BW Best Practices (3)

Realization

„

Maintain Data Models with a 3

rd

party tool (ARIS, ERwin, Visio)

„

Keep user community informed, especially key users

‹

Set user expectations – Power Users vs End Users

„

Consider BEx Analyzer (Excel) or Web for initial deployment

(30)

© SAP Labs / SAP Theater Session 9199, ASUG 2004 / Marian Maravilla / 30

BW Best Practices (4)

Final Prep

„

Define Support Infrastructure

„

Tier 1 – IT Support (Software, Accounts, Passwords)

„

Tier 2 – Power Users/Analysts

‹

Early Adopters, Slice and Dice

‹

5-20% of User Base

‹

Shield Development Team from Support/Maintenance of End Users

‹

Meet periodically with the Development Team

„

Tier 3 – Development Team

‹

New Development

‹

Error resolution

(31)

BW Best Practices (5)

Go Live and Support

„

Careful with New Patches

„

Monitor Statistics Cubes

„

Continue to educate Power Users / communicate with End Users

„

Governance Process for Change Requests

(32)

What is Business Intelligence and what is BI’s

relevance to companies of all sizes?

mySAP Business Intelligence Solution Overview

SAP Best Practice for Business Intelligence

Where to learn more about SAP Best Practices

(33)

Questions?

To order CD’s:

BP for BI Material Number:

50066055

„ Customers - SAP Best Practices for BI: CD’s available for

order in SAP Shop

„ Employees - Your country’s EBP system

Downloads available at:

http://service.sap.com/installations

Navigate to

Æ Best Practices

Other useful websites:

http://service.sap.com/BI

http://www.sap.com/bestpractices

http://www.sap.com/smb

(34)

© SAP Labs / SAP Theater Session 9199, ASUG 2004 / Marian Maravilla / 34

SAP Developer Network – sdn.sap.com

The central hub for the SAP technology

community

„

Everyone can connect, contribute and

collaborate- consultants, administrators and

developers

„

Focus around SAP NetWeaver and SAP xApps

High quality of technical resources

„

Articles, how-to guides, weblogs,

collaborative areas, discussion forums and

downloads, toolkits and code-samples

A collaboration platform, not a one-way street

„

SAP experts from customers, partners and

SAP

SDN is powered by SAP NetWeaver™

„

Built on the SAP Enterprise Portal

„

Featuring collaboration capabilities of SAP

Knowledge Management

(35)
(36)

Slide 35

(37)

SAP Developer Network – sdn.sap.com

The central hub for the SAP technology

community

„

Everyone can connect, contribute and

collaborate- consultants, administrators and

developers

„

Focus around SAP NetWeaver and SAP xApps

High quality of technical resources

„

Articles, how-to guides, weblogs,

collaborative areas, discussion forums and

downloads, toolkits and code-samples

A collaboration platform, not a one-way street

„

SAP experts from customers, partners and

SAP

SDN is powered by SAP NetWeaver™

„

Built on the SAP Enterprise Portal

„

Featuring collaboration capabilities of SAP

Knowledge Management

(38)

© SAP Labs / SAP Theater Session 9199, ASUG 2004 / Marian Maravilla / 37

„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, R/3, mySAP, mySAP.com, xApps, xApp, SAP NetWeaver 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 the trademarks of their respective

companies. Data contained in this document serves information purposes only. National product specifications may vary.

(39)

„Weitergabe und Vervielfältigung dieser Publikation oder von Teilen daraus sind, zu welchem Zweck und in welcher Form auch immer, ohne die aus-drückliche schriftliche Genehmigung durch SAP AG nicht gestattet. In dieser Publikation enthaltene Informationen können ohne vorherige Ankün-digung geändert werden.

„Die von SAP AG oder deren Vertriebsfirmen angebotenen Softwareprodukte können Softwarekomponenten auch anderer Softwarehersteller enthalten.

„Microsoft®, WINDOWS®, NT®, EXCEL®, Word®, PowerPoint® und SQL Server® sind eingetragene Marken der 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 und Informix® Dynamic ServerTM sind Marken der IBM Corporation in den USA und/oder anderen Ländern.

„ORACLE® ist eine eingetragene Marke der ORACLE Corporation.

„UNIX®, X/Open®, OSF/1® und Motif® sind eingetragene Marken der Open Group.

„Citrix®, das Citrix-Logo, ICA®, Program Neighborhood®, MetaFrame®, WinFrame®, VideoFrame®, MultiWin® und andere hier erwähnte Namen von Citrix-Produkten sind Marken von Citrix Systems, Inc.

„HTML, DHTML, XML, XHTML sind Marken oder eingetragene Marken des W3C®, World Wide Web Consortium, Massachusetts Institute of Technology.

„JAVA® ist eine eingetragene Marke der Sun Microsystems, Inc.

„JAVASCRIPT® ist eine eingetragene Marke der Sun Microsystems, Inc., verwendet unter der Lizenz der von Netscape entwickelten und implementierten Technologie.

„MarketSet und Enterprise Buyer sind gemeinsame Marken von SAP AG und Commerce One.

„SAP, R/3, mySAP, mySAP.com, xApps, xApp, SAP NetWeaver und weitere im Text erwähnte SAP-Produkte und – Dienstleistungen sowie die entsprechenden Logos sind Marken oder eingetragene Marken der SAP AG in Deutschland und anderen Ländern weltweit. Alle anderen Namen von Produkten und Dienstleistungen sind Marken der jeweiligen Firmen. Die Angaben im Text sind unverbindlich und dienen lediglich zu Informationszwecken. Produkte können länderspezifische Unterschiede aufweisen.

References

Related documents

Portal Business Intelligence Integration • Integration Broker • Interactive Services Repository Key Components: PeopleSoft Business Intelligence Siebel SAP Web Services

Although Venice remained at the centre of the music printing and publishing industry throughout the sixteenth and well into the seventeenth century, just as it remained domi- nant

SAP HANA Cloud Integration Real-Time Process Integration Prepackaged Integration flows Community and Marketplace Data Integration SAP On-Premise 3 rd Party On-Premise

 Migrated SAP Process Integration software and the SAP Business Process Management component to SAP Process Orchestration software, reusing existing integration mappings.. 

Four simultaneously treated eyes and 6 sequentially treated eyes were excluded from the analysis of refractive out- come because of intraoperative flap complications that

We studied the expression of different proinflammatory cytokines, chemokines, and their receptors as well as certain adhesion molecules by human dermal endothelial cells

It turns out that in eight of the 10 states, Democrats were in charge of both the governorship and the legislature when the laws were changed to prohibit payday lenders;

California Civil Code § 54.1 also states, in part, that: Individuals with disabilities shall be entitled to full and equal access to accommodations, facilities,