PerformancePoint Insider

Microsoft Business Intelligence Conference: BI Demo

Patrick Husting — Tue, 07 Oct 2008 18:00:00 GMT

My good friend Bruno did the demostration of a nice looking business intelligence application. Some PPS, Live Maps, Dundas and Excel Services. I like the branding of the portal and the live maps. Pretty nice.

Microsoft Business Intelligence Conference 2008 Kickoff

Patrick Husting — Tue, 07 Oct 2008 04:21:00 GMT

Well, with the financial markets melting down around the world, Microsoft kicked off its business intelligence conference. These are not the best pictures, but I could use my camera phone to capture some pictures. The below picture is from the keynote kickoff of the event.

Coming out for party for Microsoft new purchase: DATAllegro

Patrick Husting — Mon, 06 Oct 2008 00:07:00 GMT

http://blog.seattletimes.nwsource.com/techtracks/2008/10/03/next_week_microsoft_business_intelligence_conferen.html

The Seattle Times has an article about DATAllegro coming out at the Microsoft Business Intelligence conference. I look forward to checking out the keynote and finding out more about the solution offering. I'll try and post some pictures and articles of interesting things I find there.

Microsoft BI Conference, October 6

Patrick Husting — Sat, 04 Oct 2008 13:05:00 GMT

Just a couple days away from the Business Intelligence conference. I'm hoping they preview or show some direction for the Office 14 product which includes PerformancePoint. I'll try and post some "Things you should know" when I'm at the conference.

http://www.msbiconference.com/Pages/default.aspx

Creating a Second Y-Axis on an Analytic Chart

Patrick Husting — Tue, 30 Sep 2008 18:39:00 GMT

We had a need on how to add a second axis on an Analytic Chart and I found the following link. Very helpful...

http://blogs.msdn.com/performancepoint/archive/2008/02/12/creating-a-second-y-axis-on-an-analytic-chart.aspx

Maxing out the Treeview or Multi-Select Control for Filters

Patrick Husting — Sat, 20 Sep 2008 03:32:00 GMT

When using PPS M&A Treeview Filters on a scorecard, it has a default maximum values of about 200 members and then it doesn't show anymore. You can increase the number of members by adding the following tag in the SharePoint web.config file.

Where "5000" is the maximum number of members to show. Just remember this will have an impact on rendering performance.

Patrick

Creating a Free Form Text Search filters for Performance Point

mjwilson — Tue, 16 Sep 2008 13:02:00 GMT

While Performance Point offers a wide array of "Out of the box" filter solutions, one of the holes that we found was the inability to perform a user input search. While working on a project, we encountered a situation where the members we wanted to list blew way past the upper limit of the PPS filters. While one solution would be to increase the upper limit, this leads to performance hits on the pages as the reports wait until all of the selected members are loaded.

Our solution: A free form text box that would perform a search against dimensions / members in our cube, and in turn apply the searched item as a filter to the dashboard report.

I used a blog post by Joe Hayes of the PerfomancePoint Product team as an initial stepping stone (as well as the inspiration), as well as the PPS SDK found here.

The solution requires a two part development effort, on one hand you need to create a PerformancePoint Dashboard Designer plug-in in order to create the filter and add it to your dashboards. The second part requires that you build a custom web server control.

The screenshot above has 3 projects included in one solution, the third being an installer to be used to help automate the rollout of the filter to multiple machines, but that is a topic for a different post.

The creation of the PerformancePoint Dashboard Designer plugin is detailed by Joe Hayes, and in the SDK, but more than that, Joe gives you a solid code base to begin building your own filters from. When everything works right and your plug-in loads, you will have a new filter template available to you in Dashboard Designer.

One of my biggest sticking points was understanding what exactly the GetDisplayData and the GetMessageData methods in the DataProvider did, and how they facilitated the communication between not only Dashboard Designer and SharePoint, but the fitler and the report item itself.

GetDisplayData builds the datatable structure that the filter/server will use and expect, as well as define which columns are in the table are to be displayed in the "Source Value" selection box when you link the filter to the dashboard item. GetMessageData is the actual messenger of the system, it builds the datatable (by calling GetDisplayData) and fills it with the members that are to be passed to the report item. What this means is that all your "search" logic is to be built into or called from this method.

Joe and the SDK give you a good base for the Dashboard Designer part, the web server control is a little more of a challenge. While digging through the SDK I never found a section for "Building your own selection controls", but when I was reading through the Web.Config, I noticed that the inherent PPS selection controls were registered under "CustomReportViews", which Joe verified what how they were implemented. This means that the DLL for the web server control is to be registered under "CustomReportViews" in the Web.Config of the parent SharePoint site.

The web server control is really nothing more than a class that overrides the Render method of a page. This method is passed an HTMLTextWriter from which the raw HTML of our search box is loaded and written to the page. I used as StringBuilder to do this, as it allowed for a logical way to stick together a long string of HTML code, as well as the JavaScript that puts together our search value and triggers the post to the report item. This being said, the only real interaction with the report item comes in the onClick event of my button where it calls:

"PPSMA.DashboardController.get_instance().updateParameter('{0}','{1}',[txtVal]);", base.DashboardItemId, base.BeginPoints[0].ParameterUniqueName);"

where "[txtVal]" is the value from my textbox. It is worth noting that the value passed to the dashboard has to be a JavaScript array, even if it is only one value.

Through the web server control you can load any raw HTML controls, but you are not able to utilize ASP.Net controls because of where in the page lifecycle the control is being inserted.

Development notes and suggestions.

The very first suggestion that I might give is to develop on the server. This sounds a little weird, but I have 2 reasons for this:

Both projects require references to some PerformancePoint DLLs that are loaded on install
Debugging is much easier locally rather than messing with Remote Debugging. It's so much easier just to attach to a local process.

There are a couple of tools out there that will ease development as well, the first being CriTrace which is detailed here. One thing to note, by changing the value from "friendlyfile" as it suggests in the blog post to "spy", SharePoint will print out the results actually on the page versus on a file that you have to dig to find.

Also this blog details how to create an ASPX page that does nothing more than print out the parameters that are passed to the report item. This may sound simple, but it was the best tool I could find for figuring out exactly why my filters were broken, and what the inherent PPS controls were passing that I was not.

And finally download Reflector and read the PerformancePoint DLLs. They can and should be your template / insight into how to build your own filters.

Hope this points you in the right direction, and please feel free to get a hold of us if you have any questions!

ProClarity (PAS) and SQL Server 2008

Patrick Husting — Fri, 22 Aug 2008 17:26:00 GMT

If you want to get ProClarity working with SQL Server 2008, you need the following hotfixes

http://www.microsoft.com/downloads/info.aspx?na=22&p=6&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3ddc9cbe69-1db1-4f5d-9b48-06b156c0f2c6%26DisplayLang%3den

http://www.microsoft.com/downloads/info.aspx?na=22&p=9&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3dced0bd47-7d19-40de-8e80-f924784bd7af%26DisplayLang%3den

Resolving Repeating Property Columns on Scorecards with Multiple Time Members Present

Kristi McGraw — Wed, 13 Aug 2008 22:35:00 GMT

Example of Issue: Exec Owner, and Update Frequency both custom KPI Properties repeat illustrating an instance for both time members FY08 and FY09. The desired effect is to show the YTD Target and Actual repeat for FY08 and FY09 but render the Properties just once.

Steve Handy, a member of the PPS Product Team shared the following steps to achieve application of multiple time slices without repeating Property Columns:

1. The unfortunate caveat: You can do this only right most columns. It’s not possible to do this for left most columns if you want the members to come from a dashboard filter. The work around makes use of the fact the filters only replace members for the first hierarchy on the scorecard.

2. OK, so the real first step: Add a target and Property (i.e. person responsible) to scorecard columns. KPI’s are on rows.

3. Next, drag the “All” member of any dimension (other than time) and place above the Target column while pressing the [Shift] key. The result should look like this:

Add additional metrics you want to repeat under “All” member:

4. In the dashboard, connect the Time Filter to the scorecard columns axis.

5. Publish changes

6. Deploy the scorecard

7. The result is as shown:

This only works, as indicated earlier, if the column you don’t want to repeat is added at the Right end of the scorecard and it is not a child of the “All” member.

Configuring Kerberos for SharePoint 2007

Patrick Husting — Tue, 01 Jul 2008 14:27:00 GMT

If you want your credentials to pass throughout all your servers for PPS to work correctly, you really need to enable Kerbero's. I found a couple great articles that explain this and the process to do it. Enjoy...

Another one

http://blogs.msdn.com/james_world/archive/2007/08/20/essential-guide-to-kerberos-in-sharepoint.aspx

Another one in regards to Active Directory

http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/security/tkerbdel.mspx

PerformancePoint Monitoring Readme for SP 1

Patrick Husting — Thu, 05 Jun 2008 13:24:00 GMT

From the PerformancePoint Server 2007 SP1 Monitoring readme which you can download here

http://office.microsoft.com/download/afile.aspx?AssetID=AM102778591033

PerformancePoint Monitoring Readme

Effective Date: June 6, 2008

Introduction

This file contains important information that was not available when the documentation for the product was written. Workarounds, when they are available, are provided for known issues.

The content in this Readme file applies to the PerformancePoint Monitoring components of Microsoft Office PerformancePoint Server 2007 with Service Pack 1 (SP1). These include:

· PerformancePoint Monitoring Server

· PerformancePoint Dashboard Designer

· PerformancePoint Dashboard Viewer for SharePoint Services.

PerformancePoint Planning Readme for SP 1

Patrick Husting — Thu, 05 Jun 2008 13:21:00 GMT

From the PerformancePoint Server 2007 Planning Readme file. You can download it here.

http://office.microsoft.com/download/afile.aspx?AssetID=AM102778581033

PerformancePoint Planning Readme

Effective date: June 4, 2008.

Introduction

This file contains important information that was not available when the documentation for the product was written. Workarounds, when they are available, are provided for known issues.

The content in this Readme file applies to the following Planning components of PerformancePoint Server 2007 with Service Pack 1 (SP1):

· PerformancePoint Planning Administration Console

· PerformancePoint Planning Server

· PerformancePoint Planning Business Modeler

· PerformancePoint Add-in for Excel

· PerformancePoint Data Import Wizard for Microsoft Dynamics AX

· The Alpine Ski House Sample Application and the PerformancePoint Server Minimal Verification Sample Application

Microsoft PerformancePoint Server 2007 SP1 Shipped!

Patrick Husting — Thu, 05 Jun 2008 00:00:00 GMT

From Microsoft

We are very happy to announce that Service Pack 1 of Microsoft PerformancePoint Server 2007 has been signed off to ship! Representing Microsoft in the growing performance management market, PerformancePoint Server allows customers to align employees to their organization’s strategy by:

· Planning for the future of the business

· Monitoring the performance of your organization

· Analyzing the results

Thanks to everyone who worked on this release (there were many involved) and those in other organizations that assisted in that work. This is our first service pack of our first release so it signals a milestone in our internal rhythm of business.

With this new Service Pack, many enhancements have been made to help customers enhance their decision making with the monitoring, analyzing and planning functionality found in PerformancePoint Server. Usability, stability and performance enhancements are key focus areas for PerformancePoint Server SP1. Customers will have new workbook options to help improve the performance of queries and show the effects of changes in planning assignments for better “what-if” analysis.

Customers using strategy maps and KPI’s for monitoring and analytics will see improvements to scorecard and filter usability. Scorecards with negative numbers are easier to read and dashboards with filters are now much faster to render and provide the ability to link reports directly to KPI’s. There is also added support for Tabular filters and Time Intelligence Post Formula filters, as well as the ability to link multiple filters to a strategy map.

In addition, SP1 adds support for Windows Server 2008. Support for SQL Server 2008 will be available later this year with PerformancePoint Server SP2.

For more information about what’s available in SP1, please check the online help:

Office Online: http://office.microsoft.com/en-us/performancepoint/FX102380591033.aspx

PerformancePoint Server SP1 availability:

Download Center Pages:

Enterprise Version 32-bit: http://www.microsoft.com/downloads/details.aspx?FamilyId=28B1F86B-B7F2-4215-8BC9-8F8507FF8831&displaylang=en

Enterprise Version 64-bit: http://www.microsoft.com/downloads/details.aspx?FamilyId=6245C354-9191-4C4D-8C0C-C10D6C778AF8&displaylang=en

Evaluation Version 32-bit: http://www.microsoft.com/downloads/details.aspx?FamilyId=6372C24F-67DD-42DD-B034-748907B23420&displaylang=en

Evaluation Version 64-bit: http://www.microsoft.com/downloads/details.aspx?FamilyId=3ADAC793-DEF0-4BA8-A9AB-228979B8DB40&displaylang=en

ProductsWeb for internal users:

http://productsweb/product.aspx?productnameid=2170&status=3&platformid=-999&category=1

MSDN:
We anticipate SP1 availability for MSDN subscribers in the next couple of weeks.

Volume Licensing:

English bits will be available in Volume Licensing in August, 2008

Documentation:

On Office Online: Links to README and other useful information: http://office.microsoft.com/en-us/performancepoint/FX102380591033.aspx
On TechNet: For the IT pro - Deployment Guide, Operations Guide, Whitepapers: http://technet.microsoft.com/office/performancepoint/default.aspx

More PPS M&A SP1 Features/Fixes

Patrick Husting — Thu, 08 May 2008 16:03:00 GMT

PerformancePoint Monitoring Server SP1 includes the following enhancements:

· Support for Microsoft Windows Server 2008

· Add a default display condition report view (see related blog post)

· Multi-select Monitoring server filters passing to multi-select SQL Server Reporting Services report parameters

· Time Intelligence Post Filter formula date corrections

o In some instances filters were passing a one day offset, this is resolved

o Date format of filter will now honor localized formats

· Negative numbers will not cause a text wrap in scorecards

· Dashboard filter performance improvements

· Expand/collapse functions work properly with hidden parent KPI members

· Updated sample data file

· Tabular filter support

· Multi-select filters can now be passed to a Strategy Map report view

· Limit of 1,000 characters in an MDX expression for KPIs has been removed

· No longer blocked from using SQL Server 2008 as a data source (NOTE: full support for 2008 is coming in SP2, we just won’t prevent you from running on it with SP1)

Useful SharePoint Site

Patrick Husting — Mon, 28 Apr 2008 17:19:00 GMT

Since PPS M&A requirements SharePoint, I bet you find yourself doing a lot of SharePoint setup and development. I found the following link today that I have found kind of useful.

http://sharepoint.microsoft.com/Pedia/pages/home.aspx

Installing PPS on a Domain Controller

Patrick Husting — Wed, 23 Apr 2008 17:09:00 GMT

I got this from an internal document on how to install PPS on the same machine that has Active Directory installed.

Domain Controllers

While it's not a hard-and-fast rule, most AD administrators will tell you that a domain controller should not run other applications. Since your domain controllers are the "keys" to your network "kingdom", you should do your best to isolate them from attack. By adding additional applications to run on a DC, you are increasing the number of ways that a malicious user can attack that DC. Depending on the size of your network, having dedicated domain controllers may also improve performance in terms of user authentication, and logon times.

Running PerformancePoint Server 2007 on a domain controller is not an advised production scenario and is not a supported scenario. This is why the installer blocks the install of PerformancePoint Server 2007 on domain controllers.

Workaround

There is a command line parameter that will allow the PerformancePoint Server 2007 to install and configure on a domain controller. There are some manual steps to be complete before installation and configuration.

Installing PerformancePoint Planning Server on a Domain Controller

1. You MUST create a new domain account for the Planning Service Identity. You cannot use the domain administrator account as the Service Identity.

2. Using Start\Administrators\Active Directory Users and Computers:

a. Create a new domain account, e.g. DOMAIN\PlanningSI

b. Add it to the Domain Administrators group

c. Add it to the IIS_WPG group

3. Open Start\Administrative Tools\Domain Controller Security Policy

a. Under Local Policies\User Rights Assignment:

i. Grant PlanningSI the “Log on as a batch job” right

ii. Grant PlanningSI the “Log on as a service” right

4. Install the Planning server MSI using this command line:

a. msiexec /i PPLSrv.msi SKIPOSCHECK=true

5. In the Configuration Wizard, specify the domain account created above as the SI account

Installing PerformancePoint Monitoring Server on a Domain Controller

1. If you are using a domain account, you must add it to the Administrators and IIS_WPG groups before installing the Monitoring Server. You don’t need to do this if using Network Service (recommended).

2. To add a domain account to the appropriate groups: Use Start\Administrators\Active Directory Users and Computers:

a. Add it to the Domain Administrators group

b. Add it to the IIS_WPG group

3. Install the Monitoring server MSI using this command line:

a. msiexec /i PscSrv.msi SKIPOSCHECK=true

PerformancePoint Server 2007 Service Pack 1

Patrick Husting — Mon, 07 Apr 2008 13:38:00 GMT

What is in it, got this email the following week. It doesn't list everything, but if they are doing everything that is in the email, that is a good thing.

· Filter performance – you should see a 4-6x improvement in your filter performance, this is an area we would like some feedback on

· Multi-select filters in PPS will now pass to multi-select parameters in SSRS reports

· Negative numbers causing text wrap

· Time Intelligence day offset issues and localization issues

· Display conditions not working for strategy map and excel services views

· Null actual values yielding incorrect status

· Dashboard designer dashboard layout improvements

· Chart/grid bug fixes

· Strategy map improvements

· And many more

There are almost 300 fixes that are implemented in SP1.

Integrate SharePoint Web Parts into a PerformancePoint Server Dashboard

Patrick Husting — Fri, 04 Apr 2008 17:50:00 GMT

I saw this question on an internal Microsoft alias, so I answered it and several people like the answer so I figured I should blog it...

Question: What are the possibilities for combining Dashboard elements (KPIs, scorecards, filters and reports) with SharePoint elements (e.g. as shown below: list of links, announcement and shared documents)? Can this be accomplished through PerformancePoint Server / Dashboard Designer or do we have to construct the page from SharePoint using the different webparts, including Dashboard elements?

You can also do this, we have done this numerous times, works well. I have also presented this "how-to" at the Office and SharePoint developer conferences recently.

Create a blank .ASPX page using SharePoint Designer
Drop your desired "List" onto the page
Link the page with your site style sheet, so it looks pretty
Save the page and remember the URL
Open PPS M&A Designer
Create a NEW Web Page Report View
Enter the URL from above
Go to your Dashboard page and drop that report view where you want it.
Publish ALL and then Publish Page to SharePoint.
Done.

Example Screen

New Performance Management book! Drive Business Performance.

Patrick Husting — Tue, 01 Apr 2008 15:03:00 GMT

Got an email from Bruno today about a new book by him, Bruno Aziza and Joey Fitts.

I hope you have been doing well. I just wanted to share some news with you – and it’s not an April Fool’s Day joke! My book, Drive Business Performance is being printed as we speak! It will be available at your local bookstore (Barnes & Noble, Borders, etc.) by April 25, 2008. However, you can pre-order it now for 40% off from

About the book

Stories and guidance…not jargon

Drive Business Performance explains the competitive advantage experienced by organizations that create and manage a "Culture of Performance." It is filled with first-hand accounts from Fortune 500 companies who are winning by building accountability, intelligence, and informed decision-making into their organizational DNA. The book aims to demystify performance management and is jargon-free.

Debut events

· World Innovation Forum in NYC on April 8-9^th: Featured in a session on Please let me know if you happen to be attending the World Innovation, the book will make its debut there.

· Stanford Executive Briefing on April 16^th: The book co-author Joey Fitts and I will present on How to Drive Business Performance. Please let me know if you are planning to attend & I’ll look forward to seeing you there!

I hope you enjoy the book!

Performance Tuning and Capacity planning for PPS M&A

Patrick Husting — Sat, 29 Mar 2008 00:46:00 GMT

Found this article on PerformancePoint Monitoring and Analytics performance tuning.

http://technet.microsoft.com/en-us/library/bb660539.aspx

PPS Live on the web

Patrick Husting — Thu, 27 Mar 2008 23:37:00 GMT

One of my consultants passed this link onto me with PPS M&A live on the web against web logs. Pretty neat, check it out.

http://richardlees.com.au/sites/Demonstrations/Documents/Web%20Dashboard%20-%20close%20to%20real%20time%20analytics%20of%20this%20internet%20site/Internet%20Activity%20Today.aspx

PPS Management Reporting - More Screenshots

Patrick Husting — Fri, 08 Feb 2008 14:24:00 GMT

My laptop was not joined to a domain, so it took a little while longer to install that I wanted it to. The setup help wasn't any good either... Anyway, I got it up and running. Looks like this should be fun to learn... More to come

The first screenshot is what the startup screen looks like.

This screen is a good example of the Report Definitions.

PerformancePoint 2007 Management Reporter

Patrick Husting — Thu, 07 Feb 2008 14:26:00 GMT

Microsoft just released to manufacturing PerformancePoint 2007 Management Reporter. I'm in the process of installing it and will upload some screenshots and thoughts over the next couple weeks.

Microsoft Gets Gartner's Business Intelligence Top Ranking

Patrick Husting — Wed, 06 Feb 2008 20:42:00 GMT

Business Objects and Cognos have long been considered the leaders in business intelligence platforms. But in a surprising new report, Gartner ranks Microsoft (NSDQ: MSFT) ahead of those companies in its ability to execute.

More at link: http://www.informationweek.com/news/showArticle.jhtml?articleID=206104502&subSection=News

ODC 2008 Architecture Track

Patrick Husting — Mon, 04 Feb 2008 14:30:00 GMT

From my session sponsors web site....

It's Showtime Folks: T-1 Week to ODC 08 and a terrific Architecture track!

Well folks, the ODC is a week away, and the Architecture Track team is all set to deliver a compelling track that will hopefully leave you well educated about the capabilities of the Office System as a Business Solutions Platform, and yearning for more!

The final list of track sessions can be found at the following URL:

https://microsoft.crgevents.com/ODC2008/Content/default.aspx?p=7VE4KC

We have a number of top SharePoint/Office MVPs and MS folks who live & breathe the Office System day in and day out, ready to rock your days at the conference.

If you are amongst the Solution Architects or Techno Business Descision Makers who are wondering or want to learn more about what all this is buzz about Office Business Applications (OBAs) and the Office System as a Business Solutions platform is all about, then the ODC 08 Architecture track is the train that you need to ride from start to finish.

The track's single and focused overarching theme is "The Business Solution Platform capabilities of the Office System and OBAs - Office Business Applications". The track sessions are categorized into the following 3 broad sub-themes:

Fundamentals: Office System Platform capabilities related to enabling compelling Business Solution User Experiences, Business Intelligence, and BPM solutions to extend the reach of investments in Line of Business systems & applications, across an enterprise/organization. Sessions related to this theme will also help you wade the maze of MS platform offerings of pertinence to these areas, how they relate to and interplay with teh Office System to enable rich information worker and user productivity, and provide prescriptive guidance on making the optimal technology choices in these areas to land solutions that meet your business needs.

Cutting Edge: Composite Solutions Architectures, the benefits of composite solutions development, composite solution platform requirements, and how composite solutions can be materialized using the Office System will be the "cutting edge" theme for the Architecture track at ODC 08. A very cool and new open source "OBA Composition Reference Toolkit" will be announced and demonstrated to illustrate the related concepts and capabilities. Without giving too much away... if you ever wondered what Web 2.0 mashup experiences like those enabled by Popfly for the social communities could possibly mean to an enterprise/business...you should not miss seeing this work that we will be demoing and announcing in both the opening session of the Architecture track (to be delivered by Javed Sikander, a Senior Director in the Platform Architecture team at MSFT) and in the deeper drill down session on building composite Office Business Applications (delivered by your's truly).

Real World: The application of OBA concepts and solution architectures in the real world. Related sessions will include a presentation delivered by the MCS team on their real world experiences in deploying SharePoint and Office Business solutions, sessions that describe solution architectures adopted by real world ERP systems like Microsoft Dynamics and SAP to integrate with the Office System and extend the reach of their solutions, and industry focused sessions delievered by leading Microsoft Industry experts who will talk about how OBAs are being adopted and used in the Financial Services and the Public Sector industries.

All in all...it should be a terrific show in the Architecture track. I look forward to greeting you all at the ODC in a week from now.

Make sure to attend the opening session of the Architecture track on Monday Feb 11th at 1:30PM. This is a track keynote type session delivered by Javed Sikander (Senior Director, Platform Architecture, MSFT) that will provide you a broad overview of the focus domain for the Architecture track, and will include teasers + pointers to the many following drill down Architecture track sessions that will be delivered across the 3 days.

Regards, Karthik