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)

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’.

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

Case Insensitive search in OBIEE11g

As you all know we had a limitation for case insensitive search for multi-select prompt in OBIEE 10g (Later Oracle released a patch for this).

Now in OBIEE11g you can enable this feature we need to modify instanceconfig.xml and NQSconfig.ini files as shown below:

1. Add the following command in instanceconfig.xml: located in

//instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1

————-

true

——-

Save Instanceconfig.xml file.

2. Open the Nqsconfig.INI located in //instances/instance1/config/OracleBIServerComponent/coreapplication_obis1 and search for CASE_SENSITIVE_CHARACTER_COMPARISON and change this values to OFF as shown below.

CASE_SENSITIVE_CHARACTER_COMPARISON = OFF;

Save NQSconfig.ini file.

3. Restart the OPMN services (All OBIEE services).

Now check the same with multi-select prompt with some string and you should get the values irrespective of case what you have given.

Error Importing Oracle OLAP Cube

I got a problem today when importing an Oracle OLAP cube using the Administration Tool in OBIEE 11g Administration Tool .The error message:

[nQSError: 77005] An invalid parameter was passed to the nQWebIBotAPI.dll. Verify that the Agent configuration is correct.

When you install the client tools it creates a simple version of the server using the same files as the full install. One thing that misses out is a JavaHost ,so it is necessary to point the Admin Tool at a JavaHost running on another machine. To do this I edited:

C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client\oraclebi\orainst\config\OracleBIServerComponent\coreapplication\NQSConfig.INI

In the [JAVAHOST] section I put:

JAVAHOST_HOSTNAME_OR_IP_ADDRESSES = “I.P of BI Server”:9810;

After restarting the Admin Tool I was able to import the cubes as expected.