Name changed from SAP Data Warehouse Cloud to SAP Datasphere. Some links may break

Someone ask me how you could create a time hierarchy in SAP Datasphere (DSP) 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.

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 Datasphere.

Now we see in the Data Builder of the SAP Datasphere 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 Datasphere. 

My example file here are the sales orders with a date in one column, so we can build our hierarchy.

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.

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 Datasphere and use it in SAP Analytics Cloud. I hope this will help to get started with Datasphere. If you have any questions, feel free to ask in the comments.

• 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 e-book Analysis Office - The Comprehensive Guide for free