metadata query - navigate without data

[vanskier]

Greetings, I'm interested in learning how to create queries against a cubes metadata. Specifically I'm interested in writing a aquery, 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

[joozh]

Hi vanskier,

Though this will not directly help (maybe) but you might want to read tons of really useful articles on the following URL

http://www.databasejournal.com/article.php/1459531

So far, I have gone through some of the articles (that you will find via the URL posted above) and have found them to be extremely useful. You might find an answer to your query too.

HTH

Regards.

[vanskier]

Thanks joohz, that looks a really useful site, Best Regards