Subscribe to this blog
Microsoft Business Intelligence and Data Warehousing
Archives: October 2011
Dimensional Modeling Financial Data in SSAS
Part 1 – Parent Child Hierarchies and Pseudo GL Accounts
This post is born out of some real life lessons that I learned while putting together a Financial Data Warehouse based on General Ledger (GL) data i.e. all the GL’s in the foundational financial statements from Net Income and Balance… Read more
10 comments, 1,008 reads
Posted in Microsoft Business Intelligence and Data Warehousing on 26 October 2011
Self Service BI and PowerPivot
Marco Russo and Alberto Ferrari have written a book called Microsoft PowerPivot for Excel 2010: Give Your Data Meaning that I finally got around to reading. It is great book with many good practical examples. If you are not already familiar with PowerPivot and DAX I highly recommend reading and… Read more
1 comments, 202 reads
Posted in Microsoft Business Intelligence and Data Warehousing on 17 October 2011
Event Driven SSIS with Synchronous Processing and Dynamic Subscriptions
I know the title of this post is a little cryptic and something that only a techie would like but let me give you the real world requirements so that is will be a little more concrete.
Solution requirements:
- User uploads file to SharePoint 2010
- On file upload an Event…
0 comments, 290 reads
Posted in Microsoft Business Intelligence and Data Warehousing on 12 October 2011
Analysis Services 2008 R2 Performance Guide
You must read this if you work with SSAS:
Analysis Services 2008 R2 Performance Guide
Infact, I would recommend re-reading it a number times.
Introduction
This guide contains information about building and tuning Analysis Services in SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2 cubes for the…
0 comments, 148 reads
Posted in Microsoft Business Intelligence and Data Warehousing on 11 October 2011