Peter Eb.

Possibly interesting tidbits about Office (although most content is still related to PerformancePoint Planning and Excel.)

Gemini has an official name: PowerPivot

Well the Gemini team is making progress towards shipping. Now they have a real name: PowerPivot....

Author: Peter Eb Date: 10/20/2009

PerformancePoint Server 2007 SP3 released

Finally made it out the door! For the AddIn I have a couple notes: Besides the usual rollup of...

Author: Peter Eb Date: 10/16/2009

Excel 2010 is better than the PPS Planning AddIn

Although the model of using an Excel AddIn can be a little clunky (especially for what PPS Planning...

Author: Peter Eb Date: 10/15/2009

Gemini destroys the world….Not!

So in a previous post I tried to tear down Gemini to something relatively simple, instead of curing...

Author: Peter Eb Date: 08/29/2009

Radio Silence

Well radio silence has been maintained quite successfully. Sorry for the lack of updates but with...

Author: Peter Eb Date: 07/17/2009

Microsoft BI Conference 2008

I imagine that very few people who read this blog don't already know about the Microsoft BI...

Author: Peter Eb Date: 09/29/2008

SP1

If you haven’t seen it yet the english builds are available!...

Author: Peter Eb Date: 06/04/2008

When will data appear in the cube after a submit from the PPS Planning Business Client?

It's actually hard to say. This process is asynchronous which is why the status is initially...

Author: Peter Eb Date: 05/14/2008

HOWTO: Dynamic rows or columns with a dimension property filter

To filter rows and columns by a filter selection has previously been discussed here. But one thing...

Author: Peter Eb Date: 05/12/2008

HOWTO: Filter rows and columns by selecting from a filter

(Sorry for the gap since my last post, things have been a bit busy lately in Peter Eb. land…) One...

Author: Peter Eb Date: 05/09/2008

HOWTO: Select a time range that is dynamic (updates over time for a rolling forecast)

There are 2 kinds of ranges that the PPS Planning Member Picker supports: 1) From the selected...

Author: Peter Eb Date: 04/25/2008

HOWTO: Hide filters for dimensions that confuse users

For data entry forms (and even some reports) its pretty important to keep contributors focused on...

Author: Peter Eb Date: 04/24/2008

What does this status "xyz" mean for my assignments?

Workflow in PPS Planning is completely asynchronous. This allows the server side to scale and handle...

Author: Peter Eb Date: 04/23/2008

What does the error "filter selection for dimension XYZ is not in the filter scope"?

This is a confusing error for users and form authors alike, especially since the add-in help does...

Author: Peter Eb Date: 04/22/2008

HOWTO: Make 1 filter control more than 1 matrix

A common request by form authors is to create a "start here" worksheet page where contributors can...

Author: Peter Eb Date: 04/21/2008

Why not use the "where clause" for filters instead of "on pages"?

Short answer: In SP1 the PPS Planning add-in will use the where clause and life for MDX experts will...

Author: Peter Eb Date: 04/18/2008

HOWTO: Show actuals from the past while forecasting for the future

Also phrased: How can I create an "asymmetric crossjoin" without using custom MDX? MDX experts will...

Author: Peter Eb Date: 04/16/2008

"Report" authoring and PPS Planning Business Client

Sorry this isn't a super technical post, most of this information should be pretty well known by...

Author: Peter Eb Date: 04/14/2008

HOWTO: Validate 2 filter selections match using a member property

A recent post by "abdulmohi" in the PPS Planning forums asked about linking or cascading filters. So...

Author: Peter Eb Date: 04/11/2008

What does this Peter Eb. guy know anyway?

Well, I'm a developer working on the "Business Client" for the Planning side of Microsoft Office...

Author: Peter Eb Date: 04/09/2008