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.

Issue with Direct Database Request in OBIEE

We have an issue with Direct database request while creating a report. The below is the issue.

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 13017] User or group has not been granted the Direct Database Access privilege to access the database ‘YOUR CONNECTION POOL’. Please verify the User/Group Permissions in the Oracle BI Administration Tool. (HY000)

Solution

 In Presentation Services->Settings->Administrations->Manage Privilege" have given permission to "Execute Direct Database Requests"  for user or Group.

AND Mandatory to give an access in RPD.

Open OBIEE Administrative tool click on Manage->security->user or Group
Double click on the user  or group who needs to have the execute direct database request permission.Select "allow" from the drop down list in the query limits block to the respective connection pool.

Hope this will resolve your issue.

Password Change in OBIEE

To change the login password for the OBI application, there are three places where we have to change the passwords.

1. RPD
2. Job Manager
3. Credential Store.xml file

• Initially we have to change the password in RPD

Open the RPD  à go to manage àClick on Security à change the password for user adminstrator as shown below.

• Now go to the Job manager and change the password for the Administrator.

Open Job Manager à Click on Configuration options à In General section change the password for Administrator as shown below.

• In Credential Store, we have to define the login credentials and it can be changed through running the crypto tool or manually changing the password from the below path.

Go to the path \\OracleBIData\web\config\ CredentialStore.xml à Change the password

Once the following changes are done then it is must to restart the services (Presentation service, OBI Server and scheduler).

Now please use the new password to login to the application.

Pivot View Grand total issue from UNION queries in OBIEE

In OBIEE, if the report has to create based on the pivot view using UNION of 2 or more queries then there is possibility of pivot view grand total issue because server will compute and picks up random value shows in the pivot view grand total.

Issue with grand totals before changes.

To overcome issue, Click on the measures column in the pivot view edit and set aggregation rule to “SUM” instead of “default”.

After setting aggregation rule to "SUM" instead of "default" the results in pivot view Grand total calculates exactly as shown below.

Issue with Prefix Zero for a values when downloading a report in excel Format in OBIEE

In OBIEE , Generally we came the issue with the values having prefix Zero for any attribute.For examples, The report contains column called Item codes which have a value like "00715423".So when you download this report in the excel format then the values under the item code will looks like "715423".

Example: The report looks like as shown below.

When we downloads it to excel then the same will looks like below.

Here, we have noticed that values starting with zero causing the problem. Please follow the below steps to overcome this issue.

We have to change the format of this column to text explicitly by adding the code in the Edit formula section.

After adding the above code and now change the data format to HTML.

Now the run the report and extract to excel. The report will looks good with the values having prefix zero.

errors on logical columns for defining measures using absolete method in OBIEE

the scenario where we have errors on logical columns for defining measures using absolete method when we go for RPD consistency check.

To overcome this issue use the following command in the general section of NQSconfig file.

SUPPORT_OBSOLETE_MEASURES=YES;