Expert Guided Implementation

SAP Analytics Cloud, Digital Boardroom and

Analytics Hub
Day 4
Vishal Shakya, SAP
Expert Guided Implementation powered by SAP Enterprise Support Academy*
PUBLIC

* Content is exclusive to SAP Enterprise Support customers

Disclaimer

▪ The information in this presentation is confidential and proprietary to SAP and may not be disclosed without the permission of SAP. Except
for your obligation to protect confidential information, this presentation is not subject to your license agreement or any other service or
subscription agreement with SAP. SAP has no obligation to pursue any course of business outlined in this presentation or any related
document, or to develop or release any functionality mentioned therein.
▪ This presentation, or any related document and SAP's strategy and possible future developments, products and or platforms directions and
functionality are all subject to change and may be changed by SAP at any time for any reason without notice. The information in this
presentation is not a commitment, promise or legal obligation to deliver any material, code or functionality. This presentation is provided
without a warranty of any kind, either express or implied, including but not limited to, the implied warranties of merchantability, fitness for a
particular purpose, or non-infringement. This presentation is for informational purposes and may not be incorporated into a contract. SAP
assumes no responsibility for errors or omissions in this presentation, except if such damages were caused by SAP’s intentional or gross
negligence.
▪ 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, which speak only as of their dates,
and they should not be relied upon in making purchasing decisions.
▪ The figures shown are subject to vary, and are for demonstrative purposes only. If you decide to follow the steps in the demonstrations,
(which we encourage), please be aware that the screenshots are unlikely to be an exact match with your own results. This is due to
changes in the numbers and the dates. The screenshots are for the purpose of guidance only.

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

Expert Guided Implementation
SAP Analytics Cloud, Digital Boardroom and Analytics Hub

Agenda

4. Day Four
▪ Overview of Connections
▪ Simple Deployment Kit
▪ S/4HANA Integration
▪ SAC Integration with Analysis for Office
▪ Security
▪ Administration
▪ Authentication
▪ Monitoring
▪ Troubleshooting
▪ Best Practices for Model and Story Building
▪ Recommended Number of Tenants

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 3

Overview of Connections

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

Data Integration
Connect to data anywhere stored in on-premise databases, cloud databases, and personal files.

Live connections
▪ Data replication is not required
▪ Leverage business metadata
directly without additional
modeling
▪ Leverage existing security and
data authorizations

Data import connections

▪ Business users can model data
with Smart Data Preparation
▪ Easily track and reverse data
transformations
▪ Refresh data on demand or via
schedule

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

 Data Sources

Live Import

SAP cloud data sources Cloud data sources

SAP Cloud Platform1 SAP Marketing Cloud SAP S/4HANA Cloud SAP Business ByDesign SAP Cloud Platform1 SAP Concur SAP Fieldglass

SAP Commissions SAP Cloud for Customer SAP Marketing Cloud SAP S/4HANA Cloud SAP SuccessFactors

SAP Workforce Analytics Dow Jones DNA Google BigQuery Google Drive Google Sheets
SAP on-premise data sources
OData Salesforce Qualtrics SCP Open Connector
SAP HANA SAP BW SAP BW4/HANA SAP S/4HANA

SAP BPC Embedded SAP BusinessObjects Universe

SAP on-premise data sources
SAP BPC NW & MS SAP BusinessObjects Universe SAP BW SAP BW4/HANA SAP ERP
Access via SDI for SAP Cloud Platform & SAP HANA2
SAP HANA SAP Integrated Business Planning SAP S/4HANA
Apache Hive AWS SAP Vora SAP Sybase ASE, IQ, ESP OData

Microsoft SQL Server Spark SQL Oracle Teradata MaxDB Other data sources
IBM DB2 MySQL Netezza Facebook Google+ Twitter IBM Microsoft SQL Server MySQL Netezza OData Oracle
CSV Excel Progress OpenEdge Same data sources as SAP BI 4.23
Partner delivered
APOS DB2 Denodo Microsoft Analysis Services Microsoft Azure Partner delivered
Microsoft SQL Server MongoDB MongoDB Atlas MySQL Netezza APOS CDATA DataDirect Cloud EPI-USE Labs

Oracle Oracle Essbase Oracle Exadata SAP IQ SAP SQL Anywhere Web Intelligence QuickBooks eloqua SAP Payroll

Redshift Teradata Google BigQuery Cloudera Hortonworks Microsoft SharePoint Google Analytics SAP Payroll Config

Amazon S3 NetSuite CRM & ERP Microsoft Dynamics CRM SAP OnPrem Reporting

Oracle Marketing Cloud Hubspot

Delivered Planned within the next 6 months Partners
1. Requires SAP Platform DBaaS license MongoDB Marketo
2. SAP Cloud Platform connects to data using Smart Data integration and Smart Data Access Adapters
3. This does not require the BI Platform
SugarCRM

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

 Combine and Query any Data
Create end-to-end scenarios by combining on premise and cloud data

Cloud Data Sources Eg. SAP Cloud Platform,

Eg. Google Drive & Sheets Live Data Connection HANA, BW, BWoH, BW/4
Google Big Query HANA, Universe, S/4HANA
SAP Cloud Platform Cloud Edition, S/4 HANA
SuccessFactors
Concur
Hybris Cloud for Customer
SAP Business ByDesign
OData
SAP Analytics Cloud
Import Data Connection Built on SAP CP
Data is imported to cloud

SAP Data Sources

Eg. SAP BPC NW & MS
SAP BW, Universes
SAP ECC, UNX, ERP
Other Data Sources
IBM, MS SQL Server,
MySQL 5, Oracle,CSV, XLSX

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

Comparison Matrix

All selected data is replicated to SAP Analytics Cloud. SAP Analytics Cloud then
Import stores the model and data. Security can be added to the model within SAP
Analytics & Planning Analytics Cloud. Both Analytic and Planning models generate an account type
model. It is possible to schedule regular imports.

All data stays within the SAP Cloud. The data is not
Cloud data source
replicated to SAP Analytics Cloud. Modelling and model
SAP Cloud Platform, security is managed on the source system.
SAP S/4 HANA Cloud Data connection between systems is secured within SCP.

Live
Analytics & Planning

On-premise data source All data stays within the customer landscape. The data
is not replicated to SAP Analytics Cloud. Modelling and
SAP HANA, BW, S/4HANA, model security is managed on the source system.
SAP BusinessObjects Data connection between systems via CORS is secured.

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 8

Simple Deployment Kit

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

Simple Deployment Kit
SAP Analytics Cloud (SAC) allows for data acquisition from various on-premise and cloud solutions,
including SAP ERP, BW, SAP Cloud applications, SAP BI 4.x universes, OData sources, SQL
sources (via JDBC) and many more.

SAP Cloud Platform Cloud Connector (SCP CC) :

• An actual service that establishes a secure
network tunnel between the on-premise network
and the SAP Analytics Cloud network.
SAP Analytics Cloud Agent (SAC Agent) :
• Uses the secure network tunnel, is a web app
that serves as an application-aware middleware
to retrieve data from the on-premise backend
systems.

It is recommended that the SAP Cloud Connector (SAP CP CC) and SAP Analytics Cloud agent
are installed together on a dedicated Windows server on the same network as the on-premise
system or data source.
© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 11
Simple Deployment Kit
SAP offers the SAP Analytics Cloud Agent Simple Deployment Kit to streamline the installation
process. Reducing installation time from typically over 1 hour to less than 10 minutes.

SAP Analytics Cloud Agent Simple Deployment Kit

automatically downloads and installs the following
components that are needed to connect to SAP
Analytics Cloud
▪ Tomcat
▪ Cloud Connector
▪ Analytics Cloud Agent
Running the Kit is simple. Unzip the downloaded
file and run setup script. Once finished simply
configure the Cloud Connector and the cloud Agent.

For Further information:

https://www.sapanalytics.cloud/resources-
deployment-kit/

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 12

S/4HANA Integration

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

 SAC Integrated Analytics
S/4HANA Integration

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

SAC Integrated Analytics
S/4HANA Integration

1) Create a Live/Import Connection to S/4HANA

2) Create a ABAP CDS view in S/4HANA with
Annotation '@Analytics.query = True' (This
Annotation will help in generating a Transient
Query)
3) Create a Model in SAC, using the source as a
Transient Query.
4) Create the SAC Visualisations as per
requirement

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 15

SAC Integrated Analytics
S/4HANA Integration

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

SAC Integration with Analysis for Office

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

SAC Integration with Analysis for Office

You can use SAP Analytics

Cloud models as data sources in
SAP Analysis for Microsoft Office
and SAP Analysis for Microsoft
Office, edition for SAP Analytics
Cloud.

With Analysis for Microsoft

Office, you can create your own
private versions, add planning
data, and publish your planning
data back to SAC model.

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

SAC Integration with Analysis for Office

With the SAP Analytics Cloud for

Office, you can connect, organize,
and explore your plans and budgets
in a familiar experience with
colleagues together on your
(Windows or Mac) laptop, at work, at
home, or on the road.

Maximize planning and reporting

with the all-in-one business
intelligence, planning, and predictive
solution together with spreadsheets.

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

SAC Integration with Analysis for Office
Extending options to prepare and analyze data

▪ SAP Analysis for Microsoft Office workflows and user experience based on SAP Analytics
Cloud data.

▪ Workflow starts in Excel – logon, browse for models, discover data.

▪ Select table designs with SAP Analysis for Microsoft Office and perform conditional formatting.

▪ Consume native cloud models as measure-based SAP Analysis for Microsoft Office models.

▪ Work offline on a local snapshot of data.

▪ Read-access for planning models.

Further information can be found in the SAP Analysis for Microsoft Office product roadmap: https://www.sap.com/canada/products/roadmaps.products-solutions.html
© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 20
SAC Integration with Analysis for Office
Restrictions

Analysis only supports the usage of the

default currency (similar to cloud chart
behaviour). You cannot access non-converted
currencies (similar to a cloud table).

You cannot consume defined thresholds from

the model definition. In Analysis, you can use
conditional formatting and Table Design
formatting.

Analysis cannot visualize SAP Analytics

Cloud data locking. Therefore you can
change the data in locked cells in Analysis,
but you cannot recalculate and save the
changed data.

Comments added to SAP Analytics Cloud

models are not displayed in Analysis.

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 21

SAC Integration with Analysis for Office

Step 1 1
Open Analysis for Office, navigate to
Analysis tab. From Insert Data
Source menu, choose Select Data
Source for Analysis.

Step 2 2
Select SAP Analytics Cloud tenant
you want to connect to or create a
new connection to your SAC tenant.

Step 3
3
Select the model you wish to open in
Analysis for Office.

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

SAC Integration with Analysis for Office

Step 4
In the Analysis Panel on the
right hand side, drag and drop
dimensions and measures you
want to work with, apply filters
and set the drill level.

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

SAC Integration with Analysis for Office

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

SAC Integration with Analysis for Office
SAP Analytics Cloud add-in for Microsoft Office

At a glance, the add-in enables you

to:
▪ Analyse SAP Analytics Cloud models
in Excel
▪ Deepen your analysis with filters,
totals and Excel formulas
▪ Add data for planning and save it back
to the cloud
▪ Update your table with the actual data
from SAP Analytics Cloud at any time
▪ Share your Excel workbooks with
others

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 25

Security

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 26

Security
User Management

▪ SAP Analytics Cloud uses SAP Cloud Identity as the default authentication method.

▪ Single Sign-On (SSO) authentication to a custom-identity provider can be configured using

SAML 2.0 protocol.

▪ SAP Analytics Cloud provides basic user management, including creating, deleting, changing,
and role assignment.

▪ You can also import user data if you want to synchronize users with other systems or maintain
users in batch mode:
▪ Importing from CSV file.
▪ Create users automatically by enabling the Dynamic User Creation feature when configuring a custom
SAML Identity Provider.
▪ Create users programmatically via the User and Team Provisioning API.

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 27

Security
Users and Roles

▪ A Role can contain many Users

and a User can be in many roles.

▪ Need to have multiple roles,

because a single role can only
consume:
▪ One license type by application
(Analytics Hub, BI, Planning Pro,
Planning standard).
▪ One license type by user license
(named user, concurrent session)

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 28

Security
Defining Users, Teams, Roles and Security

▪ Directly enter the user ID and additional information to add a new user. A user ID cannot be changed once it has
been created.
As a default, after a user’s email is
▪ The display name is used through SAP Analytics Cloud where a user name is displayed. entered and the user is saved, the
▪ Email can be used to receive system notifications. user will be sent an email asking
them to get register with SAP Cloud
▪ Manager information can be used for a user to request system access via self-service roles. Identity.
▪ User Type (license) is determined by the roles assigned to the user and the licenses available.
▪ .X509 User Mapping can be used to link to a user’s SAML Identity in an external SAML Identity Provider.

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 29

 Security
Import Users from CSV File

You can upload valid users with a simple

file. This can include all their role
assignments.
1. Define mapping – this is a mandatory
step.
2. Select the target field from the drop-
down list.
3. Default mapping is proposed.
4. You need to add an initial password for all
users to be imported.
5. After you choose the Import button on
the Import Users pop-up, the new users
are saved.

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 30

Security
Roles

▪ Roles define:
▪ What activities a business user can conduct in the
application
▪ What data in a model a business user can access

▪ When a user is assigned to a role, he will get all the

privileges defined in the role.
▪ When a user has multiple roles assigned, he will
get the union of all privileges defined in all these
roles.
▪ Roles can be requested by user through self-
service.
▪ A user cannot see a menu if the role does not have
the privilege of the function associated with the
menu.
© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 31
Security
Predefined Roles

• Predefined Roles :
• Admin
• Modeler / Planner Reporter / Viewer
• BI Admin / BI Content Creator / BI Content Viewer
• SAPCP Content Creator / SAPCP Content Viewer
• Predictive Analyst / Predictive Administrator / Predictive Content Creator
• Analytics Hub Admin / Analytics Hub Content Creator / Analytics Hub Viewer
• Boardroom Creator / Boardroom Viewer

• HANA Analytic Privileges can be reused in SAC Roles.

• The System Owner is the primary administrator and contact
person for the system. This role includes all user privileges
to allow unrestricted access to all areas of the application.
Only one user in the system can have this role.
• The system owner can transfer the role to another user.

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 32

Security
Teams

▪ A Team can contain multiple users and a user can belong to multiple Teams.

▪ Teams can have their own folder, but generally is more problematic than beneficial.

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 33

Security
Teams

▪ Use Teams to group your Roles

▪ Teams can ‘aggregate’ roles together.
▪ If a Team or User is a member of multiple roles, they inherit the
‘Union’ of the roles rights.

▪ Include the Team name in the Teams Description.

▪ Currently Team Names are not shown when sharing content, only
the description is.

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 34

 Security
Best Practices for Assigning Roles

1. Assign Users to Teams

2. Assign Roles to Teams

By assigning people to teams then roles to the team, you indirectly assign the role to the users.

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 35

Security
Folder, File Security

• You can define individual sharing settings for

each object or folder.

• You can define who should be able to access

the content by either specific users or teams.

• You can determine which access rights they

should get, if subfolders and files should be
included.

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 36

Security
Data Access Control
Two ways to define data access in a model:
1. Read/Write Property in Dimension 2. Data Access Filter in Role

Condition: Data Access Control on Dimension Condition: Privacy flag on Model must be switched on
Preferences must be switched on

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 37

Data Access Control
Read/Write Property in Dimension

Access Assignment Data shown in Report

 Apply to all the models that use this dimension

 One model can have more than one data-access-control-enabled dimension
 Access defined on hierarchy node will be propagated to its descendants, but will be overwritten if
another access is defined on a lower-level node
 Write includes read access
 Write controls the publishing (user can change data in his private version without write access )
© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 38
Data Access Control
Define Data Access Filter in Role

 You can only select a model whose Privacy is On

 Full Access: All the data in the model can be read and write
 Multiple filters can be created on one model, the data access on
this model will be the union of these filters
 Write access includes the read access
 If Data Access is Enabled on dimension, access filter will be
based on data region restricted by data access defined in
dimension
© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 39
Administration

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 40

Administration

Administration interface provides various

tools to change system settings or perform
additional configurations.

This includes changing single parameters,

establishing SSO, or connecting other
services to SAP Analytics Cloud.

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 41

 Administration

▪ System Configuration: Configure miscellaneous

settings.
▪ Datasource Configuration: Manage information
needed to connect to remote systems.
▪ Security: Configure the authentication method
used by SAP Analytics Cloud.
▪ R Configuration: Configure connection settings
to an external R environment.
▪ App Integration: Manage third-party application
access by using OAuth clients and trusted identity
providers.
▪ Notifications: Choose users to deliver system
event notifications to, during service disruption.
▪ Appearance: Customize the default homepage
logo and background color for all users.
▪ Catalog: Active Catalog feature

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 42

Authentication

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 43

Security Authentication

SAP Cloud Identity (Default)

▪ SAC uses SAP Cloud Identity as the default authentication method.
▪ When you get the tenant URL and login for the very first time to SAP Analytics Cloud, you are
redirected to SAP Cloud Platform Identity Authentication service. This is the SAML Identity Provider
used by default.
SAML SSO
▪ SSO authentication to a custom IDP can be configured
using SAML 2.0 protocol.
▪ SAML is an open-standard data format for exchanging
authentication and authorization data between parties.

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 44

Single Sign On (SSO)
When planning to establish SSO, several prerequisites must be met within SAC:

▪ The Identity Provider must comply with the SAML 2.0

protocol
▪ You have to determine a unique attribute on which the
user is mapped between SAC and the identity provider. In
a lot of cases, this is either an email address or a unique
user ID.
▪ If you want to use the identity provider to authenticate
against your data sources (e.g. SAP BW) you have to
make sure that both SAC and the data source use the
same identity provider. We recommend setting up SSO for
live connections, This way, the authorizations from the
data source are applied in SAC.
▪ If you want to assign roles and teams using SSO, you
must configure additional SAML tags in your identity
provider. Those tags contain all roles that the user own
and all teams the user belongs to. Therefore, they must
be created and maintained in the identity provider.

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 45

Monitoring

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 46

System Monitor

The System Monitor provides a number of interactive dashboard-style overviews of the key areas
of usage and performance that a system administrator needs to monitor.

Monitoring information shows the current state of the system and also historical information for a
selected time frame in the last year. The monitor also includes Trace (a system log), containing
details of all traceable events and errors.

These monitoring features are available on four separate tab pages:

▪ Overview
▪ System Usage by Memory
▪ System Usage by User
▪ Trace

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 47

System Monitor
Overview

The Overview shows basic system information as

well as a license count chart and historical usage
charts.

The license count and historical usage charts show

separate data for the following user types:
▪ Planning Professional User
▪ Planning Standard User
▪ Business Intelligence User
▪ Business Intelligence User (Concurrent Session)
▪ Analytics Hub User

The Licenses chart also specifies whether or not

the system includes licenses for SAP Digital
Boardroom.

In the Historical Usage charts, you can select a

user type to highlight the relevant data in each
chart.
© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 48
System Monitor
System Usage by Memory

This tab page displays two charts

showing memory usage in MB
for: Memory Use by
Model and Memory Use by User.

You can get easy-to-read details of the

data by pointing with the mouse over the
chart details, and you can use
the Sort buttons to re-sequence the
data.

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 49

System Monitor
System Usage by User

This tab page simply shows, for each

user, metrics for Transaction
Count and Storage Usage in MB. If
storage space on the server is
allocated and managed for individual
user accounts, administrators can
get a visual check of the levels per
user here.

You can sort and filter columns on

this tab page using the drop-down
menu in the header of each column.

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 50

System Monitor
Trace

• The system administrator determines

what levels of error messages are
included in the log and how far back in
time the log file goes, but the log file may
extend over many pages.

• To help you identify information you are

looking for, most columns of the display
are sortable using a Sort feature in the
column headers.

• The Search feature operates on the User

Name, Component, and Message
columns and filters the items listed on
screen to those that include a match with
the search string you type.

• The Filter feature allows you to enter a

date range to select only log entries within
a fixed period of time.
© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 51
SAP Analytics Cloud Usage Tracking Content

The SAP Analytics Cloud Usage Tracking

Content package contains five models and
one story.

The models cover the domains of users,

files, other objects, activities, and
sessions.

The story, called ‘SAC Content Usage’,

contains four tabs:
▪ Story Information
▪ Model Information
▪ User Information
▪ Session Information
https://www.sapanalytics.cloud/resources-usage-tracking/
© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 52
Troubleshooting

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 53

Troubleshooting

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 54

Troubleshooting

There are many factors which can impact on performances:

▪ Local PC’s resources (CPU, memory)

▪ Corporate network (bandwidth)

▪ Back-end sizing (especially on live data connection use-cases)

▪ Model/Story design

▪ Heavy Calculations

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 55

Troubleshooting

How to isolate the problem?

▪ Test with a clean browser (check the local memory and CPU usage)

▪ Test from a different PC and check if the problem is similar

▪ Test from a different network

▪ Test with a different user

▪ Try to isolate the problem using Google Developer Tools

▪ Simplify the story/workflow as much as possible to analyze less information

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 56

Troubleshooting
Chrome DEV Tools

Chrome DEV tools Network

Traces and Timeline
▪ This generally gives a good
overview of the end user
prospective.

3 main useful tabs:

▪ Network tab: allows to look at all
calls placed on the network.
▪ Performance tab: allow to analyze
at a lower level what is happening
in the story.
▪ Identify elements in you story
pages (widgets).

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 57

Troubleshooting
Network Traces

Pay attention to green / blue

colors
▪ Long green (Waiting time to first
byte) shows long time to first byte,
and tends to indicate that backend /
HANA or server queries are slow.
▪ Long blue shows long data transfer
over network, potentially large
amount of info, and may indicate
also slow network (depends on the
data size transfer).

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 58

Troubleshooting
Network Traces

For Network traces the most common long running calls would be the GetResponse.
▪ Filter on GetResponse calls
▪ This will help you identify the queries running for a long time on the backend data source
– If a query is long to run, the widget will wait till the dataset it back to be displayed
– Optimizing that query might make sense

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 59

Troubleshooting
Identify story elements that cause the GetResponse call

Step 1 1
Identify the Widget ID in
the GetResponse Call.

Step 2
Go in Element Tab and
seach for the Widget
ID, the Widget will be
highlighted.
2

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 60

Troubleshooting

More information:
▪ 2511489 - Troubleshooting performance issues in SAP Analytics Cloud *** Master KBA ***
https://launchpad.support.sap.com/#/notes/2511489

▪ Troubleshooting Errors https://www.sapanalytics.cloud/guided_playlists/troubleshooting-errors/

▪ SAP Analytics Cloud Best Practices and Troubleshooting https://community.sap.com/topics/cloud-

analytics/best-practices-troubleshooting

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 61

Best Practices for Model and Story Building

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 62

Best Practices for Performance

SAP Analytics Cloud enables you to perform sophisticated analysis on large volumes of intricate
data. These complex scenarios can sometimes lead to less than ideal performance times for end-
users. However, there are things you can do when designing models and stories that will help
SAP Analytics Cloud run at optimal performance levels.
▪ Always use Google Chrome, our recommended browser, to
take advantage of the latest performance improvements.
▪ Take advantage of improved performance with browser
cashing of story and boardroom. This is particularly
important for stories with multiple pages, charts or models.
Cache is valid as long as there are no structural changes
made in the story or boardroom. Note that this performance
improvement is only available for Chrome users in a non-
incognito mode.

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 63

Best Practices for Performance
General Filters/Input Controls
▪ Limit number of charts and elements ▪ Limit Results through filters, parameters (including
▪ Drill to detail using hierarchies, hyperlinks, and URL), bookmark and linked analysis
explorer ▪ Use story filters, not multiple page/chart/table filters
▪ Disable unneeded cascading filters
Images
▪ Collapse page input controls
▪ Compress for web
▪ Use SVG Story
▪ Leverage header images, when possible ▪ Use responsive layouts when possible
▪ Lazy loading of Stories
Charts
▪ Limit results with Top-N, but avoid Auto Top-N System
▪ Clustering and Choropleth for geo ▪ Enable Progressive Chart Rendering
▪ Trellis or heatmap instead of multiple charts Model
Explorer ▪ Turn on Optimized Story Building Performance
▪ Leverage Explorer instead of large tables ▪ Hide unnecessary dimension & measures
▪ Disable Auto-synchronize
© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 64
Recommended Number of Tenants

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 65

Recommended Number of Tenants

We recommend adding at least two SAP Analytics Cloud systems (also known as tenants) to your
landscape. You can use one system for developing and testing content, and then promote that
content to a separate production system where your users can do their work. There are several
advantages to this type of landscape:
▪ Your test content is fully separate from the production data and content.
Content creators won’t have access to sensitive production data, for
example.
▪ Lifecycle management is easier. You can use import and export
features to promote content, and your production system will only
contain fully tested content.
▪ Performance can be improved, because you won’t need to use your
production data sources for testing and development tasks.

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 66

Additional Resources

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 67

SAP Enterprise Support Value Map for SAP Analytics Solutions
SAP Enterprise Support value maps guide you through the knowledge, Become a member by following these steps and benefit from our offerings:
skills, and services needed to help you in adopting intelligent technologies to 1. Sign Up for SAP Learning Hub
manage your landscapes, and focus your strength on continuous innovation. 2. Join the main group and choose the value map for SAP Analytics Solutions **
Find out more about the value maps program here.

SAP Analytics
SAP Analytics Solutions transform data into information. They are mission-
Solutions critical solutions that help organizations make decisions about the way they run
SAP Enterprise Support their business. This value map is intended to help customers adopt and run
Value Map their SAP Analytics solutions effectively with optimal performance. Learn more.

Why Should You Join the SAP Analytics Solutions Value Map?

Structured Approach Prescriptive Guidance Personal Onboarding Access to Expert Informative Blogs Social Collaboration
All the SAP Analytics solutions
We will show you what you need Request a call to help us Post questions to our experts in Subscribe to our blog posts and With thousands of members at
content, expert-led and self-
to consume, and when, depending understand your project plans and the forums and review other review our published content to present in our value maps
paced, from the SAP Enterprise
on your project stage. tasks plus any issues or areas of member’s comments. keep abreast of the latest SAP community, there is a massive
Support Academy are centralized
concern. We will tailor the call to Analytics solutions news and opportunity to engage with and
in one place so you can find what
suit your needs and recommend product updates. learn from other customers.
you need when you need it.
specific content for you.

What Can You Get From Your SAP Analytics Solutions Value Map Membership?
 Receive best practices and implementation guidance for SAP Analytics Cloud, Digital Boardroom and Analytics Hub.
 Learn about SAP S/4HANA embedded analytics and how to integrate these various reporting options into your analytics landscape
 Receive assistance and support to optimize the end to end performance of your analytics stories in SAP Analytics Cloud
 Gain a better understanding of the Fiori analytical apps and embedded reporting options in SAP S/4HANA and SAP S/4HANA Cloud.
 Safeguard major milestones such as SBOP BI platform implementations or upgrade projects
 Empower your organization to maximize SBOP BI platform solution adoption and develop hybrid reporting options with SAP Analytics Cloud.
 Maintain the stability of your SBOP BI Platform environment and tune for optimal performance. Receive guidance on usage of the SAP BI Platform Support tool and other monitoring applications
 Deploy and maintain SAP Lumira 2.x with guidance from our experts

©Disclaimer:
2022 SAP SE*orPlease
an SAP affiliate
note thatcompany.
the All rights reserved.
complete ǀ PUBLIC
content of the
learning journey is available within SAP Enterprise Support Value Maps Learning room. 68
**Valid S-User is required to sign up for SAP Learning Hub, edition for SAP Enterprise Support in order to access all value maps available in SAP Enterprise Support Value Maps Learning Room. Identify or request your S-User.
Additional Resources
Source Description Link

SAP community SAP Analytics Cloud Smart Assist https://community.sap.com/topics/cloud-analytics/smart-assist

SAP Analytics Hands-On Tutorial SAP Analytics Cloud, R Visualization https://www.sapanalytics.cloud/tutorial-r-visualization/

Cloud

SAP Time Series Forecasting in SAP Analytics Cloud Smart Predict in https://www.sapanalytics.cloud/time-series-forecasting-smart-
Analytics Cloud Detail predict/

SAP Analytics A learning blog describing the Search to Insight functionality https://www.sapanalytics.cloud/search-to-insight-functionality-
Cloud explained/

SAP Analytics A video explaining how to work with stories in the mobile app https://www.sapanalytics.cloud/videos/work-stories-mobile-app/
Cloud

SAP Analytics A video explaining how to use SAC smart discovery https://www.sapanalytics.cloud/videos/use-smart-discovery/
Cloud

© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ PUBLIC 69

Follow us

www.sap.com/contactsap

© 2020 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 www.sap.com/copyright for additional trademark information and notices.