Showing posts with label Oracle Business Intelligence. Show all posts
Showing posts with label Oracle Business Intelligence. Show all posts

Thursday, 4 February 2016

Configuring evaluate function to work in OBIEE

Configuring evaluate function to work in OBIEE

- For the Evaluate function to work in OBIEE, EVALUATE_SUPPORT_LEVEL must be set to 2 in NQSConfig.INI.

- cd /sid/admin/instances/sid_host/config/OracleBIServerComponent/coreapplication_obis1

- Backup NQSConfig.INI

- Edit NQSConfig.INI file and set EVALUATE_SUPPORT_LEVEL=2, comment out other similar multiple entries in NQSConfig.INI file (if any)

- Restart all services

- Verify the changes

$ cat NQSConfig.INI|grep EVALUATE_SUPPORT_LEVEL
# EVALUATE_SUPPORT_LEVEL:

EVALUATE_SUPPORT_LEVEL = 2;

Related Posts:

OBI 11.1.1.8.1 -  nQSError : 62022 Javahost has not been configured correctly. Please check your configuration in NQSConfig.ini.

[OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 1464]  [nQSError: 93001] Can not load library, oracore11.dll, due to, The specified module could not be found error in OBIEE 11g NQSAdminTool.log file

Oracle Business Intelligence Enterprise Edition Plus Client 11.1.1.7.0 Installation - Oracle BI Client Installer (64-bit) biee_client_install_x64.exe

Applying OBIA 11g: PATCH OBIEE 11.1.1.7.150120 for for Oracle Business Intelligence Enterprise Edition and Exalytics

Wednesday, 13 January 2016

Upgrading Oracle Business Intelligence (BI) Publisher Repository from 10g to 11g

Upgrading Oracle Business Intelligence (BI) Publisher Repository from 10g to 11g


- Shutdown the services

- Backup $MW_HOME/config/domains/bi_domain/config/bipublisher/repository

- Create a new directory - $MW_HOME/newrep with appropriate permissions

- Invoke a VNC session

- Start the Upgrade Assistant 

cd $MW_HOME/fmw/111/oracle_common/bin and run the upgrade assistant 

$ ./ua 





- Select Upgrade Oracle BI Publisher Repository




- Specify Source Details

Select Upgrade 10g BI Publisher Repository Directory

Repository Directory:  $MW_HOME/config/domains/bi_domain/config/bipublisher/repository/






- Specify Destination Details

Destination Repository Directory $MW_HOME/newrep




- Specify WebLogic Server



- Examining Components

Oracle Business Intelligence Publisher component should show status SUCCEEDED.




- Upgrade Summary

Review Source and Destination Repository Directory and Click Upgrade



- Upgrading Components

Monitor the upgrade progress



- Upgrading Components

Upgrade finished. 




- Upgrade Success



- Start the services

- Perform post upgrade verification checks and additional post upgrade steps as necessary.

Related Posts:

Error oracle.xdo.servlet.CreateException:Report definition not found: /Oracle_Fusion_Middleware_Audit/Common_Reports/User_Activities/Event_Details/Event_Details.xdo [username=weblogicbi] when using 11g BI with OAM report in 10g format

OBIEE Patch 18277370 conflicts with Patch 17611288 installed during OBIA 11.1.1.8.1 installation

Oracle Business Intelligence Enterprise Edition Plus Client 11.1.1.7.0 Installation - Oracle BI Client Installer (64-bit) biee_client_install_x64.exe

Applying OBIA 11g: PATCH OBIEE 11.1.1.7.150120 for for Oracle Business Intelligence Enterprise Edition and Exalytics

[OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 1464]  [nQSError: 93001] Can not load library, oracore11.dll, due to, The specified module could not be found error in OBIEE 11g NQSAdminTool.log file

OBI 11.1.1.8.1 -  nQSError : 62022 Javahost has not been configured correctly. Please check your configuration in NQSConfig.ini

Saturday, 1 August 2015

OBI 11.1.1.8.1 - nQSError : 62022 Javahost has not been configured correctly. Please check your configuration in NQSConfig.ini.

OBI 11.1.1.8.1 -  nQSError : 62022 Javahost has not been configured correctly. Please check your configuration in NQSConfig.ini.




If you see the error message as above, check the configurations in NQSConfig.ini file under 

/sid/admin/instances/sid_mthost/config/OracleBIServerComponent/coreapplication_obis1 

Possibly JAVAHOST entry is missing in the file NQSConfig.ini. Add this entry with correct value and verify if you still see this error.

If the issue persists, try reinstalling the BI Admin Tool and configure the JAVAHOST entry in the NQSConfig.ini file. nQSError : 62022 should no longer be seen.

Related Posts:


Oracle Business Intelligence Enterprise Edition Plus Client 11.1.1.7.0 Installation - Oracle BI Client Installer (64-bit) biee_client_install_x64.exe

Applying OBIA 11g: PATCH OBIEE 11.1.1.7.150120 for for Oracle Business Intelligence Enterprise Edition and Exalytics

[OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 1464]  [nQSError: 93001] Can not load library, oracore11.dll, due to, The specified module could not be found error in OBIEE 11g NQSAdminTool.log file

Upgrading Oracle Business Intelligence (BI) Publisher Repository from 10g to 11g

Thursday, 17 July 2014

OBIEE 11.1.1.7.140715 Bundle Patch Released

OBIEE 11.1.1.7.140715  Bundle Patch Released


Oracle Business Intelligence Enterprise Edition - OBIEE 11.1.1.7.140715 Suite Bundle Patch on July 15, 2014.

• OBIEE 11.1.1.7.140715 suite bundle patch 18818588 is a single patch that contains all eight component patches. 

o Oracle Business Intelligence Installer (BIINST)
o Oracle Real Time Decisions (RTD)
o Oracle Business Intelligence Publisher (BIP)
o Oracle Business Intelligence ADF Components (BIADFCOMPS)
o Enterprise Performance Management Components Installed from BI Installer (BIFNDNEPM)
o Oracle Business Intelligence: (BIFNDN)
o Oracle Business Intelligence: (BISERVER): 
o Oracle Business Intelligence Platform Client Installers and MapViewer



• The OBIEE 11.1.1.7.140715 suite bundle patch includes more than 52 BISERVER, BIFNDN and BIP bugs fixes since the last suite bundle patch released in May 2014.

Tuesday, 25 March 2014

Unable to download or Export Images to Excel 2007 or PDF Formats in Oracle Business Intelligence 11g (OBIEE)

Unable to download or Export Images to Excel 2007 or PDF Formats in Oracle Business Intelligence 11g (OBIEE)

Unable to download / export images to Excel 2007 (+) format using the new feature in Oracle Business Intelligence 11.1.1.7.x ?

You can download / export everything else except images to Excel 2007.


Images can be downloaded / exported to Excel 2003 format though in OBIEE 11g. 

This feature is not available in OBIEE 11g as of now.