Time for action – change the order of the Month attribute

For this example, we will add some attributes to the date dimension, such as a month attribute, and we will then change the ordering of that attribute to show the correct order as shown in the following steps:

  1. Double-click on the Date dimension in Solution Explorer.
  2. In the Dimension designer, go to the Browser tab; you can see all the members of the Date Key attribute there. Members of the Date Key attribute are integer values with the YYYYMMDD format. This format is not well formed from the business user's perspective. In this example, we will change this format and also add two other attributes for the year and month.
  3. Go to the Dimension Structure tab, select Date Key in the Attributes

Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.