Difference B/W OBIEE 10g and 11g

• OBIEE 11g uses WebLogic Server as the application server as compared to Oracle AS or OC4J in OBIEE 10g. 
• The session variables get initialized when they are actually used in OBIEE 11g unlike OBIEE 10g where they were initialized as soon as a user logs in.
• In 11g Users and groups are created in Enterprise Manager (EM) whereas in 10g Users and groups are created in repository.
• New time series functions PERIOD ROLLING and AGGREGATE AT are introduced.
• Timeseries function can be created in Answers as well.
• Logical Table Source(LTS) Priority ordering is introduced.
•  OBIEE Join is done from fact to dimension whereas in 10g join is done from dimension to fact.
• A new column called the hierarchical column in introduced.
• OBIEE 11g now supports Ragged (Unbalanced) and Skipped Hierarchy.
• Parent Child hierarchy is introduced.
• We can now model lookup tables in the repository.
• SELECT_PHYSICAL command is supported in OBIEE 11g.
• In OBIEE 11g we can create KPIs to represent business metrics.

    In OBIEE 11g there are some changes in terminology as well:

• iBots are renamed as Agents.
• Requests are renamed as Analysis.
• Charts are renamed as Graphs.
• Presentation Columns are renamed as Attribute Columns.
• The new UI called Unified Framework now combines Answers, Dashboards, and Delivers.