dbTalk Databases Forums  

Obtaining a complete list of members in a dimension

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Obtaining a complete list of members in a dimension in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Satori
 
Posts: n/a

Default Obtaining a complete list of members in a dimension - 06-06-2006 , 09:14 AM






What is the best way to obtain a list of distinct members in a dimension
independent of a cube?
We need the flat list of members without their hierarchical attributes.
We also need computed members to be included in the list.
A code snippet would help.
We are using MSAS 2005 and C## 2005


Reply With Quote
  #2  
Old   
AT
 
Posts: n/a

Default RE: Obtaining a complete list of members in a dimension - 06-06-2006 , 09:09 PM






Hello,

Based on my scope, the easiest way to get members is to use the GetMembers
method of a level object or the GetChildren method of another member
object. These methods are simple to use in simple cases requiring no
parameters. For example:

MemberCollection productMembers = productLevel.GetMembers();

MemberCollection chilren = productMembers[0].GetChildren();

You may want to refer to the following link for details:


http://forums.microsoft.com/MSDN/Sho...21601&SiteID=1

Thanks & Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===


This posting is provided "AS IS" with no warranties, and confers no rights.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.