Skip to content
NextLytics
Megamenü_2023_Über-uns

Shaping Business Intelligence

Whether clever add-on products for SAP BI, development of meaningful dashboards or implementation of AI-based applications - we shape the future of Business Intelligence together with you. 

Megamenü_2023_Über-uns_1

About us

As a partner with deep process know-how, knowledge of the latest SAP technologies as well as high social competence and many years of project experience, we shape the future of Business Intelligence in your company too.

Megamenü_2023_Methodik

Our Methodology

The mixture of classic waterfall model and agile methodology guarantees our projects a high level of efficiency and satisfaction on both sides. Learn more about our project approach.

Products
Megamenü_2023_NextTables

NextTables

Edit data in SAP BW out of the box: NextTables makes editing tables easier, faster and more intuitive, whether you use SAP BW on HANA, SAP S/4HANA or SAP BW 4/HANA.

Megamenü_2023_Connector

NextLytics Connectors

The increasing automation of processes requires the connectivity of IT systems. NextLytics Connectors allow you to connect your SAP ecosystem with various open-source technologies.

IT-Services
Megamenü_2023_Data-Science

Data Science & Engineering

Ready for the future? As a strong partner, we will support you in the design, implementation and optimization of your AI application.

Megamenü_2023_Planning

SAP Planning

We design new planning applications using SAP BPC Embedded, IP or SAC Planning which create added value for your company.

Megamenü_2023_Dashboarding

Dashboarding

We help you with our expertise to create meaningful dashboards based on Tableau, Power BI, SAP Analytics Cloud or SAP Lumira. 

Megamenü_2023_Data-Warehouse-1

SAP Data Warehouse

Are you planning a migration to SAP HANA? We show you the challenges and which advantages a migration provides.

Business Analytics
Megamenü_2023_Procurement

Procurement Analytics

Transparent and valid figures are important, especially in companies with a decentralized structure. SAP Procurement Analytics allows you to evaluate SAP ERP data in SAP BI.

Megamenü_2023_Reporting

SAP HR Reporting & Analytics

With our standard model for reporting from SAP HCM with SAP BW, you accelerate business activities and make data from various systems available centrally and validly.

Megamenü_2023_Dataquality

Data Quality Management

In times of Big Data and IoT, maintaining high data quality is of the utmost importance. With our Data Quality Management (DQM) solution, you always keep the overview.

Career
Megamenü_2023_Karriere-2b

Working at NextLytics

If you would like to work with pleasure and don't want to miss out on your professional and personal development, we are the right choice for you!

Megamenü_2023_Karriere-1

Senior

Time for a change? Take your next professional step and work with us to shape innovation and growth in an exciting business environment!

Megamenü_2023_Karriere-5

Junior

Enough of grey theory - time to get to know the colourful reality! Start your working life with us and enjoy your work with interesting projects.

Megamenü_2023_Karriere-4-1

Students

You don't just want to study theory, but also want to experience it in practice? Check out theory and practice with us and experience where the differences are made.

Megamenü_2023_Karriere-3

Jobs

You can find all open vacancies here. Look around and submit your application - we look forward to it! If there is no matching position, please send us your unsolicited application.

Blog
NextLytics Newsletter Teaser
Sign up now for our monthly newsletter!
Sign up for newsletter
 

Data Blending with SAP Analytics Cloud Story

Blending refers to the linking of data from different data connections. In the context of SAP Analytics Cloud, a data connection can be an imported (acquired data) or live connection. Blending is possible with the two connection types mentioned above. Ultimately, it is a join of content from different data connections. If blending is now considered in the SAC context, a local file is often linked to a live data connection. In this blog article, I will deal with data blending in SAP Analytics Cloud Story and present a possible scenario.
For blending, the data is transferred to the SAP Analytics Cloud via secure channels and stored in a cache for the duration of the blending: (https://launchpad.support.sap.com/#/notes/2715871)

To make the procedure a little more transparent, I will introduce you to four steps in the following.

Goal

The goal is to combine and visualize the data of a chart with two different models. The first model is a query from an SAP BW system and is connected live. The second model is a local Excel file that we import into SAC later on.

Step 1: Preparation

First you have to consider which fields can serve as key fields and to what extent they can be integrated into the existing data model. In this case, the dimension Continent and the key figure Number of Employees should be linked to the existing live data. In the previous model, the Region field is suitable as a key field. This field is added to the local Excel file and linked to the continents.

SAC Story Local Blending

Step 2: Import into SAC

The next step is to switch to the Data View and select Add New Data from the dropdown on the left. The local file is selected from the popup and the check mark is set so that the first row serves as the column header. The contents can then be transformed and adjusted (just like when creating a model). If the new model is now saved, it is initially set to Private so that it is only available for the creator and only for the current story.

Note: Microsoft Excel files (XLSX) can be uploaded with a size of 200 MB, CSV files with a size of 2 GB. The number of lines is not taken into account:
https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/5f61b6509a5e4d499e8cb9685f32db73.html


Dashboarding with SAP Analytics Cloud -
Download the whitepaper here!

SAP Analytics Cloud Whitepaper


Step 3: Linking the Models

In order to see whether the just imported key figures can be visualized, a simple pie chart is created and the number of employees selected by continent. This data can be easily visualized.

SAC Story Local BlendingLocal Data Pie Chart

If you now want to blend the data with a live connection, the models must first be linked together. In the upper (symbol) menu, the "Link Dimensions" entry is located in the "Data" area (represented by two overlapping rectangles).

SAC Story Local Blending Link Dimensions

All linked dimensions are listed in this popup. With a click on "Add Model Link" a new link can be added. Now select the two models to be linked. For the present scenario, the regions are linked together. The link is confirmed by a green tick. Under the dropdown and next to the dimension of the model, the data examples can be changed using the action button.

SAC Story Local Blending Local Data Linking Dimensions Data Preview

In some cases it is necessary to link the description and not the ID (this can happen, for example, if the Acquired Data Connection is used and the ID and description of a dimension are transferred in two separate columns). This is changed using the action button next to the selected model.

SAC Story Local Blending Local Data Linking Dimensions

If linked incorrectly, this can lead to distorted results and possibly to a consistent, aggregated presentation of the key figures.

Step 4: Data Blending

After the conditions for data blending have been created in the last steps, the actual data blending takes place in step four. First, a new bar chart is added. In order to merge the linked models, the linked model must first be added.

SAC Story Local Blending Local Data Model Linking

Key figures or dimensions of both models can now be selected. The primary model is represented by a blue circle, while the linked model is represented by two overlapping rectangles.

In the bar chart, the dimension selected is the continent and the regions (you can recognize the linked dimension here by the link symbol). The number of employees is selected as the key figure. All previous data comes from the Excel file.

SAC Story Local Blending

The KPI Profit is selected to also display key figures that have been linked to the data from Excel. To change the direction of the blending (join), it can be adjusted next to the linked model using the action button (context menu Link Type).

SAC Story Local Blending Link Type

You can also set what happens to the unlinked dimension entries (Unlinked Dimensions Options) or what the actively linked dimension is. It is also possible to link several models.

Tip: To check the values linked by blending, it is a great idea to use a table as a help. There you can gradually add and check the key figures.

SAC-Story-Local-Blending-Blending-1

A calculation can also take place at this point, so that, for example, the turnover per employee can be displayed.

SAC Story Local Blending

Data Blending with SAP Analytics Cloud Story - Our summary

In this article, we mainly looked at blending in the context of an imported Excel file. Blending with other models (Live- or Acquired) works on the same principle and is slightly easier. In an Excel file, for example, you have to make sure that the key fields are defined correctly (e.g. to avoid typos). For an end user from the department, this may require several attempts until the correct format for blending is available.

For this reason, the IT department should set it up once only. This can include the setup, the creation of templates, as well as (Excel) templates for blending.

Note: Blending also includes the other connection types as well as the connection types among each other. In order to enable a blending scenario with a live connection, a lot of preparation has to be done on the backend side. So it makes sense to import the latest Release Notes, if possible even the latest Support Packages. SAP provides a program with which you can examine your system requirements and identify missing Release Notes: (
https://launchpad.support.sap.com/#/notes/2541557)

 

Learn all about SAC

,

avatar

Rafael

Rafael Sachs has been working as an SAP BW and BO consultant in various industries in Germany and abroad since 2013. He covers the range from requirements management to implementation. His core competencies are tailor-made solutions in the front-end area and the professional design of the company's own software NextTables. In his spare time he is a restless hiker, dog tamer and hobby cook.

Got a question about this blog?
Ask Rafael

Blog - NextLytics AG 

Welcome to our blog. In this section we regularly report on news and background information on topics such as SAP Business Intelligence (BI), SAP Dashboarding with Lumira Designer or SAP Analytics Cloud, Machine Learning with SAP BW, Data Science and Planning with SAP Business Planning and Consolidation (BPC), SAP Integrated Planning (IP) and SAC Planning and much more.

Subscribe to our newsletter

Related Posts

Recent Posts