OLAP cube design reference for a IT support business [closed]

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

Answer1:

From your limited information it sounds like you want to model as an <strong>accumulating snapshot fact</strong> (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)

人吐槽 人点赞

Recommend

Comment

用户名: 密码:
验证码: 匿名发表

你可以使用这些语言

查看评论:OLAP cube design reference for a IT support business [closed]