Browse by Tags

PerformancePoint Server 2007 PPSCMD GUI

I've built a really simple GUI for a couple of commands of the PPSCMD utility. I always take far too long to work out the syntax and navigate to the appropriate directory (Yes, I ought to update the PATH environment variable) that I felt I could justify building a simple front end to help speed...

Posted to Sacha Tomey's blog (Weblog) by sachatomey on 08-27-2008
Troubleshooting the PEL Allocate Statement

The PEL Allocate statement can sometimes throw unexpected error messages, especially when you're setting up a pull or push cross model allocation rule. I've been keeping track of a few of the more obscure ones, which I've listed in the table below. Hopefully this will help anyone out there...

Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 08-13-2008
Using NativeSQL Business Rules for Seeding or What Ifs

You need to give really careful consideration to procedural business rules in PerformancePoint Planning. This is where multi-dimensional knowledge and experience helps, as you need to know whether its best to use a SQL or MDX implementation for your rules. User Requirements One area where I've found...

Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 08-05-2008
PerformancePoint Server Planning SP1 - Clear Changes After Workflow Action

There's a new workbook property that was introduced in PPS Service Pack 1. The 'Clear Changes After Workflow Action' effectively splats the change list for the workbook once the assignment has been submitted (either draft or final). The property can only be reached through the Report...

Posted to Sacha Tomey's blog (Weblog) by sachatomey on 07-29-2008
PerformancePoint MCPs

I was a little surprised to see that ( as of June 2008 ) there are already 329 people certified in PerformancePoint (i.e. have passed the 70-556 exam) and whilst it's not the hardest exam (IMO compared to 445 and 446) it's a good sign that PPS uptake is getting stronger and stronger. Mind you...

Posted to Tim Kent's blog (Weblog) by Tim Kent on 07-23-2008
PerformancePoint Planning - Loading the account dimension members from CSV

More for my benefit this post; I can never remember the format for the CSV file to load the Account dimension. Below is an example csv file in it's simplest form that should help get me started faster the next time I need it ! Label,Name,Description,AccountTypeMemberId 1000,Salaries Permanent...

Posted to Sacha Tomey's blog (Weblog) by sachatomey on 07-10-2008
PerformancePoint Planning - Data change tracking / audit trail

PerformancePoint Planning does contain auditing out-of-the-box. However, it's not data level auditing but instead Metadata level auditing. If you want to track when a user has been added, or a workflow cycle started then PPS-P keeps a track of all these changes plus a whole host of other...

Posted to Sacha Tomey's blog (Weblog) by sachatomey on 06-30-2008
An unknown server error occurred when submitting User

We recently had to turn a couple of demo boxes into a 2 client development environment for an overly aggressive PPS-P deadline. Both demo boxes were connected to the network and both were PPS-P Servers. We wanted to nominate a specific box as the PPS-P server for the build. Typically, the...

Posted to Sacha Tomey's blog (Weblog) by sachatomey on 06-26-2008
Multiple Assumption Models in PerformancePoint

PerformancePoint gives you the flexibility to have multiple assumption models to use as you please in your main models. Although this is great, I've found a problem when the two assumption models have different member sets for the same dimension, and so in an extension to my last assumption model...

Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 06-24-2008
PerformancePoint Planning Server Data Migration Tool

There's a new tool for PerformancePoint Planning that allows you to migrate reference and fact data between applications. (It is designed to be used for first time migrations only) Documentation here Download here

Posted to Sacha Tomey's blog (Weblog) by sachatomey on 05-31-2008

Page 1 of 7 (67 items) 1 2 3 4 5 Next > ... Last »