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:
- Choose Import Data Connection -> ODATA (see screen)
- Choose Data Source Type: SAP Business ByDesign Analytics
- Add relevant Url (see screen)<system>/sap/byd/odata/cpm_corporateperformance_analytics.svc
- Add Basic Authentication for Admin User
- Create SAC Model based on your Connection
- Choose get data from app (see screen)
- Select SAP Business ByDesign Analytics
- Select your connection -> create a new query
- Now you get a list of BYD reports, which are assigned to your work center.
- Define the ODATA Query and select the desired fields (see screen)
- 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||
Please find a video, where the general data preparation steps are explained Video, SAC Doku
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.
As usual a very nice blog to help people.
However, I am facing a very very strange and alarming issue.
I mapped a lot of my models in SAC to custom reports from ByDesign. This worked perfectly up to the last updates of SAC.
Now I am unable to see any custom report from the OData Analytics connection of SAC for ByDesign. Only the standard reports are there. Not a single custom reports.
And the reports are well assigned to a WC+view in ByD and yes I have all the access rights needed to see them. The weirdest thing is I can see them in the metadata of the OData service, however they do not show up anymore in my connection in SAC. I am currently only able to see the standard reports of ByDesign.
Moreover, this was in Production, which is horrible for the customer and also for me... as nothing works anymore.
I am sorry to put this here, but I am not able to raise any incident from my SAP Launchpad as I do not have my customers SAC systems available in my launchpad. And my customer in question does not even have an SAP Launchpad.
I am lost here as I do not see any mention anywhere that custom reports need a specific process to be called in SAC. Moreover they didn't need one before the last SAC udpates.
What can I do?
Thank you very much for your help Stefan!
Thanks for your informative blog that provides a very good overview of the SAC, integarted with ByD. However, I would like to understand the difference of the OData API which you have mentioned compare to a blog written by Thomas Salvador (https://blogs.sap.com/2017/03/13/how-to-consume-an-odata-service/) on OData Service consumption. Does this refering to the same thing?
As what I understood that we can use the OData API which is mainly built from the "Business Analytics" work center perspective, but as what seen about this OData Service, apparently it carries more information which I believes it is from the UI perspective. This makes a big difference which I believes reason being OData Services seems to be a connection that we can build from ByD to SAC without limiting to only information on data source or reports level.
Therefore, I am very interested to know based on API and Services what are the differences and I was just wondering does the OData Services (located in the Application and User Management work center) able to cater as what mentioned for SAC OData Connection?
Really hope to hear from your end about this.
Our prospect is looking to report based on sales orders with a) a cumulative and b) detailed sales report with all products, prices, ship to, etc.
They would like to see last year all sales orders for cumulative I do not think there will be an issue but for detail reporting we have only in one-month thousands of lines.
1.- Does the tool still have the limitation for the number records transferred of 10000 records?
I'm trying to extract the report 'Financial Statements' from Business ByDesign to SAP Analytics Cloud. This report has the Hierarchy/Reporting structure. This structure is from characteristic G/L Account(GLACCT) characteristic property. When i pull the report, the reporting structure was not coming through. The requirement is to extract the report with reporting structure to SAP Analytics Cloud. Is there a way to extract this Financial Structure.
Structure Details :
Report : FINGLAU17_Q0001
Datasource : FINGLAU17
Characteristic Name : GLACCT (G/L Account)
Financial reporting structure for G/L accounts : FINGLAU17_STR_01
Hi, did you find a solution to your problem?
Also were you able to create a report with all GL Accounts? When i try to do it All i manage to get are GL accounts with movements. Those without any movements do not appear.
We need to integrate ByDesign with SAP Analytics Cloud. Would you be able to tell us how to set up the communication system (step-by-step) and the communication arrangement (step-by-step)?
I referenced the below video you posted but at the 2:30 mark, you skipped the setup and just showed the result.