Transactional Business Intelligence is the real-time reporting solution for Oracle Fusion Applications. Transactional Business Intelligence reports query data directly from the transaction tables to ensure real time reporting. If the transaction data is not changing constantly, or if up-to-the-minute reporting is not required, then query performance can be improved by changing the caching options available in Oracle BI EE. Oracle BI EE can cache at two levels. BI Server can cache query result sets and use this to service additional queries on the same data set. By default, this option is disabled for Transactional Business Intelligence.
See the Managing Performance Tuning and Query Caching section in “Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.”
All Transactional Business Intelligence queries execute directly against the Oracle Fusion applications transaction tables, unless the query data is retrieved from the cache. This architecture supports up-to-the-minute BI reporting on the state of your business.
Transactional Business Intelligence queries should focus on operational reporting. Because most Transactional Business Intelligence queries do not execute against pre-aggregated sources, they should not be used for querying very large volumes of historical data or generating trend reports that span multiple years. Use the BI Applications, which query the Oracle Business Analytics Warehouse, for any such complex and historical analysis. See Additional Links.