Tim Kent's blog - All Comments

re: How to: Bullet Charts in Reporting Services 2008

SJ — Wed, 09 Mar 2011 00:15:43 GMT

Thanks for this step by step instructions. I've created a bullet graph using the steps here, however,

my target markers are aligned vertically even though the target values are different for each row in the dataset. I must be missing something. Any ideas?

-SJ

re: Dynamic Dimension members on a PerformancePoint KPI

Dean Furness — Mon, 26 Jul 2010 15:43:43 GMT

Another question, or twist... imagine a single filter on the dashboard page...based on a simple date hierarchy. Also - a top 'high-level' scorecard to display KPIs - filtered by the date...and a second scorecard that shows descendants at a level below the selected dimension element in the high-level scorecard... essentially - two scorecards where one provides a navigation point to allowing of more detailed records lower in the hierarchy to prevent a huge expand/collapse scenario. The problem is - I want to order the lower scorecard based on a KPI value...and have it filtered by the date. I have created connections from the date to both parts - just normal with no formulas. I have a connection from the upper scorecard to the lower with a formula:

order(descendants(<<UniqueName>>, [Customer].[Customer Hierarchy].[Customer Name]),measures.[Savings Amount],desc)

but this seems to ignore the date selection...or the order of evaluation is off...in effect, things are ordered, but across all time...not the selected date in the filter that should have been selected for the page...

Thoughts?

Thanks,

Dean

re: PPS Monitoring - Missing Parameters using a Reporting Services report in SharePoint integrated mode

Michael — Wed, 21 Jul 2010 02:13:08 GMT

I'm seeing the same behavior in Performance Point 2010. Do you know if this is a known issue?

re: Connecting to AS2000 from X64 Excel Services\SharePoint

Dan English — Fri, 02 Jul 2010 20:20:44 GMT

I am truly amazed when I hear that people are still using AS2000. Crazy. The fact that they would be looking at Office 2010 and SharePoint 2010 along with other x64 products before upgrading AS is funny.

re: Shapefiles for SSRS 2008 R2 Maps

Patrick PK — Tue, 08 Jun 2010 18:06:51 GMT

Thanks!

Twitter Trackbacks for SQL Server Master Data Services now available - Tim Kent's blog [adatis.co.uk] on Topsy.com

Thu, 06 May 2010 23:19:25 GMT

Pingback from Twitter Trackbacks for SQL Server Master Data Services now available - Tim Kent's blog [adatis.co.uk] on Topsy.com

Twitter Trackbacks for Feedback for SQLBits VI - Tim Kent's blog [adatis.co.uk] on Topsy.com

Thu, 29 Apr 2010 11:32:19 GMT

Pingback from Twitter Trackbacks for Feedback for SQLBits VI - Tim Kent's blog [adatis.co.uk] on Topsy.com

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.

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