Browse by Tags

• Data Warehousing
• ETL
• Kimball
• Reporting
• SSAS

• 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

• Importance of Unrealised FX Gain and Loss

  Many businesses want to see measures across multiple currencies, for example: sales for all countries or customer balances for all account currency types. Typically when dealing with multiple currencies a ‘base’ currency to report on is chosen to make... Posted Aug 07 2009, 06:18 AM by JakeSmillie with | with no comments Filed under: Reporting, Data Warehousing, Design Tips

• Multi Level Hierarchy Dimension Design Tip

  When building a dimensional modelling solution, somewhere along the line you will almost certainly have at least one multi level hierarchy within one or more dimensions. A good example of this is a Product hierarchy, which might go: Department->Sub... Posted Aug 07 2009, 04:34 AM by JakeSmillie with | with no comments Filed under: Reporting, Data Warehousing, Design Tips