pbs software gmbh - company and solutions overview · for more than 25 years leading provider of...

Jens Orhanovic

Managing Director LIS.TEC GmbH

OA4ERPOperational Analytics for ERP

Consistently increase

your company's success

Together we are strong

Operational Analytics for ERP (OA4ERP) 06/2018

Worldwide largest IBM OEM High Value Software Distributor

Worldwide more than 1,500 customers with more than 5,000 installed PBS solutions

For more than 25 years leading provider of SAP add-on solutions

First Full Service Cloud provider of Business Analytics

Consultancy on a par – committed, creative, solution-oriented, since 1999

History & Milestones of LIS.TEC

19

94

–

–2

00

1

20

03

–

–2

00

4

20

05

–

–2

00

6

20

07

–

–1

99

7

20

09

–

Worldwide largest High Value OEM Distributor

–2

00

8

–2

01

1

–1

99

5

19

96

–

19

98

–

–1

98

5

20

15

–

Mainframe

Standard Software individually

adapted

Development of the Market … new technologies and the globalization involve changes

Standard Software

Client Server/ Decentralization Mobile/Cloud

Individual Software Solutions


LIS.TEC the Specialist for Data Management Management/Consultancy

High level of business and management requirements

Cost/Benefit calculation

Business plans

Market know-how

Market requirements

Innovative ideas

Customer needs

Technical expertise

Databases, analytics, planning

Solution provider

AHS/AHL, time recording, laboratory solution,

application generator

Training / Courses

Pearson View certification center

Support

First & Second Level Support


SAP Market Requirements

Legal compliance

Optimized preparation for S/4HANA migration

Cost optimizing

Intelligent data management

Modern up-to-date analyses


The Solution – OA4ERP

Operational Analytics for ERP


▲OA4ERP Data Management ▲

OA4ERP

Analysis DB

Analysis Applications

OA4ERP Analysis Templates

Standard Reports ▲

Standard Transactions ▲

Query Configurator ▲

Analysis & Reporting ▲

Predictive

Planning ▲

SAP ERP

External Data ▲SAP Archives ▲SAP Database ▲

Ready for HANA? ▲

Query Builder ▲


OA4ERP Data Management ▲

OA4ERP

Analysis DB






Analyse & Reporting ▲

Predictive

Planung ▲

SAP ERP


Ready for HANA? ▲

Query Builder ▲

IBM Datastage

IBM Change Data Capture (CDC)


Challenges for a complex Solution

Competent Consultation

Skill requirements

technically

business

Sales support

Support

Compliance

Processing

Source: https://amperesoft.net/images/product/TDM/Data Management.png


Distribution – everything from one Source

Distributor

(Coordinator & Contact Partner)

Partner Manufacturer

IBM en

Customer

BI Templates

IBM

Components

Nearline

Analytics

Infrastructure


Compliance

Processing

Training

Support


OA4ERP

Analysis DB







Predictive

Planung ▲

SAP ERP


Ready for HANA? ▲

Query Builder ▲

IBM Datastage



Standard Transactions(PBS CFI Transaction, Line Items)

SAP Finance

Standard Transaction

/PBS/FBL5N

Access to OA4ERP

Database

PBS CXX Modules: integrated end user access to SAP

database, archive and nearline data.


SAP GUI

SAP Finance


/PBS/FBL5N

Standard Transactions(PBS CFI Document Display)


SAP Finance


/PBS/FBL03

Drilldown

Standard Transactions(PBS CFI Overview Customer )


Analyses of SAP, archives and non-SAP data can be

combined

Standard Transactions Summary

CXX modules extend SAP Standard Transactions

to include additional data sources (archives & non-SAP)

Data aggregation

Drilldown to document level



OA4ERP

Analysis DB







Predictive

Planung ▲

SAP ERP


Ready for HANA? ▲

Query Builder ▲

IBM Datastage



Enhanced CFI Standard Report(Cross-customer Sales Analysis from operative and archived data)

Cross-customer

Sales Analysis

in a few seconds

Standard Enhancement of

SAP Standard Transactions

Sum of all customers is not

possible in the standard SAP due

to performance reasons; here in a

few seconds!


Standard Reports

SAP Standard Report

Listing drilldown to individual posting values


Analyses of SAP, archives and non-SAP data can be

combined

Standard Reports Summary

CXX modules extend SAP Standard Transactions

to include additional data sources (archives & non-SAP)

Reporting via several company codes

Data comparison for different years



OA4ERP

Analysis DB







Predictive

Planung ▲

SAP ERP

External Data▲SAP Archives▲SAP Database▲

Ready for HANA? ▲

Query Builder ▲

IBM Datastage



Query Configurator Example 1

Query Configuration

Criteria Selection


Query Aggregation Example 1

Query Aggregation

Groups Fields

Drilldown


Query Drilldown Example 1

Generic Query:

Drilldown

to Document Level


Example 2:

Financial Statement Comparison: classic with generic

Classic SAP Standard Report

=

Generic Financial Statement


Query Configurator – Summary

Query Configuration

ABAP programming is only necessary for including more

complex reports

About 50% less programming work

Easy report generation via Query Configurator

Need for Excel is greatly reduced

GDPR



OA4ERP

Analysis DB







Predictive

Planung ▲

SAP ERP


Ready for HANA? ▲

Query Builder ▲

IBM Datastage



Query Builder

ABAP API supports the following

SQL Operations:

Join

Union

Complex WHERE Condition

Arithmetic Functions (+-*/)

Case Expression

Subselect

Aggregation

String Functions (LEFT, RIGHT, ..)

OA4ERP APIs


ABAP Coding with Query Builder

ABAP Query Builder

API call


Generated SQL Statements

ABAP Query Builder

Generates SQL and

results


Query Builder – Summary

very fast access to SAP data and OA4ERP DB

ABAP programming for complex queries with integration of

OA4ERP API

Access to SAP data, external sources and archives



OA4ERP

Analysis DB







Predictive

Planung ▲

SAP ERP


Ready for HANA? ▲

Query Builder ▲

IBM Datastage



Data Management

Data analysis (Analyzer)

More aggressive archiving possible since data can still be displayed

in the system

Integration of external data and archives in operative SAP system

Monitoring

Data models optimized for analyses

Relieving the load on the system Performance

Data Governance

Compliant archive optimization for SAP data,

external data and archives



OA4ERP

Analysis DB







Predictive

Planung ▲

SAP ERP


Ready for HANA? ▲

Query Builder ▲

IBM Datastage



Optimal Preparation for S/4HANA Migration

User

Interface

Before starting migrationERP

Archives

Business Suite

OA4ERP

Analysis DB

Browser

Mobile

Analysis

GUI

Large

ERP DB

Migration preparation

Larger

ERP

Archive

Small

ERP DB

Small

S4/HANA DB

Historical

ERP archives

No migration!!DB migration

S4/HANA

SAP GUI/

FIORI

Smaller dataset

during migration and in HANA

Significant cost savings

Reports from historical data

in S/4HANA with OA4ERP



OA4ERP

Analysis DB







Predictive

Planung ▲

SAP ERP


Ready for HANA? ▲

Query Builder ▲

IBM Datastage



Interactive Reporting

Browser, Mobile


Interactive Dashboard

Browser, Mobile


Reporting Templates

Financial Accounting

Controlling

Materials Management

Sales & Distribution

Human Resources

Browser, Mobile



OA4ERP

Analysis DB







Predictive

Planung ▲

SAP ERP


Ready for HANA? ▲

Query Builder ▲

IBM Datastage



Example: Planning


Planning with Excel frontend


Workflow


Planning Templates

Balance Sheet Planning

P&L Planning

Sales / Revenue Planning

Cost Planning

Profit Margin Planning

Investment Planning



OA4ERP

Analysis DB







Predictive

Planung ▲

SAP ERP


Ready for HANA? ▲

Query Builder ▲

IBM Datastage



Predictive Scenario

Predictive Analyses to see trends and create forecasts


Predictive Templates

Product Analyses

Customer Analyses

Shopping Basket Analyses

Personnel Analyses

Process Analyses



OA4ERP

Analysis DB







Predictive

Planung ▲

SAP ERP


Ready for HANA? ▲

Query Builder ▲

IBM Datastage



Point-of-sale Systems

Personnel Administration

Excel

Integration of external Data

Customer Relationship Management

Production

Warehouse

Commerce

Other ERP Systems



OA4ERP

Analysis DB







Predictive

Planung ▲

SAP ERP


Ready for HANA? ▲

Query Builder ▲

IBM Datastage



Aggressive Archiving

Database Analysis (Analyzer)

Data Management

Integration of Archives and external Data in ERP System

Monitoring

Data Models optimized for analyses

Relieving Load on operative System Performance Increase

Data Governance no DART extracts, eliminating redundant data, compliant archiving

Contains all Licenses for Databases, ETL and Replication


Database

OA4ERP is not developed as Data Warehouse

OA4ERP differs schematically from DWs

(no star scheme)

Enhancement of existing DWs by improved operative

Reporting

Scalable analytical Database(extremely fast response times and data compression)



OA4ERP

Analysis DB







Predictive

Planung ▲

SAP ERP


Ready for HANA? ▲

Query Builder ▲

IBM Datastage



Supports all SAP Database Systems

(HANA, ASE, Oracle, SQL Server, DB2)

SAP Databases



OA4ERP

Analysis DB







Predictive

Planung ▲

SAP ERP


Ready for HANA? ▲

Query Builder ▲

IBM Datastage



Archive data is always available via SAP GUI

Substantial relief by "aggressive archiving" in SAP ERP

System

SAP Archives

All SAP certified archive systems are supported (read/write)

Compliant archive optimization of SAP and external data



OA4ERP

Analysis DB







Predictive

Planung ▲

SAP ERP


Ready for HANA? ▲

Query Builder ▲

IBM Datastage



References

More than 1,500 customers worldwide rely

on the PBS add-on solutions:

More than 50 percent

of German DAX 30 companies use

the PBS solution!

In addition, German & international global

players and top-class middle-sized

companies

Extract of Customer List:


Customer Feedback

For more reviews on the PBS add-on solutions see

https://www.gartner.com/reviews/home


LIS.TEC GmbH

Gesellschaft für IT und

Businessberatung

Landgut Marienwahl

Heilbronner Strasse 51

71634 Ludwigsburg

[email protected]

www.listec.de

PBS Software GmbH

Schwanheimer Strasse 144a

64625 Bensheim, Germany

Phone: +49-6251-174 [email protected] or

[email protected]

pbs software gmbh - company and solutions overview · for more than 25 years leading provider of...

Documents