MDX Query

• Kumara1011

  SSC-Addicted

  Points: 424

  More actions

  April 29, 2013 at 11:03 pm

  #273383

  Hi,

  While running the MDX query to return prevoius month data, i am getting getting Null for previous month data.

  With

  member [measures].[T1_pytd_sales]

  as

  sum(parallelperiod([Time].[Fiscal].[Year],1,

  [Time].[Fiscal].currentmember),[Measures].[Spend])

  member [measures].[T1_ytd_sales] as

  sum([Time].[Fiscal].currentmember,[Measures].[Spend])

  member [measures].[DiffTier1] as

  '[measures].[T1_ytd_sales]-[measures].[T1_pytd_sales]'

  seelct

  (descendants({Closingperiod([Time].[Fiscal].[Year])},

  [Time].[Fiscal].[Month])*{[T1_ytd_sales],[measures].[T1_pytd_sales],[measures].[DiffTier1]}) on columns

  from

  cube

  Actually we have two time dimesions. Its working fine for one dimension, but its getting Null for other time dimension.

  For T1_pytd_sales, i am getting NULL for Month wise even for yearly also.

  Can anyone what could be the reason?

  Thanks in advance.