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

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

  • 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 1 (of 1 total)

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