A decision support system is used by decision makers for a long time. But, in some cases, the originally designed multidimensional schema does not cover the entire needs of decision makers, which can change over time. One such unfulfilled need, is using facts to describe dimension members. In this article, we propose a methodology to transform the constellation schema of a data warehouse by integrating factual data into a dimension. The proposed methodology and algorithms enrich a constellation multidimensional schema with new analytical possibilities for decision makers. This enrichment has repercussions for the entire multidimensional schema that are managed by multidimensional modeling, hierarchy calculation and the hierarchy version. In this article, we present a theoretical view of the proposed methodology supported by a case study, an implemented prototype and a complete evaluation based on a standard benchmark.

中文翻译：

---

（大）数据仓库将事实转化为维度的半自动设计方法

决策者长期使用决策支持系统。但是，在某些情况下，最初设计的多维模式并未涵盖决策者的全部需求，这些需求可能会随着时间而改变。一种未满足的需求是使用事实来描述维度成员。在本文中，我们提出了一种方法，通过将事实数据集成到维度中来转换数据仓库的星座模式。所提出的方法和算法丰富了星座多维模式，为决策者提供了新的分析可能性。这种丰富对由多维建模、层次计算和层次版本管理的整个多维模式产生影响。在本文中，我们提出了由案例研究支持的拟议方法的理论观点，