MDSCHEMA_MEMBERS - querying children/descendants

From: Matt Worsnop (matthew.worsnop_at_alphameric.com)
Date: 04/22/04

  • Next message: andrewprinceton_at_yahoo.com: "Straight Stud" 
    Date: 22 Apr 2004 06:17:08 -0700

    I have two issues with MDSCHEMA_MEMBERS that I'm having problems with.

    The first is that I need a way of returning the children of multiple
    members, and I can only see a way of returning the children of a
    single member. Ideally, I would rather not have to make multiple trips
    to the server for obvious reasons.

    Secondly, I need a way of querying descendants of a specific member,
    but only down to a specific level - not all the way down to the leaf
    node level. The only approach I can think of is to request the
    member's children, then the children of all of those children (one at
    a time - see question one!) and so on, until I reach the desired
    level. The number of trips to the server could be horrendous doing
    this.

    I realise that I can probably achieve both of the above using MDX, but
    I don't want any data at the point I'm doing this, and in any case, I
    understand that the schema query is supposed to be faster.

    Can anyone help? Is there some way that I've missed of achieving this?
    If not, then has anyone hit similar issues, and found a satisfactory
    workaround?

    Thanks

    Matt Worsnop

  • Next message: andrewprinceton_at_yahoo.com: "Straight Stud"

    Relevant Pages

    • RE: Need help with Tables Design and Relationships
      ... Member: Project = M:M - needs junction table ... The organization has multiple projects ... Multiple employees can be assigned to multiple projects ...
      (microsoft.public.access.tablesdbdesign)
    • Re: Tables - Membership DB - advice needed
      ... <I won't get confused with the Member ID field. ... <the tblMember?) Is the MembershipPK here an a auto-id field? ... The one to many relationship allows multiple ...
      (microsoft.public.access.tablesdbdesign)
    • Re: Allowed Member Set with 2 Attributes
      ... directly or indirectly related (ie. where the same member never appears ... to the hierarchy since it will never appear under multiple branches? ... Account Group ... what is the highest level to which all higher levels are ...
      (microsoft.public.sqlserver.olap)
    • Re: Data Model Help
      ... "35 distinct assessment areas with multiple questions in each area and some ... CASES (each member can have multiple cases) ... the first question would be is my data model ok and I'm just dealing ...
      (microsoft.public.access.tablesdbdesign)
    • Re: Disable dimension multi-select?
      ... multiple values in calculation? ... There will be no hierarchies defined for this dimension. ... can disable the "All" member, ...
      (microsoft.public.sqlserver.olap)