Category Archives: Berry van den Heuvel
Replace (All Column Values) text in prompt
It is possible to change the value (All Column Values) in the LOV’s of prompts in OBIEE.
- log in to the server
- change directory (choose [LANGUAGE])
cd /u01/app/oracle/fmw/Oracle_BI1/bifoundation/web/msgdb/l_[LANGUAGE]/messages/
- make a copy of the original globalfiltermessage.xml file
cp globalfiltermessages.xml globalfiltermessages.xml_org
- edit the file, for example with vi editor
vi globalfiltermessages.xml
- search for the tag kmsgGFPAllChoices
- remove the text “(All Column Values)”
- save and close the file
-
:wq
- clear all the browser cache
- restart all services in Enterprise Manager
Now, the value “(All Column Values)” is displayed empty!
Het bericht Replace (All Column Values) text in prompt verscheen eerst op OBIEE 24/7.
Change text in button
It is possible to change the text that is displayed in the buttons in OBIEE.
In this example, we change the text “Apply” to “Go”.
- change directory ([LANGUAGE] have to be replaced with the language)
cd /u01/app/oracle/fmw/Oracle_BI1/bifoundation/web/msgdb/l_[LANGUAGE]/messages/
- make a copy of the original viewmessages.xml file
cp viewmessages.xml viewmessages.xml[_orig]
- edit the file, for example with vi editor
vi viewmessages.xml
- search for the tag kmsgEVCPromptApply
- change the text “Apply” in “Go”
- save and close the file
-
:wq
- clear all the browser cache
- restart all services in Enterprise Manager
Now, the “Apply” buttons will display the text “Go”!
Het bericht Change text in button verscheen eerst op OBIEE 24/7.
Replace the Oracle logo
To replace the Oracle logo 
with an other logo, follow these steps;
- create a new logo of 119×25 pixels
- move the new logo to the server in a directory [SOURCE_DIR]
- change directory
-
cd $FMW_HOME/Oracle_BI1/bifoundation/web/app/res/sk_blafp
- make copies of the original oracle_logo.png files
cp ./login/oracle_logo.png ./login/oracle_logo.png[_orig] cp ./b_mozilla_4/oracle_logo.png ./b_mozilla_4/oracle_logo.png[_orig]
- overwrite the oracle_logo.png files with the new logo
cp [SOURCE_DIR]/oracle_logo.png ./login/oracle_logo.png cp [SOURCE_DIR]/oracle_logo.png ./b_mozilla_4/oracle_logo.png
- change directory
cd $FMW_HOME /user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/war/res/sk_blafp/
- make copies of the original oracle_logo.png files
cp ./login/oracle_logo.png ./login/oracle_logo.png[_orig] cp ./b_mozilla_4/oracle_logo.png ./b_mozilla_4/oracle_logo.png[_orig]
- also overwrite these oracle_logo.png files with the new logo
cp [SOURCE_DIR]/oracle_logo.png ./login/ cp [SOURCE_DIR]/oracle_logo.png ./b_mozilla_4/
- clear all your browser cache!
- log in to the Enterprise Manager and restart all services.
Now the new logo will be displayed!
Het bericht Replace the Oracle logo verscheen eerst op OBIEE 24/7.
TNS:no listener at OCI call OCIServerAttach
When you get the error message (“TNS:no listener at OCI call OCIServerAttach”)
the Data Source Name that is used in the connectionpool of the physical database that is used to show the report, is not found in the tnsnames.ora file.
This is how you can fix it;
- log in to the server
- go to the directory where the tnsnames.ora file is located
-
cd $FMW_HOME/Oracle_BI/network/admin
- create a copy of tnsnames.ora
-
cp tnsnames.ora tnsnames.ora[_orig]
- edit the file, for example with vi-editor
-
vi tnsnames.ora
- insert the entry
- save the tnsnames.ora
-
:wq
The error message will not be displayed anymore.
Het bericht TNS:no listener at OCI call OCIServerAttach verscheen eerst op OBIEE 24/7.
