针对IT支持业务的OLAP多维数据集设计参考 [英] OLAP cube design reference for a IT support business

问题描述

我们正在为IT支持业务设计一个维度模型.某些情况(某些情况称为票证或事件)具有不同的状态(如SCD II型维度) 我们还需要考虑案例数和SLA持续时间作为度量.

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.

在进行详细设计之前，我回顾了 Kimbal的数据仓库工具包，但找不到与我们的项目匹配的业务.此类业务的尺寸模型是否有参考文献

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

推荐答案

从您有限的信息中看来，您似乎希望将其建模为累积快照事实(以及交易表).请参阅Kimbal的数据仓库工具包.

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.

如果要更新尺寸条目，则仅是II型SCD，在您所描述的情况下，它们不是(您正在更新事实表)

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)

这篇关于针对IT支持业务的OLAP多维数据集设计参考的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！