Steps for Deploying RPD manually in OBIEE 11g

We cannot upload the rpd with large size through EM console in OBIEE 11g.

We will get the below error while trying to upload rpd with large size

We can upload the large sized rpd manually.

Note : Copy the large size rpd (Ex: test.rpd ) to rpd file location on obiee server

"/mwhome/instance/instance1/bifoundation/OracleBIServerComponent/coreapplication_obis1/repository/"

Steps for uploading rpd manually:

1. Login to weblogic em console through url (http://localhost:7001/em)

2. On the left pane expand “Weblogic Domain” >bifoundation_domain>bi_cluster. Click on bi_server1 and then in the right pane, click on WebLogic Server drop down list and choose “System MBean Browser”


















3. Expand “Application Defined MBeans” >oracle.biee.admin> Domain: bifoundation_domain>BIDomain> and select the ‘BIDomain’

4. Go to the Operations Tab in the far right pane. Click on “Lock” and then !Invoke” button.

5. Navigate to BIDomain.BIInstance.ServerConfiguration> select BIDomain.BIInstance.ServerConfiguration

6. Navigate to the ‘Operations’ Tab from the far right pane and click on “uploadRepository”

Rpd file path :
/mwhome/instance/instance1/bifoundation/OracleBIServerComponent/coreapplication_obis1/repository/test.rpd

Password : Admin123

7. Click “Invoke"

8. “Lock” on the domain needs to be released. To release the lock, Navigate back to BIDomain> Operations and click on “Commit” and then click on “Invoke”

9. Restart the BI Server (OPMN Services) from EM

OBIEE 11.1.1.9 Customizing Skins and Styles on Windows

Updating bicustom.ear file

The bicustom-template.ear file contains a bicustom.war file. Web Archive (WAR) files are also ZIP files composed of a specific folder and file structure. You must update the bicustom.war file within the bicustom-template.ear file to include your custom skin files.

Copy bicustom-template.ear 

Extract / Copy bicustom-template.ear to bicustom.ear,  bicustom-template.ear  available in below path

• <OBI_HOME> \Oracle_BI1\bifoundation\jee\
• Extract bicustom.ear into the same path

Update the bicustom.ear file

• Extract the bicustom.war file from bicustom.ear file
• Extract the files from the bicustom.war file.
• Edit the files to create your custom styles.

Replacing Oracle logo with customized logo:

To replace the oracle logo with the customized image, first save the customized image with same precision and name it as oracle_logo.png

Replace the customized image (oracle_logo.png) in the following path.

<OBIEE_HOME>\ Oracle_BI1\bifoundation\jee\bicustom\res\s_Custom\master

To modify the background color:

To change the background color in OBIEE edit master.css file

File path: <OBIEE_HOME>\ Oracle_BI1\bifoundation\jee\bicustom\res\s_Custom\master

• Open the master.css file.
• Scroll down and locate the class that you want to customize.
• In the sample code, modify the .masterBrandingArea class. Also note that the code contains inline comments to identify that code section

• Change the HTML background color value from #000000 to #115740 to change the color from black to green color.
• Save the file
• Now update the bicustom.war file with your changes.
•  To update the file archive custom folder into bicustom.zip or bicustom.7z

•         Then change the file extension from .7z/ .zip to .war (web archive)
•      Similarly update the bicustom.ear file with your new bicustom.war file by using zip

          Deploying the bicustom.ear file

          Login to Oracle Weblogic Server Administration Console   

      Click Lock & Edit.

Click Deployments in the Domain structure region

Click on Deployments

Click on Install

Give the path to bicustom.ear file as below

Select the bicustom.ear file and click next

Select install this deployment as an application and click next

Select bi_cluster as a target and click next

Select I will make the deployment accessible from the following location

Click on finish

Click save and then activate changes

Now go to the deployments again and start the newly creates application 

Modify the instanceconfig.xml file UI tag under <OBIEE_HOME>\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1 as below

Save and close the file and restart the bi presentation component

Now login to analytics page and check for the new custom page

OBIEE and OBIA Version History

OBIEE based on Siebel Business Analytics which was first developed by nQuire in the year 1997

Please find the major version releases below :

2001: nQuire acquired by Siebel

Siebel Analytics 7.0 – 2002

Siebel Analytics 7.5 – 2003

Siebel Analytics 7.7 – 2004

Siebel Analytics 7.8.2 and 7.8.3 – 2005

Siebel Analytics / Oracle Business Intelligence 7.8.4 and 7.8.5 – 2006

Please find the OBIEE versions releases below :

Please find the OBIA versions releases below :

Resolution for failure of up-gradation from OBIEE 11.1.1.7.0 to OBIEE 11.1.1.9.0 at 40% at Executing upgradenonj2eeapp.sh

When we tried to upgrade OBIEE 11.1.1.7.0 to OBIEE 11.1.1.9.0 , in the configuration step at 40% of process we may get the below error

configuration assistant: Upgrade NonJ2EEManagement.ear: Command failed: NonJ2EEManagement Application deployment failed

To resolve this error we need to redeploy and re register the instance again.

To resolved this we need to follow the below steps:

1. Login to weblogic console and click on  Release configuration

2. Deploy the instance again

Navigate to $INSTANCE_HOME/bin and issue the below command to redeploy the instance

3. Register the instance again

To register the instance again issue the below command

4. Ones the registration got succeed on the obiee 11.1.1.9.0 configuration window click retry.

Batch file for clearing OracleBIServer cache OBIEE 11g on windows

1. Open a text file and paste the below code

call sapurgeallCache();

2. Save the file as purgecache.txt and place it into the location  %ORACLE_INSTANCE%\bifoundation\OracleBIApplication\coreapplication\setup\

3. Now open another text file and paste the below code

@echo off

set ORACLE_HOME=C:\oracle\middlewarehome\Oracle_BI1

set ORACLE_INSTANCE=C:\oracle\middlewarehome\instances\instance1

set ORACLE_BI_APPLICATION=coreapplication

set JAVA_HOME=C:\oracle\middlewarehome\instances\instance1

set ESSBASEPATH=%ORACLE_HOME%\clients\epm\Essbase\EssbaseRTC

call %ORACLE_INSTANCE%\bifoundation\OracleBIApplication\coreapplication\setup\bi-init.cmd

call %ORACLE_HOME%\bifoundation\server\bin\nqcmd -d coreapplication_OH829890363 -u weblogic -p welcome1 -s %ORACLE_INSTANCE%\bifoundation\OracleBIApplication\coreapplication\setup\purgecache.txt

pause

Here 

coreapplication_OH829890363 : DSN name 

4. Save the file as purgecache.bat

5. Double click the bat file and it will clear the cache

How to enable Auto-Complete search for Prompts OBIEE Analysis

To enable auto-complete for prompts add the below tag in instanceconfig.xml file

1. Navigate to the below path

OBIEE 12c :

$ORACLE_HOME/user_projects/domains/bi/config/fmwconfig/biconfig/OBIPS/

OBIEE 11g :

$MW_HOME/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication

2. Open the instanceconfig.xml file

3. Add the below in <ServerInstance></ServerInstance> tag

<Prompts>

<MaxDropDownValues>1000</MaxDropDownValues>

<AutoApplyDashboardPromptValues>true</AutoApplyDashboardPromptValues>

<AutoSearchPromptDialogBox>true</AutoSearchPromptDialogBox>

<AutoCompletePromptDropDowns>

<SupportAutoComplete>true</SupportAutoComplete>

<CaseInsensitive>true</CaseInsensitive>

<MatchingLevel>MatchAll</MatchingLevel>

<ResultsLimit>1000</ResultsLimit>

</AutoCompletePromptDropDowns>

</Prompts>

4. Save and close the file

5. Restart the obiee components

6. Login to OBIEE with the Admin user

Go to My Account 

Change Prompts Auto-Complete to “On”

Click OK

7. Now check in the prompts auto search will work

System requirements for installing obiee on windows

Below are the recommended hardware and system configuration requirements for installing obiee on windows:

Oracle Endeca Information Discovery Integration with the OBIEE 11g

Open Integrator and select File > New > Project from the menu bar

Select Load Data from OBI Server and click next

Select create a new project
Give the project name
click next

Provide endeca server host, port and domain name and click next

Provide obiee server connection details
Click connect to obi server
If the connection got succeed click next

Select the tables to import and click next

Click finish

Now we can see the obi connection and its details in navigator pane

Run the base line graph by expanding the graph folder
Open baseline.grf
Press the run button
This will load obi repository data into endeca domain

Login to endeca studio
Create a data source like above

Test the connection
 If the test succeed click ok

In the endeca studio create new discovery application with newly created data source