SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


PerformancePoint 2010 limitations?


PerformancePoint 2010 limitations?

Author
Message
nicole.willis-508955
nicole.willis-508955
SSC-Enthusiastic
SSC-Enthusiastic (157 reputation)SSC-Enthusiastic (157 reputation)SSC-Enthusiastic (157 reputation)SSC-Enthusiastic (157 reputation)SSC-Enthusiastic (157 reputation)SSC-Enthusiastic (157 reputation)SSC-Enthusiastic (157 reputation)SSC-Enthusiastic (157 reputation)

Group: General Forum Members
Points: 157 Visits: 302
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!
//Ravi
//Ravi
Mr or Mrs. 500
Mr or Mrs. 500 (590 reputation)Mr or Mrs. 500 (590 reputation)Mr or Mrs. 500 (590 reputation)Mr or Mrs. 500 (590 reputation)Mr or Mrs. 500 (590 reputation)Mr or Mrs. 500 (590 reputation)Mr or Mrs. 500 (590 reputation)Mr or Mrs. 500 (590 reputation)

Group: General Forum Members
Points: 590 Visits: 451
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!


------------
Smile
Attachments
PP.JPG (16 views, 80.00 KB)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search