Hi!

I've noticed some client applications generate MDX in such a way that
members are referenced like [Dimension].[Level].&[Member], or something of
the sort.

What does the & character mean?

Thanks!

THe "&" references the key, rather than the name of the member. This MS
KB article explains MDX name styles:

http://support.microsoft.com/default...b;en-us;304337
...
An alternative to the Name Path algorithm is the Key Path algorithm,
where the path is defined by the keys rather than the member names. If
the path is defined by keys, the syntax is

[Time].&[1997].&[Q1].&[1]
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***