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.

Deploying RPD and Catalog using Enterprise Manger- OBIEE 11G

Publishing a repository enables the Oracle BI Server to load the repository into memory upon start-up and makes the repository available for queries.

When you upload a repository file for publishing, you provide the name and location of the repository to upload and the current repository password.

The published repository is available to all Oracle BI Server clients, not just to Oracle BI Presentation Services

Publish repository in distributed mode or shared mode:

· In distributed mode, each Oracle BI Server instance loads the repository from its default local directory. Repositories uploaded through Fusion Middleware Control are uploaded to each default local directory. Any changes made to the repository using the Administration Tool affect only the Oracle BI Server component that is associated with the changed repository file.

· In shared mode, each Oracle BI Server instance loads the repository from the shared network location designated as the repository publishing directory. Note that repositories uploaded through Fusion Middleware Control are uploaded to both the shared location and the default local directory for each Oracle BI Server. You typically publish the repository in shared mode when you have multiple Oracle BI Server components in your deployment.

Like the Oracle BI repository, the Oracle BI Presentation Catalog can be published in shared mode, or distributed mode. Each Presentation Services instance loads the Oracle BI Presentation Catalog from the catalog location specified in Fusion Middleware Control.

Login to Fusion Middle ware Enterprise console (http://localhost:7001/em) go to Business Intelligence overview page and click on Deployment

Click on Lock and Edit configuration to release the lock

You can see your rpd name next to the Default RPD : your_rpd_name,if you want to deploy a Shared Repository click on Shared Repository( shared mode)

For distributed mode you need to upload the rpd by clicking on "Browse" button and give the

respective credentials(password)

Next, give the catalog location of Presentation Service for repository.

Click on "Activate Changes" which will save the changes and restart all BI services.

Open the rpd in online mode or check the NQSConfig.ini and instanceconfig.xml file for the newly updated rpd and catalog folders.