FW - Dimensional Modeling Concepts

 Dimensional Modeling Concepts

维度建模概念

 

Regular and measure dimensions are used to enable an OLAP presentation of metadata, drilling up and down, and a variety of OLAP functions. You must use star schema groups (one fact with multiple dimensions) if you want to use Analysis Studio with a relational data source.

常规和度量维度用于启用OLAP展现的元数据，上卷下钻，和各种OLAP功能。如果想要对一个关系数据源使用Analysis Studio时，必须使用星形架构（一个事实表带多个维度表）。

 

When building your model, it is recommended that model regular dimensions and model measure dimensions be created based on a relational model in which star schema concepts have been applied.

当构建你的模型时，推荐在基于已应用了星形架构的关系数据模型上，创建常规维度和度量维度。

 

While you can convert data source query subjects to data source dimensions, data source dimensions have limited functionality in comparison to query subjects or model dimensions, and they are not recommended for general use.

一旦你把数据源查询主题转换成数据源维度后，相对于查询主题或模型维度而言，数据源查询主题的部分功能将受限。所以，通常不建议这样操作。