February 25, 2014 at 8:28 am
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy