Conventions

In this book, you will find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.

When shown in text, code words NONEMPTY() will be shown as follows: "Optimizing MDX queries using the NONEMPTY() function."

A block of code is set as follows:

SELECT
{ [Measures].[Reseller Order Quantity],
     [Measures].[Reseller Order Count] } ON 0,
   NON EMPTY
   { [Date].[Month of Year].MEMBERS } ON 1
FROM
   [Adventure Works]
WHERE
   ( [Promotion].[Promotion Type].&[New Product] )

When we wish to draw your attention to a particular part of a code block, the relevant lines or items are set in bold:

SELECT
 { [Measures].[Reseller Sales Amount] } ON 0,
 { ParallelPeriod(
   [Geography].[Geography].[Country],
   2,
   [Geography].[Geography].[State-Province].&[CA]&[US]
                 )
 } ON 1
FROM
 [Adventure Works]

New terms and important words are shown in bold. Words that you see on the screen, in menus or dialog boxes for example, appear in the text like this: "We can verify this by browsing the Geography user hierarchy in the Geography dimension in SQL Server Management Studio".