Oracle BI EE 11g – Replacing the Oracle logo in OOTB

Replacing the Oracle logo in OOTB

 

 

Right click and check the location of the oracle_logo.png location.

To find the pyhsical location login to console and check the analytics application server.

Copy the analytics.ear and replace the oracle_logo.png with your logo(IMP keep the name of your logo as oracle_logo.png with same size image).

Steps to unzip the .ear and .war as follows.

1.Take a backup of analytics.ear

    

2. Unzipping the .ear file.

Use the below commannd

jar -xvf analytics.ear for extraction

3. Unzipping the .war file

Move the analyics.war into a folder and unzip

Unzip using the below command

jar -xvf analytics.war for extraction

after unzip looks loike below:

4. Replace the oracle_logo in the below locations

 

5. delete the old analytics.war file and compress the newly added logo and other folders.

Del analyics.war

6 compress and create the analytics.war which includes new logo using the below command line.

jar -cvf analytics.war *

* denotes compress all the files and folders in that location

7 compress the analytics.war and meta-inf for ceating the analytics.ear

Move the analytics.war, META-INF folder and analytics-ws.war in to a folder for compressing

Stop the weblogic server.

Now replace the new analytics.ear in the below location.

E:\obi11g\Oracle_BI1\bifoundation\jee

 

Start the weblogic and the logo will be changed and look like below.

OBIEE Report Skin & Style Customization

Oracle BI EE 11g – Styles, Skins & Custom XML Messages

There are 2 different choices of customizing the Styles, Skin and XML messages.

1. Creating a copy of Default folder into a different location and hosting as a application
   
2. Changing the Out of Box Styles, Skin and Custom XML
   

 

1. Replacing the Oracle logo with ''Airtel" logo using the first approach:

Steps to change the orcale logo.

 

Copy the folders s_blafp and sk_blafp, create a target directory and save the two folders and rename as shown below.

Copy the WEB-INF directory from {MIDDLEWARE_HOME}\instances\instance1\bifoundation\OracleBIPresentationServer\coreapplication_obips1\analyticsRes to E:\bie11g the folder looks like this

Replace the Oracle logo in two locations with same name oracle_logo.png

 

Login to console.

Click on deployments and then Click on lock & Edit

Click on install:

Under Path provide E:\bie11g and select biee11g

Select Install this deployment as application:

Select the application bie11g and start, once it gets started this looks like this

Active State.

Open the instanceconfig.xml file and add the below XML tags:

<URL> <CustomerResourcePhysicalPath>E:\bie11g</CustomerResourcePhysicalPath> <CustomerResourceVirtualPath>/bie11g</CustomerResourceVirtualPath> </URL>

 

<UI> <DefaultStyle>blafp_Test</DefaultStyle> <DefaultSkin>blafp_Test</DefaultSkin> </UI>

 

The instanceconfig.xml looks like this: E:\obi11g\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1

Restart the presentation service and log in to Analytics:

ORACLE BI Apps(7.9.6.X) ONLINE Training

ORACLE BI Apps ONLINE Training

We provide you:

• Training from actual IT industry experience professionals.
• No commutation to training centers, waiting for trainer.
• Curriculum  as per OBI Apps / OBIEE industry requirements.
• Training module with Real time scenario based.
• Assist to
• Get Certification on OBI Apps Implementation specialist.
• Interview process.

OBIA (7.9.6.X) Online Training Curriculum:

1. Oracle OBI Apps (7.9.6.X) overview.
1. OBIA Architecture.
2. DAC Architecture.
1. Overview of DAC
2. DAC behavior.
3. What is necessity of DAC in OBIA ?
3. Informatica ETL Architecture
4. OBIEE Architecture
5. Comparison between OBIEE and OBIA. 
2. OBI Apps Installations and environment setup / Configurations.
1. Demo of following tools installations
1. Informatica
2. DAC
3. OBIEE 
2. General Configurations
1. Configuration in Informatica
2. Configuration in DAC
3. Configuration in OBIEE
3. Finance Analytic s Module for E-Business Suite.(Oracle Apps R12)
1. Configuring Finance analytics Module for EBS.
2. Run the Full load and Incremental Load.
3. BASIC Functional EBS training on AP /AR / GL.
4. Finance Analytic Data model overview
5. Group account configuration
6. Multi currency & Calenders setup
7. RPD Metadata overview
8. Finance related Dashboard and Reports
9. How to customize ?
10. How to Trouble shoot the ETL / DAC / Dashboad / Report errors.
11. Customization hands on with real time scenario.
4. Other modules 
1. HR Analytics.
2. Spend and Procurement Analytics
3. Supply chain and Oder management Analytics
5. Security Implemention in OBIEE
1. How to create Users and provide privileges.

Audience :

• OBIEE Developers / consultants.
• Informatica Developers / Other ETL Developers.
• Datawarehouse developers.
• Report Developers.

Pre- requisite for this Training:

• Basic Data warehousing concepts 
• None
• Freshers.

How to upgrade Web logic Server (WLS) 10.3.5 to 10.3.6 in Windows 64 Bit.

Pr-requisite before Upgrading:

1.ShutdownWebLogic Server and the Oracle Business Intelligence by selecting:

 
 

Start> All Programs > Oracle Business Intelligence > Stop BI Services and stopped Oracle WebLogicNodeManager (c_Middleware_wlserver_10.3) service

 
 

2. Download the  Patch - p13529623_1036_Generic.zip from Oracle Support site.

 
 

How to download the patch ? 

 Screenshot shows the patch for Linux. Similarly you can choose windows from drop down option.

 

 

 
 

 

 

3. Unzipp the p13529623_1036_Generic.zip, you will find the following file:

     wls1036_upgrade_generic.jar

4. Backup Middleware folder and inventory directory.

 

5. Check the Java version.ForWebLogic 10.3.5 installations you need JDK6, but you can also use it for WebLogic 10.3.6 installations.

 
 

6. WebLogic 10.3.6 installations can use either JDK6 or JDK7 depending on your requirements. This is the same JDK7 you will use for development or production servers. Do not use JDK7 for an Oracle BI Apps 11.1.1.7.0 installation.

 
 

7. 

 

Upgrade :

 
 

1. (UNIX or Linux only) Include the -d64 flag in the installation command when using a 32/64-bit  hybrid JDK (such as for the HP-PA, HPIA, and Solaris64 platforms). For example, if installing in graphical mode using the Package installer:

• java -d64 -jar wlsversion_generic.jar
  

2. If you are using the Sun 64-bit JDK, use the following command to install WebLogic Server: Navigate to the patch folder. Run the command

 
 

   java -Xmx1024m -jar wls1036_upgrade_generic.jar

      OR for 32 bit java

   java  -jar wls1036_upgrade_generic.jar

   
 

 

 

3. 

 

     
 

 

4.  For upgrading choose 'Use an existing Middleware Home'  You will see the Middleware Home     Directory greyed out.

 
 

 

5. Next follow the GUI on screen instructions for Upgrade.

 
 

Post Installation : 

 
 

How to check/verify the Weblogicversion ?

 

1.  Once the server is started you can access the administrator console using the "http://hostname:7001/console" URL. Log in using the username and password

 
 

2.   

 

 

 3.

 

 
 

4.   Run the following command

java -cp /optional/Oracle/Middleware/wlserver_10.3/server/lib/weblogic.jar weblogic.version –verbose

 
 

 

How to upgrade Weblogic 10.3.5 to 10.3.6

How to upgrade Web logic Server (WLS) 10.3.5 to 10.3.6 in Windows 64 Bit.

Pr-requisite before Upgrading:

1.Shutdown WebLogic Server and the Oracle Business Intelligence by selecting:

Start > All Programs > Oracle Business Intelligence > Stop BI Services and stopped Oracle WebLogic NodeManager (c_Middleware_wlserver_10.3) service

2. Download the  Patch - p13529623_1036_Generic.zip from Oracle Support site.

How to download the patch ? 

 Screenshot shows the patch for Linux. Similarly you can choose windows from drop down option.

3. Unzipp the p13529623_1036_Generic.zip, you will find the following file:

     wls1036_upgrade_generic.jar

4. Backup Middleware folder and inventory directory.

5. Check the Java version.For WebLogic 10.3.5 installations you need JDK6, but you can also use it for WebLogic 10.3.6 installations.

6. WebLogic 10.3.6 installations can use either JDK6 or JDK7 depending on your requirements. This is the same JDK7 you will use for development or production servers. Do not use JDK7 for an Oracle BI Apps 11.1.1.7.0 installation.

7. 

Upgrade :

1. (UNIX or Linux only) Include the -d64 flag in the installation command when using a 32/64-bit  hybrid JDK (such as for the HP-PA, HPIA, and Solaris64 platforms). For example, if installing in graphical mode using the Package installer:

• java -d64 -jar wlsversion_generic.jar
  

2. If you are using the Sun 64-bit JDK, use the following command to install WebLogic Server: Navigate to the patch folder. Run the command

    java -Xmx1024m -jar wls1036_upgrade_generic.jar
      OR for 32 bit java
   java  -jar wls1036_upgrade_generic.jar
   

3. 

     

4.  For upgrading choose 'Use an existing Middleware Home'  You will see the Middleware Home 

     Directory greyed out.

 

5. Next follow the GUI on screen instructions for Upgrade.

Post Installation : 

How to check/verify the Weblogic version ?

1.  Once the server is started you can access the administrator console using the "http://hostname:7001/console" URL. Log in using the username and password

2.   

 3.

 

4.   Run the following command

java -cp /optional/Oracle/Middleware/wlserver_10.3/server/lib/weblogic.jar weblogic.version –verbose