OBIEE 10g and 11g Difference

Difference between OBIEE 10g and OBIEE 11g:

a.      OBIEE 11g uses WebLogic Server as the application server as compared to Oracle AS or OC4J in OBIEE 10g.

b.      The clustering process is much easier and automated in OBIEE 11g.

c.       We can now model lookup tables in the repository.

d.      The new UI called Unified Framework now combines Answers, Dashboards, and Delivers.

e.       A new column called the hierarchical column is introduced.

f.       BI Publishers is fully and seamlessly integrated with OBIEE 11g.

g.      New time series functions PERIOD ROLLING and AGGREGATE AT are introduced.

h.      In OBIEE 11g we can create KPIs to represent business metrics.

i.        The aggregate persistence wizard creates indexes automatically.

j.        The session variables get initialized on first usage in OBIEE 11g unlike OBIEE 10g where they were initialized as soon as a user logs in.

k.      OBIEE 11g now supports Parent-Child, Ragged (Unbalanced) and Skipped Hierarchy.

l.        SELECT_PHYSICAL command is supported in OBIEE 11g.

Changed terminologies:

a.       iBots are renamed as Agents.

b.      Requests are renamed as Analyses.

c.       Charts are renamed as Graphs.

d.      Presentation Columns are renamed as Attribute Column.

e.       Security terminology and architecture has changed.

Some of the key features include:

a.       Export to xml or export to tab delimited and power point.

b.      11g lets variable have multiple value.

c.       11g RPD cannot be without a password.

d.      You can use a "selection step" to limit data for columns.

e.       Drill in data (expanding a member, without impacting rest of the report)

f.       Sorting in 11g is now enabled by default.

g.      In a pivot table, you can easily drag and drop columns to various edges and rearrange.

h.      Graphs and gauges come with new feature of section sliders.

i.        Map view is a new view type that presents data in spatial form.

j.        We can also create master-detail relationships among certain view types

k.      We can create calculated items to perform mathematical operations on members.

l.        11g allows us to work with multiple subject areas in same report.

SQL Functions for Time Series Calculations and Level-Based Measures

1.      PERIODROLLING

2.      AGGREGATE AT

3.      PERIODAGO à AGO

4.      PERIODTODATE àTODATE

Enhanced database function usage capability:

1.      OBIEE 11g allows calling EVALUATE, EVALUATE_AGGR, and VALUATE_PREDICATE function for advanced calculations.

2.      Enhancements to the Oracle BI Presentation Catalog

3.      Perform basic tasks such as creating, deleting, and copying objects and folders.

4.      Find objects by performing a search.