By Mike.Hallett-Oracle on Oct 13, 2011
Occasionally I am asked about where to find better documentation for the BI-Apps data sources. If you need this, then this is available via the Metalink note (ID 1274680.1), that provides a link to an Excel spreadsheet documenting the data “lineage” of the information found in the BI Apps data warehouse: it is almost 8 MB, in a zip file online link.
Also you may be interested in the Metalink note (ID 846917.1) that contains a link to the Business Analytics Metric Reference Guide. This contains information on the KPIs and on how certain variables are calculated.
Hope this helps you in your BI-Apps engagements.
Short-cuts to the download links, so you don’t have to read the entire Metalink notes:
BI_Apps_18.104.22.168_22.214.171.124_DL.zip (7,991.54 KB)
Metrics Reference guide for 796 (7,754.88 KB)
Oracle Business Intelligence Applications ETL Data Lineage Guide Release 126.96.36.199 and 188.8.131.52 [Article ID 1274680.1]
Oracle Business Intelligence Applications Metrics Reference Guide Release 7.9.6,184.108.40.206 [ID 846917.1]
Oracle Business Intelligence Applications Content Guide Release 220.127.116.11 [ID 1264878.1]
Oracle Business Analytics Warehouse Data Model Reference Version 7.9.6, 18.104.22.168 and 22.214.171.124 [ID 819373.1]