What to do when PerformancePoint display actions don’t work

July 19th, 2008 Russell

I spent a chunk of time this morning scratching my head when I couldn’t get PerformancePoint Monitoring & Analytics display actions working in MOSS. They worked fine in certain dashboards I had  already published, but different dashboards published to the same site were broken - display actions didn’t work at all.

I finally got my “misbehaving” dashboards working by employing the following tactics in the Dashboard Designer:

1. Open the Scorecard that contains the KPI your display condition will leverage.

2. On the Edit tab, Update the scorecard.

3. Go back to your dashboard and add/remove/whatever the display condition in question.

4. Publish/Save.

5. Repeat for each display condition you want to work with.

I don’t know if step 5 is strictly necessary, but I spent so much time on this I didn’t want to experiment any more - just needed to get on with my life! I haven’t tested to see if this is fixed in SP1, but hopefully it is!

Posted in PerformancePoint | 1 Comment »

Error “Server failed to return the table schema “ when creating PerformancePoint dimensions

July 17th, 2008 Russell

While building out some dimensions today, I ran into the following error while using Planning Business Modeler. The error occurred when I selected the name of a table/view in my data source:

Server failed to return the table schema from source database. (Error code: PerformancePoint_225000210). Getting table schema for table <table name> from database <database> on server <server> failed.

Turns out PPS can’t handle any tables or views which are not part of the dbo schema. I had a few of them, and had to use the command below to swap the schema each object belonged to before I could get them into PPS.  I suppose I could have created a dbo.View on top of each object, but I was being lazy:

 ALTER SCHEMA dbo TRANSFER someschemaname.tablename

Posted in PerformancePoint | No Comments »

Installing PerformancePoint SP1 on the AllUp BI VPC

June 17th, 2008 Russell

There has been quite a bit of internal discussion here at Microsoft around this topic since so many of us use the AllUp VPC. 

Long story short, you won’t be able to (easily) install SP1 on an “out of the box” AllUp image. Howard Morgenstern, another BI Technology Specialist has created a quick and dirty guide at http://hmorgenstern.spaces.live.com/blog/cns!28A6BE83102A0EB3!279.entry  on how to approach this scenario.

Its not a tough thing to do, but you do need to be aware of a couple issues. Thanks, Howard!

Posted in PerformancePoint | 3 Comments »

SQL Server 2005 Cumulative Update 8 Released - OK with PPS SP1?

June 17th, 2008 Russell

CU8 was relaeased yesterday for download here. Question is, has it been tested with PerformancePoint SP1? As soon as I know, I’ll post more here:

Update (6/18/2008): One of my customers wanted to know about this, and here’s the deal: SP1 got the full testing treatment against CU3, and also a wee bit was done against CU 7. Use your judgement.

Posted in PerformancePoint | 1 Comment »

Installing PerformancePoint fixes on the AllUp BI VPC (Version 6)

June 16th, 2008 Russell

As many of you know, Microsoft has a super-duper-fantastic (and free) VPC that you can download with all of our BI goodness pre-installed and configured. It’s called the “AllUp BI” VPC, and if you want more details, do a bit of reading here.

I use this image as a primary demo platform and have 3-4 different “hacked” versions of it on various machines I run. Because it is a totally self-contained system, this server acts as its own domain controller, which is a problem as far as PerformancePoint Server is concerned. PPS doesn’t support being installed on a DC, even though you can get it to work anyway.

I discovered yesterday that if you do install PPS on a DC, you’re going to run into problems getting service packs and hotfixes installed, too.

When attempting to deploy a particular hotfix I needed, the distro threw this error:

Failed package requirement analysis

Thanks to a couple guys here at Microsoft who reminded me that AllUp is a DC and offered a workaround, I was able to get back up and rolling quickly. Essentially, you’ll just need to run the .msp which is complaining from the command-line with a parameter that tells it to skip prerequsiste checking.

I’m my case, PPLSrv.msp /SKIPREQCHECK=1 did the trick.

Posted in PerformancePoint | No Comments »

PerformancePoint Server SP1: It’s here! It’s here!

June 4th, 2008 Russell

The wait is over! Download yours now! I’m giggling like a little girl!

Details about the release may be found here:

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

..and of course, the distros:

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

Posted in Uncategorized | No Comments »

Is PerformancePoint SP1 supported on SQL 2008? No, but…

June 4th, 2008 Russell

Now that SP1 has hit, I bet a lot of people are wondering about SP1 / SQL Server 2008 compatability. In fact, the PPS Help and How To page hints at same, saying (bold is mine):

PerformancePoint Server 2007 with Service Pack 1 (SP1) includes enhancements such as improved query performance, increased compatibility with Windows Server 2008, SQL Server 2008, additional data sources, and more filtering capabilities for reports and dashboards

So, is PPS SP1 officially supported with SQL Server 2008? No. The product team made it clear that we can’t support a product which hasn’t even been released yet - makes sense to me!  Offical support won’t happen until PerformancePoint SP2 hits (no, I don’t know the timeline on that).

That doesn’t mean PPS SP1 won’t work against SQL 2008, however. The product team did test the products together, and they do get along quite well. (Sorry, I don’t have a list of specific functionality that either works or doesn’t)

I’m writing this before SP1 actually released, so I expect to update this post after I get my hands on the readme.

Posted in Uncategorized | 2 Comments »

PerformancePoint Server 2007 Planning data migration tool released

June 2nd, 2008 Russell

Barry Tousley, an SDET on the PerformancePoint Server team has released a tool to help you do PPS planning data  migration.

You can find it here:

http://www.microsoft.com/downloads/details.aspx?FamilyId=FA1C6CAD-45BD-4E5C-A257-4BBA84FA4224&displaylang=en

Information on the tool itself is here

Posted in Uncategorized | No Comments »

PeformancePoint Analytic Grid & localization

May 22nd, 2008 Russell

If you have taken the time to implement translations in your SSAS cube, it is comforting to know that the Analytic Grid can and will display your localized text.

From what I can gather, we aren’t quite smart enough to simply read regional settings on the client (as defined in Control Panel | Regional Settings) and run with them like we can when leveraging Excel 2007. Instead, you must set the language in question in Internet Explorer ala:

Tools | Internet Options | Languages (button)

You’ll need to add the language you want the grid localized in to the “language list”, and then move it to the top of the list. Clear your browser cache, and you should be ready to rock and roll.

Posted in PerformancePoint | 1 Comment »