O'Reilly logo
  • jay p thinks this is interesting:

hese are “virtual” tables that represent the data set that users will use to create their analyses, sourced from a single physical table or a set of tables, and either through direct mappings or through SQL expressions. They can be categorized into three types: facts—logical tables containing measures such as profit, revenue, cost, and margin; dimensions—logical tables containing reference data by which measures are analyzed, such as customers, products, times, and stores; and lookups—new with the 11g release of Oracle Business Intelligence.