Greetings,

I'm interested in learning how to create queries against a cubes metadata.
Specifically I'm interested in writing a query, using VB, to return a
collection of bottom level members relative to a given member name.

Using the MDX Sample appication I can execute the query:

select
Descendants([Customer].[All Customer].[Canada],,leaves) on columns
from Sales

to get the members, however, the query appears to attempt to bring back
data, thus is probably an expensive method.

It would be great to understand how to implement a meta data query without
have to resort to recursion,

TIA

There are some threads already discussed in this group. I think you still
have to use ADOMD not DSO, and therefore you still have to use MDX. Because
MDX is designed to query aginst Cube not Meta data.

But looks like it is possible to get meta data from dimension using MDX
directly in AS2005.

http://groups.google.co.kr/groups?hl...gbl%26rnum%3D1

http://groups.google.co.kr/groups?hl...gbl%26rnum%3D7


Ohjoo Kwon


"Rod" <Rod (AT) discussions (DOT) microsoft.com> wrote

If your concern is to avoid accessing any cube data, how about returning
a text measure instead, like:

'[Customers].CurrentMember.Name'
select
{[Measures].[CustomerName]} on columns,
Descendants([Customers].[All Customers].[Canada],,leaves) on rows
from Sales

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!