KPI Partners Blog

Using Level-Based Measures in OBIEE

Posted by KPI Partners News Team on Mon, Oct 27, 2014 @ 10:15 AM

by Naresh Meda

What Is A Level-Based Measure?

A level-based measure is a column whose values are always calculated to a specific level of aggregation. Here is an example of a level-based measure using a Products and Revenue table.  A level-based hierarchy is created for Products as follows:
                                                           
 
By default, when we drill down within the products hierarchy from Brand level to Product level, the corresponding Revenue drills down to Product level.

Read More

Tags: OBIEE, Data Discovery, Business Intelligence, Tutorial, Naresh Meda, Oracle BI, Blog

Seamless Reporting With Endeca & OBIEE: Make Them Work Together

Posted by KPI Partners News Team on Mon, Sep 08, 2014 @ 10:38 AM

by Madan Thota

Endeca Information Discovery (EID) is a data discovery tool that helps business analysts to rapidly explore relevant data.  If you are already using Oracle Business Intelligence Enterprise Edition (OBIEE) and wish to reuse the BI data models from Endeca Information Discovery, here are the options.  The primary difference between both tools is that one is used for pre-defined analytics while the other is used for having a conversation with your data (analytics vs information discovery).  The overall goal for both approaches is to get the most value out of the data available.   

Read More

Tags: OBIEE, Endeca, Data Discovery, Business Intelligence, Tutorial, Oracle BI, Blog

Free OBIEE Cache Purge/Seed Utility

Posted by KPI Partners News Team on Wed, Aug 20, 2014 @ 02:10 PM

by Shiva Molabanti

To see reports with the most up-to-date data from the latest extract-transform-load (ETL) process, we typically purge the Oracle BI Server Cache using a common job called, "Cache Purge."

Read More

Tags: OBIEE, Pre-Built Solutions, Shiva Molabanti, Cache, Business Intelligence, Tutorial, ETL, Oracle BI, Oracle BI Applications, Blog

Tableau: Trusted Authentication & Integration with OBIEE

Posted by KPI Partners News Team on Wed, Jun 04, 2014 @ 10:11 AM
Read More

Tags: OBIEE, Imtiyaz Basha, Data Discovery, Oracle, Business Intelligence, Tutorial, Tableau, Oracle BI, Oracle BI Applications, Blog

9 Steps To Upgrade A Oracle Data Integrator Repository (11g to 12c)

Posted by KPI Partners News Team on Tue, May 13, 2014 @ 11:20 AM

by Raviteja Santosh

Upgrading A Oracle Data Integrator (ODI) Repository from ODI 11g to ODI 12c

Migrating Oracle Data Integrator (ODI) from version 11g to 12c is not straight forward as exporting and importing it into a new repository.   An administrator needs to upgrade the 11g version of the repository to the 12c version so the new features can be incorporated into into the code.

Read More

Tags: ODI, Raviteja Santosh, Cloud Services, Tutorial, Data Integration, Examining OBIA 11g, Oracle Data Integrator (ODI)

OBIEE & Microsoft SQL Server Analysis Services

Posted by KPI Partners News Team on Wed, May 07, 2014 @ 11:10 AM

by Suman Busireddy

Oracle Business Intelligence Enterprise Edition (OBIEE) 11g provides multi-dimensional navigation/analysis support.  This multi-dimensional feature is supported for almost any data source including Microsoft SQL Server Analysis Services (SASS).  For Microsoft SQL Server Analysis Services 2008/2012, we need to make an initial configuration before getting started with OBIEE.

Read More

Tags: OBIEE, Microsoft, Suman Reddy, SQL Server, XML, Business Intelligence, Tutorial, Oracle BI, Blog

Tableau Subscriptions - A Quick Start Guide

Posted by KPI Partners News Team on Thu, May 01, 2014 @ 12:46 PM

by Imtiyaz Basha

Learn How To Configure, Monitor, and Subscribe To Reports, Views and Workbooks Inside Tableau.

Tableau Subscriptions

The Subscriptions feature is considered to be one among the most important features in Tableau's interactive data visualization product.  It is by far the easiest way to ensure that you review the most critical and valuable information on a regular basis. The information is shared via email once you have subscribed to a dashboard. The subscription feature is available from Tableau version 8.0 onwards.

Read More

Tags: Imtiyaz Basha, Business Intelligence, Tutorial, Tableau, Blog

Understanding The Informatica MD5 Function

Posted by KPI Partners News Team on Fri, Apr 25, 2014 @ 03:52 PM

by S. K. Purushotham

This article will help you understand the importance of the MD5 function in Informatica. It will also help you answer questions like:

Read More

Tags: Data Warehousing, Informatica, Tutorial, ETL, SK Purushotham, Data Integration, Blog

The Oracle Data Integrator 12C Standalone Collocated Agent

Posted by KPI Partners News Team on Thu, Apr 10, 2014 @ 10:42 PM

by Raviteja Santosh

The Standalone Collocated Agent comes as additional feature with Oracle Data Integrator (ODI)  12C, which is the blend of both standalone and Java Platform Enterprise Edition (Java EE) agents in ODI 12C.  This can be configured only with an ODI 12C Enterprise Edition Installation.

Read More

Tags: ODI, Raviteja Santosh, Oracle, Tutorial, Data Integration, Oracle Data Integrator (ODI), Blog

Getting Familiar With Oracle's BIACM & FSM

Posted by KPI Partners News Team on Wed, Apr 02, 2014 @ 08:44 AM

by Ashwin Pujari

Oracle Business Intelligence Applications 11g : Getting familiar With Oracle's Business Intelligence Applications Configuration Manager (BIACM) & Functional Set-Up Manager (FSM)

Once the BIAPPS installation is completed, the newly introduced web-based JAVA applications, BI Configuration Manager (BIACM) and Functional Set-up Manager (FSM), are available for administrators to complete the set-up related tasks. As it is a new product, the first thing that most do is, run through the oracle documentation, discuss with experts and fellow colleagues, take part in Oracle webinars etc.  After that, we still land up with a long list of new terminologies and jargon.

Read More

Tags: Data Warehousing, ODI, Ashwin Pujari, BIACM, FSM, Oracle, Tutorial, ETL, Data Integration, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog