0
votes

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]
1

1 Answers

5
votes

I guess they're called "dimension cube":

select [dim].members on 0 from [$dim]

or

select [Measures].defaultMember on 0, [dim].members on 1 from [$dim]