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.

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.

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.
o \OracleBI1\network\admin (Example: C:\OBI\Oracle_BI1\network\admin)
o \oracle_common\network\admin
o (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)

Earn Income when you are at work

Ways To Make Money On Internet There Are Different Ways To Get Money On Internet But Before

Ways To Make Money On Internet there are different ways to get money on internet but before starting this there are some steps to follow them

1): you need some tools *dedicated credit card for internet. *open free internet banking accounts to receive payment. *an always Online internet connection.

2):programs where you need to invest some money, the risk is greater but reward is
huge. *high yield investment program *paying the foreign exchange market

3):programs where you earn money but free to join *DonkeyMails *Clixsense *MyLot *PetPaidTo *Cashcrate

4):make a website of your own and get advertise on it tips: *right click on login page of each program *write address and login details of each site in the back of
your diary *get in to the habit of regular visits