CODEWITHSUNDEEP
ssasmdx
NeedHack
NeedHack

Reputation: 3011

MDX query on a single dimension

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]

Upvotes: 0

Views: 2316

Answers (1)

Marc Polizzi
Marc Polizzi

Reputation: 9375

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]

Upvotes: 5

Related Questions