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.
- 3. Modeling Repositories Using Relational, File, and XML Sources
- from Oracle Business Intelligence 11g Developers Guide
- Publisher: McGraw-Hill, Oracle Press
- Released: October 2012
different types of logical tables
Share this highlighthttp://www.safaribooksonline.com/a/oracle-business-intelligence/84880/