Search code examples
ssasolapcubedimensional-modeling

OLAP cube design reference for a IT support business


We are designing a dimensional model for an IT support business. There are cases (some call them tickets or incidents) with different statuses (feels like an SCD type II dimension) We also need to consider the count of cases and SLA time duration as measures.

Before going into detailed design, I reviewed Kimbal's data warehousing toolkit but couldn't find a matching business for our project. Are there any references for a dimensional model for this type of business


Solution

  • From your limited information it sounds like you want to model as an accumulating snapshot fact (as well as a transaction table). See Insurance claim processing pipeline in Kimbal's The Data Warehouse Toolkit.

    It would only be a Type II SCD if the dimension entries were being updated, which in your described case they are not (you are updating the Fact table)