Converting Negative Numbers to Positive in PerformancePoint 2010

  • //Ravi

    SSCrazy

    Points: 2612

    How can I convert negative accounting numbers to positive to display in PerformancePoint 2010?

    I am using a Analysis Services 2008 Cube as a datasource. I can use drag and drop option to build my query and display all the data, but everything is in negative. I thought I can do it if I learn MDX. I spent a week learning MDX.

    I wrote the query in MDX, but ran into another problem: if I write a MDX query, I loose all the ability to drill down on details in PerformancePoint. Has this happened to anyone before?

    ------------
    🙂

  • //Ravi

    SSCrazy

    Points: 2612

    I got an answer for this from Stacia Misner:

    Unfortunately once you customize the MDX, you lose the context-sensitive features in PPS such as drilldown. The only way to resolve this is to add the calculation to the cube.

    ------------
    🙂

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply