Přihlásit
Microsoft.com
 
Microsoft
 
 
 
Note: Forums will be making significant UX changes to address key usability improvements surrounding search, discoverability and navigation. To learn more about these changes please visit the announcement which can be found HERE.
Microsoft >
> 
> 
MDX code for Cumulative Work in EPM Cube

Dotaz MDX code for Cumulative Work in EPM Cube

  • 15. května 2012 13:59
     
     
    Přihlásit se a hlasovat
    0

    Hi

    Does anyone know how or have a sample of how to add a 'Cumulative Work' field in the EPM 2010 portfolio analyzer cube?

    Any samples would be greatly appreciated.

    Thanks

     

Všechny reakce

  • 16. května 2012 5:45
     
     
    Přihlásit se a hlasovat
    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