KPI Partners Blog

A Detailed Explanation of ODI Knowledge Modules LKM & IKM

Posted by KPI Partners News Team on Sat, Sep 14, 2013 @ 12:52 PM

by Ashok Das

Another article in Ashok's series where he examines Oracle Data Integrator (ODI) Knowledge Modules (KM).  For an basic introductory overview, check out 'What is an ODI Knowledge Module (KM)?'

Read More

Tags: OBIEE, Ashok Das, Oracle, Business Intelligence, Tutorial, Oracle BI, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog

Preserve Historical Data in Oracle BI Snapshot Tables

Posted by KPI Partners News Team on Tue, Aug 27, 2013 @ 12:16 PM

by Prabu Varatharaju

What is Snapshot data?

Snapshot data is a copy of business data preserved at some point-in-time. In some cases we may not be able to recover older snapshot data from the current data sets because we need to preserve snapshots at regular (scheduled) intervals for historical analysis.

Read More

Tags: Data Warehousing, Financial Analytics, Oracle E-Business Suite, Prabu Varatharaju, Informatica, Business Intelligence, Tutorial, Oracle BI, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog

Build OBIEE Reports For Impact Analysis & Data Lineage

Posted by KPI Partners News Team on Thu, Aug 22, 2013 @ 11:46 AM

by Shiva Molabanti

"If a column is deleted from a RPD, what reports will be affected?" 

In general every OBIEE Application user/developer needs to know the origin of the data displayed on reports. The general questions that everyone looks for answers to understand their application are:

Read More

Tags: OBIEE, Shiva Molabanti, Data Lineage, Impact Analysis, Oracle, Business Intelligence, Tutorial, Oracle BI, Blog

Choosing the Correct ETL Tool For Oracle BI

Posted by KPI Partners News Team on Tue, Aug 20, 2013 @ 12:02 PM

by Sridhar Kasthuri

A key component to any Business Intelligence (BI) Architecture is the Extract, Translate and Load (ETL) process. The ETL process is typically scheduled on a daily basis and is capable of data movement from legacy systems into a data warehouse. It is also used to facilitate the work of the database administrators who connect different branches of databases as well as integrate or change the existing databases.

Read More

Tags: Data Warehousing, Oracle, Informatica, Business Intelligence, Sridhar Kasthuri, Oracle BI, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog

What's New In Financial Analytics-Budgetary Control? [Examining OBIA 11g: The Series]

Posted by KPI Partners News Team on Thu, Jul 25, 2013 @ 04:39 PM

by Myles Gilsenan

As part of KPI's web series on Examining Oracle BI Applications 11g, Myles Gilsenen examines what is new in the Budgetary Control area Oracle's Financial Analytics 11.1.1.7.1.

Read More

Tags: Financial Analytics, Business Intelligence, Video, Myles Gilsenan, Oracle BI, Oracle BI Applications, Examining OBIA 11g, Fixed Asset Analytics, Blog

What's New In Financial Analytics-Employee Expenses? [Examining OBIA 11g: The Series]

Posted by KPI Partners News Team on Wed, Jul 24, 2013 @ 06:22 PM

by Myles Gilsenan

As part of KPI's web series on Examining Oracle BI Applications 11g, Myles Gilsenen examines what is new in the Employee Expenses area Oracle's Financial Analytics 11.1.1.7.1.

Read More

Tags: Financial Analytics, Business Intelligence, Video, Myles Gilsenan, Oracle BI, Oracle BI Applications, Examining OBIA 11g, Fixed Asset Analytics, Blog

What's New In Financial Analytics-Holds & Discounts? [Examining OBIA 11g: The Series]

Posted by KPI Partners News Team on Mon, Jul 22, 2013 @ 12:25 PM

by Pavan Nanjundaiah

As part of KPI's web series on Examining Oracle BI Applications 11g, Pavan Nanjundaiah examines what is new in Oracle's Financial Analytics as it relates to Holds & Discounts. Areas of discussion include:

Read More

Tags: Financial Analytics, Oracle, Business Intelligence, Video, Oracle BI, Oracle BI Applications, Examining OBIA 11g, Pavan Nanjundaiah, Blog

Oracle Data Integrator Component Architecture

Posted by KPI Partners News Team on Thu, Jul 18, 2013 @ 02:26 PM

by Shiva Molabanti

The Oracle Data Integrator platform integrates into the broader Fusion Middleware platform and becomes a key component of this stack. Oracle Data Integrator provides it's run-time components as Java EE applications, enhanced to fully leverage the capabilities of the Oracle WebLogic Application Server. Oracle Data Integrator components include the FMW exclusive features for Enterprise-Scale Deployments, high availability, scalability, and hardened security. 

Read More

Tags: Shiva Molabanti, Oracle, Tutorial, Oracle BI, Oracle BI Applications, Oracle Data Integrator (ODI), Blog

Using Custom Group, Current View or All Views in OBIEE 11.1.1.7.0

Posted by KPI Partners News Team on Wed, Jul 17, 2013 @ 07:18 AM

by Rushendra Prasad

We can create a "Custom Group" for a "Single View" or "All Views" available in a particluar Oracle Business Intelligence Enterprise Edition (OBIEE) report.

Read More

Tags: OBIEE, Rushendra Prasad, Oracle, Business Intelligence, Tutorial, Oracle BI, Oracle BI Applications, Blog

Generating Oracle BI Apps 11g Data Load Plans

Posted by KPI Partners News Team on Mon, Jul 15, 2013 @ 02:14 PM

by Veera Reddy Ramidi

This blog introduces and explains the detailed step by step process for executing the Data Load to Business Analytics Warehouse. Here, we are illustrating for the Student information Analytics data using the new OBIA 11g which is supported only for PeopleSoft 9.0 Campus Solutions.

Read More

Tags: Student Information Analytics, Data Warehousing, OBIEE, Peoplesoft Campus Solutions, Veera Reddy Ramidi, Oracle, Tutorial, Oracle BI, Oracle BI Applications, Examining OBIA 11g, Peoplesoft, Blog