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_126.96.36.199_188.8.131.52_DL.zip (7,991.54 KB)
Metrics Reference guide for 796 (7,754.88 KB)
Oracle Business Intelligence Applications ETL Data Lineage Guide Release 184.108.40.206 and 220.127.116.11 [Article ID 1274680.1]
Oracle Business Intelligence Applications Metrics Reference Guide Release 7.9.6,18.104.22.168 [ID 846917.1]
Oracle Business Intelligence Applications Content Guide Release 22.214.171.124 [ID 1264878.1]
Oracle Business Analytics Warehouse Data Model Reference Version 7.9.6, 126.96.36.199 and 188.8.131.52 [ID 819373.1]