webinar: reporting mitsap s/4hana analytics 24....

25
Walldorf, Baden Webinar: Reporting mit SAP S/4HANA Analytics 24. Oktober 2019

Upload: others

Post on 21-Jan-2021

8 views

Category:

Documents


1 download

TRANSCRIPT

Page 1: Webinar: Reporting mitSAP S/4HANA Analytics 24. Oktober2019consultrain.at/wp-content/uploads/2019/10/Webinar...Analytical Fiori Apps Overview Pages Analytical List Page PhysicalTable

Walldorf, Baden

Webinar: Reporting mit SAP S/4HANA Analytics24. Oktober 2019

Page 2: Webinar: Reporting mitSAP S/4HANA Analytics 24. Oktober2019consultrain.at/wp-content/uploads/2019/10/Webinar...Analytical Fiori Apps Overview Pages Analytical List Page PhysicalTable

2PUBLIC© 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ

§ The Virtual Data Model§ Fiori – Basic Ideas§ Custom Analytical Query§ Multidimensional Reporting and Drilldown to Line Items§ Embedded Analytics Reporting with the KPI Designer

Agenda

Page 3: Webinar: Reporting mitSAP S/4HANA Analytics 24. Oktober2019consultrain.at/wp-content/uploads/2019/10/Webinar...Analytical Fiori Apps Overview Pages Analytical List Page PhysicalTable

The Virtual Data Model

Page 4: Webinar: Reporting mitSAP S/4HANA Analytics 24. Oktober2019consultrain.at/wp-content/uploads/2019/10/Webinar...Analytical Fiori Apps Overview Pages Analytical List Page PhysicalTable

4PUBLIC© 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ

The Virtual Data Model - A Foundation for S/4HANA Embedded Analytics

Database Physical Tables

View View View

View View

View

UIs BI Application

Virtual Data Model

Transactional system, for example, SAP S/4HANA

Page 5: Webinar: Reporting mitSAP S/4HANA Analytics 24. Oktober2019consultrain.at/wp-content/uploads/2019/10/Webinar...Analytical Fiori Apps Overview Pages Analytical List Page PhysicalTable

5PUBLIC© 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ

Check Content CDS View in ABAP Project Explorer – Dependency Analyzer

Page 6: Webinar: Reporting mitSAP S/4HANA Analytics 24. Oktober2019consultrain.at/wp-content/uploads/2019/10/Webinar...Analytical Fiori Apps Overview Pages Analytical List Page PhysicalTable

6PUBLIC© 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ

Documentation Link: Virtual Data Model https://help.sap.com/viewer/6b356c79dea443c4bbeeaf0865e04207/1809.000/en-US/8573b810511948c8a99c0672abc159aa.html

The Virtual Data Model – Looking for Information

Content CDS View I_ACTUALPLANJRNLENTRYITEMCUBE

Page 7: Webinar: Reporting mitSAP S/4HANA Analytics 24. Oktober2019consultrain.at/wp-content/uploads/2019/10/Webinar...Analytical Fiori Apps Overview Pages Analytical List Page PhysicalTable

7PUBLIC© 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ

Frontend Tools and Consumption Views

SAP BI Tool Analysis

SAP BI ToolLumira 2.2

Query Browser

SAP Smart Business Cockpits

Analytical Fiori Apps

Overview Pages

Analytical List Page

Physical Table

Multidimen-sional Reports

CDS Query/Analytical Query/Transient Query

CDS View

Interface View

VDM

Consumption View

S/4 HANA UIs – Scope of Standard Reporting Delivery SAP Analytics UIs

SAP Analytics Cloud

VDM is …

SAP´s Strategic Solution forReporting in S/4 HANA

KPI Design Modeler

Report Design Modeler View Browser

Page 8: Webinar: Reporting mitSAP S/4HANA Analytics 24. Oktober2019consultrain.at/wp-content/uploads/2019/10/Webinar...Analytical Fiori Apps Overview Pages Analytical List Page PhysicalTable

Fiori – Basic Ideas

Page 9: Webinar: Reporting mitSAP S/4HANA Analytics 24. Oktober2019consultrain.at/wp-content/uploads/2019/10/Webinar...Analytical Fiori Apps Overview Pages Analytical List Page PhysicalTable

9PUBLIC© 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ

The SAP Fiori Apps Reference Library

http://www.sap.com/fiori-apps-library

Page 10: Webinar: Reporting mitSAP S/4HANA Analytics 24. Oktober2019consultrain.at/wp-content/uploads/2019/10/Webinar...Analytical Fiori Apps Overview Pages Analytical List Page PhysicalTable

10PUBLIC© 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ

Fiori Launchpad Elements: Tile – Catalog – Group - Role

Page 11: Webinar: Reporting mitSAP S/4HANA Analytics 24. Oktober2019consultrain.at/wp-content/uploads/2019/10/Webinar...Analytical Fiori Apps Overview Pages Analytical List Page PhysicalTable

11PUBLIC© 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ

Semantic Object - ActionSemantic Object - Action

Page 12: Webinar: Reporting mitSAP S/4HANA Analytics 24. Oktober2019consultrain.at/wp-content/uploads/2019/10/Webinar...Analytical Fiori Apps Overview Pages Analytical List Page PhysicalTable

Custom Analytical Query

Page 13: Webinar: Reporting mitSAP S/4HANA Analytics 24. Oktober2019consultrain.at/wp-content/uploads/2019/10/Webinar...Analytical Fiori Apps Overview Pages Analytical List Page PhysicalTable

13PUBLIC© 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ

General Tab & Field Selection Tab

Selected fields that are copied into Analytical Query

The Landing page lists all the available Analytical Queries: - SAP released Queries- Customer Queries

Custom CDS View

Remove field from Analytical Query

Measures

Dimensions

Display icon indicates whether Field is shown in the report or not

Filter icon indicates whether fixed filter values are defined on this field in the Filters tab or not

Page 14: Webinar: Reporting mitSAP S/4HANA Analytics 24. Oktober2019consultrain.at/wp-content/uploads/2019/10/Webinar...Analytical Fiori Apps Overview Pages Analytical List Page PhysicalTable

14PUBLIC© 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ

Display Tab & Add Restricted Measure

(19)

Variable Creation

Variable Default

Display Tab & Add Restricted Measure

Page 15: Webinar: Reporting mitSAP S/4HANA Analytics 24. Oktober2019consultrain.at/wp-content/uploads/2019/10/Webinar...Analytical Fiori Apps Overview Pages Analytical List Page PhysicalTable

Multidimensional Reporting andDrilldown to Line Items

Page 16: Webinar: Reporting mitSAP S/4HANA Analytics 24. Oktober2019consultrain.at/wp-content/uploads/2019/10/Webinar...Analytical Fiori Apps Overview Pages Analytical List Page PhysicalTable

16PUBLIC© 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ

Page 17: Webinar: Reporting mitSAP S/4HANA Analytics 24. Oktober2019consultrain.at/wp-content/uploads/2019/10/Webinar...Analytical Fiori Apps Overview Pages Analytical List Page PhysicalTable

17PUBLIC© 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ

Create Tile

Page 18: Webinar: Reporting mitSAP S/4HANA Analytics 24. Oktober2019consultrain.at/wp-content/uploads/2019/10/Webinar...Analytical Fiori Apps Overview Pages Analytical List Page PhysicalTable

18PUBLIC© 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ

Page 19: Webinar: Reporting mitSAP S/4HANA Analytics 24. Oktober2019consultrain.at/wp-content/uploads/2019/10/Webinar...Analytical Fiori Apps Overview Pages Analytical List Page PhysicalTable

19PUBLIC© 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ

Assign Tile to Group and Execute Tile

Page 20: Webinar: Reporting mitSAP S/4HANA Analytics 24. Oktober2019consultrain.at/wp-content/uploads/2019/10/Webinar...Analytical Fiori Apps Overview Pages Analytical List Page PhysicalTable

20PUBLIC© 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ

Jump To…

Page 21: Webinar: Reporting mitSAP S/4HANA Analytics 24. Oktober2019consultrain.at/wp-content/uploads/2019/10/Webinar...Analytical Fiori Apps Overview Pages Analytical List Page PhysicalTable

Embedded Analytics Reporting with theKPI Designer

Page 22: Webinar: Reporting mitSAP S/4HANA Analytics 24. Oktober2019consultrain.at/wp-content/uploads/2019/10/Webinar...Analytical Fiori Apps Overview Pages Analytical List Page PhysicalTable

22PUBLIC© 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ

The KPI Design Modeler

You want to analyze the data of one Key Performance Indicator (KPI) including trends, thresholds and alerts.You need to define color-coded thresholds on KPIs.You want to expose a KPI on the Fiori Launchpad.Any other floorplan can be configured as navigation target

Page 23: Webinar: Reporting mitSAP S/4HANA Analytics 24. Oktober2019consultrain.at/wp-content/uploads/2019/10/Webinar...Analytical Fiori Apps Overview Pages Analytical List Page PhysicalTable

23PUBLIC© 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ

KPI Designer – Assign KPI Tile to the Fiori Launchpad Group

Revenue Actuals ps for all productsand all customers in 2019!

Page 24: Webinar: Reporting mitSAP S/4HANA Analytics 24. Oktober2019consultrain.at/wp-content/uploads/2019/10/Webinar...Analytical Fiori Apps Overview Pages Analytical List Page PhysicalTable

24PUBLIC© 2019 SAP SE or an SAP affiliate company. All rights reserved. ǀ

Mini Chart - 2019

START IN SCALE: ZERO CRITICAL

WARNING

TARGET

START IN SCALE: CRITICAL

KPI Designer - Target and Thresholds

Page 25: Webinar: Reporting mitSAP S/4HANA Analytics 24. Oktober2019consultrain.at/wp-content/uploads/2019/10/Webinar...Analytical Fiori Apps Overview Pages Analytical List Page PhysicalTable

Contact information:

F name L nameTitleAddressPhone number

Thank you.