Any suggestions? Export (0) Print
Expand All

-- (Comment) (MDX)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Indicates comment text that is provided by the user.

-- 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.
    [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]
    [Measures].[Gross Profit Margin]

Community Additions

© 2016 Microsoft