Oracle BI EE requires the ability to efficiently access data from two or more master or detail linked view objects in order to aggregate, present, or report on that combined data set. An essential requirement is to efficiently retrieve the levels of related information as a single, flattened query result, to perform subsequent aggregation and transformation. The Oracle ADF Composite view object API allows the caller to create a new view object at runtime. It contains the hierarchical results from two or more existing view-linked view objects into a single, flattened query retrieving the same effective set of data.