mysap bi and crystal decisions.pdf

7/25/2019 mySAP BI and Crystal Decisions.pdf

1/21

mySAP BI &CrystalDecisions

SAP AG


2/21

SAP AG 2003, mySAP BI and Crystal Decisions

mySAP Business Intelligence


3/21


Business Intelligence Users, Needs and Functions

Customization Data Depth Complexity

Executive /

Management

Strategic

Operational

Analyst/Knowledge

Worker

Tactical

Information Consumer

Query

Design

Portal

Tabular

Reports

Pre-builtReport

Templates

Managed,formatted

Reports

Any Device

Interactive

Content

iViews

Role-based

Targeted

Dashboards

OLAP

Analysis

Data Mining

Ad-hoc

Analysis

Alerting

Geographical

Analysis

Packaged

Applications

Query

Reporting

Analysis Deployment

User Access


4/21 SAP AG 2003, mySAP BI and Crystal Decisions

Formatted Reporting within the Business Explorer

Presentation-quality reporting

with fine-grained formatting

Print optimized reports

Professional Layout

Broad range of pre-defined Crystal

reports within Business Content

SAP BW and non-SAP BW data in

a single report

View and modify Crystal Reports in web

environment (Web Browser or Portal)

Presentation-quality reporting

with fine-grained formatting

Print optimized reports

Professional Layout

Broad range of pre-defined Crystal

reports within Business Content

SAP BW and non-SAP BW data in

a single report

View and modify Crystal Reports in web

environment (Web Browser or Portal)

Query, Reporting and AnalysisQuery, Reporting and Analysis

Formatted ReportingFormatted Reporting

Web Application DesignWeb Application Design

Mobile IntelligenceMobile Intelligence

Portal Integration & CollaborationPortal Integration & Collaboration

Business Explorer

Formatted Reporting

A I t t d C t f SAP BW B i



An Integrated Component of SAP BW BusinessExplorer

By combining the formatted reporting

capabilities of Crystal with the reporting,analysis and information delivery in the

Business Explorer BI Suite, SAP offers the most

complete reporting solution available in the

marketplace today with support for all

reporting requirements across any array of data

sources



Where can Crystal add Value?

Typically, organizations will leverage the Crystal Decisions

option when their end-users have a need for:

Use of standard business document templates (e.g., legal, financial)

Presentation-quality reports with fine-grained formatting (e.g., downto the pixel level)

Optimized printing for web-based reports

Leveraging existing Crystal expertise and reports

Integration of non-BW data directly into your SAP BW reports



Solution Offering: OEM

OEM Agreement

Crystal Enterprise SAP Edition

NEW: Up to ten reports can be

choosen from the pool of pre-defined Crystal Reports delivered with SAP

BW Business Content. These reports can be modified as well via theCrystal Reports Designer

created by the customer using the Crystal Reports Designer

Deployment of reports via Web Browser / Enterprise Portal to be

viewed from any SAP user

Access to SAP BW data

NT only (Crystal Enterprise server components)

Limited to one CPU

Available at no extra cost


8/21



Technology Integration Points

Seamless integration into the SAP user interface enables

the launch of Crystal Reports directly from SAP BW

Support of SAP authentification (single sign on) and

security

based on SAP BW roles Access to BEx queries and theability to combine SAP BW data

and non-SAP BW data in one report

Multi-language support

Easy management of reports in the SAP BW repository

Comprehensive predefined report templates

Integration into the Enterprise Portal based on iViews

provide a secure, personalized view of business content


10/21


How Crystal Reports integrates into SAP BW

SAP BUSINESS INFORMATIONWAREHOUSE

BI SUITE

BUSINESS EXPLORER (BEx)

BI PLATFORM & DATA WAREHOUSE

BEx QUERY DESIGNERBEx QUERY DESIGNER

OLAP PROCESSOROLAP PROCESSOR

SAP Enterprise Portal/

Web Browser

SAP Enterprise Portal/

Web Browser

PublishingPublishing

Data InterfaceData Interface

CRYSTAL

REPORTS

CRYSTAL

REPORTS

Crystal EnterpriseCrystal Enterprise


11/21


How Can I Design a Report?

CrystalConne

ctor

1. Start CrystalReports Designer

2. Choose BW

query and get meta

data information

3. Design and

preview the report

PublishingInterface

6. View report from

any Web Browser or

the SAP Enterprise

Portal

BI

4. Save report inBW repository

Data Interface

5. Publish report to

Crystal Enterprise

Design View

Client viewing

Server


12/21


The Integrated Architecture

Design View

Server

Client

CrystalConne

ctor

BI

Crystal ConnectorDesign new reports

Open / Save reports

Change reports

Upload reports to BW

Th I t t d A hit t


13/21



CrystalConnector

PublishingInterface

BI

Design View

Client

Server

Publishing InterfacePublishing reports to CE

Translate into languages

Synchronize roles and users

Th I t t d A hit t


14/21



CrystalConnector

PublishingInterface

BI

Design View

Client

Server

Data InterfaceGet meta data information

Read data from BW queries

Data Interface

Th I t t d A hit t


15/21



CrystalConnector

PublishingInterface

BI

Data Interface

Web Browser /

Enterprise Portal

(SSO)

Design View

Client Viewing

Server

C t t V l H R R ti


16/21


Content Value: Human Resources Reporting

Feature overview

access of master data,

appraisals and

qualifications, header / detail sections

special fields

form based

logo

Master data

Master data 2

qualifications

appraisals

Content Value: Project Status Reporting


17/21


Content Value: Project-Status Reporting

Feature overview

access four data

sources

various layout formats embedded charts

date / page number

(1)

(2) (3)

(4)

Content Value: Legal Reporting


18/21


Content Value: Legal Reporting

Feature overview

legal form based

page totals

report totals grouped column

headers

vertical text barcode

embedded logos

Multi line headings

different data sources

in one line

Content Value: Cost Management Reporting


19/21


Content Value: Cost Management Reporting

Feature overview

use of bitmaps

form based layout

multiple formatted fonts flexible layout of report

header

multiple data sources different structured

subreports

hyperlinks on report

(1)

(2)


21/21


Copyright 2003 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.

mysap bi and crystal decisions.pdf

Documents