KPI Partners Blog

Using WITH in Physical Tables ("Opaque Views")

Posted by KPI Partners News Team on Fri, May 24, 2024 @ 02:15 AM

by Kurt Wolff

Common practice is to use derived tables (sometimes referred to as “inline views”) when creating a physical layer “Select” table.

Read More

Tags: Kurt Wolff, Oracle BI, Blog

Evaluate With Date Functions in OBIEE

Posted by KPI Partners News Team on Fri, May 24, 2024 @ 01:56 AM

by Kurt Wolff

If you’re not concerned about database portability – for example, you use Oracle and that’s that, forever – then the evaluate function in OBIEE can be useful. However, using the evaluate function can be tricky, and the documentation could be better.

Read More

Tags: Kurt Wolff, Oracle BI, Blog

Oracle BI Server Connectivity with Tableau (Part 2)

Posted by KPI Partners News Team on Thu, Jan 26, 2017 @ 11:27 AM

by Rushendra Prasad

To read part 1 of this blog post, please click here.

This blog post discusses how to integrate Oracle BI server and make use of the existing Subject Areas built on RPD in Tableau desktop workbook as Data Source.

This is applicable for 8.2, 8.3, 9.0 and later versions.

Read More

Tags: OBIEE, Rushendra Prasad, Tableau, Oracle BI, Blog, Oracle BI Server

Oracle BI Server Connectivity with Tableau (Part 1)

Posted by KPI Partners News Team on Thu, Jan 19, 2017 @ 12:31 PM

by Rushendra Prasad

This blog post discusses how to integrate Oracle BI server and make use of the existing Subject Areas built on RPD in Tableau desktop workbook as Data Source.

This is applicable for 8.2, 8.3, 9.0 and later versions.

Read More

Tags: OBIEE, Rushendra Prasad, Tableau, Oracle BI, Blog, Oracle BI Server

KPI Forms Oracle BI Cloud Services (BICS) Task Force

Posted by KPI Partners News Team on Wed, Nov 05, 2014 @ 01:12 PM

Los Angeles, CA – November 5, 2014. KPI recently announced the launch of an internal expert services team for Oracle BI Cloud Services (BICS) that acts as a specialized advisory group for projects focused on this new technology.  The KPI Partners Oracle BICS Task Force can demonstrate real-world use case scenarios and an accelerated value-driven approach to cloud-based analytics.

Read More

Tags: Cloud Services, Oracle, Business Intelligence, News, Data Integration, Oracle BI, Darren Chilton, Oracle BICS, Blog

17 Key Metrics for Financial Managers

Posted by KPI Partners News Team on Mon, Nov 03, 2014 @ 10:38 AM

by Myles Gilsenan

Financial managers in all industries need to be aware of the health of their organization as well as the health of the processes that enable sound financial management.  In this article, I will outline some basic metrics that can be used to identify and evaluate the health and efficiency of the accounting and finance function as well as the financial health of the organization.

While it is true that specific metrics can vary across industries, in this article we will address metrics and concepts that can be applied across most industries.

The metrics to be discussed will be broken up into the following categories:

Read More

Tags: Financial Analytics, Oracle, Finance, Business Intelligence, Myles Gilsenan, Oracle BI, Performance Management, 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

Cloud Services Are Reaching Maturity - Thoughts from OOW 2014

Posted by KPI Partners News Team on Fri, Oct 24, 2014 @ 10:29 AM

by Myles Gilsenan

I attended Oracle OpenWorld (OOW) 2014 recently with a focus on BI, Big Data and ERP. As usual there was no shortage of information. The Partner briefings were particularly helpful in getting some insight into how Oracle sees the future.  

Read More

Tags: OBIEE, Oracle E-Business Suite, Real-Time BI, Oracle OpenWorld, Cloud Services, EPM, Essbase, Real-Time Supply Chain and Inventory Analytics, Big Data, Data Discovery, Myles Gilsenan, Oracle BI, ERP, Real-Time Financial Analytics, Oracle BICS, Oracle GoldenGate

Oracle BICS and Identity Management – A New Security Architecture

Posted by KPI Partners News Team on Thu, Oct 16, 2014 @ 08:17 AM

 by Shiva Molabanti

Read More

Tags: OBIEE, Cloud Services, Shiva Molabanti, Oracle, Cloud Application Integration, Oracle BI, Oracle BI Applications, Oracle BICS

Treemap Views, Global Variables & Adapting To Oracle BICS From OBIEE 11g

Posted by KPI Partners News Team on Tue, Oct 14, 2014 @ 09:09 AM

by Shiva Molabanti

Oracle Business Intelligence Cloud Service (BICS) - Every organization should carefully evaluate the tool, as well as its potential for end-user adoption.

In today’s technological landscape there’s an ever-accelerating demand for increased efficiency and effectiveness. An organization, before evaluating a new solution, must consider end-user adoption for every technology prior to implementation, particularly when the cost of deployment and training are often driven by the rate of user adoption.  

Read More

Tags: OBIEE, Migrations, Cloud Services, Shiva Molabanti, Oracle, Business Intelligence, Oracle BI, Oracle BICS, Blog