CODEWITHSUNDEEP
mdxolapmondrian
Daniel
Daniel

Reputation: 28104

Good MDX default query

I have build an MDX editor and now need a good default query which executes and already has two dimensions. I would like to place the measures on the first dimension (without knowing their names), and any other cube dimension on the second result dimension. Currently I have achived this:

select {[Measures].members} ON COLUMNS
  from [mycubename]

But I don't know how to populate the second column... Any Ideas?

Something like 

select {[Measures].members} ON COLUMNS,
       {[Dimensions].[first].members} ON ROWS  
  from [mycubename]

which would work against any cube if the cube name is given in the from clause.

Upvotes: 1

Views: 373

Answers (1)

Meff
Meff

Reputation: 5999

This works in Microsoft SSAS, so you may need to tweak the syntax for Mondrian:

SELECT Measures.DefaultMember ON COLUMNS,
Dimensions(1).Members ON ROWS
FROM [Cube]

Upvotes: 2

Related Questions