Post reply

Converting Negative Numbers to Positive in PerformancePoint 2010

  • February 25, 2014 at 8:28 am

    #396319

    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?

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

  • March 5, 2014 at 10:43 am

    #1694417

    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 1 (of 1 total)

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