SAP Embedded Analytics in S/4HANA

by: Nawab Siddiqui

1
SAP Analytics Solutions - Today

• SAP S/4HANA embedded analytics

• SAP Data Warehouse (BW) & SAP BW/4HANA
• SAP Analytics Cloud - SAC
• SAP Business Objects suite – BOBJ
• SAP Lumira Designer & Discovery
• SAP Fiori Analytical Apps
• SAP Data Warehouse Cloud
• SAP Cloud Platform
• SAP Roambi
• SAP Data Hub, SAP Vora, SAP Leonardo, SAP Predictive
• SAP Data Intelligence

2
Data Analytics – outlook

What Data telling you?

Value Prescriptive
Descriptive: What’s happening in my business?
Predictive - Live , comprehensive

Diagnostic Diagnostic: Why is it happening?

- Reasoning , drill down , Self service

Descriptive Predictive: What’s likely to happen?

- read historical data pattern, use algorithm to
predict and decision support

Prescriptive: What do i need to do?

Complexity - advanced data analytics technique

3
SAP Embedded Analytics

Embedded
SAP S/4HANA Analytics End to End
Business
SAP S/4HANA Embedded BI Solutions
SAP BI Platform
Applications
Business Analytics End to End
Applications

SAP S/4HANA
Business
Applications

4
What is SAP Embedded Analytics

• SAP S/4HANA embedded analytics provides real-time analytics on

live transactional data.

• Embedded Analytics is about blending BI features like dashboard

reporting, data visualization to the existing business applications.

• Embedded analytic reports are provided through standard SAP

Fiori applications for multiple user types.

• The Embedded Analytics is not only Real-time reporting but

seamlessly augment ERP functions with respective Analytical
insights.

• The Embedded Analytics offers tools, features and pre-build

contents, out of the box - S/4HANA. This enables business to get
real-time business analytics within the business context.
SAP S/4HANA
Business Applications
One screen for business transactions and Analytics.

5
Embedded Analytics - Features

6
Embedded Analytics – High level Architecture

SAP S/4HANA analytics

architecture key components

• Fiori Apps
• SAP ABAP CDS views
• OData services
• Transient analytical query

7
Embedded Analytics - Virtual Data Model + Analytical Apps + Design Tools

8
SAP Fiori Apps – Embedded Analytics

1. Embedded Analytics is the SAP recommended solution for S/4

operational reporting.

2. Follow the ABAP CDS view paradigm for operational reporting

requirements.

• To build reports should use ABAP CDS views as base, keep

application layer lean and push down the costly functions to
the database. i.e. SQL statement instead of Internal tables.

• Shouldn’t go with the traditional/legacy ABAP report

development approach. i.e. ALV, report painter, report
designer, SE38,SQ01.

9
Embedded Analytics – End users & key users Tools

10
Embedded Analytics – End users Tools

11
Embedded Analytics - End users Tools
Overview Page

• SAP delivers Overview Page applications that consists of multiple cards which provide most relevant information.
• Simplified Dashboard, Analytical information presented by cards
• Both flavour of Data, KPI tile and graphical view

 Navigation to other Fiori apps that are

semantically linked to the data
 Most important information at a glance (instead of
opening many different transactions) for your
business role.
 Combination of analytical and transactional
information

12
Embedded Analytics - End users Tools
Smart Business KPI – KPI Tile (Generic Drill Down)

• The Tile depicts business performance indicators on the launchpad.

• Navigate from tile to the detailed analysis – drill down.
• A rich graphical visual information to analyse by different business dimension i.e. by vendor,
issues.
• View data by multiple type of graphs i.e. line series, pie chart.
• Fields filtration, sorting, add to the graph axis…etc.

13
Embedded Analytics - End users Tools
Analytical List page – ALP

• It has two type of visualizations of the same data (typically an overview chart and a detailed tabular view).
• Provides dynamic filtering between visualizations.

Visuals & usual dropdown paraments

Graphical Data visualization

List/tabular format Data visualization

14
Embedded Analytics - End users Tools
Multidimensional Reports

• Drag and drop

• Slice and Dice Function
• Data & visual view
• Row and Column dimensions
• Works like a BW Bex query

The Web Dynpro grid used to display

results.

Design studio data grid is deprecated,

Should plan to move reports to Web
Dynpro grid.

15
Embedded Analytics - End user Tools
Query Browsers
• Review inventory of standard and custom
ABAP CDS View queries.

• Understand definition and annotations.

• Preview multidimensional reports from ‘Open

for Analysis.

• SAP_BR_EMPLOYEE
Role required to access the Query Browser

16
Embedded Analytics - End users Tools
Analysis Path Framework – A guided path
• A pre-defined step by step drill down analysis in a visual and intuitive fashion.

• Key users developed pre-configured analysis path based on business need. The end users just focus
on the business insights without additional filtration or need to do selections.

17
Embedded Analytics - Key users Tools
Embedded Analytics - Key user Tools
Manage KPI and Reports

• To create/modify KPI tiles – Smart Business KPI and Analytical List page – ALP
• The ALP can also be created by Fiori Elements – Analytical list Floor plan.
• There were 6 apps till S/4 1809 to develop KPI, which combine into one single app from S/4
1909.

KPI: to measure the crucial business metrics.

Groups: collection of KPI’s, each KPI must assign to at

least one Group.

Reports: to develop Smart business KPI (Generic

Drilldown) and Analytical List page.

Stories: Integrate with SAP Analytics cloud and can

embedded SAC stories in the launchpad.

19
Embedded Analytics - Key user Tools
Manage KPI and Reports
• Generic Drill down reports should be created from KPI, must create KPI first and assign to KPI Group.
• KPI Group works as KPI repository to manage KPI.
• Once KPI is created and assigned to some KPI Group then can create Generic Drill Down report/Smart Business KPI.
• Analytical List Page - ALP report can be created without KPI.

Analytical list page can also be created by SAP Elements

– Floor plan. A rapid template-based development

• Overview Page
• List Page
• Object page
• Analytical List page

20
Embedded Analytics - key users Tools
View Browsers
• SAP has delivered standard CDS views to create S/4HANA Real Time Analytics and this is also called
Virtual data models- VDM.

• The CDS Views are the foundation of the Fiori apps and Analytical Application.

• Catalogue of pre-built Views – CDS

• Review inventory of standard and

custom ABAP CDS Views

• Understand definition, annotations,

and cross references

• Only use CDS status with ‘Release’

status.

• Don’t use CDS with ‘Not Released’

status, couldn’t change/remove by
SAP in future releases.

21
Embedded Analytics - key users Tools
CDS Views
The CDS views used to create virtual data models (VDM) that facilitate the analytics capability in S/4.
Three types of CDS views

1. Basic
Consumption views
2. Composite
3. Consumption

Interface views
Composite views
Don’t confuse with CDS & VDM’s terms. They are the same. Indeed, VDM generated
by CDS views. The annotations describe and classify the nature of the Virtual models.
Basic views

S/4HANA Tables
Embedded Analytics - key users Tools
CDS Views

Basic: Master data like customer, sales order, behave

like as BW info object, Dimension, Text, Hirarachy

i.e. I_<XXX> - VDM.VIEWTYPE = BASIC.

Composite: Transactional nature, behave like BW Cube

i.e. I_<XXX> - VDM.VIEWTYPE = Composite

Consumption: like BW multi provider, expose to Fiori

apps to consume

i.e. C_<XXX> - VDM.VIEWTYPE = consumption

Embedded Analytics - End users Tools
Custom CDS View

• Can tailor custom CDS views based on SAP released CDS by joining multiple ABAP CDS views.
• A sophisticated way to develop custom CDS views.
• Eclipse-ADT for complex CDS views development.

24
Embedded Analytics for IT & Key users
Custom Analytical Queries

• The Key users or IT dept. can create custom queries based on delivered SAP HANA CDS
views leveraging key figures, layout formatting, chart & filtering.

25
Embedded Analytics for IT & Key users
Custom Analytical Queries

• VDM.ViewType – Consumption
• Ready to use in Fiori apps

• Odata.Publish – True
• Expose as OData service for Fiori apps or any
BI/external tools/apps those are compliance with
OData standards.

• Analytics. Query – True

• The CDS view behave as Analytical query or
Transient query to feed BW system.

Annotations are just like code snip for rapid

development.
i.e. OData.Publish generate OData service
without SEGW

26
Embedded Analytics - End users Tools
Analysis Path Framework – Configuration Modeler

Create/Edit Analysis Path Framework Configurations

27
Embedded Analytics - End users Tools

Fiori Application Fiori ID Details

Manage KPIs and Reports F2814 Create KPI Tiles and Analytical List Reports
APF Configuration Modeler F1768 Configure Analysis Path Framework
Custom Analytical Queries F1572 Create/Edit Analytical Queries
Custom CDS Views F1866 Join CDS Views Within Fiori
Review ABAP CDS View Inventory and Create
View Browser F2170
Multidimensional Reports
Review ABAP CDS View Query Inventory and Preview
Query Browser F1068
Multidimensional Reports

SAP_BR_ANALYTICS_SPECIALIST
Standard role which provides access to key user S/4HANA Embedded Analytics Fiori Applications

S_ATO_SETUP - Adaptation Transport Organizer

Required to setup to move changes in landscape.

28
End User - Embedded Analysis S/4HANA End User – BI System (BOBJ)
Query
Smart Business
Multidimensional Browser / SAP Analytics Analysis for
Overview KPI (Generic Lumira SAC
Discovery WEBICloud - SAC
Reporting End User office
Page Drill down)

Key User – Enabling End-User (S/4HANA) Key User – Enabling End-User (BOBJ)

Custom Analytical Manage KPIs Bex Query

Lumira Designer Crystal Reports
Queries and Reports Business Designer
Analyst

IT Developer
View Browser
CDS Views Custom CDS Views
IT Developer

S/4HANA S/4HANA

29
Embedded Analytics – SAP Standard Fiori Apps
• SAP Fiori library is the first point for App selection
• Key users and Functional Analyst must explore the Fiori Library
• Identify the Business Roles associated with Fiori apps.
• SAP Fiori Lighthouse is Jump start with bare minimum app required for business to run, based on SAP Best practices.

A quick guide - How to find Analytical SAP Fiori apps Microsoft Word
Document

30
 Standard S/4HANA Analytical Fiori Applications

• Apply appropriate filtration criteria to identify standard analytical apps.

• To get the compatible standard apps, ensure have selected the correct
of your S/4 product version. i.e. S/4 HANA 2020,FP02.
Standard S/4HANA Analytical Fiori Applications
• The Fiori library is comprehensive reference for all the SAP delivered app,
describe its features, functionality and technical details required to implement.
i.e. Odata service, business roles..etc.
• A Usage Profile is a list of SAP GUI transaction codes used to determine SAP
Fiori apps relevant for your business processes.
• This required S-ID to run the analysis and it's saved for future reference, can
run multiple times as needed, can download to excel for analysis.
• You can upload any list of transaction codes as long as the list is provided as
a CSV file. An easy way to generate a Usage Profile is to extract the list of
transactions used from the ABAP Workload Monitor (transaction ST03).
• The “Group by” & Aggregate are quite handy options once select multiple
Apps. Its aggregate the apps details like by Business roles that club all the
apps associated to that.
Embedded Analytics – SAP Standard Fiori Apps

Relevance Score – The App relevancy based on respective T.code usage

• Three star (***) - Highly relevant , direct match (exact replacement of the t.code)

• Two star & one Star (**) | (*) - Less degree but relevant since using t.code from the
same Application area that Fiori app belongs to.

• Can get the respective ECC t.codes for each Fiori app.

• Aggregate on the business roles to get unified business roles to activate all the
associated Fiori apps via ‘Rapid Fiori Activation’ in one Go.

33
Sales – Fiori Analytical apps
1- Sales Order Fulfillment Issues (Version 2), App ID – F0029A
Business Role: (SAP_BR_SALES_MANAGER – Sales manager)

This app allows you to analyze and resolve issues that impede sales orders from being fulfilled. With it, you can analyze sales orders in critical stages, collaborate
with contacts, and efficiently address issues to ensure that sales orders in critical stages are fulfilled as quickly as possible. The app highlights impediments,
provides supporting information, and allows you to navigate to Track Sales Order Details to display further details and resolve the issues.

2- Sales Performance - Plan/Actual , APP ID – F2941

Business Role: (SAP_BR_SALES_MANAGER – Sales manager)

you can compare planned and actual sales data on different dimensions, such as sales organization, customer, and product. By doing so, you can analyze to what
extent your sales targets are being achieved and thus gain insights into your current sales performance.

3- Sales Volume - Check Open Sales, App ID – F2270

Business Role: (SAP_BR_SALES_MANAGER – Sales manager)

you as a sales manager can check your sales volume in comparison with previous months, with the additional insight of open orders and open deliveries for the
current month. This enables you to see at a glance how the current month's sales volume relates to the previous month, and shows you where you can still increase
your sales volume in the current period, for example, open orders, open billing requests, open deliveries.

4 - Sales Volume - Profit Margin, App ID – F2271

Business Role: (SAP_BR_SALES_MANAGER – Sales manager), (SAP_BR_INTERNAL_SALES_REP - Internal Sales Representative)

With this app, you as a sales manager can check your sales volume against your profit margin for your sales organizations. The tile of the app displays the profit
margin for the top 3 sales organizations in percentage, but you can also use other selection criteria. The app enables you to see at a glance whether your profit
margin is low for a particular sales organization or, for example, for a particular product. The profit margin is an indicator of your company's pricing strategies and
how well you control costs.

5- Incoming Sales Orders - Flexible Analysis, App ID - F1249

Business Role: (SAP_BR_SALES_MANAGER – Sales manager), (SAP_BR_INTERNAL_SALES_REP - Internal Sales Representative)

You can use this app to gain an understanding of the monthly rolling trend of incoming sales orders.
KPI – Net value, incoming orders, incoming orders value

34
Sales – Fiori Analytical apps
6- Track Sales Orders (S/4HANA), APP ID – F2577

you can check whether the delivery of a sales order is on track regarding its fulfillment. For example, you can see whether it has been shipped, invoiced, or even whether an
accounting document has been cleared. You can immediately recognize whether the fulfillment of the sales order contains issues or not, or whether it has been completed, or
is still in process. The app enables you to work reactively, for example, if a customer calls, asking for information on their order, or a colleague asks for information of all orders
belonging to a specific customer.

7- Sales Management Overview , App ID - F2601

A sales manager can get a graphical overview of your various sales data on analytical cards. You can further analyze the data by navigating to related analytical apps from the
cards. Using this app, you can gain comprehensive insights into your current sales situation and respond quickly.
8 - Order-to-Cash Performance, App ID – F2005

This app helps you, as a manager or owner of your company’s order-to-cash process, to get a comprehensive overview of the performance and conformity of all the sales
order processes in your company. It provides key figures with respect to the duration of certain process steps in the order-to-cash process as well as to the number of
occurrences of important events that have been triggered during process execution. With the help of these key figures you can easily determine the health status of your sales
process and find potential areas of improvement at a glance.

9- Sales Orders - Demand Fulfillment, APP ID – F2458

you as a sales manager can use 3 different tiles for the following purposes, help to indicate bottlenecks in fulfilling customers orders.
• Sales Order Items – Confirmed
• Sales Order Items – Backorders
• Sales Orders - Demand Fulfillment

35
Confidential & Proprietary | © 2020
Sales – Fiori Analytical apps
10- Predicted Delivery Delay, APP ID – F3408

This app allows you to identify potential delays for open sales orders regarding the predicted delay of the planned delivery to the customer. The app enables you to
take action early on to avoid a possible delay, for example, by instantly recognizing issues and triggering the appropriate actions.

11- Customer Returns, App ID – W0139

Analyze the monthly rolling trend of your customer returns based on flexible combinations of dimensions.
KPI - Customer Returns , Return Item Quantity, No. of Return Items

12- My Sales Overview, App ID - F2200

in the My Sales Overview app provide information on sales data, including: open sales quotations and sales orders, blocked credit memo requests, customer
returns, and customer information.

13- Customers Overview, APP ID – F4645

you can get an overview of the sales data of one or more customers.

14- Sales Volume - Flexible Analysis, APP ID - 1250

can use this app to gain an understanding of the monthly sales volume.

36
Sales – Fiori Analytical apps
15- Delivery Performance - Delivered as Requested, APP ID – F2783

With this app, you can monitor the current delivery performance of sales orders to keep track of customer satisfaction and retention. The app provides you with
insights into delivery performance, and, in the case of a deterioration, enables you to navigate to the relevant sales document and master data object pages for
detailed information. You can also collaborate with your plant manager, or communicate with your customer to discuss or clarify a situation. The app compares the
customer's requested delivery date of sales order items with the actual delivery date of the corresponding outbound deliveries, that is, the latest outbound delivery, in
the case of partial deliveries.

37
Confidential & Proprietary | © 2020
Finance – Fiori Analytical apps
1- Overdue Receivables (S/4HANA), App ID - F1747
You can use this app to view the Key Performance Indicator (KPI) Overdue Receivables. You can drill down to analyze the 10 highest overdue receivables by customer, which enables you to take quick action to
reduce the highest amounts owing to your business. You can also analyze overdue receivables by company code or by accounting clerk. You can view the overdue receivables in a chart or a table according to
company code, customer, country and region of the customer, and accounting clerk.

2- Future Receivables (S/4HANA), APP ID - 1744

This analytical app displays the Key Performance Indicator (KPI) Future Receivables. You can view the results in a chart or table according to due period, company code, or the top 10 customers who have the
highest amounts receivable. You can also drill down to see the numbers of open items for the relevant customers. In addition, you can analyze your future amounts receivable according to account group,
accounting clerk, company code, country key, customer, customer classification, display currency, exchange rate type, G/L account, net due interval, region, or special G/L.

3- Overdue Receivables in Dispute, APP ID – F2540

With this app you can display the amount of overdue receivables in dispute. It allows you to prioritize the open disputes that are delaying the payment of overdue
invoices.

4- Cash Flow - Detailed Analysis, App ID – F0740

With this app you can get an overview of the daily cash inflows and outflows, and analyze them for the last weeks or months for all subsidiaries and liquidity items. You can then identify
the extraordinary and abnormal cash flows, ensure that they were accurate and compliant, and that they have taken the liquidity planning into account. The data presented in the app
can be used to give an overview of the cash flow status to the management.

5- Actual Cash Flow, APP ID – F0513A

With this app, you can gain an overview of the daily cash flows for the past 90 days. This KPI helps you identify unusual inflows and outflows and take action accordingly. You can filter
and drill down by various dimensions. This app is available for the roles of Cash Manager and Cash Management Specialist.

6- Incoming Sales Orders - Predictive Accounting, APP ID – F2964

This analytical app allows you to evaluate and analyze predicted revenues, cost of sales, margins, and sales deductions based on incoming sales orders. The app uses predictive postings, which are generated in
the predictive ledger based on sales orders, goods issues and billing documents. You can use the features of the app to more deeply analyze the structure of the predicted cost of sales, sales deductions, and
orders at hand.

38
Finance – Fiori Analytical apps
7-Days Payable Outstanding Analysis (S/4HANA), APP ID – 1740
With this app you can drill down to check the top 10 suppliers with the highest or the lowest days payable outstanding. You can view the result in a chart or a table according to
company code, supplier, country of the supplier, and timeline.

8- Accounts Receivable Overview, APP ID - 3442

With this analytical overview app you can monitor important accounts receivable indicators and access the relevant accounts receivable apps. You can use the filters to limit the data
behind the indicators to the information most relevant for you.

9- Days Sales Outstanding (S/4HANA) , APP ID – F1741

The analytical app displays the Key Performance Indicator (KPI) Days Sales Outstanding, that is, the number of days it takes on average for your company to collect receivables. A
high Days Sales Outstanding (DSO) figure can indicate that your company is taking too long to collect money, and that your company is extending too lenient credit terms to customers.
The app clearly indicates when predefined thresholds have been exceeded. You can view DSO figures in a chart or a table according to account group, accounting clerk, calendar
month, calendar year, company code, country key, customer, customer classification, display currency, exchange rate type, G/L account, reconciliation account, region, or special G/L.

10- Aging Analysis (S/4HANA), App ID – F1733

With this app you can see the aging information across your organization so that you can identify negative trends in the total payable amount, the net due amount, and the overdue
amount. This allows you to timely react by having your team taking appropriate actions to reverse these trends.

11- Cash Collection Tracker - Accounts Receivable, App ID F2925

With this analytical app you can track your collection progress against due receivables for a selected period. You select a period or date and the app displays the sums of all open
invoices due in previous periods, invoices posted in previous periods that are due in the selected period, and new invoices that are both posted and due in the selected period. The sum
of these due receivables forms the total target.

12- Days Beyond Terms (S/4HANA), APP ID – F1739

The analytical app displays the Key Performance Indicator (KPI) Days Beyond Terms. It provides you with an insight into the payment history of your customers and indicates how
effectively your company collects payments. A high Days Beyond Terms (DBT) figure indicates that your company is taking too long to collect payments. The app clearly indicates when
predefined thresholds have been exceeded. You can view DBT figures in a chart or a table according to account group, accounting clerk, calendar month or year, company code,
country key, customer, customer classification, display currency, exchange rate type, reconciliation account, or region

13- Group Data Analysis, App ID – W0135 (complex)

With this app, you can display different views of consolidated data: Group View based on the group structure that includes consolidation groups and units and Hierarchy View based on
hierarchies of profit centers, segments, and consolidation units. By selecting different FS item hierarchies within the app, you can generate consolidated financial statements (FS) such
as balance sheet and profit and loss statement.

39
Finance – Fiori Analytical apps
14- Trial Balance, App ID – F0996
With this app you can display debit or credit balances for a specified time range. You can do this for each ledger and all company codes. If you select individual
periods only, you can show the balances of the previous and the following periods in the reporting year.

15- Plan Actual Comparison, App ID – F3700

With this app you can compare and analyze your planned closing times against your actual closing times for the current closing cycle.

This application is not assigned to a business catalog. To add this application to your SAP Fiori launchpad, you can create a reference from the technical catalog of
the app to your business catalog.

16 - Cost Centers - Plan/Actual, App ID – F0949

With all Analytical Apps for Management Accounting you can report on actual and plan data for different entities relevant for management accounting. The name of
the app indicates the entity as well as the type of data,
likewise, there are apps Cost Centers - Plan/Actual, Profit and Loss – actuals, Internal orders (App ID – F0958)– Plan/actuals (APP ID – W0076)

17- Sales Accounting Overview, APP ID – F3228

With this app you can easily access key information and KPIs within the Sales Accounting area, and gain insight into current trends. The app provides a central
source of information for the sales accountant, and offers a range of filters and built-in navigation to related apps.

18 - Monitor GR/IR Account Reconciliation, App ID – F3303

With this app you can get an overview over the status of open items on your GR/IR accounts that need clarification. You can analyze the goods and invoice receipts
reconciliation by KPIs for purchasing document items and open FI items. After you have detected where you would like to dive deeper, you can also navigate from
this app to the Reconcile GR/IR Accounts app where you can investigate the details or even start to further clarify purchasing document items where amounts or
quantities in goods receipts and invoice receipts do not match.
19 - Financial Status (Book Value), APP ID – F2136
This analytical app displays the financial status of a company or group of companies on a specific key date and allows you to drill down to individual financial
positions. These financial positions can have either of the following data sources based on user-defined parameters: treasury positions from Treasury and Risk
Management, bank account balances from Cash Management, and account balances from the general ledger.

40
Finance – Fiori Analytical apps
20- Analyze Overdue Items, APP ID – 086
With the Analyze Overdue Items app, you can display how many items are overdue in Contract Accounts Receivable and Payable (FI-CA) or what the total amount is that overdue
items add up to. You can total or filter the amount and number of overdue items by various criteria.

Pre-requisite:
you can only use this app if you are using one of the following industry solutions that includes Contract Accounts Receivable and Payable (FI-CA): SAP Contract Accounts Receivable
and Payable , SAP Utilities, SAP for Public Sector SAP for Insurance.
The app only accesses postings and data from Contract Accounts Receivable and Payable and not data from other subledgers such as Accounts Receivable (FI-AR) and Accounts
Payable (FI-AP).

41
ABAP CDS Views – 1/2

Custom Analytical Queries Custom CDS Views ABAP Development Tools

Fiori Application Fiori Application Eclipse-Based IDE
Develop new queries based on
Develop new ABAP CDS Views by Develop new ABAP CDS Views,
Use released cube or dimension ABAP
joining together released cube or edit existing ones, and extend
Case CDS views or copy existing
dimension ABAP CDS Views standard ones with a full feature set
released query ABAP CDS Views
• Easy to use
• No need to install client tools • Easy to use
• Ability to add filters, • No need to install client tools • Feature-rich integrated
Pros remove/hide fields, customize • Ability to perform simple joins development environment for
names/formatting of fields, and on ABAP CDS Views via a ABAP CDS Views
add calculated measures via a graphical interface
graphical interface
• Restrictive toolset
• Inability to pull in additional data • Inability to create complex logic • Requires installation of client
Cons if it is not already exposed via • Inability to consume unreleased tools
the ABAP CDS View ABAP CDS Views • Requires developer skillset
• Inability to add scripting logic

42
ABAP CDS Views – 2/2

43
Fiori Analytical vs Business Intelligence solutions

44
Appendix

45
CDS Views Usage Scenario

• The source of Fiori apps (OData)

• The source of Web Dynpro Grid or Design Studio
• The source of API (OData)
• The source for external BW system
• Compatibility View is created with CDS View
• CDS View is available in ABAP Program

46
Application type - Summary
Classification Description Interface/Data source Tools
Generic Graphically Drill down capability OData Manage KPIs
Drilldown App and Reports
Analytical List Page Combination of Chart & Tables. Can be develop by SAP Fiori OData Manage KPIs
elements and Reports + Fiori tools
Fiori elements app Template based app, leverage UI annotation to develop presentation. OData BAS (Business Application
This includes List Report, Worklist, Overview Page, Analytical Studio) on BTP
List Page.
Freestyle Apps created with SAPUI5 free style but with high TCO OData BAS (Business Application
Studio) on BTP
Analysis Path Predefined visual steps to explore business data OData OData APF Config
Framework

Web Dynpro Grid / Pivot table. Design studio phased out, should focus on Web Dynpro Analytic
Design Studio based grid. Query

47
SAP Analytics Cloud (SAC) Integration

• SAC stories can be integrated in Fiori launchpad as a Tile.

• It’s gives seamless user experience to access S/4 transactional/Analytical apps along with
SAP analytics cloud stories from one single place.

48
Embedded Analytics vs Data Warehouse

Enterprise
Embedded
Concern Data
Analytics
Warehouse

Do you require operational real-time reporting? Real-Time Reporting

SAP S/4HANA Embedded Analytics provides real-time reporting without the requirement to
Yes No
replicate or federate data into an additional system.

Would you like to leverage standard SAP content? Standard Content

SAP S/4HANA provides a great deal of standard content in tables, ABAP CDS Views, and Fiori
Applications which can be used instead of building custom content in an enterprise data Yes No
warehouse.

Do you wish to integrate reporting with transactional applications? Simplified User Experience

SAP S/4HANA provides intent-based navigation to seamlessly transition between transactional

Yes No
and analytical Fiori Applications for both standard and custom content.

49
Embedded Analytics vs Data Warehouse

Enterprise
Embedded
Concern Data
Analytics
Warehouse

Do you need to cleanse the data before reporting? Data Cleansing

An enterprise data warehouse is better suited for detecting and correcting/removing inaccurate data during
No Yes
the staging process.

Do you need to harmonize, transform or enhance the data before reporting? Data Harmonization

An enterprise data warehouse is better suited for harmonizing or transforming data during the staging
No Yes
process.

Is there a requirement for complex hierarchies? Complex Hierarchies

S/4HANA Embedded Analytics provides standard hierarchies, e.g. for cost center reporting. However,
No Yes
complex hierarchy creation and processing is better suited for an enterprise data warehouse.

Do you work with time-dependent master data? Time Dependency

S/4HANA Embedded Analytics usually provides the view on the data as-is when the report is executed on
the actual data and the master data change history is usually not kept in the system. An enterprise data
No Yes
warehouse provides time-dependency features for master data that allows for the maintenance of historical
master data attributes and texts that are shown in reporting based on the key date.

50
Embedded Analytics vs Data Warehouse

Enterprise
Embedded
Concern Data
Analytics
Warehouse

Do you need to consolidate data from multiple sources? Multiple Data Sources

Loading data from multiple source systems usually yields high data volumes and requires complex consolidation logic
that results in high system resource utilization. This requirement is better satisfied by an enterprise data warehouse to No Yes
ensure business-critical transactional workflows are not negatively impacted.

Are complex calculations or logic required? Complex Logic

This requirement is better satisfied by an enterprise data warehouse to ensure business-critical transactional workflows
No Yes
are not negatively impacted by the high resource utilization required to process complex logic.

Do you have a requirement to freeze data based on time slices? Data Snapshot

Snapshots are better realized in an enterprise data warehouse as this will require data redundancy and thus will highly
No Yes
contribute to the overall data volume.

Do you need to perform long-term trend analysis? Data Retention

Long-term data analysis requires long retention periods that typically exceed that of granular data in an ERP system. An
enterprise data warehouse provides the ability to store aggregated data that is better suited for reporting against longer No Yes
periods of time.

51
Helpful Tips

• View Browser” to find VDM/CDS View.

• /N/UI2/FLP – Fiori Launchpad
• /N/UI2/FLPD_CUST – Fiori Launchpad Designer
• SEGW – SAP Gateway Service Builder
• /N/IWFND/MAINT_SERVICE – Activate and Maintain Services
• /N/IWFND/ERROR_LOG – SAP Gateway: Error Log
• SICF – Define Services
• T.code “SDDLAR” to see CDS View definition in SAPGUI.
• T.code “RSRT” to run Analytic Query of CDS View.

52
Thank You….
NS
SAP Bookshelf & Insides

53