Blog

by Sharath Venkataranga

The most common question faced by any ETL developer or a Data Warehouse project implementer is always related to performance. Whatever the tool may be, and however fast the job may be running, the end user will always desire something which is a little faster and quicker.

by Keith Mascarenhas

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.

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. 

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.

by Nancy Hamilton

Join me as I will be representing KPI University at KScope 2013, the Oracle Development Tools User Group (ODTUG) Conference, June 23 – 27 in the exciting city of New Orleans.  Register to attend one of our two hands-on BI labs featuring OBIEE 11g Analysis and Dashboards.  See you in New Orleans!

As part of the prestigious honor of being recognized with an Oracle Excellence Award for Specialized Partner of the Year, KPI Partners is mentioned in the most recent printed and online issue of Oracle Magazine.

by Kurt Wolff

It may be strange to be writing this with the intention of posting to a blog, but I thought someone should step back a minute and issue a few words of warning about information that can be found on the web about Oracle BI EE.

Oracle Exalytics was recently launched at Oracle's Open World Event, which was held during October in San Francisco. Despite the numerous of claims of product excellence and testimonies from former clients, guests at the event were largely left wondering about the $100,000+ product.  Since the product was largely unseen, it leaves many clients asking is Oracle's newest BI innovation, the self-described "BI Machine" an absolute necessity?

Several of Oracle's customers who've used the product seem to think so.  A key feature of the project that has been touted by Oracle enthusiasts is the product's ease of deployment. A current client of Oracle and Exalytics enthusiast, Nilson Group, which is based in Sweden, praised the software's ability to update on the back end, without causing any project delays. Allowing the Oracle Business Intelligence Enterprise Edition (OBIEE) to run on the Exalytics software eliminates operations problems that would otherwise be present on other systems.

Another client, Thomas Reuters, praised the new in-memory feature of the program that allowed it to analyze a 10 billion row data set, due to the capacity for in-memory storage. For a customer without Exalytics that attempted this same feat on traditional hardware, it would be impossible.

The main features that have been praised include the 1TB of ram (Oracle claims it can use even more data to its memory management capabilities) and exceptional processing speed, which has been known to remarkably serve up to 10,000 individual program users at once. Despite it's success, Oracle's newest program is not the end-all be-all solution.  No piece of hardware can take the place of the strategical and visonary components that only expert human resources can supply.  

For business owners that are looking to this newest development to solve glitches and memory problems, it looks like there is a solution. However, one must also consider the expertise and strategic vision needed to develop complete solutions customized to an enterprise or industry.

Time will tell if the newest addition to Oracle's high-profile business tools is indeed a must for the BI community.