|
Home > Archive > MS SQL Server OLAP > September 2005 > Simple MDX question - selecting dimension members
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Simple MDX question - selecting dimension members
|
|
| Kevin Dente 2005-09-21, 1:26 pm |
| 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?
| |
| Deepak Puri 2005-09-22, 3:23 am |
| 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:
[color=darkred]
select Non Empty [Store].[Store State].Members on columns
from Sales
----------
select Non Empty [Store].[Store State].Members on columns
from Sales
where [Measures].[Unit Sales][color=darkred
]
- Deepak
Deepak Puri
Microsoft MVP - SQL Server
*** Sent via Developersdex http://www.droptable.com ***
| |
| Kevin Dente 2005-09-22, 8:24 pm |
| 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@progress
ive.com> wrote in message
news:OKhU4BzvFHA.3860@TK2MSFTNGP09.phx.gbl...
> 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:
>
> select Non Empty [Store].[Store State].Members on columns
> 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.droptable.com ***
| |
| Darren Gosbell 2005-09-26, 3:23 am |
| 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_do
t_com>
Blog: http://www.geekswithblogs.net/darrengosbell
In article <eQh2xM6vFHA.2792@tk2msftngp13.phx.gbl>,
kevind@no.spam.denteworld.com says...
> 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@progress
ive.com> wrote in message
> news:OKhU4BzvFHA.3860@TK2MSFTNGP09.phx.gbl...
>
>
>
|
|
|
|
|