本文探讨了数据仓库设计中的核心概念，包括特性（Characteristics）、属性（Attributes）与关键指标（Key Figures）。特性如CustomerID和MaterialNumber代表数据中的维度，而关键指标如SalesRevenue则量化了业务活动。这些元素共同构成了InfoObjects，用于构建InfoCubes以实现高效的数据分析。
In BW, Customer ID, Material Number, Sales Representative ID, Unit of Measure, and Transaction Date are called characteristics. Customer Name and Customer Address are attributes of Customer ID, although they are characteristics as well. Per Unit Sales Price, Quantity Sold, and Sales Revenue are referred to as key figures. Characteristics and key figures are collectively termed InfoObjects.
A key figure can be an attribute of a characteristic. For instance, Per Unit Sales Price can be an attribute of Material Number. ....... Per Unit Sales Price is a fact table key figure. In the real world, such decisions are made during the data warehouse design phase.
InfoObjects are analogous to bricks. We use these objects to build InfoCubes. An InfoCube comprises the fact table and its associated dimension tables in a star schema.
A key figure can be an attribute of a characteristic. For instance, Per Unit Sales Price can be an attribute of Material Number. ....... Per Unit Sales Price is a fact table key figure. In the real world, such decisions are made during the data warehouse design phase.
InfoObjects are analogous to bricks. We use these objects to build InfoCubes. An InfoCube comprises the fact table and its associated dimension tables in a star schema.
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
