Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Converting Negative Numbers to Positive in PerformancePoint 2010 Expand / Collapse
Author
Message
Posted Tuesday, February 25, 2014 8:28 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 2, 2014 1:47 PM
Points: 97, Visits: 363
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?


------------
:)
Post #1544969
Posted Wednesday, March 5, 2014 10:43 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 2, 2014 1:47 PM
Points: 97, Visits: 363
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.


------------
:)
Post #1547934
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse