Utilizing MDM techniques, relationships and patterns are revealed by the existence of Facts at the cross section of Dimensions . For example, if there are sales from Customer X of Product Y, then a relationship between Customer and Product is implied. Each Dimension in the star schema is described in its own table. Facts are arranged in a single large table indexed by a multipart key composed of the individual keys of each Dimension . Fact tables contain the quantitative data about a business and can consist of many columns and millions of rows.
Dimension tables are smaller and hold descriptive data that reflect the Dimensions of the business.
They describe Facts . The categorical X and Y axis of the Landscape Schema are comprised of any two Focus Dimensions . These Dimensions provide the structure for the exploration of Facts . For example, an icon's color and height above the Information Landscape indicates discrete, Product Sales information. 3-D icons represent the cross section of Dimensions and Facts .