none
MDX expression to calculate Cumulative Baseline Work and Cost RRS feed

  • Question

  • Would be extremely grateful for any help with a MDX formula.

    Has anyone written / know of the correct MDX expression to calculate the Cumulative Baseline Cost or Work field in the OLAP cube / Pivot Table ?

    I am a scheduler with minimal programming experience so a thorough answer would be most appreciated.

    Many thanks and regards,

    Mick,

    Bristol, England

     


    Mick Delany

    Wednesday, March 13, 2013 12:25 PM

All replies

  • hi,

    You should try this on the Virtual Portfolio Analyser cube:

    iif([baseline work]=0,NULL,sum(Null:[Time],[measures].[baseline work]))

    For the other cumulatives, you just have to change the field name.

    Regards,

    Sylvain

    Thursday, March 14, 2013 10:58 AM
  • Great - thanks Sylvian,

    I should have mentioned that I am only using OLAP Cubes generated from the Visual Reports feature in MS Project 2010 desktop (no Project Server !)

    Therefore I do not have access to the Portfolio Analyser Cube - only the prebuilt cubes from Visual Reports (eg Baseline Cost Report etc)

    Have tried using your formula as an MDX expression in the Excel Pivot Table but received an error message about expecting a tuple ! I think it was stubling at the [Time] component above.

    Cheers,

    Mick

     


    Mick Delany

    Thursday, March 14, 2013 4:07 PM