Peter Eb.

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

Blog - About

About Peter Eb.

I'm a developer working on Office (formerly PerformancePoint Planning and PerformancePoint Services for SharePoint)

I'm using this blog to have a place to put my answers to common questions in a consistent location...

  • Peter Eb.

    Gemini has an official name: PowerPivot

    • 0 Comments
    Well the Gemini team is making progress towards shipping. Now they have a real name: PowerPivot . They still don’t have any pricing/licensing/packaging details; that is promised later this year. There’s also links to sign up for a beta. But I don’t have...
  • Peter Eb.

    PerformancePoint Server 2007 SP3 released

    • 0 Comments
    Finally made it out the door ! For the AddIn I have a couple notes: Besides the usual rollup of hotfixes (bug fixes) there is a new feature: Line Item Details (LIDs). This was supported by the server but not on the client side, and now it is! We did our...
  • Peter Eb.

    Excel 2010 is better than the PPS Planning AddIn

    • 0 Comments
    Although the model of using an Excel AddIn can be a little clunky (especially for what PPS Planning called the contributor scenario) I think my team did a pretty good job getting some very usable reporting elements. Now I get to point you to things my...
  • Peter Eb.

    Gemini destroys the world….Not!

    • 0 Comments
    So in a previous post I tried to tear down Gemini to something relatively simple, instead of curing cancer. This post is when I build it back up. Gemini just lets end-users combine data without having to get IT and DBAs involved. This is precisely where...
  • Peter Eb.

    Gemini Cures Cancer…Not!

    • 1 Comments
    Most of the people reading this blog have probably also seen demos or at least heard of Gemini and it’s magical powers of solving all BI problems known and unknown. (And you probably want to be looking at it. You can see if you get accepted to the CTP...
  • Peter Eb.

    Radio Silence

    • 1 Comments
    Well radio silence has been maintained quite successfully. Sorry for the lack of updates but with Planning development ended I haven't had a lot to say… Office 2010 (aka Office 14) is finally starting to see the light of day. I know some of you by now...
  • Peter Eb.

    Microsoft BI Conference 2008

    • 0 Comments
    I imagine that very few people who read this blog don't already know about the Microsoft BI Conference happening in Seattle this year during October 6-8. I'll be spending as much time as I can there (since I'm local its easy for me to go but I've still...
  • Peter Eb.

    Extended absences and other people doing my job for me!

    • 0 Comments
    Its been quite a while since I've posted. I've still been hanging out in the PPS TechNet forums, but just haven't been finding as much time to post. I've had a little change in job duties that are taking some time to adjust to. Anyway I'm very pleased...
  • Peter Eb.

    SP1

    • 0 Comments
    If you haven’t seen it yet the english builds are available! http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3444589&SiteID=17   I have some details about the addin performance improvements http://forums.microsoft.com/TechNet/ShowPost...
  • Peter Eb.

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

    • 1 Comments
    It's actually hard to say. This process is asynchronous which is why the status is initially Pending, then WaitProcess, then finally Partial/Submitted. See my other posts about assignment statuses and assignment actions for more details and a quick overview...
  • Peter Eb.

    HOWTO: Dynamic rows or columns with a dimension property filter

    • 0 Comments
    To filter rows and columns by a filter selection has previously been discussed here . But one thing you might not have noticed is that the list of property values (aka the filter scope) is static. If a new member property appears the form needs to be...
  • Peter Eb.

    HOWTO: Filter rows and columns by selecting from a filter

    • 2 Comments
    (Sorry for the gap since my last post, things have been a bit busy lately in Peter Eb. land…) One simple way to do this filtering is to enable suppress blank rows or suppress blank columns. Then when there is no data (non-null) in the cube for those rows...
  • Peter Eb.

    What does this PPS Planning workflow action mean?

    • 2 Comments
    Workflow handles jobs, cycles, assignments and more. In keeping with my focus on the PPS Planning Business Client (aka Add-In for Excel), this post will just cover those actions related to assignments. In keeping with my new analogy of describing workflow...
  • Peter Eb.

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

    • 1 Comments
    There are 2 kinds of ranges that the PPS Planning Member Picker supports: 1) From the selected member to an offset from current period (or vice versa). 2) Or from an offset from the current period to another offset from the current period. (It's also possible to simply use an offset from the current period without a range specified). When using the member picker with Time look for the special dropdown that appears - hopefully this isn't surprising - called...."Time"!...
  • Peter Eb.

    HOWTO: Hide filters for dimensions that confuse users

    • 7 Comments
    For data entry forms (and even some reports) its pretty important to keep contributors focused on their specific task. Its especially easy for users who are not familiar with OLAP or PPS to be confused by some things: "TimeDataView" and "Business Process...
  • Peter Eb.

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

    • 1 Comments
    Workflow in PPS Planning is completely asynchronous. This allows the server side to scale and handle many, many simultaneous submissions, job requests etc. Its possible to add more server's to the pool that handles this asynchronous queue. From the add...
  • Peter Eb.

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

    • 1 Comments
    This is a confusing error for users and form authors alike, especially since the add-in help does not have a glossary entry for "filter scope". I fear I came up with the error text, so I apologize. So to hopefully rectify this situation, we...
  • Peter Eb.

    HOWTO: Make 1 filter control more than 1 matrix

    • 4 Comments
    A common request by form authors is to create a "start here" worksheet page where contributors can change some global filters. Then they advance to other worksheets in the workbook to do their actual data entry. Other times authors just want to link multiple...
  • Peter Eb.

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

    • 5 Comments
    Short answer : In SP1 the PPS Planning add-in will use the where clause and life for MDX experts will be back to normal.* Long answer : Because of the extra properties needed for writeback. The CellSet returned by AdoMd.Net does not return member properties...
  • Peter Eb.

    HOWTO: Show numbers as 1,000s in Excel

    • 0 Comments
    Bonus post that isn't specific to PPS. HOWTO use an Excel custom number format to display a number in thousands or millions etc. ...
  • Peter Eb.

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

    • 3 Comments
    Also phrased: How can I create an "asymmetric crossjoin" without using custom MDX? MDX experts will probably recognize this issue right away and understand how to build a matrix from scratch for this. But not everybody recognizes that the add-in has specific...
  • Peter Eb.

    "Report" authoring and PPS Planning Business Client

    • 2 Comments
    Sorry this isn't a super technical post, most of this information should be pretty well known by now. Ah the glory of having your own blog: you get to say a lot of junk that everybody already knows but you repeat anyway just to sound important.... Off hand there are 6-ish ways I can think of to describe how to author a report on PPS Planning data. Not all of them involve the PPS Planning Business Client (aka the add-in) but I will spend the most time with the add-in based options. The first 2 and the last 1 are the most common based on my experience. ...
  • Peter Eb.

    HOWTO: Validate 2 filter selections match using a member property

    • 2 Comments
    A recent post by "abdulmohi" in the PPS Planning forums asked about linking or cascading filters. So that once one filter was selected, another filter would be updated to match the first. In abdulmohi's case it was obvious what the linkage should be because...
  • Peter Eb.

    What does this Peter Eb. guy know anyway?

    • 1 Comments
    Well, I'm a developer working on the "Business Client" for the Planning side of Microsoft Office PerformancePoint Server (aka the PPS Add-In for Excel or the PPS Planning Add-In). My main area of responsibility has been the data-entry and workflow features...
Page 1 of 1 (24 items)