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

Creating Permanent Calculated Members

Up until now, you’ve been placing calculations and named sets in-line, as part of the MDX query. In an actual production environment, if you want to reuse these definitions, it’s a good idea to store these calculated members and named sets inside the OLAP cube. As we discussed in Chapter 8, you create permanent calculated members using the Calculations tab in BIDS.

For example, you might want to create a calculation for sales for the previous fiscal period (which could be the previous month, previous quarter, or even previous year from the current date selection) using the following MDX code.

WITH MEMBER [SalesPriorFiscalPeriod] AS ([Measures].[Internet Sales Amount], [Date].[Fiscal].PrevMember) SELECT {[SalesPriorFiscalPeriod], ...

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