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

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 is an ODI Knowledge Module (KM)?

Posted by KPI Partners News Team on Mon, Aug 19, 2013 @ 11:15 AM

by Ashok Das

Knowledge Modules (KM), components of Oracle Data Integrator’s Open Connector Technology, are generic, highly specific and reusable code templates which defines the overall data integration process. Each Knowledge Module contains the knowledge required by ODI to perform a specific set of actions or tasks against a specific technology or set of technologies, such as connecting to this technology, extracting data from it, transforming the data, checking it, integrating it, etc.

Read More

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

NYPD Analytics: Fighting Crime With A Business Intelligence Dashboard

Posted by KPI Partners News Team on Wed, Aug 14, 2013 @ 08:39 AM

by Jaime Seagraves

The New York Police Department has developed what they are calling a hi-tech analytical dashboard tool that collects crime and event data around the city. This Domain Awareness System, known as “The Dashboard,” is helping the NYPD combat crime and terror on the streets.

Read More

Tags: Real-Time BI, Case Study, Unstructured Data, Business Intelligence, Video, Jaime Seagraves, Blog