Frank Banin (12/18/2012)
Comments posted to this topic are about the item <A HREF="/articles/MDX/91730/">MDX Guide for SQL Folks: Part II - Hierarchies and Functions </A>
Very good article.
There does seem to be a few typos in areas:
Missing &
SELECT
(
[Measures].[Internet Sales Amount]
,[Product].[Category].[Bikes]
,[Sales Territory].[Sales Territory Group].&[Europe]
,[Sales Territory].[Sales Territory Group].[North America]
,[Sales Territory].[Sales Territory Group]. [Pacific]
)
ON COLUMNS
FROM [Adventure Works];
should be:
SELECT
(
[Measures].[Internet Sales Amount]
,[Product].[Category].[Bikes]
,[Sales Territory].[Sales Territory Group].&[Europe]
,[Sales Territory].[Sales Territory Group].&[North America]
,[Sales Territory].[Sales Territory Group].&[Pacific]
)
ON COLUMNS
FROM [Adventure Works];
A missing comma after COLUMNS
SELECT
[Measures].[Internet Sales Amount] ON COLUMNS
{
[Sales Territory].[Sales Territory Group].&[Europe],
[Sales Territory].[Sales Territory Group].&[North America],
[Sales Territory].[Sales Territory Group].&[Pacific]
} ON ROWS
FROM [Adventure Works]
WHERE [Product].[Category].[Bikes];
None of these are big deals, but they will cause a person new to MDX some consternation.
Well done,
Rob