OBIEE 11g

Here, There and Everywhere: Oracle Business Intelligence On The Go

Author: Timothy Simkiss Date: January 25th, 2013
Categories: Oracle Business Intelligence

I am a self-proclaimed Beatles nut, as well an Oracle Business Intelligence and Mobile technology enthusiast. Believe it or not, these qualities aren’t necessarily mutually exclusive. Not anymore. When I think about the availability of Oracle Business Intelligence metrics, dashboards and reports on the go, I am often reminded of the great Beatles Song, Here, There and Everywhere. In today’s fast paced environment, managers need the latest information, access to reports, updates on customers and clients and the ability to see key performance metrics on a daily basis. The need to react to critical information almost instantaneously is the biggest change in the business world in the past ten years.  

» Read More

Operating Room Business Intelligence, Lessons Learned from Manufacturing Companies

Author: Stephen Goldsmith Date: October 22nd, 2012
Categories: Oracle Business Intelligence

With continued mounting pressures to reduce healthcare costs, healthcare providers can leverage the lessons learned in the 90’s by the world’s leading manufacturing companies. This blog is the first in a series of blogs that will discuss how healthcare organizations can employ manufacturing best practices to reduce costs, increase efficiency and improve patient satisfaction. Given that this is a business intelligence blog, the focus will be on how existing data can be transformed into information to achieve the aforementioned healthcare objectives. 

» Read More

OBIEE 11.1.1.6.2 issues

Author: Stephen Goldsmith Date: October 22nd, 2012
Categories: Oracle Business Intelligence

11.1.1.6.2 BP1 Upgrade

The latest bundle patch set has been available for OBIEE for a few months now.  We have noticed an issue where the SQL generated by the RPD is different after the Patch set is applied.

Issue

The new SQL generated by the .RPD file aggregates data incorrectly.  For example, I created a report based off of one column in a fact table.  The SQL that was correctly generated in 11.1.1.6.0 is as follows:

WITH
SAWITH0 AS (select distinct T185463.COLL as c1
from
CC_FINANCIAL_DETAIL T185463 /* Fact Financial Detail */ )
select distinct 0 as c1,
D1.c1 as c2
from
SAWITH0 D1
order by c2

This is what you would expect.  A distinct listing of 1 column.  However, after upgrading the instance to 11.1.1.6.2 BP1, this is the sql that is generated:

WITH
SAWITH0 AS (select T185463.COLL_GROUP as c1
from
CC_COUNTS_ALL T171648 /* Fact Counts All */ ,
CC_COUNTS_DETAIL T171654 /* Fact Counts Detail */ ,
CC_FINANCIAL_DETAIL T185463 /* Fact Financials Detail */
WHERE ( T171648.GRP_ID = T171654.GRP_ID AND T171654.COLL = T185463.COLL AND T171654.GRP_ID= T185463.GRP_ID) )
select 0 as c1,
D1.c1 as c2
from
SAWITH0 D1
order by c2

This doesn’t make much sense.  There are a few things wrong with this query, but the most obvious is the lack of a distinct clause.  With more complex answers based off of the business model, you start to see that all of the aggregation is incorrect.  The upgraded RPD is issuing Cartesian joins in many cases.

Here is the solution

Solution

1)      Take a copy of the 11.1.1.6.0 .RPD file.

2)      Open the 11.1.1.6.2 version of the Admin tool

3)      Open the 11.1.1.6.0 version of the .RPD file with the 11.1.1.6.2 version of the Admin tool.

4)      Save the .RPD file and upload it.

Note that opening a copy of the .RPD file from the upgraded (11.1.1.6.2) OBIEE server will not work.  The version of that RPD is already 11.1.1.6.2, so the 11.1.1.6.2 Admin tool will not “upgrade” it to the current version.  You need to use the 11.1.1.6.0 RPD.

Blog author: Brian Makarewicz

Brain is a contributing blog author on the Business Intelligence Practice team at BizTech.

Setting up iBots in OBIEE 11 g

Author: Stephen Goldsmith Date: October 3rd, 2012
Categories: Oracle Business Intelligence

This post explains how to setup ibots in OBIEE 11g. In this case, the ibot setup was done by the weblogic OBIEE administrator. ibots are received by the end user and the end user login is integrated to OBIEE 11g from EBS. The limitation on this setup is that the end user can’t create iBots and send it to another user. Only weblogic administrator can login to OBIEE directly and create the ibots. 

» Read More

Using Presentation Variables to Dynamically Configure Aging Buckets at Runtime

Author: Stephen Goldsmith Date: September 24th, 2012
Categories: Oracle Business Intelligence

I came across a requirement where a client wanted to see specific records that had end dates before 30, 60, or 90 days from now. In other words the client wanted to dynamically change the date range to include records with a date less than Today’s Date + (30,60,90 days). 

» Read More

Why OBIA Financial Statements Cannot be extended through ETL Enhancements

Author: Stephen Goldsmith Date: September 17th, 2012
Categories: Oracle Business Intelligence

Why it’s not possible to modify a P&L statement just through the OBIA csv files? We recently ran into an issue that most clients who use OBIA Financials encounter. We want to show two revenue line items on the BI apps prebuilt P&L dashboard (for example: Line of business #1 Revenue and Line of business #2 Revenue). The account group names from file_group_acct_names partially determine what shows up on the balance sheet and income statement.  

» Read More

How to Extend OBIA Financial Statements

Author: Stephen Goldsmith Date: September 10th, 2012
Categories: Oracle Business Intelligence

Completing these 3-configuration steps provides a great foundation for extending the Financial Statements of an OBIA Financials installation. By following the steps outlined, any additional custom items needed for your Financial Statements can be created in this same manner.  

» Read More

Oracle’s Business Analytics Strategy

Author: Stephen Goldsmith Date: April 11th, 2012
Categories: Oracle Business Intelligence

Recently Mark Hurd, Oracle President and Balaji Yelamanchili, Oracle Senior Vice President, Analytics and Performance Management, unveiled the latest advances in Oracle’s strategy for analytics. The webcast focused on the latest developments in business intelligence technology and applications, advanced analytics, performance management applications, and engineered systems 

» Read More

Workaround for OBIEE 11g and Firefox 10

Author: Stephen Goldsmith Date: February 26th, 2012
Categories: Oracle Business Intelligence

If you are reading this blog, you are probably like me in that you downloaded a 10.x update to Firefox and found that OBIEE no longer works. Here is a quick and dirty workaround until Oracle is ready with a patch: 1. type "about:config" into an address bar 2. right click anywhere and choose New / String 3. name it "general.useragent.override" 4. put the value "Mozilla/5.0 (Windows; Windows NT 6.1; rv:10.0)Gecko/20100101 Firefox/9.0" 5. refresh OBIEE login screen 

» Read More

OBI 11g version 11.1.1.6 Release is Generally Available

Author: Stephen Goldsmith Date: February 26th, 2012
Categories: Oracle Business Intelligence

The latest release of Oracle Business Intelligence 11g, 11.1.1.6 is now downloadable from OTN for Windows, Linux, Solaris, and AIX  

» Read More