O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

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

Calculated Members and Named Sets

Although OLAP cubes contain summarized and synthesized subsets of your raw corporate data, your business requirements might dictate that you add more aggregations. These are called calculated members because you most often create them by writing MDX expressions that reference existing members in the measures dimension.

For instance, if you want to create a calculated member on Profit Per Unit (as Internet Gross Profit divided by Internet Order Quantity) and use that as the sort definition in a subsequent MDX query, you can use the WITH MEMBER statement to create a new calculation on the fly. For instance, the following query creates a calculated member that not only appears in the COLUMNS axis, but is also used ...

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