Comment - MDX Operator Reference

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Indicates comment text that is provided by the user.

Syntax


-- Comment_Text      

Parameters

Comment_Text
The string that contains the text of the comment.

Remarks

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.

Examples

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]  

See Also

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