Calculated Measures and Named Sets

Overview

Fields from fact tables get converted into measures in measuregroups in a cube. When measuregroups are created in a cube, one measuregroup is created per fact table. Often in production systems, developing calculated measures is a regular requirement. Multi-Dimensional Expressions (MDX) is the query language for a cube and is synonymous to what T-SQL is to SQL Server. Often queries that are frequently used are required to be in some ready format in a cube, so that the users do not need to develop them over and over again. One of the solutions for this is named sets, which can be perceived as a query already defined in the cube, similar to views in SQL Server. We will develop a calculated measure and a few named sets in this section.

Source collected from mssqltips.com