Connection failed while Importing Tables using Admin Tool in OBIEE 11g

Got the “The connection has failed” error while trying to import database tables into repository (.rpd) using OCI call interface.

Solution:

1. Copy the tnsnames.ora from Oracle Database home (ORACLE_HOME\NETWORK\ADMIN\) to the following locations.
• \OracleBI1\network\admin (Example: C:\OBI\Oracle_BI1\network\admin)
• \oracle_common\network\admin
• (Example: C:\OBI\oracle_common\network\admin)

2. Set the TNS_ADMIN environment variable value with one of the copied locations in the step 1 in user.cmd or user.sh file depending on your OS.

This file will be found under \instances\instance1\bifoundation\OracleBIApplication\coreapplication\setup

(Example : C:\OBI\instances\instance2\bifoundation\OracleBIApplication\coreapplication\setup)

How to Disable Presentation cache in OBIEE11g

To turn off the Presentation Services Catalog Attribute Cache in OBIEE 11g. We need to set the following tags in the instanceconfig.xml file:

false

Conversion of Timestamp to date and vice-versa in Answers.

Conversion of Timestamp to date and vice-versa in Answers.

In Criteria ..on the column click on EDIT FORMULA

Change the formula as shown…

Formula : CAST (CAST (expression as CHAR (20)) as TIMESTAMP)

Click on ‘OK’.