MDX code for Cumulative Work in EPM Cube

Wszystkie odpowiedzi

• 16 maja 2012 05:45

   

   
  

  0

  Hi there--

  Cumulative Work for a tasks is calculated based on work already performed on the task + scheduled remaining work on the task.
  These values are based on the task Work field and added to the previous time period for the cumulative value. For each time period, cumulative work equals cumulative work for the previous period + scheduled work for this period.

  Please see the below example:
  http://carl-projectserver.blogspot.in/2011/06/return-of-data-geek-epm-olap-cube.html

  This example would give you a cumulative WORK calculation, specifically from the earliest date possible.
  >  sum(periodstodate([time].[(all)]),[measures].[Work])

  Some more samples:
  http://www.msprojectnow.com/Blog/tabid/142/entryid/11/Default.aspx

  Hope that helps.

  ---

  If you found this post helpful, Please "Vote as Helpful";. If it answered your question, Please "Mark as Answer".
  
  Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

  
  

  • Zmodyfikowany przez Amit Khare - Project Management Consultant 16 maja 2012 05:46
  •  
  • Odpowiedz
  • Cytuj