Jeremy Kashel's Blog

PerformancePoint Management Reporter - First Look

PerformancePoint 2007 Management Reporter was launched recently, with the specific intention of providing financial users with the ability to easily create financial reports that can be distributed across the organisation. Management Reporter can connect to PerformancePoint and there are plans to allow it to connect to ERP systems such as Dynamics AX, GP and SL, among others.

On the PerformancePoint side of things, the interesting feature to note is that you won't be able to connect to just any old PerformancePoint model - you can only connect to Financial Models that contain a a Currency Dimension. Once you are connected, its quite easy to create and publish reports. This is partly due to the excellent wizard, which essentially allows you to map your PerformancePoint account dimension members to the relevant section of a Balance Sheet or Income Statement report:

image 

In addition, the product uses the idea of 'building blocks' in order to give users flexibility when designing reports. A building block is essentially a section of the report (e.g. the rows or columns) that you can re-use amongst multiple different reports. Therefore, if you have a common set of columns that you want to see on all your reports, then there's no need for you to manually re-create the column definitions for every report. The 'Report Designer' application contains an area where you can simply pick your row and column definitions based on building blocks that you have already created:

image 

Management Reporter is actually based on a product called FRx, which has been around for a while and is able to connect to a lot of the major ERP systems. There are a lot of good resources on web for FRx, in particular FRxBuzz, which contains a few FRx tips and tricks that can be applied to Management Reporter.

Comments

Jeff Wall said:

thanks for the information - do you know where I can get a demo version?  have used FRx for a number of years and am very eager to get management reporter

thanks & regards

# May 12, 2008 1:06 PM

Jeremy Kashel said:

Hi Jeff,

Glad you found it useful.

As far as I'm aware, Management Reporter is only available on volume licensing (licensing.microsoft.com/.../Default.asp) or more recently for MSDN subscribers (http://msdn.microsoft.com). I downloaded mine from MSDN, but I didn't see an evaluation version.

If an evaluation version becomes available then I'll mention it on this site

Best regards

Jeremy

# May 13, 2008 11:29 PM

amarneh said:

Management Reporter take only Financial Data Mart(FDM) type as data source.

i want to create reports in another data source type,kindly i need your help.

# August 3, 2008 9:59 AM

Jeremy Kashel said:

Hi Amarneh,

First of all, Management Reporter can also connect to PPS Financial Models that contain a currency dimension.

If you want to make it connect to other data sources, then you need to create a provider using the new Data Integration Toolkit - technet.microsoft.com/.../cc514360.aspx

There is also a good discussion on the forums that talks about connecting to other data sources - forums.microsoft.com/.../ShowPost.aspx

Best regards

Jeremy

# August 3, 2008 2:39 PM
Leave a Comment

(required) 

(required) 

(optional)

(required)