Stairway to MDX - Level 8: Member “Family” Functions: .LastChild and .FirstSibling

  • Bill Pearson

    Ten Centuries

    Points: 1359

    Comments posted to this topic are about the item Stairway to MDX - Level 8: Member “Family” Functions: .LastChild and .FirstSibling

  • jeff122877

    Mr or Mrs. 500

    Points: 525

    I'm getting a strange result from the following. Any clues as to why?

    {[Date].[Calendar].[Calendar Quarter].[Q1 CY 2007].firstsibling}

    Returns itself, Q1 CY 2007 (ok I understand that)

    {[Date].[Calendar].[Calendar Quarter].[Q2 CY 2007].firstsibling}

    Returns Q1 CY 2007 (makes complete sense)

    {[Date].[Calendar].[Calendar Quarter].[Q3 CY 2007].firstsibling}

    Returns itself, Q3 CY 2007. A bit confused here. Is it because the parent for Q1 and Q2 are different than the parent for Q3 and Q4?

    Jeff.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply