Posts Tagged ‘OBIEE’

« Older Entries

OBIEE 11g – Import Metadata connection problems

Monday, April 16th, 2012 by Robin Harris

While looking at BI Applications 7.9.6.3 on OBIEE 11g we encountered an issue trying to import metadata into an OBIEE repository. As can be seen below the only error you are given is “The connection had failed”!

 Import Metadata Error

We checked that the connection was defined correctly in the tnsnames.ora in the Oracle client installation. This was tested with a tnsping and also connecting via SQL*Plus, etc.

After various searches on the net it was found that OBIEE 11g comes with it’s own copy of the client software, so the solution is to make sure you have a copy of the relevant entry in the tnsnames.ora file under the 11g install.  This will be {Oracle_BI1}\network\admin (e.g. C:\FMW11115\Oracle_BI1\network\admin).

Once the tnsnames.ora file was put into that directory the client tool could connect fine.

Tags: , , ,
Posted in Business Intelligence, OBIEE | No Comments »

Rank function syntax in OBIEE

Tuesday, March 20th, 2012 by Andy Coates

A question came up recently during an OBIEE 10g training course we were running which merits a note on the blog. As part of the training, a request was built that displayed the TopN most expensive projects within an organisation for a specified year. The question posed by a delegate was “how do I display the TopN most expensive projects across a range of years? For example, the top 3 most expensive projects on a year-by-year basis.
Read the rest of this entry »

Tags: , , , , ,
Posted in Business Intelligence, OBIEE | No Comments »

QlikView versus BI Applications and OBIEE

Friday, March 9th, 2012 by Andy Coates

Having worked with Oracle Business Intelligence (BI) products for several years, some colleagues and I recently spent some time evaluating a third party offering called “QlikView”. Whilst our main interest at Projected has always been Oracle’s BI Applications for E-Business Suite, the buzz being generated around QlikView intrigued us. The Oracle BI Applications provide pre-packaged analytics reporting built on OBIEE, so we were keen to see if QlikView was a suitable competitor to BI Applications for our E-Business Suite customers.

Read the rest of this entry »

Tags: , , , , , , ,
Posted in BI Applications, Business Intelligence, OBIEE | 3 Comments »

Installing BI Publisher (10G) Into Weblogic

Tuesday, March 29th, 2011 by Robin Harris

As part of a recent BI Apps project it was required to install BI Publisher (version 10.1.3.4.1).  The OBIEE installation was deployed via WebLogic (10.3) and there where a couple of issue’s along the way, so this entry will cover the installation method I used along with some pointers to solve various issues.

Read the rest of this entry »

Tags: , , , ,
Posted in Business Intelligence, OBIEE | 1 Comment »

OBI Appications 7.9.6.2 released, Project Analytics new features

Wednesday, September 22nd, 2010 by Andy Coates

Version 7.9.6.2 of OBI Applications has recently been released and is available for download from Oracle eDelivery.

Project Analytics sees some updates in the latest release, most notably the introduction of a project commitments subject area. The full list of updates to Project Analytics are:-

  • New Project Commitments Subject Area for Oracle EBS 
  • Updates to Universal Adapter for Oracle Project Analytics 
  • Configuration Update for Project Customer for Oracle EBS 
  • My Oracle Support Technical Note on How to Configure RPD if the Cost Aggregate Grain is Set to Period or Year 
  • New Dimension for Project Budget and Forecast Fact 
  • Linear Spread Metrics for Project Budget Fact

A full summary of the new features across the 7.9.6.2 OBI applications can be found on oracle.com here, with the Project Analytics updates here. No doubt that a number of bug fixes have also been included, as previously alluded to in My Oracle Support.

Tags: , , , ,
Posted in Business Intelligence, OBIEE, Project Analytics | No Comments »

« Older Entries