Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Microsoft Business Intelligence and Data Warehousing

Garrett Edmondson, Independent Consultant MCITP & MCTS: 10+ years experience with BI stack.

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, 2,334 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, 451 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:

  1. User uploads file to SharePoint 2010
  2. On file upload  an Event…

Read more

0 comments, 667 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…

Read more

0 comments, 366 reads

Posted in Microsoft Business Intelligence and Data Warehousing on 11 October 2011