Friday, September 16, 2011

Measures in PerformancePoint Dashboard filter

You might know how to get dimensions in a filter in PerformancePoint Dashboard filters, but what if you want to change the measures of a report, using a filter?

You can use the MDX Query filter type when creating the filter and then specify [Measures].[Measures].Members as the MDX query to populate the filter.

You can obviously also specify particular members if you do not want all of them.



Thursday, September 15, 2011

Changing PPS Report measures with filters

Hi guys,

The below link gave me the information that I needed:



MDX Filter Connection Formula

The Connection Formula setting for PerformancePoint Dashboard Designer is quite useful in many instances. For example, if we want to create a report with the top 10 US states by the revenue generated by employees in that state, then we can build the filter using a dimension hierarchy like Employees by State. The problem is that we cannot simply connect this filter to the chart by connecting it directly to one of the chart dimensions. The reason is that if we select "Arizona" from the hierarchy, the natural result that we would want to see in the chart is for it to show the top 10 Employees for Arizona.

To get the desired result, we somehow have to specify that when we select "Arizona" we want to pass all the Employees in Arizona as a parameter to the report. The report can then do all the filtering on this set which includes only Employees from the desired state.

This is where the Connection Formula property comes in very handy. When creating a connection between a filter and a report, it is possible to specify a Connection Formula so that you can actually specify exactly what custom values you want to pass to the report when this filter is used.

The formula has to be written in MDX where <<SourceValue>> refers to the value in the filter, that is selected by the user.

For instance, in the above mentioned case we can use something like the below MDX query (the syntax might not be exactly right). The query assumes that we are using a Employee by Location hierarchy that contains all the Employees as Children of the state members in the hierarchy.

IIF(<<SourceValue>>.Member_Name = 'Arizona', [Hierarchy].[Arizona].Children, "whatever else you want to do here")

Please let me know if I can be of any help,



Wednesday, September 14, 2011

Migrating PerformancePoint Charts to another server

It seems that the migration of PerformancePoint content like charts, between servers have been somewhat of a vague area for many of us. I searched around the internet and found that quite a lot of people, like the people in our team, opted to recreate all the content on the new server. This is obviously not a very efficient migration method at all, and this is just not suitable for moving content to the production server of a client.

I found a solution to a part of our problem, but not to the whole problem. Dan English is a BI developer and it seems to me that the guy knows what he's talking about. Read what he has to say about migrating content between servers:

The problem with his solution is that we need to have a connection to both the "old" server from where we want to migrate the content and to the "new" server to where we want to migrate the content. I am sure some of you can immediately see that this is still not the optimal solution for migrating content to a client server although it can be done.

What I am looking for is a way for us to package the content that we want to migrate and then restore it on the client server. One of my teammates suggested that it might be possible to do this by backing up the Sharepoint site or site collection (all our content is deployed to Sharepoint sites), but we have not had the time to look into it.

I would appreciate it if anyone can suggest anything. We are working on this and I will definitely post the solution once we have found it!