Someone ask me how you could create a time hierarchy in SAP Data Warehouse Cloud (DWC) to use it in SAP Analytics Cloud (SAC). Because out of the box by just create the time dimension it isn't working right now. So here are the steps you have to make.
1. Create a new Space
First we create a new space and start from scratch.
After we created our new space and added our user to this space, we are able to create the time dimensions direclty in SAP Data Warehouse Cloud.
2. Data Builder and Upload an own file
Now we see in the Data Builder of the SAP Data Warehouse Cloud the time dimensions we just created.
To show you an example I need to upload some example data. We use for this the CSV-File upload functionality of Data Warehouse Cloud.
My example file here are the sales orders with a date in one column, so we can build our hierarchy.
3. Create a new graphical view
After I uploaded my files, we can create a new graphical view to associate our time dimension to our sales data.
As you see the view is very simple we just join the sales order header with the details. Now we can assign in the properties of the view element our time dimension.
Now we can select our association target and here we select the time dimension day and click OK.
Now we have to join our view with the time dimension. In my case I use the order date for my hierarchy.
As penultimate step of this view we define our view as an Analytical Dataset and expose it for consumption. As last step we save and deploy our view to make it available in the SAP Analytics Cloud.
4. Create SAC Story
Now after we have deployed our view we can switch through the application switcher to the SAP Analytics Cloud.
We open via the menu our corresponding space and create a new story there.
Here we have to select our Analytical Dataset.
After we selected our Analytical Dataset, we choose for the demonstration a table to show the hierarchy.
Now we add the Order Date to our table and can select our corresponding hierarchy.
As you see our table shows the time hierarchy.
When you know where the options are, it is not heavy to build a time hierarchy in SAP Data Warehouse Cloud and use it in SAP Analytics Cloud. I hope this will help to get started with Data Warehouse Cloud. If you have any questions, feel free to ask in the comments.
I am Tobias, I write this blog since 2014, you can find me on twitter, facebook and youtube. I work as a Senior Business Warehouse Consultant. In 2016 I wrote the first edition of Analysis Office - The Comprehensive Guide. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.
- In my newsletter you get informed about new topics
- You learn how to use Analysis Office
- You get tips and tricks about SAP BI topics
- You get the first 3 chapters of my ebook Analysis Office - The Comprehensive Guide for free
You want to know SAP Analysis Office in a perfect detail?
You want to know how to build an Excel Dashboard with your Query in Analysis Office?
You want to know how functions in SAP Analysis Office works?
Then you have to take a look into Analysis Office - The Comprehensive Guide. Either as a video course or as a ebook.