It’s not common and recommended to work directly in a production environment. So, in most of your BW projects, you must import SAP BW objects from one system to another. We usually start working in a development system and transport all our objects from the source to the next target system chosen by the company […]
Tag: Cubis
5 Tips & Tricks for your Business Objects
Hi again, in this short article I’ll go over 5 functions of Business Objects I often used and think are worth spreading the word about. They will highlight the possibilities of WebIntelligence and Analysis for Office You might know none of them or you might know all of them. Even so it would never hurt […]
Pareto chart in SAP Analytics Cloud
In this blog we will explain you how we can create a Pareto chart in SAP Analytics Cloud using a Live Data connection to BW. A Pareto chart is a type of chart that contains both bars and a line graph, where individual values are represented in descending bars and the cumulative total is […]
SAP BW (parent/child) hierarchies in Power BI
Hierarchies are a very powerful concept in the world of data processing and visualization. For anyone working with hierarchies, it’s important to understand the different formats that can exist on DB level, and how they can be handled in the reporting tools. In this blog we’ll specifically look at the SAP BW (external) hierarchies, […]
New Planning Area for Data Entry
In SAP Analytics Cloud, release 2021Q4 (2021.20.12) many new features were introduced. (https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/2021.20/en- US/c96a267c5da04fff90bb55313ee9f77c.html One of these new features was a bit hidden in the background, but of great importance when using SAP Analytics Cloud for Planning. Especially when using Planning on large Data Models with millions of records. If that is the case, it […]
Data Services Python Script Call
In the magical world of data extraction Data Services offers great out of the box functionality to extract data from databases like SQL Server, MySQL, PostgreSQL, Oracle… and from SAP ECC. However, to extract data from REST APIs it lacks some functionality. Therefore, we will use one of the most currently popular programming/scripting language: Python. […]
Comment créer une vue à partir d’une Cluster Table sur SAP
Une table au niveau de la base de données peut parfois contenir de multiple colonnes qui ne font pas l’objet d’un « select .. from .. » souventefois et pour éviter de faire la sélection des colonnes à chaque requête, on préfère opter pour la création de ce qu’on appelle, une vue. Les vues renvoient un […]
Advantages of using SAP Analytics Cloud for a Rolling forecast
What is a rolling forecast? A rolling forecast is a way of reporting that uses historical data to predict future numbers. In contrast to a static budget that is established each year, a rolling forecast is used to revisit and update those budget assumptions throughout the year. This enables companies to react to external or […]
Advantages of using SAP Analytics Cloud for a Rolling forecast
What is a rolling forecast? A rolling forecast is a way of reporting that uses historical data to predict future numbers. In contrast to a static budget that is established each year, a rolling forecast is used to revisit and update those budget assumptions throughout the year. This enables companies to react to external or […]
SAP Datawarehouse Cloud [Part IV]
Governance & Architecture with SAP Datawarehouse Cloud ______________________________________________________ Note: This is the last part of the blog series. If you haven’t read the 3 previous articles, please check them first at Part I, Part II, and Part III. Data Governance is evolving rapidly with the rise of self-service BI and the technologies it governs. In a traditional Datawarehouse set […]
