MDX error: The 'Fiscal' hierarchy appears more than once in the tuple

• john_k

  SSC Veteran

  Points: 270

  More actions

  October 16, 2008 at 11:18 am

  #383102

  I'm new to MDX and having trouble with the following:

  WITH MEMBER [Time].[Fiscal].[FYTD] AS

  Aggregate(PeriodsToDate([Time].[Fiscal].[Fiscal Year],

  [Time].[Fiscal].[Fiscal Period].&[200809]))

  SELECT

  ([Time].[Fiscal].[FYTD], [Time].[Fiscal].[Fiscal Year].&[2009]) ON COLUMNS,

  non empty([Person Office].[Office].Children) ON ROWS

  FROM

  [Performance]

  WHERE

  [Measures].[Time Billable Hours]

  It runs well when I run it only for the member FYTD, but when I add the second column for FY 2009 I get the error:

  The 'Fiscal' hierarchy appears more than once in the tuple.

  Any help would be appreciated.

  Thanks,

  John

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  October 16, 2008 at 11:49 am

  #886013

  enclose it in a set:

  ({[Time].[Fiscal].[FYTD], [Time].[Fiscal].[Fiscal Year].&[2009]}) ON COLUMNS,

• john_k

  SSC Veteran

  Points: 270

  More actions

  October 16, 2008 at 11:54 am

  #886018

  That did it. Thank you.