Export (0) Print
Expand All

Comments in MDX

SQL Server 2000

Statements in Multidimensional Expressions (MDX) can contain user-readable comments that are ignored when the commands are processed. The three different character sets that indicate comments are outlined in the following table.

Characters Description
// C++-style forward slashes. All text between the forward slashes and the end of the same line is ignored.
-- SQL-style hyphens. All text between the dashes and the end of the same line is ignored.
/*...*/ C-style forward slash and asterisk pairs. All text between the opening forward slash and asterisk and the closing asterisk and backward slash is ignored. This type of comment can span multiple lines.

The following example shows the use of comments in an MDX command:

/* Using this query to view 
   info about units shipped 
   and units ordered  */

WITH MEMBER [Measures].[ShippingPercent] AS
'-- Returns [Units Shipped] over [Units Ordered] as a percent value
Measures.[Units Shipped] / Measures.[Units Ordered]',
FORMAT_STRING = 'Percent'

SELECT
   { [Measures].[Units Shipped], [Measures].[Units Ordered], [Measures].[ShippingPercent] } ON COLUMNS,
// The next command specifies nonempty members only
   NON EMPTY [Store].[Store Name].Members ON ROWS
FROM Warehouse   -- Pulled from the Warehouse cube

Comments are recommended in complex or difficult to understand MDX queries, because they add information without incurring performance penalties.

Show:
© 2014 Microsoft