Jeremy Kashel's Blog

Browse by Tags

All Tags » PerformancePoint (RSS)
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...
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...
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,...
Executing Rule Sets in PerformancePoint to Move Data
As I mentioned in my post a few weeks a ago, the PEL Allocate statement is a powerful method of moving data between PerformancePoint models. Although it's powerful, the end result of an Allocate statement is simply that the destination model will...
Assumption Model Design Techniques and Business Rules
PerformancePoint assumption models are very useful if you want the data in one model to drive and affect another model. However, if you’ve been using assumption models, then the chances are that you may have noticed that they can sometimes be a...
Intercompany Eliminations Video for PerformancePoint Planning
Useful post on Norm's PerformancePoint Server Blog showing a short video on how to do intercompany eliminations in PerformancePoint. The video is actually by Forrest Dermid, who sets the scene by explaining why you would actually want to do an intercompany...
PerformancePoint Planning Performance Tuning White Paper
A PerformancePoint Planning white paper has recently been published that documents the performance and scalability of Planning Server. Included are some very interesting test results that will come in handy when planning the deployment of PPS for a large...
PEL Allocate Statement Vs Associations
PerformancePoint provides you with a few options when you want to move data between models, the most obvious of which is Associations. However, there is also the powerful PEL Allocate statement.... So which method should you use to move data? Associations...
PerformancePoint Management Reporter - First Look
PerformancePoint 2007 Management Reporter was launched recently, with the specific intention of providing financial users with the ability to easily create financial reports that can be distributed across the organisation. Management Reporter can connect...
PerformancePoint Dimension Schema Error 225000210
I'm a big fan of schemas in SQL 2005, and like to use them for both organisation and security. However, I've found that PerformancePoint Planning Business Modeller doesn't appear to like schemas as much as I do.... It seems that if you try...