TechNet
Export (0) Print
Expand All

-- (Comment) (MDX)

 

Updated: March 2, 2016

Indicates comment text that is provided by the user.


-- Comment_Text    

Parameters

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]

Comment (MDX)
(Comment) (MDX)
MDX Operator Reference (MDX)

Community Additions

ADD
Show:
© 2016 Microsoft