OAS : Custom Links in the Global Header

 Sometime we have requirement to put any kind of Custom Link along with the OAS Global Header.

In order to do we will have to do two things. First need to create a Custom XML file where details will be mentioned and enable the Customlink in instanseconfig.xml file. 

Note: If you would have created the same in OBIEE , can Custom XML file can be manually moved to OAS.

Custom XML File Content (customlinks.xml)

<?xml version="1.0" encoding="utf-8"?>

<customLinks xmlns="com.siebel.analytics.web/customlinks/v1">

      <link id="l2" name="Data Visualiztion" description="Data Visualiztion" src="http://OAS_URL:PORT/dv/?pageid=home" target="blank" >

         <locations>

               <location name="header" insertBefore="catalog" />

         </locations>

      </link>  

</customLinks> 

We need to keep this file in below location: 

$DOMAIN_HOME/bidata/components/OBIPS/

Now we will have to add a new line in instanseconfig.xml file to enable custom link.

Location: $DOMAIN_HOME/config/fmwconfig/biconfig/OBIPS

Add the below tag in instanseconfig.xml file 

<CustomLinks>
<Enabled>true</Enabled>
</CustomLinks>

Restart the OAS Presentation services. 

Happy Learning !!

OAS : OBIEE 11g to OAS 5.9.0 Upgrade Steps

 Here we will try to capture all required steps to upgrade OBIEE 11.1.1.7.0 to OAS 5.9.0 but in very high level. 

High Level Steps are as Follow. 

                 1. OBIEE 12C Installation

                 2. Migration OBIEE 11g to OBIEE 12C. 

                 3. Post Migration Activity & Tuning. 

                 4. OAS 5.9.0 Installation & Upgrade. 

                 5. Security Configuration

Now lets see the above steps in little bit more details. 

           1. OBIEE 12C Installation

                    a. OBIEE 12C Infrastructure Installation ( Enterprise Manager, WLS, etc.. )

                    b. OBIEE 12C Installation ( OBIEE, BI Platform, BI Publisher, etc. ..)

                    c. RCU - Repository Create Utility ( All BI Schema create & tablespaces)

                    d. OBIEE 12C Configuration ( New Domain Setup)

                    e. Apply Patches (OBI Bundle Patches, WLS patches)

            2. Migration OBIEE 11g to OBIEE 12C.        

                    a. Generating the BI Migration Tool

                    b. Creating the Export Bundle

                    c. Importing with the BI Migration Script

                    

             3. Post Migration Activity & Tuning.     

                    a. Enable Usage Tracking

                    b. Export & Import Users & Groups

                    c. Removing the BISystemUser Policy

                    d. Set Compatibility Framework

                    e. Save Content with HTML

                    f. Increase Java Heap

                    g. Configure Maximum Number of Allowed Records

                    h. BI JavaHost Configuration

                    i. Enabling Clusters

                    j. Enabling Oracle Hardware Acceleration

                    k. Set Compatibility Mode

              4. OAS 5.9.0 Installation & Upgrade.  

                    a. Infrastructure Installation

                    b. Apply the Weblogic Patch

                    c. Install Oracle Analytic Server

                    d. Run the Readiness Check

                    e. Upgrade Schemas

                    f. Backing up Mapviewer Config File

                    g. Reconfigure BI Domain

                    h. Restoring Mapviewer Config File

                    i. Upgrade the Configuration

                 5. Security Configuration

                            OBIEE 12C or OAS has removed Catalog concept. 

Happy Learning !!

OAS : Dashboard Slowness Issue

Sometime we face slowness issue while trying to open any dashboard. Reason behind this When the dashboard list link is clicked, a lot of Catalog object permissions need to be checked. When there are multiple dashboards, the number of operations checking permissions get multiplied - these result in multiple calls back and forth to BI Server, the database, etc., causing slowdown.

Solution : 

Solution is to enable Catalog Cache as follows.

1. Edit <DOMAIN_HOME>/bi/config/fmwconfig/biconfig/OBIPS/instanceconfig.xml

2. Enable catalog cache by adding the below tags under Cache section.

<Cache>
...
<CatalogAttributes>
<Enabled>true</Enabled>
</CatalogAttributes>
</Cache>

3. Restart OBIPS(obips1) to reflect the change.

Note:

The same issue resolved in another case for a different root cause by adding the below tag in instanceconfig.xml

<Dashboard>

<CacheBannerList>true</CacheBannerList>

</Dashboard>

This setting would give performance improvement on dashboard menu listing within a user session i.e. first time in a new session, user may see slowness.

But after that within the same session, it would be instantaneous irrespective of how long the session ends.

But there is an implication of it: Any newly created dashboard would not get automatically listed in the dashboard menu until user logs off and logs in again.

Happy Learning !!