Tim Kent's blog - All Comments

re: How to: Bullet Charts in Reporting Services 2008

Tim Kent — Mon, 22 Feb 2010 10:07:47 GMT

Nice Tip Lohic! Thanks for the update

re: How to: Bullet Charts in Reporting Services 2008

lohic.beneyzet@assensia.com — Sat, 20 Feb 2010 09:50:34 GMT

Hi Tim,

I found a workaround for the border problem. I put my chart in a rectangle. The advantage of a rectangle is that you can set the top, bottom, right, left border properties separately. I set the border properties as I desire and then put the rectangle inline of my table. Et voila!!! It results in a graceful score card table.

re: PerformancePoint Services 2010 – First impressions

Bidoma — Fri, 05 Feb 2010 10:49:11 GMT

I would like to introduce a new Alerting Solution for PerformancePoint that is coming soon.

Bidoma Alert is a productivity add-on for Microsoft PerformancePoint Server 2007 and PerformancePoint Services 2010 providing extensive e-mail alerting capabilities.

Read more about Bidoma Alert for PerformancePoint and see first screenshots at www.bidoma.com/.../BidomaAlert.aspx or contact Bidoma directly via info@bidoma.com

PerformancePoint applicatie security

Hans Geurtsen — Thu, 17 Dec 2009 16:56:33 GMT

In de voorbereiding van een PerformancePoint dashboard deployment, liepen we tegen een leuk security

Twitter Trackbacks for Shapefiles for SSRS 2008 R2 Maps - Tim Kent's blog [adatis.co.uk] on Topsy.com

Wed, 09 Dec 2009 17:02:01 GMT

Pingback from Twitter Trackbacks for Shapefiles for SSRS 2008 R2 Maps - Tim Kent's blog [adatis.co.uk] on Topsy.com

SSRS 2008 – Icon Charts

Tim Kent's blog — Tue, 24 Nov 2009 19:29:42 GMT

In my last post I had a bit of a moan about the lack of new data visualisation features in PerformancePoint

re: PerformancePoint Monitoring Web Service - Part 3

GUID — Mon, 09 Nov 2009 18:35:40 GMT

Hi, I am new to Performancepoint Server 2007 Monitoring web service (PMService).

I would like to get the actual value displayed in a scorecard. For example:

1. I have one kpi (named "ABC KPI") placed on ScoreCard, the kpi uses analysis service data source for its actual value.

2. Suppose on ScoreCard the actual value displayed as "20000"

I am unable to figure out which property will contain value “20000” in the web service.

Any clues no how to get the value?

Please help me out. Thank you.

re: PerformancePoint Monitoring Web Service - Part 3

GUID — Mon, 09 Nov 2009 17:58:46 GMT

Hi, I am new to Performancepoint web service.

Do you know how to get MDX from KPI and Scorecards using Performancepoint Monitoring Web Service (PMService) ?

My server is Microsoft Performancepoint Server 2007. I am using PM web service to capture and display the actual values from KPI and Scorecards. I would like to get the MDX and connect to the data source, then query the actual data. One way I found from the web service method getScorecards() will return an array of Scorecards. From that I can do the following to get the dimensions metadata:

scorecard[0].ConfiguredViews[0].GridViewDefinition.RootRowHeader.Children[0].Children[0].DimensionName

scorecard[0].ConfiguredViews[0].GridViewDefinition.RootRowHeader.Children[0].Children[0].DimensionValue

scorecard[0].ConfiguredViews[0].GridViewDefinition.RootRowHeader.Children[0].Children[0].DisplayText

So as you can see, this is not a good approach because I do not know the exact clause or aggregation. Is there a simple way to get MDX from scorecards and KPIs using the web service? Thank you.

PerformancePoint Services 2010 – First impressions

Tim Kent's blog — Thu, 05 Nov 2009 18:01:09 GMT

We’ve been lucky enough (or we rather hassled enough people in MSFT for long enough!) to have been participating

SSRS 2008 – Lattice Charts

Tim Kent's blog — Wed, 14 Oct 2009 14:47:27 GMT

As I’ve mentioned before , we always try and design reports, dashboards and charts for our customers

SSRS 2008 – Lattice Charts

Tim Kent's blog — Wed, 14 Oct 2009 14:43:10 GMT

As I’ve mentioned before , we always try and design reports, dashboards and charts for our customers

re: How to: Bullet Charts in Reporting Services 2008

lohic.beneyzet@assensia.com — Tue, 13 Oct 2009 14:56:52 GMT

Hi Tim,

Really nice post. It helped me a lot till now. I'm struggling with 2 things right now:

1. the borders

You wrote: "One of the quirks of any inline chart is that it overrides the border of the cell it's placed in so you need to set the border for the GaugePanel to the same as your cell borders." I have the impression that the sentence misses one word between "same" and "as". My header has got one bottom border. When I add the scale into my header, this bottom border is overriden but when I add border to my gauge, it adds a border bottom, top, right and left. Not really the effect that I want. Too much borders. Not nice.

2. the scale font size

Putting the scale in the header as you advise is really nice. the problem of the inline scale is that the font size is too small. I sized it bigger (40pt) but the result is not really nice on the report.

Any idea's?

thanks in advance. Keep up the good job.

re: PerformancePoint Monitoring Dashboard Object Security

nkarthik — Wed, 10 Jun 2009 02:40:17 GMT

Hi,

I am having an issue something related to this article. We have a SharePoint farm and PerformancePoint Server installed on one of the SharePoint server and integrated with SharePoint farm. I can build the dashboard elements in dashboard designer and published it to a SharePoint web application (http://intranet) and I had extended this web application and created a forms based authenticated web application which is SSL certified for extranal users (https://extranet).

I could deploy the monitoring webpart to my extranet web application https://extranet which I could find in some blog.

When I published the dashboard to http://intranet, everything works fine. But when I try to see it in https://extranet, it shows me an error. The Dashboard is unavailable. Contact your system administrator for assistance.

I read in this article that, If we get this error then it means that we don't have permissions on the dashboard. But the PerformancePoint dashboard works with the application pool account right?

I created a service account and assigned it to application pools of PerformancePoint Monitoring Server and SharePoint Web applications deployed with Dashboard Viewer Web Part. And also assigned this account a reader permission to all the elements in the dashboard, data source and also SQL Server databases and cubes.

It works fine with windows authentication, can't we dispaly dashboard with forms based authentication?

My doubt is Can we dispaly PerformancePoint dashboard in SharePoint with Forms Based Authentication?

Thanks,

Karthik

re: PerformancePoint Monitoring Web Service - Part 1

john.brookmyre — Tue, 07 Apr 2009 14:37:55 GMT

I have been a fan of the site for some time and wonder if you can help with this - We are trying to replicate some functionality in Performance Point which works in Reporting Services (2005). What we want to be able to do is direct the user to a particular cube on a particular server depending on their username. Here is an example of how we would do this in SSRS (on SQL Central) - www.sqlservercentral.com/.../2945.

As ever any assistance would be much appreciated,

John

twitter.com/brookmyre

re: Dynamic Dimension members on a PerformancePoint KPI

NickBarclay — Thu, 05 Mar 2009 20:12:45 GMT

No problem, glad to help :)

All is well over here. Cold, but well.

Cheers,