Blog Article
Usage of “SAP Analytics Cloud Add-In for Microsoft Excel” in a planning scenario
Since 2020, the tool "SAP Analytics Cloud Add-In for Microsoft Excel" has been available. Time to take a look at how well you can create a more complex planning scenario with Excel as the frontend for the SAC using this tool.
Integrated Planning (BPC) in SAC – pitfalls with additional authorizations
You can use IP planning solutions directly in the SAC, you "only" have to create additional BPC models. This blog describes our experiences with the use of IP / BPC solutions in SAC.
SAP BW Roles & Authorizations
A role and authorization concept is crucial for data security, integrity, efficiency and scalability in corporate data management. Our blog describes the technical steps for developing such a concept in SAP Business Warehouse.
Integration of SAP Data in Microsoft Fabric
Die performante Datenintegration aus verschiedensten (Quell)-Systemen ermöglicht es Unternehmen, agil, effizient und konsistent zu arbeiten. Hierfür veranschaulicht unser Blog die Potenziale und technischen Möglichkeiten der Integration von SAP Daten in Microsoft Fabric.
Changelog für Kommentare in einer Query anzeigen
In the context of corporate planning, explanatory comments and notes on pure key figures are gaining in importance. This blog shows how these can be easily displayed in a query if they are saved via “Attributes as key figures”.
Options for Master Data Maintenance by end user in BW, BPC and SAC
This blog provides an overview of various options for maintaining master data in the SAP Analytics Cloud and shows different use cases at the same time.
Planning process in the SAP Analytics Cloud
This blog shows which insights, possibilities but also limitations the current version of the SAP Analytics Cloud brings with it. In particular, the calendar as a standard planning process control is highlighted.
Experience report GeoEnrichment
The GeoEnrichment blog describes the pitfalls of geo-enrichment, but at the same time shows the enormous potential. When deciding to enrich data, this blog can be used as an orientation guide.
Machine Learning with Databricks on Azure
The many comfortable features of Databricks for Machine Learning are described in this blog. Further, the blog describes how it enables teams to work together interface-free.
SAP DATA Intelligence: GEO-Enrichment through API
This blog explains how to use the OpenAPI client in an SAP Data Intelligence data flow. Information about a specific location (point of interest), e.g. geo-coordinates, opening hours, websites are to be obtained with the help of GoogleMaps. It is thus shown how data can be enriched with...
SQL in the Composite Provider - Powerful Function but Possibly Surprising Calculations
In a composite provider, you can now fill new characteristics or key figures using your own SQL! This is an exciting function that can be used to elegantly solve many requirements. If you use this for key figures, however, it can happen that the result does not quite meet...
Not yet on BW/4 - What to do? - Considerations and experiences of our customers
In discussions with customers, the question often arises as to how to proceed with a BW 7.5 and smaller. When should the migration to BW/4 be carried out or should a completely new path be taken? Therefore, we would like to compile some aspects that can support the decision...
Exporting data from the SAC to a BW using the ODATA service
For most users of a BW who want to enter SAC planning, the question will arise as to how data can be loaded from the BW into the SAC and plan data from the SAC into the BW. If the SAC introduction is not to take place with a big bang, data must be transferred between the old and the new solution...
SAP Analytics Cloud: Story vs. Application
Decision support on when to use which solution. The SAP Analytics Cloud (SAC) is SAP's strategic data analysis tool that combines business intelligence, dashboarding, visualisation, planning and predictive functionalities in one solution. To analyse or plan the data, SAP now offers two approaches...
Next level analytics cloud data platform – Covid-19 use case
Even though the number of corona infections is decreasing drastically in most countries around the globe, the pandemic has shown us how fast companies have to adapt and adjust their working habits, team structures, and business models. Meanwhile, obtaining a better...
Hands On with the new model on the SAP Analytics Cloud
In March, the Q2 2021 release added several new features to SAC. Among them is a way to make data modelling more flexible and effective. A new model is made available to the modeller, which can now also be used to create key figure models...
Planning content in the SAP Analytics Cloud (SAC)
Using the example of a story in the "integrated Financial Planning (4RC)" package One argument for planning in SAC that SAP likes to market as a great advantage is the planning content. This promises to be a template for the "classic" planning processes in most...
Creation and use of autoencoders with SAP PAL
Data sets to be used in Machine Learning (ML) are usually unprocessed and immensely large in practice. Most ML algorithms require the input data in a specific form, which is provided by data preprocessing. Even then, however, the data model at hand is usually very complex...
Proof-of-Concept Data Orchestration with SAP Data Intelligence
A central challenge for every larger company is the consolidation and linking of master or transaction data. Data can be organised in a DWH such as SAP BW or unorganised in a data lake. It can also flow in as streaming data or come from...
biX AI Tools - Case Study: Customer Churn Prevention
Customer-Churn is the termination of a contract by the customer. Predicting such events before they occur is of great interest in many business areas. Focusing countermeasures on relevant customers reduces the effort and prevents a sleeper effect with customers who are not at risk...
biX AI Tools - Case study: Shopping cart analysis
Within the framework of a project in the area of payment services, we were given the task of examining the configurations of ATMs and POS systems for their similarities in order to make them comparable and to integrate them into the current SAP BW-based sales reporting. Since the complexity of...
biX AI Tools - Case study: Master data optimisation
biX Consulting examined the quality and distribution of master data for a provider of fuel and toll invoices. In the case described, 30,000 German number plates, which were directly available in SAP BW, were to be checked for quality, as they were entered manually...
Change from SAP IP to SAC Planning
Mindchanges when switching from SAP IP to SAC Planning. If you change from the IP - Planning application to the SAC - Planning programme from SAP with your previous experience, you first have to get used to the following new philosophy...
SAP Data Intelligence Platform 3.0 – Let’s install on Open Source
With the Data Intelligence Platform (DI) SAP enhances the functionality of the Datahub by adding special tools for machine learning and AI. Although the Datahub has been available for some time now as both a cloud and as an on-premise system, the successor to the...
Let’s install an Open Source infrastructure for the SAP Datahub on-premise – Part 2 of 2
This is the second part of our article in which we explain, how to install an SAP Datahub on an Open Source infrastructure. The following expects that you successfully have a Kubernetes cluster running and additionally, fulfil all other requirements for the...
Let’s install an Open Source infrastructure for the SAP Datahub on-premise – Part 1 of 2
In this article we want to explain how to install an SAP Datahub into an Open Source infrastructure and what’s important to consider. This is the first part, which deals with the underlying container- and storage-system. You can skip this part if you already know all...
Webinar on 09.07.2020: Integration of SAP and Tableau
Live webinar on 09.07.2020 from 10.00 to 11.00 a.m. Biopharmaceuticals are produced from living cells in complex and expensive processes. Sartorius AG's innovative products and services enable researchers and laboratory personnel in the pharmaceutical...
Analyses of purchasing behaviour in the Corona crisis
The Corona crisis has changed everything in a very short time - worldwide and indefinitely. What happens next in the post-Corona economy? Entrepreneurs and politicians who are in charge today have never experienced anything comparable...
Predictive Content - Case Study: Customer Churn
For a provider of fuel and toll invoices, biX Consulting created a customer churn analysis in which it was determined which customers would churn at what point in time. With the help of the biX A.I. tools, it was possible to recognise patterns in the historical movement and master data of the customers and to classifyn...
SAP Infotage Business Data and Analytics 2019 – Nachlese
In spektakulärer Kulisse fand am 11./12.September in Essen in der Grand Hall der Zeche Zollverein der erste SAP Infotag Business Data and Analytics statt. In der historischen Kulisse des Industriedenkmals wurde unter dem Leitthema #GiveDataPurpose über vernetzte...
