Navigation
The navigation is one of the major phases. The navigator processes the logical request tree to an initial physical execution plan as its output, and it uses a knowledge of content to eliminate the traditional multi-database joins.
Read more about this topic: Oracle BI Server