Defining calculated measures

You can add calculations to the cube at any time by simply typing calculation definitions on the Calculations tab and saving the database. Cube-level calculations are stored in the MDX script, which you can review on the cube designer's Calculations tab. This tab has two views: Form View and Script View. The Form View is helpful in developing individual calculated members, calculated measures, and named sets. The Script View contains all calculations as a single script, which is essentially a collection of MDX statements separated by semicolons. Regardless of whether you use Form View or Script View, the Calculations tab includes the metadata—dimensions and measures as well as a list of all supported MDX functions along with the syntax reference. Additionally, SSDT also includes templates for the most common types of calculations.

Calculated measures are measures derived by performing operations on other, previously defined measures. Calculated members are very...