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 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 team didn’t do, but are native features of Excel….

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 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 support for this scenario. It’s called “defining member intersections” and it can be…