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 decisions.

2.1. Creating an InfoArea

2.2. Creating InfoObject Catalogs

2.3. Creating InfoObjects—Characteristics

2.4. Creating InfoObjects—Key Figures

2.5. Creating an InfoCube

2.6. Summary