Implementing a Hyperlink from a KPI in a Scorecard

ASPX File SampleFile

ASPX File Redirect to New Page SampleFile2

 

One of the capabilities of Business Scorecard Manager 2005 (BSM) that was changed in PerformancePoint was the ability to specify a URL to link to upon clicking a KPI. This was the Overriding URL property in BSM. It is still possible to get this functionality in PerformancePoint, but it requires adding an aspx page (attached to this blog post) and implementing the following procedures.

1. Extract the aspx page that is attached to this blog post in a zip file and extract the redir.aspx file to any site, preferably under the PerformancePoint Monitoring web site. If you want to place it at the root of the PerformancePoint Monitoring web site, you would add the file to the following location:

C:\Program Files\Microsoft Office PerformancePoint Server\3.0\Monitoring\PPSMonitoring_1\Root

2. Create a New Report view of type Web Page. For the URL, you will enter the redir.aspx page that you extracted in step 1. If you used the above example, your URL will read as follows: http://ppsmademo:40000/redir.aspx

3. Edit the KPI you wish to implement a hyperlink on. Select the Properties tab, click on New Property and select Hyperlink. For the Value of the property, enter the URL you wish to link to. For the Name of the property enter OverridingURL.

Hyperlink1

4. Repeat step 3 for each KPI that you wish to implement a hyperlink on.

5. Create a new dashboard adding your scorecard containing your KPIs and your URL report view created in step 2 to a dashboard.

6. In your scorecard you will have a property called OverridingURL that now appears as an Available Field. Drag this to the URL report view in your dashboard to create a link.

Hyperlink2

Hyperlink3

7. Publish your dashboard. Now, when the KPI is clicked on the page will be redirected to the URL you specified in step 3.

 

Alyson Powell Erwin (alysonp@microsoft.com) and Ramesh Arimilli (ramesha@microsoft.com)

 

NOTE:  Thanks for all of your comments - we have added an additional sample file that will redirect you to a new page.  Thanks to Ramesh for this!

Published 05 October 07 03:03 by alysonp

Comments

# Noticias externas said on October 5, 2007 10:37 AM:

ASPX File SampleFile One of the capabilities of Business Scorecard Manager 2005 (BSM) that was changed

# howardm said on October 12, 2007 4:51 PM:

This is very cool but you need to put a blank web part on your dashboard. Dashboard real estate is expensive. Also I tried your sample and the url popped up in a new window. I was expecting it in the web part on the dashboard.

# Suman_sundar7 said on October 29, 2007 3:08 AM:

I have also tried it, the URL opens in the same window, but not in the separate webpart in the same page. When i click 'back' the dashboard opens and reverts back to the same webpage.

If i want to pass a value to conditionally dispaly a webpage how do i give the URL for override.

# beeeyedev said on October 30, 2007 11:16 PM:

I have also tried it, the URL opens in the same window and i cannot go back to my previous webpage.

How can i display this in a separate window?

# engy79 said on November 7, 2007 3:03 PM:

I agree.  I like this, but what I don't like is the other "redirect report" showing up with it's title and zone on the same dashboard.  Is there any way to hide the title of an item in a zone?  If I could hide this item, this would give me exactly what I want.

# Katara said on November 19, 2007 11:48 AM:

It works fine when the KPI name is in the sorecard rows, but doesn't work when I pivot the scorecard contents. Also, is there a way to make the "OverrideURL" property attached to a scorecard cell instead of a KPI Row?

# Katara said on November 19, 2007 1:36 PM:

Hey Engy,

You can hide the title of the redirect page after publishing your dashboard to SharePoint. Edit the page and choose to modify the webpart containing the redirect report. Set its Chrome Type to None. I guess you could also check the 'Hidden' checkbox for the layout to avoid the 'updating' progress msg that appears there.

# Microsoft Business Intelligence Blog said on December 6, 2007 12:20 PM:

You know, there used to be a neat feature in BSM2005 that when you clicked on a KPI you could redirect

# talwar_ said on January 29, 2008 9:47 PM:

what if i have a scorecard that has a dropdown filter attached. In that case i would need to dynamically append a string to the report URL which would contain the value of the filter parameter. Is that possible?

Otherwise the report is going to display data with the default value of that paramater.

# d5lau said on April 7, 2008 8:57 PM:

Is it possible to pass a filter value that is applied to the Scorecard to the OverridingURL link?

# Alex1PME said on May 21, 2008 5:02 AM:

Hi! It is possible to show the new page on full screen mode? because when I click in link I have to maximize the new page.

Thanks!

# dwing2 said on January 30, 2009 10:58 AM:

Can a hyperlink be added to a SSRS report? or Analytic Chart report?

# alysonp said on January 30, 2009 12:08 PM:

Your best bet for an analytic chart is to add an HTML action to the SSAS cube that you can then access through the actions menu.  For SSRS, you could add the hyperlink to the SSRS report when created.

# Bob Hmine said on February 23, 2009 12:21 PM:

"6. In your scorecard you will have a property called OverridingURL that now appears as an Available Field. "

FYI, not working for me, I can't get the new property to show up in the scorecard dropdown of Available Fields.  Is this an SP1 issue in MOSS?

# alysonp said on February 23, 2009 1:12 PM:

You are most likely hitting a bug we have.  If you go and add another property to your KPI then go to the dashboard you should see all properties.  We don't show the properties, unless you have a newly added one.  You can remove the newly added one later or just not save the KPI.  sorry for the inconvenience.

Thanks.

# zhyg said on April 2, 2009 10:51 PM:

Hi! Can you tell me where the URL report view is? I can't find this view.

# alysonp said on April 3, 2009 10:29 AM:

It is whatever URL you want to direct the user to.

# zhyg said on April 7, 2009 12:41 AM:

I just did all the steps, and when I use preview function in the Dashboard Designer, the link can work. But when I publish the dashboard to the website. The link can't work in the website. I don't know how to resolve this problem. Please give me some suggestions.

# zhyg said on April 7, 2009 5:02 AM:

“Drag this to the URL report view in your dashboard to create a link”,this sentence is the quotation of your article.But I can't drag the OverridingURL, and I can't find "URL report view".

Anonymous comments are disabled

Search

This Blog

Microsoft BI Sites

Syndication

Page view tracker