0301 achieve real-time financial and operational reporting with sap crystal reports 2011 and sap erp

8/9/2019 0301 Achieve Real-Time Financial and Operational Reporting With SAP Crystal Reports 2011 and SAP ERP

1/47

Achieves Real-Time Reports withrysta eports

Rich Heilman Tammy Powlas


2/47

[ Learning Points

Learn how to use SAP Crystal Reports 2011 to develop andmaintain financial and o erational re orts with ro er desi n

and integration of SAP ERP and SAP Crystal Reports 2011 Learn about SAP Crystal Reports 2011 data connectivity

op ons w roug use cases

Review proof of concept for SAP Crystal Reports 2011 mobileBI

Learn how to embed SAP Crystal Reports 2011 inside yourSAP ERP ALV Reports (embedded analytics)

Real Experience. Real Advantage. 2


3/47

[ Agenda

Using Crystal Reports 2011 against an SAP ERP system

Learning about Crystal Reports 2011 authorization concepton SAP ERP

Reviewing mobile BI with Crystal Reports 2011 proof of

concept

Wrap-up



4/47

[ SAP Crystal Reports in SAP BusinessObjects BI 4.0

Source: SAP

Real Experience. Real Advantage.

4

.


5/47

[ SAP Crystal Reports 2011 and SAP ERP Background

Use SAP ERP as a data source for Crystal Reports 2011 (BI4.0 *

Create management and financial reports and distributethem in various ways in real time

Crystal Reports 2011 is an incremental upgrade from SAPCrystal Reports 2008

-

Ability to save .XLSX format

Recommended for SAP ERP Reporting over SAP Crystal Reports

or nterprise New start page


5*BI 4.0 Feature Pack 3 can connect Crystal for Enterprise to ERP


6/47

[ SAP Crystal Reports 2011: New Start-Up Page

Free e-Learnin


6sap.com/learnbi


7/47

[ Data Connectivity: SAP Crystal Reports 2011 and SAP

Software Required

Cr stal Re orts 2011 client side

SAP BusinessObjects Enterprise 3.1 or BI Platform 4.0 SAP Integration Kit (XI 3.1 only)

SAP ERP Available Data Sources

SAP queries

ABAP functions

Tables and cluster (Open SQL)


7Source: SAP


8/47


9/47

[ SAP Crystal Reports Data Connectivity for SAP

ODBC toHANA

Source: SAP


9


10/47

[ Agenda




concept

Wrap-up



11/47

[ Use Cases

A use case captures the contract between stakeholders of as stem about its behavior under various s stem conditions

The primary actor initiates an interaction with the system toaccomplish some goal

Consumer

Business Analyst

Ad Hoc Analysis

Report Developer


11


12/47

[ Report Developer

Actor: Report Developer

report any data regardless of where creating managementreports, financial statements and distributing them in variousways

Successful criteria: Create Crystal Reports

ABAP Function Modules created

Designs Crystal Reports

Installs the Crystal Reports Viewer Makes reports available through Crystal Reports Viewer or PDF


12


13/47

[ Crystal Reports Viewer www.sap.com/solutions/sap-crystal-solutions/query-reporting-

analysis/sapcrystalviewer/techdetails/index.epx

. .


13


14/47

[ Demo Developer : Create report against ERP table


14


15/47

[ Demo Developer : Create report using ABAP


15


16/47

[ Business Analyst Use Case Actor: Business Analyst

Description: Design Crystal Reports against InfoSets or SAP

Successful criteria: Create Crystal Reports against InfoSets orSAP queries


16


17/47

[ Demo Business Analyst Create Report from InfoSet


17


18/47

[ Demo Business Analyst Create Report from SAP


18


19/47

[ Consumer Use Case (Business User)

Actor: Consumer

Successful criteria: Consume pre-defined Crystal Reports viaCrystal Reports Viewer

View Crystal Reports using the Crystal Reports Viewer

View PDFs of Crystal Reports


19


20/47

[ Demo Consumer


20


21/47

[ Agenda




concept

Wrap-up



22/47

[ Authorizations InfoSet Only Access


22


23/47

[ Report Developer FULL Access

ALL Tables!

Access above includes Open SQL Driver, InfoSets, SAP Query


23


24/47

[ Authorization Concept

Because we use both Human Capital Management and SAPPa roll, we did not want all re ort develo ers to have access

to report off of all tables Some options:

Security Definition Editor

Allow report development only by InfoSet, not all tables

Develo views of master data name and ersonnel numbervendor number and name


24


25/47

[ Other Options Security Definition Editor Transaction

/CRYSTAL/RLS allows you

level security using theOpen SQL Driver

By default, this is open toall


25


26/47

[ Data Connectivity: InfoSets

Prerequisites

Re ort Desi ner must be assi ned as a user in the

SAP Query user group (SQ03) If not, you receive these error messages:


26


27/47

[ SAP ERP InfoSet Access: Why SQ03 Is So Important

If the Report Designer is

not assigned to the user

group, the designer will not


27


28/47

[ Agenda




concept

Wrap-up



29/47

[ Steps for a Proof-of-Concept Mobile Crystal Reporting

rea e n eman ccoun

p oa rysta eport toOnDemand

Download SAP BusinessObjectsExplorer to mobile device

View Report on mobile device


29


30/47

[ Step 1: Create BI OnDemand Account

Create an account, or use your SAP StreamWork account

. .


30


31/47

[ Step 2: Upload Crystal Reports 2011 to BI OnDemand


31


32/47

[ Step 3: Download SAP BusinessObjects Explorer to iPador iPhone

http://itunes.apple.com/us/app/sap-businessobjects-ex lorer/id422267790?mt=8


32


33/47

[ Demonstration Loading Crystal Report to BI On


33


34/47

[ Benefits

Reports available at your fingertips

No Crystal Reports 2011 installation needed on the iPad

No training required; easy to use

Initial feedback was positive


34


35/47


36/47

[ Overview of Embedded Crystal Reports

Required frontend component, SAP Note 1353044

ALV content is exported in XML format which the CrystalReports Viewer is designed to consume.

No Crystal Reports server or other infrastructure, Designer is

required if you need to create custom templates

.

Must be activated in the IMG(Transaction SPRO)

SAP NetWeaver -> A lication Server > SAP List Viewer ALV

Separate activation for SAP GUI and Web Dynpro ABAP


36


37/47

[ Crystal Reports Viewer for Business Suite Applications

Crystal Reports Viewer for SAP Business Suite Applications download it from service.sa .com/notes, SAP Note 1353044

,Applications Different than the other Crystal Viewer

Required frontend component which needs to be installed on


client/desktop machine

37


38/47

[ Embedded Crystal Reports Configuration

ALV Crystal Reports in-place is activated in IMG

-ALV reports


38

[


39/47

[ Embedded Crystal Reports Output

Report is rendered via Crystal Reports Viewer in-place


39

[


40/47

[ Benefits of Embedded Crystal Reports

Automatically generate a Crystal Report based on the contentof an existin SAP ERP re ort

Associate a specifically designed Crystal Report with an SAPList Viewer report

Import templates for a corporate identity

Crystal Reports becomes part of the ALV software logistics

You can import and export a Crystal Report


40

[


41/47

[ Benefits of Embedded Crystal Reports

Simplification of navigation, especially in summarized financialre orts

Response from users has been positive Uses best-of-breed reporting

Standardize on one reporting front-end: BI


41

[


42/47

[ Key Learnings

Use SAP Crystal Reports 2011 for SAP ERP reporting

(sap.com/learnbi) Consider trying BI OnDemand for Crystal Reports mobile

reporting on the iPad A free application

Consider authorization concepts; do you have protected

Use SAP Crystal Reports 2011 for financial and managementoperational real-time reporting

No modeling is needed; data is available in your SAP ERPsystem


m e ng rys a epor s ns e your

reports gives report consumers a new view on their reports

[


43/47

[ Related Sessions

What's New for SAP Crystal Reports in SAP BusinessObjects4.0 Feature Pack 3, Tuesda , Ma 15th, 11:00 am

Crystal Reports Influence Council, Tuesday, May 15th

, 12:30 SAP Integration Influence Council, Wednesday, May 16th, 1:45

pm


[


44/47

[ Check it out!

Join the ASUG BI Community

htt ://tin url.com/2df4mr5

Follow us on Twitter: http://twitter.com/asug_bi

http://twitter.com/@asug_bi


[


45/47

[ Share Your Experience at SAP TechEd 2012Covering the following tracks:

Technology Overview and Infrastructure

A lication Lifec cle Mana ement

Business Intelligence and Performance Management

Enterprise Information Management

, ,

Custom Development

Security, Compliance, Identity and Access Management Mobile


[


46/47

[

Questions

Rich.Heilman sa .com richheilman

[email protected] @tpowlas


[


47/47

[

.Please remember to complete and return yourevaluation form following this session.

For ongoing education on this area of focus, visit the

Year-Round Community page at www.asug.com/yrc

[ SESSION CODE:0301


0301 achieve real-time financial and operational reporting with sap crystal reports 2011 and sap erp

Documents