Compare and contrast Report Execution, Element Browsing and Object Browsing Execution flows in a 3 Tier Environment.
1. RE: 9 possible steps, Caches, SQL Engine, Query Engine Analytical Engine, IServer Bus; if no cache, Bus obtains report def and app. objects from metadata, SQL Engine formulates SQL sends back to Bus --> Query Engine <-> DW -> Bus; can be multiple passes, back to Bus and Desktop.
2. EB: 7 Steps, Same as RE, but no Analytical Engine/Multipass
3. OB: 5 steps, Same as EB but no SQL Engine, Query Engine, DW.