Dimensions and measures

At the time of cube development in the SSAS, there might be many times when you would need to make changes to the dimensions and measures. For example, you might need to change the display format of a measure or change the aggregation function of it. For dimensions, you might also need to add/remove an attribute or change the relationship between the attributes. In this section, we will add some attributes to the Sales Territory dimension and also make changes in the display format of the measures.

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.