O'Reilly logo

SQL Server 2012 Reporting Services Blueprints by Mickey Stuewe, Marlon Ribunal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a calculated member

Since we want to take advantage of the power of the analytic engine, we want all of the aggregations in our report to be calculated in the cube rather than in our report server. This is an efficient way of handling the calculations.

Let's say we want to find out the variance between the sales goal and the actual sales of each territory in dollars. We can handle this simple calculation using the query designer:

  1. On the query designer, right-click on the empty space in the Calculated Members pane on the lower left-hand side of the designer, as shown in the following screenshot:
    Creating a calculated member
  2. That displays the Calculated Member Builder

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required