Chapter 2. Creating an InfoCube

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. In our examples, Per Unit Sales Price is a fact table key figure. In the real world, such decisions are made during the data warehouse design phase. Chapter 7 provides some guidelines for making such ...

Get SAP® BW: A Step-by-Step Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.