Named Sets and Calculated Members

You can use MDX to specify a name for set expressions (named sets). You can also define formulas and treat the formula as a new member.

Named sets are useful because they can be used concisely in other MDX expressions. Creating formulas and treating them as members of a dimension is a very powerful feature and has a variety of applications. The following examples illustrate these concepts.