KPI Partners Blog

by Shiva Molabanti

The new Sample App 305 Virtual Box image for OBIEE 11.1.1.7.0 is now available to download from Oracle Technology Network.

Tags: OBIEE, Shiva Molabanti, Essbase, Oracle, Oracle BI, Exalytics

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.

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

by Varun Reddy

Oracle Data Integrator (ODI): Executing A Load Plan

Load Plan 

A Load Plan is an executable object in Oracle Data Integrator that can contain a hierarchy of steps that can be executed conditionally, in parallel or in series. Procedures, interfaces, packages, variables, and can be added to Load Plans for executions in the form of scenarios in a Load Plan.

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

by Jeremiah Johnson

As part of KPI's web series on Examining Oracle BI Applications 11g, this short video provides a brief overview of the new release of the Oracle BI Applications.  Areas of examination for this session include:

Tags: Student Information Analytics, OBIEE, Financial Analytics, Peoplesoft Campus Solutions, Ramesh Ponganti, Project Analytics, Rushendra Prasad, Jeremy Simmons, Srinivasan T, Sharath V, Vlad Valeyev, Prabu Varathaju, Informatica, Video, Myles Gilsenan, Jeremiah Johnson, HR Analytics, Oracle BI Applications, Procurement & Spend Analytics, Examining OBIA 11g, John Whitaker, Oracle Data Integrator (ODI), Fixed Asset Analytics, Indirect Spend Planning, Oracle GoldenGate, Supply Chain and Order Management, Blog

by Keith Mascarenhas

Tags: Keith Mascarenhas, Oracle, Tutorial, Oracle BI, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog

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.

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

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.

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

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. 

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

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.  

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

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.

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