Overview and Update on Built-in Analytics in SAP Business ByDesign
-> Oct. 25th. 2019 – Roll-out Videos Release 1911 – see chapter 3
-> July 23rd. 2019 – Discount Analysis on Sales orders – see chapter 4
-> April 29th. 2019 – Please enroll for the new open SAP course Built-in Analytics – click here
This article serves as the central place to inform you on Built-in Analytics in SAP Business ByDesign (ByD)
Please bookmark this link to always find the latest answers to the following questions:
- How to find getting started information on Built-in Analytics?
- What are latest developments of the current release 1911?
- What are frequently asked questions and mission critical business topics,
helping you to better leverage built-in analytics.
Table of Content
- Introduction into built-in Analytics
- Getting started information
- Release Highlights of Release 1911
- Featured Application Examples
- Frequently asked questions and important featured topics
- Outlook and next steps
What means 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. Accordingly 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. As a result customers get full transparency into all aspects of their business processes.
What are the aspects of built-in analytics, which make the difference:
- Uis connects insighs to actions
Uis include analytical insights to make better decisions in the context of your daily work and business processes.
- Model-driven Adaptability
Customers use an integrated approach to adapt and extend business objects and processes within and end-to-end custom reporting approach.
- Business Processes integrate Analytics
Scoping and fine-tuning makes the related content available out-of-the box.
Access rights to operational and analytical data are managed consistently via work centers.
Insights are real-time and each number can be immediately explained by navigating to the underlying business document.
2) Getting Started – Learning Material
You will find a quick introduction into built-in Analytics by viewing the following assets:
|Deep Dive /
Introduction into Built-in Analytics
|Overview Page Concept|
|KPI and Report
|Blog: how KPI Variants are used in Financials link|
|Please watch the Open SAP Course: Reporting with BYD
|Open SAP W4|
|Please watch the Open SAP
Course: Reporting with BYD
|SAC Integration||Blog: Extend SAP Business ByDesign with SAP Analytics Cloud|
3) Release Highlights of Release 1911
Current Release Highlights for 1911:
Focus Topic: Custom Relative Selections
This is helpful, when you need to define a dynamic logic e.g. on dates to simplify the selection of KPIs and reports:
Focus Topic: Analysis of Won and Lost Customers supported by new date fields in business partner master
New date fields wrt. change and creation date are added to the business partner allowing you to build restricted key figures for won and lost customers:
Focus Topic: How to embed custom reports into operational UIs using Cloud Application Studio
You can now embed your custom report at the place, into the context of your operational UI and process where needed
Please find the release highlights of earlier releases here:
|Release 1908||Release 1905, 1902||Rel. 1811 and earlier|
Focus Topics Videos 1908:
Focus Topics Videos 1905:
Focus Topics Videos 1902:
|Overview Pages and Dashboards
|KPI and Report
Create KPI from Report
Bookmarks for Casual Users
Share Personal Views
Navigate to HTML5 UI from Excel:
Formula parameters and date calculations:
Join data sources supporting time-dependent joins
Adapt Data Source :
|Integration||How to embed SAP Analytics Cloud stories into launchpad and dashboards||
Push-Upload to Cloud Data Source
|Build OData Query
4) Featured Application Examples:
|CRM||Discount Analysis on Sales Orders||Video|
|Central KPI Blog||Process Monitoring and Optimization with KPIs||Blog|
|SCM||Analyze Delivery Performance with On Time In Full Delivery|
|Financials||Analytics Insights for Cost Center Manager||Blog|
|Financials||Tracking Days Sales Outstanding (DSO) Cash Conversion Cycle||Blog|
How to setup projected sales dashboards and KPIs with tablets
Alexa meets SAP Business ByDesign and Built-in Analytics
5) Frequently asked Questions
|Excel-based Reporting||Where can I find examples and Infos on exce-based Reporting ?||Open SAP
Course – Week4
|Excel-based Reporting||I cannot find the Navigate Button in the Add-in, which allow me to navigate to the Web Client?||Deactivate Dynamic Paging (Show/Hide)|
|KPI Monitoring||Is there an easy way to upload and download KPIs?||Video|
|KPI Monitoring||I want to show my KPI in Kilo, Mio. – Where is the Scaling field ?||Start Personalization
and add the field scale.
|KPI Monitoring||When can a business user see a KPI?||A user can see those KPIs, which is based on reports he is authorized to see.|
|Key User Tools|
|Documentation on Data Sources||How can I better understand the content, delivered from
SAP as integral part of the BYD Processes?
|Restricted Key Figures||Restricted key figures return blank, when the restriction is not met – can I also show 0?||At the moment a calculated key figure with NoErr(1+KF-1) will fix this problem.|
|Calculated KeyFigures||Where I learn more on available calculations and aggregation logic?||
|Advanced Lesson on
Cloud Data Source and
|How to create and Analyze Net Promoter Score with SAP Business ByDesign||Video|
|Openess / BYD – SAC Integration|
|How to extend BYD Analytics with SAP Analytics Cloud?||SAP Analytics cloud is recommended to support the following analysis and planning scenarios:
– reporting across cloud applications
– advanced dash-boarding and visualization
– planning and predictive scenarios
|Learn more on ODATA API for Data Sources||How do I scope, activate and use the new ODATA API ?
– How to scope the new feature?
– How to create a communication arrangement?
– Howt to expose a data source?
– How to test my ODATA Service?
– How to expose Code Lists ?
|How to access data from third party clients ?||In the current release ByD provides for each report an ODATA API, which delivers the underlying result set for
third party reporting clients.An improved interface for data replication on data source level is currently in preparation.
|ODATA API for Reporting Clients|
|How to integrate Planning Data from SAC with BYD?||In this video we show an example how you
1) replicate actuals to SAP Analytics Cloud (SAC)
2) plan your values in SAC
3) export the plan values and import to BYD
4) use a cloud data source in BYD to load the data
5) Combine actual and plan values for variance analysis
6) Outlook and Next Steps:
Looking at the road map for built-in analytics you will find the following key themes, which determine the strategic directions of future investments in SAP Business ByDesign Analytics:
- Further leverage HTML5 and simplify analytics UIs for casual users.
- Execute on the overview page concepts incl. KPI and report cards.
In a next step we will extend the overview page under home to all work center overview pages and enable key user adaptation. Custom-built overview pages will become a subsequent step on this path.
- Simplify adaptation and key user tools
Reuse of delivered content in custom reporting scenarios is a key area of improvement.
Key topics here are improved transparency into existing content, simplifications of key user tools and completion of existing application content.
Beyond the built-in analytics scenario the side by side reporting with SAP Analytics Cloud (SAC) , Business Warehouse as well as third party platforms are key.
To achieve this we started a new ODATA API in 1802, which will form the basis for future data replication scenarios and improved SAC integration.