Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

"SELECT *" in MDX

0 views
Skip to first unread message

Alex

unread,
May 17, 2005, 4:09:08 PM5/17/05
to
Is there an easy way to query something along the lines of "SELECT *"
from a cube? Or must one always define row/column members?

I need to "select *", on just one axis with a "where" slicer as well.

Thanks in advance,

Alex

Igor Krupitsky

unread,
May 18, 2005, 1:50:36 PM5/18/05
to
Alex,

select * in MDX translates to .MEMBERS.

For example "select * from sales" would tralslate to

select
[Measures].MEMBERS on columns,
[Education Level].MEMBERS on rows
from Sales


Regards,
Igor Krupitsky
www.ReportPortal.com

"Alex" <fwd_new...@hotmail.com> wrote in message
news:1116360548.8...@g47g2000cwa.googlegroups.com...

Alex

unread,
May 18, 2005, 4:13:26 PM5/18/05
to
What if I'd like more than one dimension per row? (or all dimensions)

E.G. -

"select

[Measures].Members on columns,
{[Date].Members, [Product].members} on rows


from [KPI Warehouse]"

Igor Krupitsky

unread,
May 18, 2005, 11:57:03 PM5/18/05
to
Try this:

select
[Measures].MEMBERS on columns,

{{[Product].[Product Family].MEMBERS} * {[Time].[Year].MEMBERS}} on rows
from Warehouse

Regards,
Igor Krupitsky
www.ReportPortal.com


"Alex" <fwd_new...@hotmail.com> wrote in message

news:1116447206.8...@f14g2000cwb.googlegroups.com...

0 new messages