OBIEE10G & 11G Knowledge Sharing

Stopping and Starting OBIEE Services in linux

STOP OBIEE Services:

1. Shutdown OPMN Components

Oracle Process Manager should be used to shutdown all system components.

Go to> /u01/app/Middleware/instances/instance1/bin

cd /u01/app/Middleware/instances/instance1/bin

./opmnctl stopall

2.Shutdown Managed Server

Go to > /u01/app/Middleware/user_projects/domains/bifoundation_domain/bin

cd /u01/app/Middleware/user_projects/domains/bifoundation_domain/bin

./stopManagedWebLogic.sh bi_server1 t3://obie.new.com:7001 weblogic weblogic

Verify that the Managed Server has shut down completely with ps -ef | grep bi_server1.

3. Shutdown Node Manager

There should be a single Node Manager for the machine. Shut it down with the command below.

ps -ef | grep Node | grep nodemanager | grep -v grep | cut -c10-15

kill -9 ####

4. Shutdown Admin Server

There should be a single Node Manager for the machine. Shut it down with the command below.

Go to> /u01/app/Middleware/user_projects/domains/bifoundation_domain/bin

./stopWebLogic.sh weblogic weblogic t3://obie.new.com:7001

Verify that the Managed Server has shut down completely with ps -ef | grep AdminServer.

START OBIEE SERVICES:

1. Start Admin Server

cd /u01pt/app/Middleware/user_projects/domains/bifoundation_domain/bin

weblogic ./startWebLogic.sh -Dweblogic.management.username= weblogic Dweblogic.management.password=weblogic

tail -f weblogic.out

Weblogic.out is log file which logs the running status

After issuing the start command we tail the log until we see the message below, indicating that the server has started successfully.

StartNode Manager

cd /u01/app/Middleware/wlserver_10.3/server/bin

nodemanager ./startNodeManager.sh > nodemanager.out &

tail -f nodemanager.out

nodemanager.out is log file which logs the running status

After issuing the start command we tail the log until we see the message below, indicating that the server has started successfully.

3. Start Managed Server

By default there should be one managed server, bi_server1 that we will start up. At this point you should start any other Managed Servers in this WebLogic domain.

cd /u01/app/Middleware/wlserver_10.3/common/bin

./commEnv.sh

cd / u01/app/Middleware /user_projects/domains/bifoundation_domain/bin

./setDomainEnv.sh

weblogic ./startManagedWebLogic.sh bi_server1 t3://machine:7001 > bis1_startup.log &

tail weblogic.out

Weblogic.out is log file which logs the running status

After issuing the start command we tail the log until we see the message below, indicating that the server has started successfully. Server started in RUNNING mode

4. Startup OPMN Components

Oracle Process Manager should be used to shutdown all system components.

cd /u01/app/Middleware/instances/instance1/bin

./opmnctl startall

./opmnctl status

Now you can login to console and verify the status of the running servers.

Hope it Helps !!

Thanks,

Shanmugha Bharathy G B

Downgrading OBIEE RPD from 11.1.1.6 to 11.1.1.5 Version

"Downgrading OBIEE RPD from 11.1.1.6 to 11.1.1.5 Version"

Repository downgrade utility nqgenoldverrpd.exe is used to downgrade OBIEE RPD versions.
This utility was present in the 10.1.3.2.1 version of OBIEE but was removed in the later releases.

Note:

Using this Utility you cannot downgrade the RPD from 11g to 10g version. You can downgrade from one version to another 11g Versions.

Physical location of the nqgenoldverrpd.exe file will be
1 ) If you are using Admin tool on your system , the directory path will be

<BI_HOME>\bifoundation\server\bin

2) If you are using Admin client, the directory path will be

C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client11.1.1.6\oraclebi\orahome\bifoundation\server\bin

Downgrading:

1. Goto>StartMenu>All Programs>Oracle Business Intelligence Enterprise Edition
2. Select BI Command Prompt
3. Syntax for Downgrading
nqgenoldverrpd [-P repository_password] -I input_repository_pathname –O
output_repository_pathname -V version
-P: your RPD password
-I: Repository path and name
-O: Repository path and new name of the rep you want to name for the downgraded version
-V: To which version you want to downgrade.
You can only generate repository of version 302 to 318 [ 318 being 11.1.1.6 Version].

Downgrading Process:
1. Copy the 11.1.1.6 RPD to a location you want to ( Here I copied the file to C drive)

2. Now go to Run > Cmd and type the downgrade command as follows and hit enter

3. After hitting Enter on successful downgrade completion you will get the below screen.

Hope It Helps!!

Thanks,
Shanmugha Bharathy G B

Custom Login pages,Images and Logos in OBIEE11G

Custom Login pages,Images and Logos in OBIEE11G

1. Create a custom image in the standard size and keep in the following paths and restart the services .

Drive:\Middleware\Oracle_BI1\bifoundation\web\app\res\sk_blafp\login
Drive:\Middleware\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\.appmergegen_1316154755380\analytics.ear\ukjjdc\res\sk_blafp\b_mozilla_4
Drive:\Middleware\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\.appmergegen_1316154755380\analytics.ear\ukjjdc\res\sk_blafp\login
Drive:\Middleware\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\sk_blafp\b_mozilla_4
Drive:\Middleware\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\sk_blafp\login

.appmergegen_1316154755380 this folder number may vary from from one server to another and if this folder is not present also dont worry let the image be replaced at rest of the folders and restart the services.

PATCH UPDATE (USERNAME/PASSWORD) ISSUE FACED FROM 11.1.1.6.0 TO 11.1.1.6.12

PATCH UPDATE (USERNAME/PASSWORD) ISSUE FACED FROM 11.1.1.6.0 TO 11.1.1.6.12

Hi,

Recently we updated our OBIEE version from 11.1.1.6.0 to 11.1.1.6.12.
In 11.1.1.6.0 chrome was not working properly. Issues faced like catalog not opening and only loading symbol appears for long time.

So we planned for patch update.
After patch update we dont find any issues which we faced earlier.
But during patch update automatically username and password has been changed by default.
For this we have to update username and password manually in two areas.
You will be getting Error cause : Error retrieving user/group data from Oracle BI Server's User Population API.
Solution :
Make sure have same password at the below
in Oracle Weblogic Server : Console / Home >Summary of Security Realms > myrealm > Users and Groups > BISystemUser
AND
in EM, weblogic domain > bifoundation_domain > Security > Credentials > oracle.bi.system -> system.user

Thanks,

Shanmugha Bharathy G B

Hope it Helps!

Custom Sign Out Text in OBIEE 11g

For Sign out text the changes to be done in productmessages.xml file.

D:\MiddlewareHome\Oracle_BI1\bifoundation\web\msgdb\l_en\messages

Search and replace FROM name="kmsgProductGeneral"><TEXT>ORACLE BUSINESS INTELLIGENCE</TEXT><HTML>ORACLE BUSINESS INTELLIGENCE</HTML>

To your custom text as below name="kmsgProductGeneral"><TEXT>SBL BUSINESS INTELLIGENCE</TEXT><HTML>SBL BUSINESS INTELLIGENCE</HTML>

Text has been replaced in both the tags to display at sign page

Thanks,

Shanmugha Bharathy G B

Hope It Helps!!

Custom logo for Login and Home Page of OBIEE 11g

1. The changes of the image are done in the below two folder paths.

Copy your image and paste in below mentioned two folders.

D:\MiddlewareHome\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\sk_blafp\b_mozilla_4\ oracle_logo.png
D:\MiddlewareHome\Oracle_BI1\bifoundation\web\app\res\sk_blafp\b_mozilla_4\ oracle_logo.png

2. After the replacement of the images cache from Administrative tool should be removed.

Manage>cache>Edit>select all>purge

3. Then go to Presentation services and clear the cache and reload server metadata.

Administration>Manage Sessions>Cancel Running Request and Close all Cursors>back>Reload files and Metadata.

4. Clear all browser history and cache.

5. Size of logo has to be w:119*h:25 and if the size changes image size conflicts. All the below search bar, Advanced, Administration button etc.. all are integrated into a single template, size and format are called in different css class file which changing may conflict with many files resulting blank display sometimes.

Thanks,

Shanmugha Bharathy G B

Hope It Helps!!

Display TopN Revenue Every Year by Customer in Obiee11g

Display TopN Revenue Every Year by Customer in Obiee11g:

Hi All,

I had a requirement to generate topN Constituents Revenue based on every year. In this blog i am going to explain how to display top 10 constituents revenue for 2012;2013 etc...

1. Create a new analysis with your required columns
Here i have used the following columns and the last column displays our business scenario.

2. For Revenue By TopN column goto>edit formula> and select f(..) formula button, expand aggregate icon and select TOPN function which will look like below screenshot.

3. Then select variable button >presentation variable and type COUNT as Variable Expression and Default Value as 10 like below screenshot.

4. After entering all the values the edit formula value passing pane should look like below screenshot and select ascending to this column.

5. Now we go to to create two prompts for our analysis.

6. Select the “Prompts” tab and click on the ” + ” symbol to create a new prompt, select the “Column Prompt” -> “Time”.”Year”.

7. Keep the default values and make sure these are checked: “Enable user to select multiple values”, “Enable user to type values”, “Require user input”.

8. For the “Default selection” select “Specific Values” and use the ” + ” icon to open the “Select Values” window.

9. In the “Select Value” window select 2013 and 2012 and move them to the “Selected” side and click the OK button.

Refer and make sure the values are correct as per below screenshot:

10. Create One More Prompt:

Add one more prompt by select the ” + ” icon on the “Definition” window.
Select the “Variable Prompt”.
On the “New Prompt” window for “Prompt for” select “Presentation Variable” and on the side box enter “Count”.
For the “Label” enter “Number of Ranks”.
For the “User Input” select “Text Field”.
For the “Variable Data Type” select “Number”
Check the “Require user input” checkbox.
For the “Default selection” select “Specific Value” and enter “10″.
Then finally click the OK button.

make sure it is as below screenshot:

11. Once all done Save the analysis as TOPN Constituents Revenue By Year.

12. The Result look like

13. Select ok and run the analysis.

Hope it Helps!!

Thanks,

Shanmugha Bharathy G B