Did you know that SAP HANA is much more than a high-speed analytic appliance? TEC principal analyst P.J. Jakovljevic reveals how HANA is a universal database that will enable companies to analyze large volumes of operational and transactional information in real time, from virtually any data source, and that will eventually deliver an entirely new class of applications that will change the way people think, work, plan, and operate.
Analytic View or OLAP cube is a set of physical tables, interconnected in a star schema. Only the fact table provides the information the user is actually interested in. The facts, also referred to as metrics, measures, or key figures, are generally numbers (or numerical values) such as “Sales Net Revenue.” The dimension tables provide the categories, classes, or attributes by which the facts can be grouped. In other words, the fact table provides the content of the OLAP cube, i.e., the “what” to