KPI Partners Blog

Why ODI? A Look Into Oracle Data Integrator Architecture

Posted by KPI Partners News Team on Mon, Jun 03, 2013 @ 07:29 AM

by Varun Reddy

E-L-T vs. E-T-L

Oracle Data Integrator, or ODI, provides a new declarative design approach to defining data transformation and integration processes based on a unique Extract-Load-Transform (ELT) architecture.  The declarative design approach separates the declarative rules from the implementation details. ODI architecture eliminates the need for a standalone ETL (Extract-Transform-Load) server and proprietary engine while leveraging the inherent power of RDBMS engines.

Read More

Tags: Data Warehousing, Training, Varun Reddy, Oracle, Oracle BI, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog

Migrating Financial Statements To Oracle BI Applications

Posted by KPI Partners News Team on Fri, May 31, 2013 @ 07:02 AM

FSG is a report-building tool for Oracle E-Business Suite used for creating financial statements such as the income statement, trial balance, balance sheet, and cash flow statement. FSG reports typically are complex to build, difficult to maintain, and do not provide the modern analytical capabilities that exist with the Oracle Business Intelligence platform.

Read More

Tags: Webinar, Financial Analytics, Pre-Built Solutions, Oracle BI, Oracle BI Applications, Kumar Krishnaswamy, Pavan Nanjundaiah, FSG Reporting for Financial Analytics, Blog

Using The Performance Layer Inside Oracle BI

Posted by KPI Partners News Team on Thu, May 30, 2013 @ 12:40 PM

The BI Apps from Oracle present customers with a nice head start to getting their BI environment up and running. But for many customers, their user community demands lighting-fast speeds while running dashboards, reports and ad-hoc queries. 

Read More

Tags: Data Warehousing, Webinar, OBIEE, Performance Layer, Oracle BI, Oracle BI Applications, Jeff McQuigg, Blog

15 Steps To Configure Oracle BI Apps 11.1.1.7.1

Posted by KPI Partners News Team on Tue, May 28, 2013 @ 02:48 PM

by Ashwin Pujari

With the release of the new version of Oracle's BI Applications, we've published some introductory articles such as 'Under The Hood Of The New Oracle BI Apps' and 'The ALL-NEW Oracle BI Apps... now with ODI (11.1.1.7.1)'.   I thought I would take a deeper look into the steps involved with configuring this new version of the BI Apps.  

Read More

Tags: Vision Workshop, Ashwin Pujari, Oracle, Business Intelligence, Tutorial, Oracle BI, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Indirect Spend Planning, Blog

Multi-Source Session Variables in OBIEE

Posted by KPI Partners News Team on Tue, May 21, 2013 @ 01:44 PM

by Shiva Molabanti

Version 11.1.1.7.0 of Oracle Business Intelligence Enterprise Edition (OBIEE) Supports Multiple-Source Session Variables

In addition to supporting regular session variables that are populated from one data source, Oracle Business Intelligence 11.1.1.7.0 also supports session variables that can be populated from multiple data sources. These multi-source session variables can be used in logical queries or in repository data filters and contain the union of values from the different data sources. There is no restriction on the number of values that the multi-source session variable can hold. To create a multi-source session variable, you first create row-wise initialization blocks for each source.

Read More

Tags: OBIEE, Shiva Molabanti, Business Intelligence, Oracle BI, Blog

Changing the OBIEE Repository Password from the Command Line

Posted by KPI Partners News Team on Wed, May 01, 2013 @ 03:21 PM

by Shiva Molabanti

In OBIEE 11.1.1.7.0 there is new BI Server utility called obieerpdpwdchg to change the RPD password from command line.

Read More

Tags: OBIEE, Shiva Molabanti, Oracle, Oracle BI, Blog

SmartView: An Intelligent Addition To Hyperion & OBIEE

Posted by KPI Partners News Team on Thu, Apr 25, 2013 @ 03:30 PM

by Shiva Molabanti

OBIEE and SmartView integration – A Great Oracle BI / MS-Office Add-in

Oracle Hyperion SmartView for Office Integration.

SmartView is much more powerful than its well-known predecessor, the Hyperion Excel Add-In. It not only connects to Essbase, Hyperion Planning, and now to Oracle BI EE. The Smart View 11.1.2.2 Add-in replaces the Oracle BI Office Add-in as the primary Office application for Oracle BI Foundation. For benefit of the users, both are still available with OBI 11.1.1.7.

Read More

Tags: OBIEE, Shiva Molabanti, MS Office, Oracle, Business Intelligence, Oracle EPM, MS Excel, SmartView, Oracle BI, Hyperion, Blog

[Recording] Extending Oracle BI for Real-Time Analytics

Posted by KPI Partners News Team on Fri, Apr 12, 2013 @ 11:54 AM

Organizations do not have the ability to wait for a data refresh during critical business times like the financial close process & the management of an enterprise's supply chain.  The innovators at KPI Partners have extended the Oracle BI Applications to support real-time analytics.

Read More

Tags: Data Warehousing, Webinar, Sid Goel, OBIEE, Financial Analytics, Pre-Built Solutions, Oracle E-Business Suite, Real-Time BI, Bruce Wroughton, Oracle Discoverer, Real-Time Supply Chain and Inventory Analytics, Oracle, Business Intelligence, Oracle BI, Oracle BI Applications, Kumar Krishnaswamy, Real-Time Financial Analytics, Exalytics, Fixed Asset Analytics, Blog

OBIEE QA/Testing Presentation from the 2013 BIWA Summit

Posted by KPI Partners News Team on Tue, Mar 05, 2013 @ 10:40 AM

by Jeff McQuigg

I thought I’d post my presentation on QA (testing) that I delivered at the BIWA Summit near Oracle HQ in California. The presentation is based off of the recent QA posts I did on my personal blog, with a bit more silly graphics on top of it.  The one take away from the presentation is that some people prefer the term "testing" as opposed to QA.  Good to know.  Anyway, enjoy!

Read More

Tags: Seminar, OBIEE, Endeca, Essbase, Big Data, Oracle, Oracle BI, Jeff McQuigg, BIWA Summit, KScope, Blog

[Recording] Why Integrate OBIEE, Essbase, and Hyperion?

Posted by KPI Partners News Team on Wed, Feb 20, 2013 @ 02:26 PM

While business intelligence (BI) is meant to serve the purpose of managing the analysis of day-to-day transactional activity, enterprise performance management (EPM) is summary analysis that provides forward-thinking predictive and what-if analysis.

Read More

Tags: Webinar, Sid Goel, OBIEE, Case Study, EPM, Essbase, Mark Joslin, Oracle, Business Intelligence, Oracle EPM, Oracle BI, Oracle BI Applications, Hyperion