Browse by Tags

• Data Warehousing
• Design Tips
• ETL
• Kimball
• Microsoft
• SQL Server

• Modelling & Loading a Slowly Changing Many-to-Many Relationship

  I haven’t blogged for a while, mostly because I have been busy. Today I am on a train to London , so I thought what better thing could I do to fill the time than to blog about something I have been meaning to blog about for a while: Modelling Slowly changing... Posted Feb 18 2010, 01:56 PM by JakeSmillie with | with no comments Filed under: ETL, Data Warehousing, Kimball, SSAS, Design Tips

• Creating Slowly Changing Hierarchies in SSAS 2005

  In a Data Warehouse, you’ll typically get at least one slowly changing hierarchy. You’ll probably also have other slowly changing attributes on the same dimension that are not in the hierarchy, causing many changes. Setting up this scenario in SSAS 2005... Posted Jul 03 2009, 11:27 AM by JakeSmillie with | with no comments Filed under: Microsoft, Data Warehousing, Kimball, SQL Server, SSAS