Week 1: Introduction, Overview, and Business User
Unit 4: Using Multidimensional Reports
Using multidimensional reports
SAP S/4HANA analytics overview
SAP S/4HANA SAP Analytics
SAP S/4HANA embedded analytics, powered by SAP Fiori and SAP Analytics SAP Analytics Cloud, for
▪ SAP Fiori analytical apps for the business user Real-time access to Enterprise Planning
▪ SAP Fiori extensibility apps for the analytics specialist SAP S/4HANA data and BI
Data replication of
SAP S/4HANA data SAP BW/4HANA,
(both using the virtual SAP Data Warehouse
Spend off- Incoming PO avg. Non-managed ….
data model) Cloud
contract sales order delivery time purchasing spend
SAP S/4HANA – Virtual Data Model
SAP HANA DB SAP HANA DB
▪ Provide embedded insights in the solution, optimally support business users in defined business processes with decision support and information at the user's fingertips
▪ Integrate seamlessly into the enterprise intelligence offerings such as SAP Analytics Cloud and SAP BW/4HANA
▪ Provide real-time access to solution data as well as replication of data and blending with multiple other sources for end-to-end enterprise intelligence
© 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 2
Using multidimensional reports
Recap – The business user persona
▪ Uses SAP S/4HANA embedded analytics in the context of a business process
or line-of-business departmental activities, typically no IT background.
▪ Here are a few of many examples (have a look at
[Link]
− Material planner:
SAP Fiori app in SAP S/4HANA: Stock Availability Analysis for Just-In-Time
Calls, F3923
− Purchaser:
SAP Fiori app in SAP S/4HANA: Manage Purchase Requisitions, F1048
− Collection supervisor:
SAP Fiori app in SAP S/4HANA: Supervise Collections Worklist, F2375
− Sales clerk:
SAP Fiori app in SAP S/4HANA: Sales Order Fulfillment Issues, F0029A
© 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 3
Using multidimensional reports
Recap – Overview of current offering per user type
we are here
SAP S/4HANA Business User: Analyze the data and act according to insights SAP Analytics
▪ separate products/services
Smart Embedded ▪ direct access to SAP S/4HANA data
Multi- Analytical
dimensional
Business KPIs, Analytical list Overview
SAP Fiori
SAP Analytics ▪ Dashboards and Digital Boardrooms developed
analysis path pages pages Cloud by SAP S/4HANA, available for SAP Analytics
reports apps
apps dashboards Cloud
SAP S/4HANA Analytics Specialist: Enable the Business User
Other SAP BI
Products:
SAP Analytics
Cloud Examples: Analysis
Key user tooling KPI and report for Office, Design
(e.g. Query Designer) modeling apps Studio, …
SAP S/4HANA IT User: Provide the single source of truth in one semantic layer
View maintenance:
ABAP for Eclipse
© 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 4
Using multidimensional reports
Recap – Capabilities for the business user
Smart Business KPIs Overview Pages Analytical List Pages
• KPI monitoring on SAP Fiori launchpad • Consolidated view on a certain domain, e.g. Purchasing • Generic approach to mix analytical and transactional activities
• Drill-down into further analytical or transactional apps • Information presented in analytical tables and charts • Display table or chart or a combination
• Save personal variants • Take action in the same place or navigate to other apps • Take action directly in the same app or navigate to other apps
• Save personal variants • Save personal variants
we are here Powered by SAP Analytics Cloud
In-App Analytics and ML Multidimensional Reports Dashboards
• Combine analytics with transactional content in one screen • Analyze and visualize data from multiple dimensions • SAP S/4HANA: Optional, additional content, stories (SAP
• Insight-to-action to prioritize based on facts • Display pivot-table or chart or a combination S/4HANA data only) shipped via analytics content repository
• Use drill-downs to determine transactional input parameters • Save personal variants • Used as templates, customers will copy and adapt
• SAP S/4HANA Cloud: SAP Fiori-embedded SAP Analytics Cloud
© 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC content, stories come as part of SAP S/4HANA Cloud apps5
• Queries supplying the data are shipped with SAP S/4HANA
Using multidimensional reports
Business user: analyze the data and act according to insights
Embedded
Multi- SAP Smart SAP Analytical
Analytical Overview
dimensional Business Analytics SAP Fiori
list pages pages
reports KPIs Cloud apps
dashboards
▪ Slice and dice, sort, filter
▪ Subtotals at any level
▪ Drill down, drill across
▪ Swap rows and columns
▪ Display chart and table
▪ Save personalized views
▪ Navigate to other SAP Fiori
apps
© 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 6
Using multidimensional reports
Business user: analyze the data and act according to insights
Embedded
Multi- SAP Smart SAP Analytical
Analytical Overview
dimensional Business Analytics SAP Fiori
list pages pages
reports KPIs Cloud apps
dashboards
Typically used
▪ For insight-driven, explorative, and flexible
analysis of large amounts of data
▪ For data centered around one specific topic,
such as sales orders, purchase orders,
G/L line items, cost center reporting,…
▪ Examples of SAP Fiori apps:
− Incoming Sales Orders (F1249, role
SAP_BR_SALES_MANAGER)
− Cost Centers – Actuals (F0963A, role
SAP_BR_OVERHEAD_ACCOUNTANT)
© 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 7
Using multidimensional reports
Demo
How to use multidimensional reports
© 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 8
Using multidimensional reports
Key takeaways
▪ A multidimensional app in general works like a very
elaborate pivot table.
▪ The user can explore the data using slice and dice,
filtering, sorting, showing subtotals, and viewing the
data in a chart.
▪ From the data in a multidimensional report, the user can
easily navigate to other SAP Fiori apps, while keeping
the context like the selected ID.
▪ The result set of a multidimensional report can be
extensively personalized. The personalization is saved
in variants.
▪ A certain variant can be set as the default. Variants can
also be shared with others by making them “public”.
▪ The role of the analytics specialist has all the tools to
create additional, customer-defined multidimensional
reports.
© 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 9
Using multidimensional reports
Where to find more information
Blogs Books
SAP S/4HANA embedded analytics
SAP S/4HANA embedded analytics – User Roles
Machine Learning and Predictive Analytics with SAP S/4HANA
Implementer’s Guide to S4-based Financial Planning & Analysis
for SAP S/4HANA using SAP Analytics Cloud
SAP S/4HANA Embedded Analytics – A Step Ahead and Beyond |
SAP Blogs
Part 1 – SAP S/4HANA Cloud Data Integration to power your
Intelligence Enterprise
Part 2 – SAP S/4HANA Cloud Data Integration Overview
Creating Dynamic Date filter using the Manage Date Function App
Six reasons why Web Dynpro is Better than Design Studio in SAP
S/4HANA Cloud
SAP Docu Others
SAP S/4HANA 2020 OP YouTube: SAP S/4HANA Cloud
SAP S/4HANA Cloud 2105 SAP Fiori Apps Reference Library
© 2021 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 10
Thank you.
Contact information:
open@[Link]
Follow all of SAP
[Link]/contactsap
© 2021 SAP SE or an SAP affiliate company. All rights reserved.
No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of
SAP SE or an SAP affiliate company.
The information contained herein may be changed without prior notice. Some software products marketed by SAP SE and its
distributors contain proprietary software components of other software vendors. National product specifications may vary.
These materials are provided by SAP SE or an SAP affiliate company for informational purposes only, without representation or
warranty of any kind, and SAP or its affiliated companies shall not be liable for errors or omissions with respect to the materials.
The only warranties for SAP or SAP affiliate company products and services are those that are set forth in the express warranty
statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional
warranty.
In particular, SAP SE or its affiliated companies have no obligation to pursue any course of business outlined in this document or
any related presentation, or to develop or release any functionality mentioned therein. This document, or any related presentation,
and SAP SE’s or its affiliated companies’ strategy and possible future developments, products, and/or platforms, directions, and
functionality are all subject to change and may be changed by SAP SE or its affiliated companies at any time for any reason
without notice. The information in this document is not a commitment, promise, or legal obligation to deliver any material, code, or
functionality. All forward-looking statements are subject to various risks and uncertainties that could cause actual results to differ
materially from expectations. Readers are cautioned not to place undue reliance on these forward-looking statements, and they
should not be relied upon in making purchasing decisions.
SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered
trademarks of SAP SE (or an SAP affiliate company) in Germany and other countries. All other product and service names
mentioned are the trademarks of their respective companies.
See [Link]/trademark for additional trademark information and notices.
