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

PerformancePoint 2010 limitations? Expand / Collapse
Author
Message
Posted Wednesday, February 5, 2014 1:00 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, July 25, 2014 7:51 AM
Points: 139, Visits: 254
I have a couple of things I'm trying to do in my scorecard and absolutely cannot figure out and have found no help online.
1) I have a hierarchy with measures that drill down a couple levels. The top level heading I do NOT want totals and I can't figure out how to remove them.
2) I also need to filter out a lower level measure and have done that....however the subtotal STILL includes the filtered amount.
3) Worst child rollup is NOT working.

Why is this product so hard to use?

Any help or helpful sites to use for more advanced questions would be extremely appreciated!
Post #1538346
Posted Tuesday, February 25, 2014 8:18 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 21, 2014 8:58 AM
Points: 97, Visits: 355
You didn't mention type of datasource. I am assuming it's a Analysis Services cube and I will answer the rest.

1) Go into details using drop down and deselect the total checkbox. It wouldn't show up. See attached picture.
2) If you use the filter mechanism in PerformancePoint, then it would show up in total. It's basically hiding it, not taking it out of calculation. If you need to do this, then you need to edit it at MDX level. You can use except funtion
select
{[Product].[Product Categories].[Category],[Product].[Product Categories]}
on columns
from
[Adventure Works]
where
except([Sales Territory].[Sales Territory].[Country],[Sales Territory].[Sales Territory].[Country].[United Kingdom])

3) Rollup will work if you to go Select Members pop up, and right click a dimension and select children. It should automatically show the rollup. See the image attached.

Yes, PerformancePoint is very limiting. I just spent a week learning MDX, only to find out if I write MDX myself, I loose all the ability to drill down in PerformancePoint. Maybe I am not doing something wrong, but still trying to figure it out. MDX is new for me.

nicole.willis-508955 (2/5/2014)
I have a couple of things I'm trying to do in my scorecard and absolutely cannot figure out and have found no help online.
1) I have a hierarchy with measures that drill down a couple levels. The top level heading I do NOT want totals and I can't figure out how to remove them.
2) I also need to filter out a lower level measure and have done that....however the subtotal STILL includes the filtered amount.
3) Worst child rollup is NOT working.

Why is this product so hard to use?

Any help or helpful sites to use for more advanced questions would be extremely appreciated!


------------
:)


  Post Attachments 
PP.JPG (2 views, 80.88 KB)
Post #1544963
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse