ü OBIEE
11g uses the WebLogic Server as the server application and in 10g it is OC4J (Oracle
Connector for J2EE).
ü Clustering
process is much easier and automated in OBIEE11g.
ü We
can have model lookup tables in repository.
ü The
new UI call Unified Framework combines Answers, Dashboards and Delivers.
ü A
new column called the Hierarchical column is introduced.
ü BI
Publishers is fully and seamlessly integrated with OBIEE 11g.
ü New
Time series functions PERIOD ROLLING and AGGREGATE AT are introduced.
To_DATE(<Measure>,
<Level>)
Ago
(<Measure>, <level>,< No.of Periods>)
PeriodRolling(<Measure>,<Starting
Period Offset>,<Ending Period Offset>)
periodRolling(<Measure>,-2,0) à 3
PeriodRolling Sum
A measure with the PERIODROLLING function
calculates results based on the query grain(if u select month in criteria it
will calculate last 3months, if u select year it will calculate last 3years
rollingsum).In your criteria if u have qtr, month and
week it will calculate based on week. (It always takes low granularity)
ü In
OBIEE 11g we can create KPIs to represent business metrics.
ü The
Aggregate persistence wizard creates indexes automatically.
ü The
session variables get Initialized when they are actually used in OBIEE11g
unlike 10g where they are initialized as soon as a user logs in.
ü OBIEE11g
supports ragged (unbalanced) and skipped hierarchy.
ü You
can also define parent child hierarchy in OBIEE11g.
ü OBIEE 10g need to install the OBI Briefing Book Reader software in order to open the .sbb (Siebel Briefing Book) files. Where as in OBIEE 11g there is no briefing book reader and no .sbb output anymore. We can download briefing book as pdf or MHTML format.
ü In OBIEE10g you have to install Event pooling table (S_NQ_EPT) manually in database where as in OBIEE11g it will be installed while creating RCU (Repository Creation Utility) in BIPLATFORM schema.
ü In OBIEE 11g Presentation variable can hold more than one value. Where as in OBIEE 10g it can hold only one value at a time.
ü OBIEE 10g need to install the OBI Briefing Book Reader software in order to open the .sbb (Siebel Briefing Book) files. Where as in OBIEE 11g there is no briefing book reader and no .sbb output anymore. We can download briefing book as pdf or MHTML format.
ü In OBIEE10g you have to install Event pooling table (S_NQ_EPT) manually in database where as in OBIEE11g it will be installed while creating RCU (Repository Creation Utility) in BIPLATFORM schema.
ü In OBIEE 11g Presentation variable can hold more than one value. Where as in OBIEE 10g it can hold only one value at a time.
ü SELECT_PHYSICAL
command is supported in OBIEE 11g.(in 10g we have directdatabase request
only.Here we will mention database columns …SELECT_PHYSICAL will get the data
from rpd physical layer. here we will mention physical layer alias tables and
columns.
Benefits
of using SELECT_PHYSICAL
By using SELECT_PHYSICAL, the developer can:
- Create queries using the alias names, simplifying the query readability
- Simplify the query, in case of using opaque views created in the Physical Layer of the RPD
- Join tables from multiple data sources
- Access the data sources without need of knowing the login credentials
