Extending SAP ByDesign Analytics using SAP Analytics Cloud
This article describes how SAP Business ByDesign (ByD) Customers can leverage SAP Analytics Cloud (SAC) to extend the ByD built-in analytics solution with additional visualizations, features and analytical scenarios. It answers the following questions:
- What are the recommended integration scenarios for customers considering SAC as an extension platform?
- How do you connect ByD and SAC and what are the considerations?
- How to avoid known mistakes, achieve maximum benefits and best possible performance?
Table of Content
- Recommended Integration Scenarios from a Business Perspective
- ByD – SAC Integration from a Technical Perspective
- Step-by-Step Procedure to integrate ByD and SAC
- Recommendations – What to Consider when integrating both Systems
- Business Content Example
Built-in Analytics within SAP Business ByDesign (BYD):
SAP Business ByDesign is a cloud-based ERP solution, which delivers integrated and insight-driven business processes for mid-size companies. Built-in analytics is a key theme for SAP Business ByDesign and customers get the analytics content as an integrated part of their standard processes out-of-the box.
What is meant by built-in analytics?
Built-in analytics in context of ByDesign processes means:
- User Interfaces embed analytical insights into business processes.
- Business users get transactional and integrated analytical content via work centers.
- Access rights to transactional and analytical data are managed consistently via assignment to work centers.
- Scoping and configuration of business process makes the related analytics content available out of the box.
- Insights are based on live data and it is ensured that each number can be immediately explained by navigating to the underlying business document.
- SAP Business ByDesign customers can use an integrated approach to adapt and extend the business objects and processes. Every adaptation is made available via key user tools for analytical data sources, reports, and KPIs.
Learn more on built-in analytics in SAP Business by Design.
There is no further licensing for built-in analytics required.
Analytics within SAP Analytics Cloud (SAC)
SAP Analytics Cloud (SAC) contributes a powerful analytics extension platform in the cloud, which is based on the SAP Cloud Platform. SAC connects to multiple cloud applications and leverage data models from different cloud applications and SAP BW. It offers strong visualization and dashboarding, corporate performance management capabilities with SAP Digital Boardroom, powerful planning, and predictive workflows.
Discussions to include limited users/functionality into the BYD application license are on-going. Nevertheless, full functionality will require an additional license fee (e.g. for planning, prediction, digital boardroom, multiple data sources, etc.)
Recommended Integration Scenarios from Business Perspective
The following reporting scenarios are best supported within BYD:
Due to the strong integration of built-in analytics into the BYD solution, operational and process-centric analytics, optimizations and contextual decision making is directly done in SAP Business ByDesign.
Consider the following Extension Scenarios contributed by SAC:
SAP Analytics Cloud (SAC) contributes strong side by side analytics. The following use cases add value in combination with SAP Business ByDesign:
- SAC is the place for cross reporting and consolidating the data of multiple sources and applications to one coherent picture.
- As a strong analytics platform, SAC also adds dashboarding, visualization and data exploration capabilities, which can be added on replicated BYD data in side by side reporting scenarios.
- Furthermore SAC adds strong planning and forecasting capabilities, which allows customer to add cross-domain planning scenarios based on BYD-data. Later the transfer of planning results back to the BYD System shall be improved.
BYD – SAC Integration from Technical Perspective
The current BYD – SAC Integration is designed as a data acquisition scenario, which imports aggregated report results to SAC using a ODATA APIs on top of BYD Reports. This has the following advantages and disadvantages:
- Summary calculations and report results can be reused in SAC
- You can reuse BYD semantics (such as master data relations, attributes,…)
- The replication approach allows to uses the full spectrum of SAC features
- The current ODATA API is designed to deliver summary data for reporting clients. Accordingly it has limitations, when data on business document level is needed. Therefore, you cannot transfer large lists of line-item data to SAC with this approach.
- Please consider that the number of summary records transferred is limited and should not exceed 10000 records.
Please refer to the interface “ODATA API for Analytics” in the picture below:
You will find more information on the ODATA Api with regard to set-up, meta data and limitations, when you read the following sources:
- BYD Documentation on ODATA API (ByD Help Center search for “Retrieving Analytics Data Using Odata”)
- BLOG on ODATA for SAP ByDesign Analytics
- SAC Documentation on ODATA Connector.
- SAC Documentation
Step-by-Step Procedure to integrate BYD and SAC
In order to set-up a connection between BYD and SAC you have to do the following steps:
(Please watch the following SAC video as introduction click here)
- Check your ODATA Service on BYD Side and identify the relevant work center used for integration:
- Determine the user and the work center, which you would like to use for data access.
https://<system>/sap/byd/odata/ => Delivers the list and technical names of work centers for your user
- We recommend to use a dedicated work center/view, which only includes the reports needed for replication.
- Check the available reports and related report meta data in ODATA:
- Check your report results within ODATA (see screen)
- Determine the user and the work center, which you would like to use for data access.
- Create the connection to BYD on SAC side:
- Create SAC Model based on your Connection
- Data Preparation within your SAC Model
- Add relation from ID and text fields (see screen)
- Identify Time fields and choose the time format
- Add additional calculations to your model
- Build you SAC Story
Further details can be found in the documentation of SAC here.
Recommendations – What to consider when integrating BYD and SAC
It is now important to understand that the current integration is very useful under well-defined conditions. Here are a number of recommendations, which can help you to avoid inconsistent data and performance problems:
Why should you care?
a) Consider the granularity of data. Avoid fine granular fields on document level.
The current integration approach transfers aggregated report data from your BYD source report to SAC repositories. In step 3 you need to add the required fields to the “selected data” area of your Odata query.
For example if you are only interested in purchasing information by month and product category we recommend to only add those fields to the ODATA query. Keeping your data on an aggregated level keeps the number of records minimal.
In other words it makes a huge difference, if you add fine granular fields on business document level (e.g. the purchase order ID) to “Selected Data” of your ODATA Query. This will dramatically increase the number of records transferred to SAC, which can cause performance problems or even hit limitations.
=> Please do not transfer the data on lowest record level to SAC.
b) Prefer custom reports, when you connect to SAC.
|It is important to consider, that BYD delivers Standard reports out of the box. Key users can copy and adapt those reports, which leads to a custom report.Standard reports can theoretically change with every release.
c) Choose a dedicated business user/admin user for replication
The scheduling and replication of data is done with one dedicated administration user. In order to make this integration as secure as possible, we suggest to assign all replication relevant reports to one dedicated work center and create one administration user, which is has limited read-access to only this work center.
On the SAC side you would use this user for “basic authentication”
d) Users and Access rights for consumption
To manage the access rights on SAC side you would create dedicated users to represent each business users in BYD. Please use an Identity provider in case you need single sign on.
In case each SAC business users has different access rights, you have to set up data access in your SAC model and maintain the relevant restrictions on SAC side. (see SAC docu)
e) Please consider, which key figures you choose for replication:
|In the screenshot below, you can see the different types of key figures are offered. Please consider:
To summarize, we recommend choosing amounts in one stable home currency and quantity fields with one consistent unit.
f) Scheduling of data transfer
We recommend to schedule a daily transfer of your data. See screenshot.
You will always be able to match your aggregated data with your BYD System when you choose the update rule “clean and replace”. This ensures that all changes (e.g. the change of a delivery status of a sales order) are always up-to date and considered correctly on SAC side.
Please find more information on the Update and Scheduling Model in SAC here
|g) Consider data preparations to enrich the data on SAC with additional semantics||
It is important to consider, that additional data preparations steps are needed.
Some of these steps are required, when the model is created and cannot be changed afterwards.
Important steps are:
Business Content Example
As stated before, we recommend, that you configure the BYD – SAC Integration optimized to your need.
Especially considering that the granularity of your data will dramatically impacts the performance or your system.
For this reason the SAP delivered business content can only serve as a reference and example and is not ideal for productive use.
Please find a great example for a procurement dashboard, which illustrated the relationship of organized spending via contracts or purchase order versus maverick / unorganized spending.
You find details how to download this example from the app store in the following blog:
As stated before SAP Analytics Cloud (SAC) can contribute a powerful analytics platform to extend analytics scenario in the cloud.
Important scenarios such as cross-system reporting, predictive and planning scenarios can make a huge difference. Nevertheless we strongly recommend to consider the recommendations for the current BYD – SAC Integration.
If we look into the future, you will come across two types of data connectivity, which make a fundamental difference, when you use SAP Analytics Cloud.
You will find live data connections for some cloud applications on the one hand and on the other hand “data acquisition models”, which import the data into SAP cloud for analytics.
Please note that at the moment, the full range of analytics capabilities, including planning, blending and data preparation can only be leveraged for data acquisition scenarios. At the same time there is already a strong real-time and built-in reporting in SAP Business ByDesign, which will contribute to intelligent automation of business processes in future.
This leads to the conclusion, that SAP ByDesign team continues to invest in a strong ODATA Interface on data source level, which helps to overcome the current limitations of the report-based and aggregated ODATA API. With this customers will be able to acquire data to a much broader extend and also use the BYD data for comprehensive cross- reporting, planning and predictive scenarios.