Creating a Month List ​

In preparation for adding formulas to our workviews we will need a hierarchy which acts as an ordered list of months. We will feed this list into a Sequence function in our formula which rolls the prices.

From our model page, click Dimension → Month and then add a new hierarchy named Month List.

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

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

Now we can create our rolling and override price formulas in the next section.