cloud · 28. February 2024
In this post I want to describe how you can use hierarchies in SAP Datasphere just like in good old SAP BW. To be able to use a hierarchy in SAP Datasphere like in SAP Business Warehouse, you need an object with the semantic type "Hierarchy with Directory". There are several blog posts on this topic that explain it in detail:
cloud · 04. January 2024
I know it's been a long time since I wrote the last post, and also make some housekeeping on the site. But the last quarter was as always very busy with different topics. I have now four pilot projects with SAP Datasphere, which I have to manage and develop the cool stuff. 😉 For example, how to use the command line interface (CLI) for SAP Datasphere to create views or tables based on a remote table. I had a really cool meeting with Ronald & Tim about this topic - Thank you guys for the...
cloud · 31. May 2023
SAP BW hierarchy
It was quite a bit silent here. That's a fact. I had a lot on my plate since I have a new job and also before the promotion. But now I have a super cool topic on my mind I want to share with you. Hierarchies are a common topic in companies. They offer the business users' flexibility to navigate in the frontend reports. In this example, I flatten the hierarchy structure to consume a hierarchy with text nodes and infoobjects. The Product Group hierarchy looks like the following screenshot.
cloud · 08. March 2023
Data Warehouse Cloud: Analytic Model
The Data Warehouse Cloud Analytic Model is now on all tenants available. With this wave, you have now the possibility to use instead of an Analytical Dataset (ADS) the new Analytic Model. The Analytic Model is a kind of cube which allows you to slice and dice your data model. I wrote about the preview access on December, and now I want to show you some details.
cloud · 22. December 2022
Wow! It's now a long time since I wrote the last blog post. I think many of my posts starts with this now. But anyway, let's get back to the subject. I have the opportunity to have a look at the new Data Warehouse Cloud (DWC) Analytic Model. It was presented in the keynote of Hagen Jander and Eric Schemer on the DSAG Jahreskongress.
cloud · 19. April 2022
SAP BW transaction stc01
In this blog post, I want to share my experience with the Data Warehouse Cloud Bridge. There are several blogs out there that describe how to set up eclipse ( and So I won't consider this, because there are other sources for this. I will focus on problems I had during the conversion from an SAP...
cloud · 29. March 2022
SAP BW InfoObject with hierarchy
There are different ways to create hierarchies in Data Warehouse Cloud. One way is to use a CSV file and upload it into DWC. Another way is to use the existing hierarchies of your SAP BW system. In this post, I want to show how to use a hierarchy from BW and transform it into a parent-child hierarchy in Data Warehouse Cloud. After the transformation, we use the hierarchy in a view. First, we need a hierarchy on one InfoObject in SAP BW.
cloud · 15. February 2022
SQL View in Data Warehouse Cloud
There are different ideas and logics to determine year-to-date. Besides my post, which is also available on there is another post to determine a week-to-date (WTD) and year-to-date (YTD). I think that idea is also a good starting point, and I looked into it.
cloud · 22. January 2022
control table
In this blog post, I want to share an idea of how you can generate month-to-date (MTD), quarter-to-date (QTD), and year-to-date (YTD) values in SAP Data Warehouse Cloud (DWC). This is only one way, I think there are several other ways how you can solve this issue. I am happy to discuss your ideas in the comment section. In my old post, I describe the same logic for SAP HANA Calculation Views.
cloud · 23. March 2021
Create a hierarchy in SAP Data Warehouse Cloud
In the last post I wrote about authorizations in SAP Data Warehouse Cloud and I had an open topic about authorization on hierarchy nodes in SAP DWC. So I looked into and here is one example of how it could work at the moment. I don't know if SAP changes something in future releases. So let us started with a CSV file to create our authorization we can use in the SAP Data Warehouse Cloud. I would now authorize my user to a Product Category because my hierarchy looks like this:

Show more