stevienova.com

Last week, the Business Analyst at work sent me a link, Office 2003/2007 Assistant What the link will show you is the differences in commands between Excel 2003 and 2007, so users can learn how to do things with the Ribbon. Excel 2007 really should be used when hitting SQL 2005+ OLAP Cubes, but companies [...]

In a perfect world, your master data and master data management (MDM) is set up so everyone can see things how they want. Categories of Items, Regions, etc, etc are all defined in your dimension data, and you can create hierarchies, etc that make sense and everyone is happy. But, this is not a perfect [...]

This weekend, I ran across this on CodePlex – OLAP PivotTable Extensions which got me thinking back to a post by the Excel blog about adding calculated measures and named sets in VBA (which is another blog post completely) From CodePlex: OLAP PivotTable Extensions is an Excel 2007 add-in which extends the functionality of PivotTables [...]

One feature of Excel 2007 that I think is really cool, and also a little hidden, is the “Offline OLAP” feature. If you insert a pivot table connected to an OLAP cube into Excel 2007, and go to the PivotTable Options Ribbon Menu, You will see the “OLAP Tools” Button. Click on that and then [...]

Recently I blogged about easing the transition to Excel 2007 from Excel 2003, by changing your PivotTable design and options. This post is going to be about creating PivotTables that connect to OLAP cubes (and PivotTables in general) that will work in either client, or sometimes called “Compatibility Mode“ If you create a PivotTable in [...]

Being that we are now in the year 2009, you would think that most people are currently using or have been using the Office 2007 suite for a couple of years now. The truth is that there are many businesses “in the wild” that are still standardizing on the Office 2003 suite. Why? Well there [...]