Sacha Tomey's blog

Molding the Microsoft BI Stack

Browse by Tags

All Tags » PerformancePoint » Business Intelligence (RSS)
New PerformancePoint Contoso Demo - Released
Amidst my write up of the first day of the Microsoft BI Conference , I mentioned a new planning demo suite was imminent, and I would post more information about the demos soon.  Well, as it has now been officially released (27th October) I can spill...
Dynamic Range, Time Property Filter = Empty Matrix - A bug?
I think I've found a bug in the way the Excel Add-In generates MDX under certain 'rolling' conditions.  The requirement I have is to be able to forecast at the day level for a rolling 6 months; starting from the current period (which...
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...
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...
Book Review: Monitoring and Analyzing with Microsoft PerformancePoint Server 2007
Tim Kent already reviewed this book last month after polishing it off over a weekend. Tim liked the book and gave a positive review. However, I felt that it is difficult to gauge how good the book is as, to be fair, Tim is hardly a newbie when it comes...
More Posts Next page »