Sacha Tomey's blog

Molding the Microsoft BI Stack

Browse by Tags

All Tags » PerformancePoint (RSS)
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...
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)....
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...
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...
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...
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
PerformancePoint Suggestion box
Inspired by Adrian 's post on the TechNet Planning Forum here's my list of 'I wants' for PPS-P.  I've cross posted this to the forum discussion too.  A few of these have been suggested before but there are some new ones in...
PEL Business Rule Re-use and Pre-defined What If Scenarios
You’ve built a rule set to satisfy an original set of business requirements for calculating budget, and all is good with the world. Then, a change order is raised and approved that requires, for want of a better description, a set of pre-defined what...
New Microsoft Insider PPS Planning Blog
A great new PPS-P focused blog has been up and running for a good few weeks now. Peter Eb. , a developer on the PPS Excel add-in has started blogging some real gold with a mixture of definitions, 'howtos' and workarounds. He's one of the resident...
Book Review: Planning with Microsoft PerformancePoint Server 2007
I've had this book for a while and have been meaning to publish a review for sometime. I reviewed the companion book Monitoring and Analyzing with Microsoft PerformancePoint Server 2007 by the same authors, Adrian Downes and Nick Barclay of B(iQ)...
PerformancePoint Planning Account Type Crib Sheet - Update
I've updated my Account Type Crib Sheet . It now has a back page where other PerformancePoint Planning types have been detailed. Included are: - Flow - Biz System Flag - Business Process - Consolidation Method - Entity Type - Exchange Rate - Time...
Essential Adatis Blogs
I've been speaking to a couple of people recently that, although subscribe to my blog, are not aware of our PPS Planning Sharepoint Web Part that Tim has blogged about here and here . This post is more of an awareness that we have other bloggers onboard...
Share Calculations and Effective Ownership
In PerformancePoint Planning Server there are several pre-defined model types that satisfy different requirements. One of these model types is Financial Model with Shares Calculations and its primary use is for the financial consolidation of a group of...
PerformancePoint Server Job Parameters
Just a quick tip to save some mouse clicks. When you are setting parameters for period start/end type variables you only have to set the end period if it differs from the start period. I used to think all parameters were mandatory. It's particularly...
PerformancePoint Planning Staging Fact Load Validation
PerformancePoint provides a staging database to load data into.  Data loaded can be validated within the staging database before synchronising to the main application. Below is a quick description of the validation steps performed - it could help...
More Posts Next page »