Skip to content

Creating a Dimension

Let’s create some of the necessary dimensions. Creating a dimension is very simple, we can go to Dimensions tab from the Model page and and in the top right of the page there is a New Dimension button.

Creation of a new dimension

Once we hit the New Dimension button, a window will pop up to name the dimension. We will create a dimension called Month with type Standard. Month dimension

In a dimension we can have alternative hierarchies to allow for multiple ways of reporting on the underlying information within a cube.

We will make a month dimension with two hierarchies. First is a list of months for the Default hierarchy:

js
All Months
	Jul
	Aug
	Sep
	Oct
	Nov
	Dec
	Jan
	Feb
	Mar
	Apr
	May
	Jun
All Months
	Jul
	Aug
	Sep
	Oct
	Nov
	Dec
	Jan
	Feb
	Mar
	Apr
	May
	Jun

Month Default Hierarchy

Click on the Save Changes in the top right to save the Default Hierarchy.

Next, to create the Quarters hierarchy we will click Add located above the hierarchy list.

Creating a New Hierarchy from Dimension Management page

Name the new hierarchy as Quarters and set its contents as follows:

js
Full Year
	Q1
		Jul
		Aug
		Sep
	Q2
		Oct
		Nov
		Dec
	Q3
		Jan
		Feb
		Mar
	Q4
		Apr
		May
		Jun
Annual
Full Year
	Q1
		Jul
		Aug
		Sep
	Q2
		Oct
		Nov
		Dec
	Q3
		Jan
		Feb
		Mar
	Q4
		Apr
		May
		Jun
Annual

Month Quarters Hierarchy

The annual element at the bottom will be used to hold annual assumptions. Once we have entered the values in a hierarchy, we will hit the Save Changes button.