C4: SAP Analytics Cloud im Einsatz bei der Vetropack ......SAP Business Objects (4.2) - Dashboard &...

Sergio Cenci, BI-Consultant, Vetropack

Alexander Jost, BI-Expert Consultant, itelligence AG

itelligence World 2019 – Let‘s transform! Design your future.

24. Oktober 2019

C4: SAP Analytics Cloud im Einsatz bei der Vetropack. Warum wurde die Cloud-Lösung gewählt und wie sind die ersten Praxiserfahrungen?

Vetropack

24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

2

Glass-Container

Agenda

24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

3

Goal of this presentation

Vetropack group

Vetropack system insight

Vetropack reporting environment/changes & benefit with SAC

SAP SAC System/learning

SAP Analytics Cloud/files/monitor/connectivity/layout/authorizations/ implementation time/features

Vetropack – lessons learned

Q&A

30min

Goal of this presentation

24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

4

Present the Vetropack experience of SAP Analytics Cloud on our production system

Show some insights of the look and feel of SAC at Vetropack

Provide helpful links to enable the audience to gain free knowledge

Vetropack group

24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

5

Leading glass packaging manufacturer in Europe

Workforce of over 3,000 people (≈374 BW users)

Eight glass factories across 7 countries

18 furnaces capable of producing more than 4,000 tons of glass packaging per day

Producing 4.5 billion units of glass containers a year

www.vetropack.com

SAP ERP/BW HDB 2.0

SAP release 750 on support package 9 (with S/4 753)

Running ERP with embedded BW

≈374 active BW users

≈726 active ECC users

SAC Version 2019.15.9

EU tenant (Data Center Germany Frankfurt)

100 pred. public users

Vetropack system insight

24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

6

SAP ERP/BW hosted by

SAC

S/4 HANA Go-Live on the CW45 2019

Group reporting systems/tools IBM COGNOS (FI statements / consolidation)

SAP Business Objects (4.2) - Dashboard & Cockpitwith Design Studio (1.6 SP5)

SAP NW Portal (7.5) – i-views to BW via WAD (7.6)

SAP Analysis for Office (2.7.501)

SAP Bex Query Designer (7.6)

Vetropack reporting environment

24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

7

Controller BEX

NW Portal BW

AFO

BOBJ

COGNOS

ERP/BW

SAC just another reporting tool

or a game changer?

24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

8

Controller

BEXAFOSAC

COGNOS

ERP/BW

We replace BOBJ (on-going) with SAC

We replace NW portal reports (future) with SAC & Analytics HUB if needed.

We shift report front end developments from IT to business

SAC - Finally not an “IT nerd” tool!

Vetropack reporting environment - changes with SAC for Vetropack

Free up BI developer resources

Simplify front-end developments

Empower business

Become more agile in reporting

No planning of release update of software / get new features automatically rolled out by SAP https://www.sapanalytics.cloud/product_updates/

24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

9

Vetropack reporting environment - benefit with SAC

https://www.sapanalytics.cloud/product_updates/

24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

10

SAP System/Learning

SAP provides under https://www.sapanalytics.cloud/

Free 30-day trial to SAP Analytics Cloud

Learning tutorials (Guided Playlists, Videos, Quick Answers)

24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

11

SAP System/Learning

SAP provides under https://open.sap.com/

Free courses to SAP Analytics Cloud & S/4 HANA topics

Recommended course

“Intelligent Decisions with SAP Analytics Cloud”

https://www.sapanalytics.cloud/

https://open.sap.com/

Transparent prices with SAC https://www.sapanalytics.cloud/plans/

24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

12

SAP System/Learning

https://www.sapanalytics.cloud/plans/

24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

13

SAP System/Learning

24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

14

Explore your Connection Options https://www.sapanalytics.cloud/learning/data-connections/

SAP System/Learning

https://www.sapanalytics.cloud/learning/data-connections/

24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

15

SAP Analytics Cloud – files

Access to reports, dataset and models are managed via folders and should be in the responsibility of the system owner

24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

16

SAP Analytics Cloud – monitor

Monitoring of the SAC system usage and storage displayed in a glance

24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

17

SAP Analytics Cloud – monitor

Whenever you import data into the cloud you are consuming storage. This consumption can be monitored by model and users

Connect to live data: Only meta data are replicated into the cloud

Data in source system are populated at runtime only

user authentication in source system required (Single Sign-on installation possible) https://blogs.sap.com/2017/07/13/saml-authentication-in-sap-analytics-cloud/

24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

18

SAP Analytics Cloud – connectivity (Live Data)

https://blogs.sap.com/2017/07/13/saml-authentication-in-sap-analytics-cloud/

Drag and Drop or import files: Data only stored in SAC

24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

19

SAP Analytics Cloud – connectivity (Drag and Drop Files)

24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

20


24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

21


24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

22


24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

23


24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

24


24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

25

SAP Analytics Cloud – Layout

24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

26


24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

31

SAP Analytics Cloud – Authorizations / Vetropack Concept

Roles

Teams

User N

VP_EVERYBODY

VP_EVERYBODY VP_...

VP_....

VP_... Actions: Read, Write, Delete,

Menu: Grouping actions and files

24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

32

SAP Analytics Cloud – Authorizations / Files

Roles

Teams

User N

VP_EVERYBODY

VP_EVERYBODY VP_...

VP_....

VP_...

24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

33

SAP Analytics Cloud – Authorizations / Teams

Roles

Teams

User N

VP_EVERYBODY

VP_EVERYBODY VP_...

VP_....

VP_...

24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

34

SAP Analytics Cloud – Authorizations / Roles

Roles

Teams

User N

VP_EVERYBODY

VP_EVERYBODY VP_...

VP_....

VP_...

24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

35

SAP Analytics Cloud – Implementation time at Vetropack

Get SAC license

1 – 3 days depending on license type and amount, pre-paid

purchase or contract.

Get live-connection ready 4 days

Try out features 5 days

Build story template 1 day

Create data source 4-6 days

Creating authorization concept 2 days

Build reports 20 Train the users 5

>1month for

implementation and go

productive with some

reports

24.1

0.2

019

itellig

ence w

orld 2

019 ©

ite

llig

ence

37

SAP Analytics Cloud – Lessons learned

Think different

Reporting will change in the future with dynamic text search “Search to Insight”

New content Data Sources with S/4 HANA

Investigate in future S/4 HANA content e.g. CDS views

Pivot table reporting not possible yet in SAC

Keep Excel users in Excel until this feature will come in SAC as it has been announced already

Look forward

Run parallel with SAC and try out new ways of reporting possibilities before re-building old things

C4: SAP Analytics Cloud im Einsatz bei der Vetropack ......SAP Business Objects (4.2) - Dashboard &...

Documents

Transcript of C4: SAP Analytics Cloud im Einsatz bei der Vetropack ......SAP Business Objects (4.2) - Dashboard &...