KPI Partners 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

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

OBIA 11g Domain Load to Business Analytics Warehouse

Posted by KPI Partners News Team on Thu, Jul 11, 2013 @ 02:05 PM

by Veera Reddy Ramidi

This blog introduces and explains the detailed step by step process for executing the Domain 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. This blog can be used similarly for any other Analytics using OBIA 11g.

Read More

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

New Features for Oracle BI Mobile – OBIEE 11.1.1.7.0

Posted by KPI Partners News Team on Wed, Jul 10, 2013 @ 01:12 PM

by Rushendra Prasad

With this release, we can download a complete new Oracle Mobile BI HD application from the Apple App Store. This release provides end-user enhancements in the following areas:

Read More

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

Performance Tuning Oracle Data Integrator (ODI)

Posted by KPI Partners News Team on Fri, Jun 28, 2013 @ 10:40 PM

by Sharath Venkataranga

The most common question faced by any ETL developer or a Data Warehouse project implementer is always related to performance. Whatever the tool may be, and however fast the job may be running, the end user will always desire something which is a little faster and quicker.

Read More

Tags: Data Warehousing, Training, Sharath Venkataranga, Business Intelligence, Tutorial, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog

Creating Custom Print Layouts in OBIEE 11.1.1.7.0

Posted by KPI Partners News Team on Wed, Jun 26, 2013 @ 01:06 PM

by Rushendra Prasad

We can create Custom Print Layouts for high-fidelity printing of dashboard pages.  Custom Print Layouts allow your end users to produce high-quality printed dashboard content.

When you create a custom print layout, the dashboard page is exported to BI Publisher and the following items are generated automatically:

Read More

Tags: OBIEE, BI Publisher, Rushendra Prasad, Oracle, Tutorial, Oracle BI, Blog

OBIA: Working with "Patches" in DAC 11.1.1.6

Posted by KPI Partners News Team on Tue, Jun 18, 2013 @ 04:44 PM

by Raviteja Mamillapalli

The Use of "Patches"

A traditional Oracle BI Applications implementation involves customizations which require changes in Data Warehouse Administration Console (DAC) metadata objects like Tasks, Tables, Indices, Subject Areas, etc.

Read More

Tags: Data Warehousing, DAC, Raviteja Mamillapalli, Oracle, Tutorial, Oracle BI, Oracle BI Applications, Blog