grab our rss feed

stevienova.com

Homepage of Steve Novoselac

Entries Tagged ‘CodePlex’

Excel 2007, OLAP Cubes: Customizable, User Defined Named Sets in Excel 2007 using VBA

Jul.12, 2009 in Business Intelligence, Geeky/Programming, SQLServerPedia Syndication

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 [...]

Comments | 2,443 views

OLAP PivotTable Extensions on CodePlex

Apr.20, 2009 in Business Intelligence, SQLServerPedia Syndication

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 on Analysis [...]

Comments | 1,462 views

  

Business Intelligence, SQL, Geek, Music, Programming, and More!

Welcome to stevienova.com. This is my personal blog. I like to write about mostly geeky stuff (Programming, .NET, Microsoft, C#, SQL, Business Intelligence, iPhone, Apple, Mac, Networking, etc) and other stuff that I just run across and feel like posting up to the net!