When I run an MDX query like this:

select [Dimension Name].Members on columns from [Cube Name]

the result comes back with multiple columns and one "row". Obviously I'm not
requesting any measure values (or anything else on rows), so I assume the
server/client library/whatever is synthesizing that row. What do the
contents of that row represent?

The values belong to the cube default measure. For example, the Foodmart
Sales cube has [Unit Sales] as default, and so these 2 MDX queries
return the same results:

from Sales

----------

select Non Empty [Store].[Store State].Members on columns
from Sales
where [Measures].[Unit Sales]

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

Hmm, interesting. In this case, the cube doesn't have a default measure set.
Is SSAS just picking one (this is SSAS 2005, btw)?


"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote

If you have not explicitly set a default measure I believe the first
measure in the list will be used.

BTW every dimension has a default member, its just that for all the
other dimensions their default is the All member.

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

In article <eQh2xM6vFHA.2792 (AT) tk2msftngp13 (DOT) phx.gbl>,
kevind (AT) no (DOT) spam.denteworld.com says...