problem with measaures

• cbscarlos

  SSC Enthusiast

  Points: 186

  More actions

  June 19, 2008 at 5:32 am

  #124378

  i have a measures :

  sum(nonempty([Time].[Year - Trimester - Month - Date].currentmember.lastchild,[Measures].[Cantidad]),

  [Measures].[stock])

  and [Measures].[stock] is :

  Sum(

  PeriodsToDate([Time].[Year - Trimester - Month - Date].[(All)]

  ,[Time].[Year - Trimester - Month - Date].currentmember),

  [Measures].[Cantidad]

  )

  my problem is when i have a time filter by date (day) in browser and in columns is the Months , the stock is the last stock nonempty of month and i want if i have a filter 15 september that is the stock of 15 septiembre and not 31 septiembre.

  thanks

• GGKK

  SSC Veteran

  Points: 205

  More actions

  July 7, 2008 at 3:26 am

  #838737

  Try this function in the MDX using WITH Member clause,

  Sum({ClosingPeriod([Time].[Year - Trimester - Month - Date],[Time].[All Time]).lag(15)},([Measures].CurrentMember))

  where 15=filtervalue ie., before 15 days for example.