Cannot load library, oracore11.dll, The specified module could not be found error in OBI admin tool

Error while checking global consistency in OBI 11g;
Cannot load library, oracore11.dll, The specified module could not be found error in OBI admin tool

This issue is because of the library file that has missed during the installation of oracle client or you have set the path environment variable manually to locate this file from the Oracle database installation location.

• If the oracle database 11g or oracle database client, are not installed on the local machine. If the above are NOT installed then by installing oracle database will take care of the issue that automatically add to a path in bin folder.

If oracle database is installed and the issue is still persists. Please do the following!!

• Before proceeding, take back up of the bi_init.bat file located under the %ORACLE_HOME%\bifoundation\server\bin and edit and delete %PATH% and replace the oracore11.dll file location path manually (If oracle 10g database installed then oracore10.dll location path has to give and depends on the oracle database version installed) and save the file.

Custom images in OBIEE

OBIEE 10g Path:

In OBIEE 10g the custom images has to be placed in two places.

If you want show any of your custom images then you have to add the images into the below mentioned paths and can used the same images with fmap syntax.

1.C:\OracleBI\oc4j_bi\j2ee\home\applications\analytics\analytics\res\s_oracle10\  

   images

     (and)

2. C:\OracleBI\web\app\res\s_oracle10\images

OBIEE 11g Path:

If you want to show any of your custom image then you have to add the images into the below mentioned paths and can use the same images with fmap syntax.

1. C:\OBIEE11g\Oracle_BI1\bifoundation\web\app\res\s_blafp\images

      (and)

2. C:\OBIEE11g\user_projects\domains\bifoundation_domain\servers\bi_server1\   

    tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\s_blafp\images

To add New Font in OBI Answers 10g

To introduce the new font in OBI, Please edit the commonuitemplates.xml file and add the required font as below codes in this location (\\OracleBI\web\msgdb\messages)

Eg: <option value="Calibri">Calibri</option>

After the modification, please restart all the services to take place the changes.

OBI High Level 11g Architecture

Weblogic console

The Admin Server consists of a J2EE "Admin Console" application which is WebLogic's UI for Providing management functions across the WebLogic domin.

http://localhost:7001/console

WebLogic  Console is used for:

• ·         Deploying J2EE application components
• ·         Start/Restart/Stop of WebLogic Managed Servers
• ·         Start/Restart/Stop of J2EE Deployments
• ·         Diagnostics for J2EE Components
• ·         Configuration of Authentication/Authorization (Users&Groups)

Enterprise Manger

Enterprise Manager provides System Management and monitoring capability across the whole Oracle BI domain.

http://localhost:7001/em

Enterprise Manger is used for:

• ·         Monitoring and troubleshooting all WebLogic and BI System Components
• ·         Start/Restart/Stop of BI System Components
• ·         Deployment of RPD and Presentation Catalog
• ·         Setting a Sub-set of NQSconfig.ini and instanceconfig.xml parameters
• ·         Configuration of BI Delivers scheduler
• ·         Capacity of BI Delivers scheduler
• ·         Capacity Management
• ·         Diagnostics
•         Configuration of Application Roles/Policies

Managed Server

It contains deployed J2EE application components.

A WebLogic Domain can have multiple Managed Servers, each of which can run on a different machine.

Action Service : Services "Action Framework" requests.

BI Office: Integration with MS Excel / Powerpoint via the BI Office plug-in

BI Publisher: The BI Publisher application

Web Services SOA:  Services web service request for OBIEE.

BI Plugin: The main Oracle BI application component (/analytics)

Security: For Servicing OBIEE Security requests

Node Manager

A daemon process that provides remote start,stop,restart and monitoring capabilities for WebLogic process. Each machine running WebLogic will have one (and only one) Node Manager process.

OPMN "Oracle Process Manager Network" component responsible for remote start, stop, ping of System Components. OPMN can be controlled from the command line or via Entriprise Manager. OPMN is required on every OBIEE machine.

OPMN (Oracle Process Manager and Notification Server)

Oracle Process Manager and Notification Server (OPMN), which is used for process Start/Stop/restart and it can be used for process recovery.

• It can be managed via Enterprise Manger

         

• It can be managed through the command line and it can be located in the following path.

      [Oracle Home]/instances/instance1/bin/opmnctl.bat

Starting or Stopping all processes or services from the command line

• Checking the current status of all managed services

[Oracle Home]/instances/instance1/bin>opmnctl status

• To start all the services

[Oracle Home]/instances/instance1/bin>opmnctl startall

• To stop all the services

[Oracle Home]/instances/instance1/bin>opmnctl stopall

Start/Stop/Restart the individual process or service from the command line

• To start individual service

[Oracle Home]/instances/instance1/bin>opmnctl startproc  ias-component=coreapplication_obis1

• To Stop individual Service use the below command

Opmnctl stopproc 

• To restart individual service use the below command

Opmnctl restartproc 

Start/Stop/Restart the individual process or service from the Enterprise Manager

Using Custom Format in OBIEE Answers

The report requirement is show (+) Character if the value is positive and (-) character if the value is negative and Values to be shown as "$425 K"

To achieve this format in OBI answers, we have to manually change the custom format in column properties to show the results in desired format as shown below.

"+" #,##0;"-" #,##0
$#,##0 K

Result:

To avoid blank spaces or Null Values in Pivot table view, use below format in custom format section.


#,##0;-#,##0;0

column name has Leading or Trailing spaces in it

Error :[39015]

The name @1%s has leading or trailing space(s) in it.

Cause. The name has leading or trailing space(s).

Response. Remove the leading or trailing space(s) using the Administration Tool.

Error: [39016]

The alias "@1%s" of @2%s has leading or trailing space(s) in it.

Cause. The alias has leading or trailing space(s).

Response. Remove the leading or trailing space(s) using the Administration Tool.

The above errors, causes and responses are provided in Oracle Bookshelf. 

To resolve your issue, remove extra spaces after the column names.