Considerations and Recommendations for Creating Joint Venture Operational Reports

OTBI is for real-time operations analysis. You shouldn’t run queries on large volumes of historical data. You can use filters to restrict the data to include in your analysis.

You might run into a scenario in which an analysis for reporting on transactions from two or three of the sources doesn’t show transactions from all sources. This occurs when an attribute that you select to include in the report, such as the Accounting Class Code attribute, isn’t an attribute in all the source tables. You can remove the attribute from the analysis, or if you need to include it, then you can use a union to create the analysis. This will help ensure that the results include transactions from all sources, even the sources in which the attribute is not applicable. See Advanced Techniques: Combine Columns to Display Data Differently for information on how to create a union.