-
metadata query - navigate without data
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
-
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.
-
Thanks joohz, that looks a really useful site, Best Regards
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|