I want to make an MDX query that will return a list of available measures.
Can anyone help with this?


Thanks,

Jim

Try:
select
measures.children on rows
from <cube>

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 (AT) donotspam (DOT) conchango.com> wrote

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:

This is a Foodmart query that may be what you want:

with member store.[measurename] as 'measures.currentmember.name'
select {[measurename]} on columns,
measures.members on rows
from sales

You should substitute "store" by any dimension in your cube other than
measures.

As a general rule it is a better practice to retrieve metadata such as
measures, dimension members, etc using OLE DB for OLAP schema rowsets or
equivalent methods in other APIs (such as the Discover method in XML/A or the
CubeDef object in ADOMD.net).
HTH,
Brian Altmann
www.geocities.com/brianaltmann/olap.html




"Jim L" wrote: