Devising an Enterprise Reporting Strategy with ECC/BW/CRM on SAP HANA and SAP Business Objects Solutions at Love s Travel Stops & Country Stores

Orange County Convention Center Orlando, Florida | June 3-5, 2014

Devising an Enterprise Reporting Strategy with

ECC/BW/CRM on SAP HANA and SAP Business Objects

Solutions at Love’s Travel Stops & Country Stores

Walk-through of a productive enterprise reporting

strategy (ERS) for an integrated SAP HANA™ supported

Business Suite (ECC/CRM/HCM) & BW enterprise

solution.

Practice followed and lessons learned from Enterprise

SAP solution powered by HANA™ implementation and

Learning Points from this session

SAP solution powered by HANA™ implementation and

integration with EPM 10 and BOE 4.2 reporting suite.

New-age productive SAP Customer Business Experience

(CBE) model. A new way of delivering reporting &

analytics solution breaking the boundaries of the OLAP

and OLTP world.

Family owned, $26.09 billion company with 10,000 +

employees. Headquartered in Oklahoma City

Energy, Retail (convenience store), Travel Stop business –

3 companies (Love’s, Musket & Gemini)

Gemini: O&G transportation

Musket: O&G Wholesaler

Loves: Financials and Retail

Who we are: Love’s Travel Stops & Country Stores Inc.

Loves: Financials and Retail

300+ locations in 39 states.

20-25 store opening/year

One-Stop shopping for Travelers

Forbes’13 - # 9 in America's largest private companies

Capgemini: SAP HANA™ Solution Capability & Maturity

Q2’2013 HANA Enterprise Cloud

HANA RDS Q2’2011 Standalone HANA Appliance (1.0) Q4’2011 BW Running on HANA (1.5) Q2/3’2012 HANA Stabilization & Optimization – HA&DR Q4’2012 HANA on Cloud, Open

Development

Q1’2013 Business Suite Running on

HANA (ECC, CRM, SRM..)

Q3’2013 Business Intelligence 4.1 on

HANA, SAP UI5 for HANA

ECC Real-time Replication HANA as an Analytical Data Mart BW & BPC

• Open HANA/ Native HANA Deployment • SAP-agnostic architecture possible • High potential for big Enterprises • New EDW / BI strategy needed • Innovative & Unique Solutions (RDS)

• Real Real-time data acquisition possible • RT-Use case need be derived carefully • Non-SAP sources can feed in real-time

• Social Networks/ Military/ Defense may advantage with real-time intelligence

• Loss/ theft/ fraud prevention in real-time

• New LSA++ (Avoid layers in warehouse) • Transformations in-Memory

• Full Ad-hoc reporting capabilities

A cc e le ra to r D a ta b a se Innovation Stabilization Stability Durability

In-Memory DB Columnar DB Appliance/ Scale Out Real-Time Data Big Data Any Data

Agile BI HANA Cloud

SAP & non-SAP application consolidation Foundation for EDW Transformation Mobile Intelligence

Business Suite Foundation HANA to run applications BW & BPC Powered with HANA

• Full Ad-hoc reporting capabilities • 3x-5x Database Compression • 3-times better data load performance • 200x improved planning applications • Cost-effective solution for big install base

• E.g. COPA Accelerator, Smart-Meters… • Massive Performance improvements

• Replacement of core functionality adds risks to the integration

• High license costs/ specific use case • SAP Certification is must for Apps

• Future of SAP, basis for cloud-based/ hosted offerings & solutions

• SAP redesigning the Business Suite Core for the in-memory data centers

D a ta b a se P la tf o rm Stabilization

Integration & expansion

Optimization & implementation acceleration

CRM-CFC

Loves: SAP Program Overview

GL AR CO AP FA PS CRM-IC HCM BPC BI

ECC 7.0 - FIN ECC 7.0 - CRM ECC 7.0 - CRM SAP Success Factors BW 7.4 sp6 BOE 4.2 BPC 10 NW BODS 4.2 CRM Phase 1 start June’13 CRM Phase 1 Go-Live Nov’13 SAP Financials start July’13 SAP Financials Go-Live June’14 Success Factors/HCM start Dec’13 Success Factors/HCM Go-Live Jan’15 CRM Cloud-for-customers start April’14 CRM Cloud-for-customers Go-live Aug’14

Multiple reporting systems requiring duplicate maintenance. Reporting is done in many disparate systems - creates conflicting reports, requiring

manual reconciliation. Data Quality is a challenge

High degree of data-duplication.

Operationally heavy ‘Month-End’ process related to reporting.

CAPEX forecasting is extremely manual and relies on strong communication between accounting and operations. Multiple systems, aggregation

reporting not possible.

Some mandatory reporting (specifically tax) is not automatically generated

Reporting Challenges

Some mandatory reporting (specifically tax) is not automatically generated out of the current system.

Master Data Maintenance Problem: multiple GL account codes (master

data) created and maintained across the systems

No self service access for a customers; not able to easily access information

about their accounts across business lines. Problems in ‘credit limits’ or ‘quantity received’ view.

Push vs. Pull – Reporting Access v/s Distribution

SAP Business Intelligence – Customer Business Experience

Tools

Crystal Reports 2008/11 Analysis for Office/OLAP Explorer SAP Lumira Enterprise Portal MS Excel Predictive Analysis SAP BO Classical SAP BI ABAP/HTML5 Data Warehouse Business Suite Transactional CBE SAP ECC G/L AR AP PS SAP CRM OM MKT SER SAL SAP Personas

Classical SAP GUI

Netweaver Business Client

H

H

ABAP Application

Development _{ABAP Reporting}

SAP UI5/Fiori SAP IDE UI5 Reporting standard custom standard custom B u si n e ss O b je ct s U n iv e rs e SAP BW BPC for Excel Reporting H HANA Live (HL Browser) Information Design Tool Mobility SAP Enterprise Foundation, Extended edition powered by HANA

SAP BO Reporting Tool Set Framework

Interactive Experience

BEx Analyzer/WAD are SAP BW

application centric, rest of the options are predominantly Source agnostic

Intelligence Intelligence BEx BEx Analyzer Analyzer/ Design Studio

BO Analysis (OLAP & MS BO Analysis (OLAP & MS

Office Edition) Office Edition) Technically Capable Dynamic & Free Interactive & Guided Lumira Thank God – Excel!!

SAP BO Reporting Tool Set - Usability Matrix

Formatted/Static/

Enterprise Publish Ad-hoc

KPI/ High Level

Visualization Slice & Dice/ Trends

OnDemand Answers/ Data Exploration Visualization Web Look & Feel

• Crystal Reports Enterprise • Crystal Reports 2011 •Web Intelligence

•Web Intelligence •Analysis for OLAP

• Dashboard • Design Studio

• Web Intelligence • Analysis for OLAP

• Explorer

• Lumira

Excel Look

& Feel • Analysis for Office • Analysis for Office •Analysis for Office

Data Source

• SAP BW BEx Query • SAP BW Info cube • SAP BO Universe

• SAP HANA Live (ECC & CRM)

• SAP BW BEx Query • SAP BW Info cube • SAP BO Universe

• SAP HANA Live (ECC & CRM)

• SAP BW BEx Query • SAP BW Info cube • SAP BO Universe

• SAP HANA Live (ECC & CRM)

• SAP BW BEx Query • SAP BW Info cube • SAP BO Universe • SAP HANA Live (ECC &

CRM)

• SAP BO Universe • Local user files

High-End Comparison Chart of Business Objects BI 4.2 Tools

Crystal Reports Web Intelligence Dashboards Explorer Analysis Design Studio

Highly formatted layout (print

focused) 4444 2222 1111 1111 2222 3333

Parameterized

/dynamic layout 4444 3333 3333 2222 2222 2222

Self Service/ Free

form layout 2222 4444 0000 3333 3333 3333

Hierarchical

Awareness 2222 3333 2222 1111 4444 4444

Dash boarding &

Visualizations 2222 2222 4444 3333 3333 3333

Interoperability 2222 3333 3333 1111 3333 2222

Interoperability 2222 3333 3333 1111 3333 2222

Guided Navigation 2222 2222 3333 2222 4444 2222

Excel Look and Feel 1111 1111 0000 0000 4444 1111

Mobile Device

Support 3333 4444 4444 4444 0000 4444

Broadcasting 4444 4444 1111 1111 1111 3333

Offline Viewing 4444 4444 4444 0000 2222 0000

Combine several sources into single

report 4444 4444 2222 2222 3333 2222

Existing custom data warehouse solution on SQL database. It has fairly broad usage and follows a Layered Scalable Architecture principle.

New SAP Applications roll out at Love’s – SAP ECC (Finance) and CRM both running on SAP HANA™ database. To leverage HANA Live component for

operational reporting & analytics.

% of total active business data in SAP ECC/CRM is has been determined to quantify SAP BW-EDW proposal factor. SAP BPC NW version is in scope for

enterprise application footprint to conduct financial consolidation and possibly planning/budgeting in future. BPC NW demands all relevant data set to be

Enterprise Data Warehouse - Background

planning/budgeting in future. BPC NW demands all relevant data set to be available in SAP BW.

To feed SAP data back to existing custom data warehouse so the legacy reporting works out-of-the box. Enterprise need to feed non-SAP data in SAP solutions, preferably leveraging standard ETL framework.

No BW-near line storage solution leveraging Sybase IQ to support true EDW

framework now. Will consider the solution in future. Archiving is a big a factor for deciding EDW solution.

SAP’s open EIM tool – Business Objects Data Services is present in current enterprise architecture.

Do you need BW?

Understanding Data Temperature and near-line data storage

Hot Data Data is read and/or written frequently. Always inMemory. All features

enabled < 1 year

Warm Data Infrequent access, on disk no need to keep inMemory all the time. All

features enabled

Depends on applications, generally between 1-3 years but application dependent

Cold Data Sporadic access, not stored in HANA DB but in NLS. Restricted to NLS

capabilities > 3 years of data

BW Near line Adapter

(ABAP based)

DBSL for Sybase ASE (/w IQ ext)

BW Porting

General Porting

SAP HANA predominantly holds its data in its volatile memory space. There is a certified high availability and disaster recovery

solution in place, but still rebuilding TB scale data after system restart will take time. SAP HANA is comparatively 60% more expensive than a comparable RDBMS solution but can hold somewhere between 500-1000% more data. Also the memory cost is going down at a rate of >20%. A standard IT warehouse extends at a rate of 20% year over year.

HANA DB

(/w IQ ext)

ODBC Driver from IQ DB Client

NLS Interface

Current Data Historical Data

Loves: SAP BW Roadmap

Immediate Mid-Term Long-Term

Reporting source of truth for Finance G/L SAP FI-G/L Data warehouse (pre and post consolidation) – minimum 2 years of data

SAP FI A/R, A/P, AA & CO-PS data warehouse – minimum 2 years of data

Feed other data warehouse/data mart - FI G/L

Rollout BW Workspace to support self service ad-hoc analysis framework

Load SAP-CRM data in BW for interim data warehouse and reporting support

Load SAP-Phase 2 (selective or all) data in BW for interim data warehouse and additional reporting support

Implement, SAP BW on HANA™ - NLS and Archival design

Move other DW data (Global?) to SAP BW and start IT-DW

consolidation

Point all strategic and tactical reporting solution to SAP BW

Feed other data warehouse/data mart - FI G/L (pre and post consolidated data) for existing legacy report support

Design LSA++ Structure

Design LSA Structure to support EDW – FI G/L, AP, AR, AA and CO-PS ??

SAP BW will be the EDW for Love’s ?

Design LSA Structure to support SAP-CRM, SAP Phase 2 Feed other data warehouse/data mart with SAP FI

(other than G/L) & CO-PS ?? Feed other data warehouse/data mart with CRM & SAP Phase 2?

Yes

No

Expand Data Footprint for the strategic BW-EDW

Standardize feed to Love’s EDW Strategy for Data/Volume management

Expand SAP BW foot-print for relevant dataset only, governed by EIM strategy

SAP BI Reporting Tools – Connection Matrix

SAP BW

Query (BICS) SAP BW Cube

SAP BW – HANA DB SAP ECC – HANA DB (HANA Live) BO Relational Universe (4.x) Non-SAP DW (SQL) BPC –NW Application Web Intelligence Analysis for Office Analysis for OLAP Dashboards *1 *2 *2 *3 *3 *4 *4 Crystal Reports 2011 Crystal Reports Enterprise Design Studio Explorer Lumira BPC for Excel BEx Analyzer

*1 possible through Universe connection *2 through ODBC connection

*3 through JDBC connection *4 through ODBC/JDBC connection *5 through universe/ODBC/JDBC connection

*4 *4 *5 *5 *3 *3 *3 *3 ! !

Love’s: Overall SAP Reporting Delivery Selection Strategy

Data warehouse Need/ BPC Support SAP BI Reporting Decision Tree + External System Support Matrix Non-SAP External Data

No Data warehouse Need

Crystal ALV Standard ECC Report available Standard ECC ABAP Report Yes Availability of Std.SAP HANA VDM No SAP ECC-HANA Reporting Decision Tree Yes Possibility of VDM Extension** * SLT not considered ** License constraints

*** BPC-BO Integration not considered

No Yes Possibility of near-real time access No Custom ECC ABAP Report Special Load to SAP BW Yes No SAP Fiori/UI5 Mobile

SAP BI Reporting - Decision Tree

* Not considering SAP HANA Live options

Report Delivery Mechanism

Distribution Browser PC _Wireless

BW Information Broadcasting BO Report Bursting Batch/ Printing SharePoint BO Infoview Run

OnDemand Live Office Mobile

Web Intelligence Design Studio Analysis for OLAP Analysis for Office Explorer Crystal Reports

SAP ECC-HANA Reporting – Decision Tree

Distribution Browser PC _Wireless

BO Report Bursting Batch/ Printing SharePoint BO Infoview Run

OnDemand Live Office Mobile

Web Intelligence Design Studio Analysis for OLAP Analysis for Office Crystal Reports Enterprise Dashboards* Design _Studio

SAP SAP ABAP Universe Universe * restrictions applied Universe Office Web based

Reporting Practice.

Office/OLAP SAP Lumira

Semantic Layer Business Objects Universe

Success Factors Redwood Distribution Enterprise Portal EP EP Automated Recon Share Point Data Warehouse Business Suite SAP ECC G/L AR AP PS H SAP BW _H Business Suite SAP CRM OM MKT SER SAL H SAP BW CRM SAP HR SAP Personas ECC ALV CRM EP EP EP Real-time Reporting - BW - HANA Live Automated Recon Automated

1. Reporting in SAP ERP using the classic reporting tools

Low cost option, resource optimization, ideal for green-field

2. Reporting via generated virtual Info Provider

Automated reconciliation scenarios

3. Reporting via HANA models

Licensing Considerations

Post Calculation v/s pre calculations

Real-time Reporting

Post Calculation v/s pre calculations

4. Reporting via Crystal Reports

Report Schedule/Basis tuning

5. Reporting via BW-jump

Technical overhead

6. Real-time load using RDA etc to BW.

Leveraging SAP provided Virtual Data Model

Note 1778607 – SAP HANA Live for SAP Business Suite

Note 1782065 – Tables for SAP HANA Analytics for SAP Business Suite Note 1782066 – Tables for SAP HANA Analytics for CRM 1.0

Note 1781992 – Tables for SAP HANA Analytics for ERP 1.0 Note 1799254 – Schema mapping for HANA based Analytics

When joining multiple sources systems, metadata

standardization is necessary

Real-time Reporting

standardization is necessary

Security.

SAP BW – Z/X/Y Query Concept

SAP Authentication

Crystal ALV usage vision

Publication & Broadcasting

Virtual Info Provider Considerations

THANK YOU FOR PARTICIPATING

Please provide feedback on this session by completing

a short survey via the event mobile application.

THANK YOU

SESSION CODE: 1301

For ongoing education on this area of focus,

visit www.ASUG.com