OBIEE 11g Features

Some important points/enhancements in OBIEE 11g when compared to OBIEE 10g are listed below

1. OBIEE 11g uses WebLogic Server as the application server as compared to Oracle AS or OC4J in OBIEE 10g.
2. The clustering process in much easier and automated in OBIEE 11g.
3. We can now model lookup tables in the repository.
4. The new UI called Unified Framework now combines Answers, Dashboards, and Delivers.
5. A new column called the hierarchical column in introduced.
6. BI Publishers is fully and seamlessly integrated with OBIEE 11g.
7. New time series functions PERIOD ROLLING and AGGREGATE AT are introduced.
8. In OBIEE 11g we can create KPIs to represent business metrics.
9. The aggregate persistence wizard creates indexes automatically.
10. 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.
11. OBIEE 11g now supports Ragged (Unbalanced) and Skipped Hierarchy.
12. You can also define Parent-Child hierarchy in OBIEE 11g as well.
13. SELECT_PHYSICAL command is supported in OBIEE 11g.

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

• iBots are renamed as Agents.
• Requests are renamed as Analyses.
• Repository password was introduced in obiee 11g  
•   
•  
• Difference of Siebel & OBIEE
• 1. In OBIEE, we can use Evaluate fn
  2. Time series wizard s used in Siebel whereas ago & todate functions added in OBIEE
  3. OCI call interface connection is available in OBIEE
  4. Presentation variables are introduced
  5. Meta data dictionary is there in obiee
  6. Multi select feature ( contains any, begins with, ends with, wildcards like %) are available in obiee
  
   
•  
• Difference of OBIEE 10g and 11g
  1. In 10g OC4J (Oracle container for java) . In 11g its Weblogic server
  2. Security is managed by RPD in 10 g. In 11g the security is managed by the welogic server.
  3. In 10g we had Foreign key join (physical layer) & complex key join (BMM). We only have a New Key Join in case of 11g , which is used at both the BMM & Physical layer.
  4. 11g supports cross join hierarchies example we can move from customer dimension to product dimension during drilling down. Supports ragged hierarchies etc.
  5. 11g also has column hierarchies available in the presentation services, which are created simply by dragging the dimension hierarchies from the BMM layer to the presentation layer in RPD. when column hierarchies are used to build an analyses the default view is Pivot table.
  6. The time series functions Ago & ToDate which where only available in the RPD with 10g are now also available in the presentation services along with a new function Period rolling.
  7. The analyses can now by reconstructed at run time, that means we can move column attribute from the x-axis to the y-axis and reverse as well.
  8.KPI’s are available in the 11g along with KPI Watchlist on which they are deployed to be viewed by the end user. Key Performance indicators (metrics very essential for the business)
  9. Concept of scorecards is available in 11g, which can measure the goal/mission by using KPI’s as the building blocks for the same
  10. concept of Seletions is now available in the presentation services in 11g.
  11. There is a single portal for the bi publisher/bi intelligence. The reports that are built in the BI Publisher are stored in the same catalog, as the analyses created using the bi intelligence.
  12. 11g has Action Framework which can by used to invoke, existing analyses, html, java procedures.
   
•