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

• Bill Pearson

  SSCommitted

  Points: 1520

  More actions

  August 9, 2011 at 8:58 am

  #242971

  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: 535

  More actions

  August 30, 2011 at 12:02 pm

  #1375179

  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.