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?