Can someone please remind me how I do this?
I want an MDX query (MS SSAS) which will query a dimension. Not interested in cubes or measures.
So far as I remember the syntax involves a $ sign, something like [$MyDimension].
I know I can do the below, but I want to query the dimension without touching a cube.
select [DimensionName].Children on 0 from [CubeName]