Export (0) Print
Expand All

-- (Comment) (MDX)

Indicates comment text that is provided by the user.

-- Comment_Text    

Comment_Text

The string that contains the text of the comment.

Comments can be inserted on a separate line, nested at the end of a Multidimensional Expressions (MDX) script line, or nested within an MDX statement. The server does not evaluate the comment.

Use this operator for single-line or nested comments. Comments inserted with -- are delimited by the newline character.

There is no maximum length for comments.

The following example demonstrates the use of this operator.

-- This member returns the gross profit margin for product types
-- and reseller types crossjoined by year.
SELECT 
    [Date].[Calendar].[Calendar Year].Members *
      [Reseller].[Reseller Type].Children ON 0,
    [Product].[Category].[Category].Members ON 1
FROM -- Select from the Adventure Works cube.
    [Adventure Works]
WHERE
    [Measures].[Gross Profit Margin]

Community Additions

ADD
Show:
© 2014 Microsoft