Skip to main content

Difference between OBIEE 10g and OBIEE 11g


Difference B/W OBIEE 10g and 11g

Some important points/enhancements in OBIEE 11g when compared to OBIEE 10g are listed below
  • OBIEE 11g uses WebLogic Server as the application server as compared to Oracle AS or OC4J in OBIEE 10g.
  • The clustering process in much easier and automated in OBIEE 11g.
  • We can now model lookup tables in the repository.
  • The new UI called Unified Framework now 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.
  • 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 OBIEE 11g unlike OBIEE 10g where they were initialized as soon as a user logs in.
  • 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.

·         Charts are renamed as Graphs.

·   Presentation Columns are renamed as Attribute ColumnSecurity terminology and architecture has changed.

Apart from major architectural differences, OBIEE 11g has several new features that were not available in 10g.

Some of the key features include:
  • Supports creating hierarchy objects in Subject Area
  • Export to xml or export to tab delimited/ and power point
  • 11g lets variable have multiple value
  • 11g RPD cannot be without a password
  • 11g supports ragged hierarchies
  • Column selector in 11g can be defined on multiple columns, compared to just one column in 10g.
The user interface has undergone major improvements in several areas, including a new Home page and redesigned editors and panes.
  • You can use a "selection step" to limit data for columns by specifying the criteria for a set of members
  • Drill in data (expanding a member, without impacting rest of the report)
  • Sorting in 11g is now enabled by default. Sorts can be applied to members, measures, and rows in views such as tables, pivot tables, graphs, and maps
  • In a pivot table, you can easily drag and drop columns to various edges, to rearrange the display to suit your needs
  • Graphs and gauges come with new feature of section sliders.
  • Map view is a new view type that presents data in spatial form
  • We can also create master-detail relationships among certain view types
  • We can create calculated items to perform mathematical operations on members. In 10g, we could create a calculated item for an attribute column. In 11g, we can create a calculated item for the members of an attribute column or of a hierarchical column
  • 11g allows us to work with multiple subject areas in same report. In addition to the primary subject area that you select when you create a new analysis, filter, or dashboard prompt, you can include additional subject areas that are related to the primary subject area with which to work
 Interaction with Other Oracle Products
  • Oracle BI Publisher is a fully integrated member of the Oracle BI EE 11g by default. All of the BI Publisher functionality appears seamlessly within the Oracle BI EE application, and all of the reports and related objects are created within Oracle BI EE and saved to the Oracle BI Presentation Catalog
  • Oracle Hyperion Smart View is available for download from the Oracle BI EE Home page
  • Interface with MS Office is enhanced, including an additional functionality to download to CSV. In 10g, there was an option to download data, but it was only 'Tab delimited', not Comma seperated.

SQL Functions for Time Series Calculations and Level-Based Measures


The following new and revised SQL functions enable you to create time series calculations and level-based measures:


  • PERIODROLLING is a new function that computes the sum of a measure over the period starting x units of time and ending y units of time from the current time.
  • AGGREGATE AT is a new function that aggregates columns based on the level or levels specified.
  • AGO is a time series aggregation function that calculates the aggregated value from the current time back to a specified time period. In this release, the time_level argument is optional, and there are additional syntax changes. This function was called PERIODAGO in the previous release.
  • TODATE is a time series aggregation function that aggregates a measure attribute from the beginning of a specified time period to the currently displayed time. The syntax for this function has changed in this release. This function was called PERIODTODATE in the previous release.

Enhanced database function usage capability



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



Enhancements to the Oracle BI Presentation Catalog

The Oracle BI Presentation Catalog is a powerful, underlying storage directory-based system that contains the objects (dashboards, scorecards, prompts, and KPIs for example) that you create. If you use BI Publisher, then the catalog also contains BI Publisher data and objects (data models and schedules, for example). Using the catalog, you can:

  • Perform basic tasks such as creating, deleting, and copying objects and folders.
  • Perform object-specific tasks (for example, modifying settings using the associated editor, or creating and assigning an agent).
  • Find objects by performing a search.
In addition to these tasks, administrators can:

  • Access the root folder that contains system-wide object and user data.
  • Specify permissions that determine the folders and objects that users can view.
  • Create folders.
  • Work with properties such as changing the ownership of a folder or viewing the creation date of an object.
  • Archive the entire catalog, folders, or objects to unzip them in another directory location.
Actions



you can create actions that navigate to related content or that invoke operations, functions, or processes in external systems. You can include actions in analyses, dashboard pages, agents, scorecard objectives, scorecard initiatives, and KPIs


Comments

  1. I love your content above, but the font is very difficult to read. :) Warmly, Annie

    ReplyDelete
  2. Hi Annie,

    Thanks for your feedback, I changed the font as per suggestion..

    ReplyDelete
  3. Anyone know if OBIEE 10 will work with oracle 12c database ?

    ReplyDelete

Post a Comment

Popular posts from this blog

Contact Me

Do You have any queries ?                   If you are having any query or wishing to get any type of help related Datawarehouse, OBIEE, OBIA, OAC then please e-email on below. I will reply to your email within 24 hrs. If I didn’t reply to you within 24 Hrs., Please be patience, I must be busy in some work. kashif7222@gmail.com

Top 130 SQL Interview Questions And Answers

1. Display the dept information from department table.   Select   *   from   dept; 2. Display the details of all employees   Select * from emp; 3. Display the name and job for all employees    Select ename ,job from emp; 4. Display name and salary for all employees.   Select ename   , sal   from emp;   5. Display employee number and total salary   for each employee. Select empno, sal+comm from emp; 6. Display employee name and annual salary for all employees.   Select empno,empname,12*sal+nvl(comm,0) annualsal from emp; 7. Display the names of all employees who are working in department number 10   Select ename from emp where deptno=10; 8. Display the names of all employees working as   clerks and drawing a salary more than 3000   Select ename from emp where job=’clerk’and sal>3000; 9. Display employee number and names for employees who earn commission   Select empno,ename from emp where comm is not null and comm>0. 10

Informatica sample project

Informatica sample project - 1 CareFirst – Blue Cross Blue Shield, Maryland (April 2009 – Current) Senior ETL Developer/Lead Model Office DWH Implementation (April 2009 – Current) CareFirst Blue Cross Blue Shield is one of the leading health care insurance provided in Atlantic region of United States covering Maryland, Delaware and Washington DC. Model Office project was built to create data warehouse for multiple subject areas including Members, Claims, and Revenue etc. The project was to provide data into EDM and to third party vendor (Verisk) to develop cubes based on data provided into EDM. I was responsible for analyzing source systems data, designing and developing ETL mappings. I was also responsible for coordinating testing with analysts and users. Responsibilities: ·          Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business. ·          Understood the requirement and develope