Oracle BI apps 11.1.1.7.1 (BI apps on ODI)

Oracle Business Intelligence (BI) Applications 11.1.1.7.1 (also known as 11g PS1) is now available on theOracle Software Delivery Cloud (eDelivery) and on the Oracle Technology Network (OTN). This is the first major release on the 11g code line leveraging the power of ODI, and certified with the latest version of Oracle BI Foundation 11.1.1.7.

What’s New

This major new release of Oracle Business Intelligence Applications 11g adds:

1. New in-memory analytic applications

2. Significantly expand functional content across existing CRM and ERP Oracle BI Applications

3. Re-design to leverage the power of Oracle Data Integrator and, optionally, GoldenGate

4. New out-of-the-box utilities to increase productivity and further drive down Total Cost of Ownership (TCO).

New Oracle BI Applications:

· Oracle Student Information Analytics enables academic institutions to improve recruitment, lower dropout rate by tracking student attendance in real-time, monitor graduation rate, manage student financial transactions, and match up school resources with student needs more effectively.

· Oracle Indirect Spend Planning – a prebuilt planning application that teams with Oracle Procurement and Spend Analytics to enable businesses to optimize spend through what-if modeling

New Content Enhancements: Significant expansion of content improves existing front and back-office Oracle BI Applications including:

· Oracle Human Resources Analytics expands analysis on HR programs and workforce performancewith new

Time and Labor Analysis, global Payroll Analysis and Headcount Gain and Loss.

· Oracle Financial Analytics improves company Financial Performance with new Fixed Assets Analysis, providing complete lifecycle of assets from acquisitions, capitalization to retirements.Budgetary Control Analysis, ideal for public sector, delivers insight into expense & revenue budgets including analysis of budgeted amounts, encumbrances, expenditures, funds available, overspending, and recognized revenues.

· Oracle Project Analytics expands insight into project-based data with new Resource Management Analysis, providing visibility into project requirements, trending, utilization, competencies and alignment. Reconciliation of project sub-ledger and General Ledger assist project accountants in reconciling differences between the two ledgers for cost and revenue transactions. Perspective based dashboards provide an optimized Project Analytics user interface that orients the content around specific user perspectives.

· Oracle Supply Chain & Order Management Analytics introduces new Enhanced Inventory Analysis, providing deep insight into Inventory Cycle Count, Inventory Aging, Inventory Expiration/Obsolescence tracking and Inventory balances and transaction details at lot level. Item Cost History Analysis allows insight into historical cost of Supply Chain related items.

· Oracle Procurement & Spend Analytics introduces new Sourcing Analysis, providing a new comprehensive Sourcing Business Process that includes negotiations, awards, savings and performance. Award decisions will help identify trends and check if there is a margin for any savings opportunity.

· Oracle CRM Analytics expands insight into front office Analytics with Indirect Forecasting and Service Contracts support. Forecasting Analysis is now possible when submissions are made up a forecast hierarchy that is outside of the reporting hierarchy. Oracle Price Analytics has added E-Business Suite to the list of supported sources. Customers now have a ready means to assess pricing performance and arrest revenue and margin leakage.  Robust price waterfall analysis possible with the new Waterfall view.

Using New Oracle BI Foundation Suite 11.1.1.7 Features:

· Visualization Enhancements, and User Interaction Improvements

· BI Mobile HD Enhancements: BI Applications available on mobile without additional development

New Oracle Data Integration: BI Apps are completely re-architected to leverage Oracle Data Integrator and Oracle GoldenGate. 

· BI Applications is now available with next-generation Data Integration. Oracle Data Integrator (ODI) delivers unique next-generation, Extract Load and Transform (E-LT) technology that improves performance and reduces data integration costs—even across heterogeneous systems, and improves productivity.

· Functional Setup Manager provides a Web based Administrative User Interface to track and manage implementation projects and their required functional setup steps

· Configuration Manager provides a centralized Web based administrative user interface to simplify the setup and maintenance of Oracle Business Intelligence Applications.

· A new optional pre-packaged solution, that leverages GoldenGate, eliminates the need for an ETL batch window and minimizes the impact on OLTP systems, while providing near real-time reporting and enabling more reliable change data capture and delete support.

· Customers may continue alternatively to use Oracle BI Apps 7.9.6.x and Informatica ETL.

Regards,

Zafar Habib

Oracle BI Apps 11.1.1.7.1 and Why Fusion is More than just Applications

The arrival of the latest version of Oracle Business Intelligence Applications, namely 11.1.1.7.1 has ignited quite a buzz (and a bit of confusion) in the OBI community.

Fellow bloggers and the Oracle documentation as well as the official data sheet do a good job explaining what the major new features of this milestone release are.

Image source: Oracle data sheet

It is truly worthwhile to spend a few minutes to marvel at the new features:

E-T-L is now E-L-T and done by Oracle Data Integrator, the former Sunopsis product and data integration platform of choice for Oracle customers. Yes, loading the Oracle Business Analysis Warehouse is no longer performed by Informatica which is used in the 7.9.x and previous 11.1.1 product lines (see below).

Of course this raises a few eyebrows especially among customers who intend to upgrade from Informatica-based OBI Apps 7.9.x to the new architecture introduced with 11.1.1.7.1. As Mark Rittman reports, customers will have to migrate existing customizations from Informatica to ODI on their own, or start from scratch with 11.1.1.7.1. Nonetheless both paths (Informatica and ODI) will be supported by Oracle for a while.

Time to say goodbye also for DAC, the Datawarehouse Administration Console which was developed by Siebel Systems. The new tools on the block are Oracle BI Configuration Manager (BICAM) and Functional Setup Manager (FSM).

Mentioning the latter will ring some bells for Oracle applications professionals who spent time with Oracle Fusion Applications recently. Both FSM and BICAM are around since the first release of Fusion Apps which came with - you guess - Oracle BI Applications 11.1.x.

So Oracle has been working a while on OBI Applications 11.1.x and I think it is safe to say that the development of the new general release 11.1.1.7.1 has greatly benefited from the the Fusion Applications development initiatives.

Interestingly, the Oracle BI Apps for Fusion Applications still use Informatica for ETL.

Besides the new ETL E-L-T tool and administrative components like BICAM and FSM, thedata sheet points out the other new features which shall be listed quickly below to make this post complete.

• A new planning application - Indirect Spend Planning - directed at procurement users.
• Student Information Analytics for academic institutions.
• Enhancements in many analytic applications such as HR analytics.
• Optional deployment of Oracle Golden Gate for real-time ETL.
• And, last but not least, a new Data Lineage tool (in a future patch release, thanks to Florian for the update on that).

have a nice day


Regards,
Zafar Habib

OBIEE paths and commands

Hello friends , today I am posting OBIEE paths , log files locations , commands and steps how to manally start OBIEE.

My friend Rahul has provided me this helpful document.

For Download:

Click Here









Thanks,
Zafar Habib

Data Warehousing Ebook

Ebook by Paulraj Ponniah :

Download

                                                                                  

Thanks,
Zafar Habib

Data Warehousing Development Lifecycle

The Data Warehousing Development Lifecycle

Some Important steps must be taken before starting any development.

I have uploaded PDF file , which u can easily downloaded and you can get basics information about Data warehousing Development Lifecycle

Download

Thanks,

Zafar Habib

Informatica - ETL Tool

The Informatica Platform Simplifies Your ETL Processes

Initiate ETL Projects Quickly and Cost-Effectively

Serving as the foundation for all data integration projects, the Informatica Platform lets IT organizations initiate the ETL process from virtually any business system, in any format. As part of the Informatica Platform, Informatica PowerCenter delivers robust yet easy-to-use ETL capabilities that simplify the development and deployment of smaller departmental data marts and data warehouses. In addition, the ETL capabilities facilitate reuse from one project to another.

Enhance ETL with Universal Data Access Capabilities

PowerCenter improves the flexibility of your ETL process with the ability to extract more enterprise data-types than any other technology on the market. Complemented by Informatica PowerExchange and PowerCenter Options, PowerCenter delivers successful ETL initiatives with access to virtually any enterprise data-type, including:

• Structured, unstructured, and semi-structured data
• Relational, mainframe, file, and standards-based data
• Message queue data
• Automate Most ETL Processes for Fewer Errors and Greater Productivity

PowerCenter makes your ETL developers' jobs easier with cross-functional tools, reusable components, and an enterprise-wide platform that automates many ETL processes. For data warehousing and ETL developers, that means fewer ETL errors and emergency fixes, less risk of rework, faster development time, and greater productivity.

Informatica Presentation
Session 1:
Click Here

Session 2:

Click Here

How to practically work in Informatica?

Click Here

Concept of KPI's in OBIEE world

Key performance indicator (KPI) are used as a tool to measure the performance of business set objective against a predefined benchmark like actual budget utilization % of a particular cost center is 95% for a particular month against a desired goal of 90% .So here it is lagging the benchmark by 5%.


As we know that KPI (Key performance Indicator) is used by organizations to measure performance, make strategies and set targets, Oracle OBIEE gives ability to define these performance, strategies and targets within OBIEE envirnment, basically it brings the corporate annual pictures to the desktop.

















Thanks,
Zafar Habib