instantOLAP Tutorial 2.2.7 - Lesson 4: Adding a time-dimension

Lesson 4: Adding a time-dimension

Till now, our configuration only contains one dimension. But the fact-table of the TUTORIAL-database also contains other columns named "YEAR" and "MONTH". These define the moth which the record of the table is also related to.

In this lesson will we will learn how to set up a calendar-dimension and how to connect it to the cube.

Contents of this chapter:

Adding the time-dimension
Using the time-dimension in your query

Getting started
Tutorial
Lesson 1: Creating a simple configuration and query
Lesson 2: Adding a display-text to the dimenson
Lesson 3: Creating a dimension with a hierarchie
Lesson 4: Adding a time-dimension
Adding the time-dimension
Using the time-dimension in your query