Re: Can a query return a list of all measures?

From: Jamie Thomson (jamie.thomson_at_donotspam.conchango.com)
Date: 10/08/04 

Date: Fri, 8 Oct 2004 14:09:12 -0700

OK, try this:
select
   {measures.children} on rows,
   {<dimension>.defaultmember} on columns
from <cube>

<dimension> can be any of your dimensions. It doesn't matter which one.

Regards
Jamie Thomson
http://www.conchango.com

"Jim L" wrote:

> I"m not getting anywhere with this.
>
> The MDX sample app that comes with reporting services reports
> an "Axis name is unrecognized or duplicated or creates a sequence gap
> 'rows'" . If I try to put it on columns I get an "Cells cannot be created
> ..... because one of the axis contains no postitions"
>
> I have also tried with the ProClarity OLAP client application and get the
> same "..sequence gap" error message.
>
> Jim
>
>
>
>
> "Jamie Thomson" <jamie.thomson@donotspam.conchango.com> wrote in message
> news:E4D8B768-30F8-4593-8EF1-F9C6D3307F3D@microsoft.com...
> > Try:
> > select
> > measures.children on rows
> > from <cube>
> >
> > Regards
> > Jamie Thomson
> > http://www.conchango.com
> >
> >
> >
> > "Jim L" wrote:
> >
> >> I want to make an MDX query that will return a list of available
> >> measures.
> >> Can anyone help with this?
> >>
> >>
> >> Thanks,
> >>
> >> Jim
> >>
> >>
> >>
>
>
>

Relevant Pages
Loading