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    

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]
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft