Auto Generating Time Dimensions and Tables in Spaces

Time Dimensions allow a time entry to utilize all the time functions in a SAC story. Time dimensions and related tables can be created automatically in a space in Datasphere.
Beginner
March 6, 2024

Dimensions tables add extended properties about dimension members.

These properties could describe the date with every time entry, like what day of the week it is or the hierarchy of that time. This makes time dimensions useful but also large and hard to maintain.

Datasphere will generate time dimensions that can be associated with a model and utilize all the functions found in SAC, such as Time Series charts and drillable hierarchies.

To create time dimensions:

1

Select Space Management in Datasphere.

2

Find your space, and click edit.

3

Scroll down to Time Data.

4

Select Create Time Tables and Dimensions. A “create timetable and dimension” popup will open.

5

In the Time Table Settings, update the range of years populated in the dimensions using the From Year and the To Year options.

Note

The Calendar Type and Granularity are currently fixed to Gregorian and Day.

Time Dimensions show the 4 dimension tables that will be generated. These are for Year, Quarter, Month, and Day.

In addition, 3 translation tables are also created.

6

Click Create. The space will automatically deploy the tables.

Tips

  • To make changes to the time configuration, select Edit
  • Once you have made changes, click the Update Time Data Views
  • To delete your Time Tables, select Delete

7

Select Data Builder from the Navigation Bar. Your tables and views are generated here.

8

Select the Time Table.

9

Toggle on the Data Viewer to see the generated data.

This table will contain a Timestamp as a primary key for every day within the selected From Year to To Year.

Then, it will have columns containing further attributes describing each day.

Learning Path

Enroll Today!

This learning path would be a great starting place if you want to learn more about the topics covered in this article.

Learning Path Thumbnail

Next

Next Article

Previous

Previous Article

See What's New

Featured Articles

Our most recent and proudest works, ready to make your life a little bit easier.

SAP Analytics Cloud

SAC Key Features & Capabilities

Let’s learn about the key features and capabilities of SAP Analytics Cloud.

Datasphere

Creating a Space

Spaces are the areas where all data is retrieved, prepared and modeled. This article will walk you through creating a space in Datasphere.

SAP Analytics Cloud

Adding a Table (Datasphere Dataset)

Learn how to insert a table based on an existing SAP Datasphere dataset.

Curated For You

Article Recommendations

Here are some articles handpicked by our experts to help you continue your learning journey.

Datasphere

Creating a Space

Spaces are the areas where all data is retrieved, prepared and modeled. This article will walk you through creating a space in Datasphere.

Datasphere

Managing Space Storage

A space could be allocated with either too much storage and memory or too little. In this article, we will look at how to gauge this and walk through correcting it.

Datasphere

Setting Up External Database Access in a Space

You may require your data and models to be accessed externally, by third-party BI products. The first stage is to create Database Users.
New SAP Boosters!

Learn all about SAP functions in the SAC Add-in for Excel or discover the all new SAC Add-in for PowerPoint.

Contact Us

Reach out if you have any questions or to see how we can create a custom training solution for your organization!

Contact Form Pop-Up - General Use

Custom Training Solution

Fill out and submit the form below, and we’ll reach out to you to discuss how we can work toward achieving your training goals in a way that works best for you and your team.

Contact Form - Custom Training