title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | ms.custom |
---|---|---|---|---|---|---|---|---|---|
-- (Comment) (MDX) |
Comment - MDX Operator Reference |
kfollis |
kfollis |
kfollis |
02/17/2022 |
sql |
analysis-services |
reference |
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]