This section describes how to add comments to MDX queries.
MDX supports two types of syntax for comments:
Example:
/* commented text is ignored by parser */
Example:
-- short comment can go on till line break
The following example uses both styles of comments:
/* Query the profit figures in each
market for the "100" products
*/
SELECT
{([Market].levels(1).members)} --L1 members of Market
ON COLUMNS,
--Cross of the "100" products and their profit figures:
CrossJoin ([100].children, [Profit].children)
ON ROWS
FROM Sample.Basic
| ©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |