Skip Headers

Oracle® Student Learning Installation and Deployment Guide Release 3.1.3 Part Number E20664-04 |
Home | Book List | Contents | Contact Us

Previous | Next
| PDF · Mobi · ePub

# 7 Configuring Oracle Business Intelligence Enterprise Edition

To access the learning tool reports, you must install and configure Oracle Business Intelligence Enterprise Edition (OBIEE). After installation, perform the following configuration steps.

For information about OBIEE 10g installation and configuration, see `http://download.oracle.com/docs/cd/E10415_01/doc/nav/portal_booklist.htm`.

For OBIEE 11g installation and configuration, follow the document guides available at `http://download.oracle.com/docs/cd/E14571_01/bi.htm`.

## 7.1 Configuration for OBIEE 10g

This section describes the configuration steps for OBIEE 10g.

### 7.1.1 Configuring OBIEE Data Source

Ensure that OBIEE is installed before configuration.

To configure data source in OBIEE 10g:

1. Open a command prompt.

2. Create the OSL Data Source using the Oracle Database 11g Client by running this command:

       export ORACLE_HOME=<Your Oracle Client home>
       $ORACLE_HOME/bin/netmgr

3. Create a new data source under Oracle Net Configuration > Local > Service Naming, according to the data source you use for OSL.

   Remember to test the database connection at the last step.

4. Update the connection pool of the OSL repository to point to the OSL data source:

   1. Return to Windows.

   2. Copy the `OSL.rpd` file from the `[OSL Home directory]/LearningTool/StudentReporting` directory to your Windows file system.

   3. Open the Administration Tool by selecting Start > All Programs > Oracle Business Intelligence > Administration.

   4. To open a repository for editing in an offline mode:

      i) Verify that the connection pool parameters for your data source `OSL.rpd` are correct.
      ii) Select File > Open > Offline.
      iii) Enter OBIEE Administrator account password.
      iv) Click Open. The repository layers appear.

   5. Expand the OSLDataSource database object.

   6. Right-click the Connection Pool object and select Properties.

   7. Ensure that the data items listed in Table 7-1, "Data Items" are accurate.

      Table 7-1 Data Items

      Object | Description
      --- | ---
      Call Interface | The call interface is the application program interface (API) used to access the data source. Use OCI for Oracle Database 10g/11g.
      Data Source Name | The data source name is the name that you configured to connect to the database. The data source name corresponds to the TNS Service Name.
      Shared logon and User name | Select Shared logon, and enter the user name and password.

   8. Click OK.

      This step completes the OBIEE data source configuration. All changes are saved in `OSL.rpd`.

   9. When prompted to verify the password, enter the password of the OBIEE data source.

   10. Click OK.

### 7.1.2 Configuring OBIEE for OID Authentication

You can control user access to OBIEE by the OID instance. Access control allows users to log in to OBIEE using their OID accounts.

In the OBIEE Security Manager, update the details of the OID instance LDAP_R3 used for OSL.

For the User name attribute type field under the Advanced tab of the LDAP server configuration, select Automatically generated.

All changes are saved in `OSL.rpd`.

### 7.1.3 Setting Administrator Password for Student Reporting

The administrator can configure Student Reporting settings. Secure the administrator user account is with a strong password.

In the OBIEE Security Manager, update the password of the administrator user.

### 7.1.4 Importing OSL Repository into OBIEE

To import OSL Repository into OBIEE:

1. Copy the configured `OSL.rpd` repository file from your Windows file system to the OBIEE folder on the Linux server: `<Installation drive>/OracleBI/server/Repository`.

   Note:

   Here <InstallDrive> refers to the root directory of your OBIEE installation.

2. Update the `<InstallDrive>/OracleBI/server/Config/NQSConfig.ini` file with this entry:

   `Star=OSL.rpd, DEFAULT;`

3. Unzip the `OSLCatalog.zip` file from the `<OSL home directory>/LearningTool/StudentReporting` folder.

4. Copy the OSL catalog folder from `<OSL home directory>/LearningTool/StudentReporting` to the OBIEE folder

   `<InstallDrive>/OracleBIData/web/catalog`.

5. Update the

   `<Install drive>/OracleBIData/web/config/instanceconfig.xml` file

   with this entry:

   `<Catalog Path><Install Drive>/OracleBIData/web/catalog/OSLCatalog</CatalogPath>`

### 7.1.5 Importing Error Messages into OBIEE

To import error messages into OBIEE, copy the `OSL_error_messages.xml` file from `<OSLHome>/LearningTool/StudentReporting/` to `OracleBI/web/msgdb/customMessages` folder.

### 7.1.6 Configuring OBIEE

To configure OBIEE:

1. Disable the page options from the dashboard.

   In the `OracleBI/web/msgdb/messages/dashboardtemplates.xml` file, add `style="display:none"` for tag WebMessage named `"kuiPersonalizeLink"`. Refer to below example:

       <WebMessage name="kuiPersonalizeLink">
       <HTML><span class="minibuttonOn" style="display:none">
       <a href="javascript:void(null)" onclick="return NQWPopupMenu(event,&#39;idPersonalizationMenu&#39;,null,&#39;top&#39;)">&amp;nbsp;
       <sawm:messageRef name="kmsgDashboardPageOptionsMenu"/>&amp;nbsp;
       <img src="fmap:Views/sortdesc.gif" border="none"/>&amp;nbsp;</a></span><br/>
       </HTML>
       </WebMessage>

2. Disable the top menu from dashboard.

   In the `OracleBI/web/msgdb/messages/dashboardtemplates.xml` file, add `style="display:none"` for tag Webmessage named `"kuiDashboardMainBar"` and `"kuiDashboardBanner"`.

   Refer to following example:

       <WebMessage name="kuiDashboardMainBar" translate="no"><HTML>
       <table class="PortalBottomTable" width="100%" border="0" cellspacing="0" style="display:none">
       <tr><td><sawm:choose><sawm:when name="dashboardDesc"><div class="PortalName" title="@{dashboardLongName}@{dashboardDesc}">
       <sawm:param name="dashboardName"/></div></sawm:when><sawm:otherwise><div class="PortalName" title="@{dashboardLongName}">
       <sawm:param name="dashboardName"/></div></sawm:otherwise></sawm:choose></td>
       <td class="PortalLinks"><table class="WelcomeTextTable" align="right"><tr><td class="WelcomeTextCell">
       <sawm:param name="welcomeText"/></td><td><sawm:messageRef name="kuiMainBarActionsTable">
       <sawm:setParam name="target">_self</sawm:setParam><sawm:setParam name="classPrefix">DashBar</sawm:setParam></sawm:messageRef>
       </td></tr></table></td></tr></table>
       <sawm:messageRef name="kuiMainBarActionsMenus"><sawm:setParam name="target">_self
       </sawm:setParam><sawm:setParam name="classPrefix">DashBar</sawm:setParam>
       <sawm:setParam name="proxyStartPage">dashboard</sawm:setParam></sawm:messageRef>
       </HTML></WebMessage>

       <WebMessage name="kuiDashboardBanner" translate="no">
       <!-- Param bannerHtml --><!-- Param dashboardsURL -->
       <HTML><table class="PortalBanner" width="100%" border="0" cellspacing="0" style="display:none">
       <tr><td class="PortalLogo"><a href="@{dashboardsURL}"><img class="PortalLogoImage" border="0" src="fmap:Portal/PortalLogo.gif"/>
       </a></td><td class="PortalTop" style="vertical-align:top"><sawm:param name="bannerHtml"/></td></tr></table>
       <sawm:messageRef name="kuiDashboardMainBar"><sawm:setParam name="product">dashboard</sawm:setParam></sawm:messageRef>
       </HTML></WebMessage>

3. Disable the PDF print from dashboard.

   In the `OracleBI/web/msgdb/messages/controlmessages.xml` file, remove or comment the following message:

       <sawm:if name="enablePDF">
       <a class="NQWMenuItem" name="pdf" href="javascript:void(null)" onclick="return PortalPrint(&#39;@{pdfURL}[javaScriptString]&#39;,@{bNewWindow});">
       <sawm:messageRef name="kmsgDashboardPrintPDF"/></a></sawm:if>

4. Configure the refresh time.

   In the `OracleBIData/web/config/instanceconfig.xml` file, add the following message before `</ServerInstance` :

       <CacheMaxExpireMinutes>1</CacheMaxExpireMinutes>
       <CacheMinExpireMinutes>1</CacheMinExpireMinutes>
       <CacheMinUserExpireMinutes>1</CacheMinUserExpireMinutes>

5. Disable the cache.

   In the `OracleBI/server/Config/NQSConfig.INI` file, set `ENABLE` to `NO`, like the following message:

       [ CACHE ]
       ENABLE=NO;

6. Configure the Oracle Client for OBIEE (Linux version).

   In the `OracleBI/setup/user.sh` file, find the correct operating system and Oracle version, like the following message. Then specify the correct `ORACLE_HOME`.

       ###############################################################
       # Linux: Oracle BI 32 bit mode
       ################################################################
       #set +u

       # Oracle Parameters
       #---------------------------
       # Make sure that Oracle DB 32 bit Client is installed
       ORACLE_HOME= <oracle home path>
       export ORACLE_HOME
       TNS_ADMIN=$ORACLE_HOME/network/admin
       export TNS_ADMIN
       PATH=$ORACLE_HOME/bin:/opt/bin:$PATH
       export PATH
       LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
       export LD_LIBRARY_PATH

7. Deploy the `OracleBI\web\analytics.ear` file to the WebLogic domain.

   If the OBIEE and WebLogic are not on identical computers, update the `analytics.ear/analytics.war/WEB-INF/web.xml` file. Set the OBIEE Server IP as the localhost.

       <init-param>
               <param-name>oracle.bi.presentation.sawserver.Host</param-name>
       <param-value>localhost</param-value>
       </init-param>

## 7.2 Configuration for OBIEE 11g

This section describes the configuration steps for OBIEE 11g.

### 7.2.1 Configuring the Data Source

To configure the data source in OBIEE 11g for OSL, perform the following steps.

1. Switch to Windows.

2. Copy `OSL.rpd` from the [OSL home] > LearningTool > StudentReporting > obiee11g to your Windows file system.

3. Open the Administration Tool by selecting Start > All Programs > Oracle Business Intelligence > BI Administration.

   You can open a repository for editing in offline mode.

4. Verify that the connection pool parameters for the data source `OSL.rpd` are correct.

   1. Select File > Open > Offline.

   2. Enter OBIEE the repository password.

   3. Click Open.

      The repository layers appear.

   Note:

   The default OSL repository password is `welcome1`.

5. Expand the database object OSLDataSource.

   1. Right-click the Connection Pool object and select Properties.

   2. Ensure that the data items are accurate as shown in Table 7-2, "OSLDataSource Data".

   Table 7-2 OSLDataSource Data

   Object | Description
   --- | ---
   Call Interface | The call interface is the application program interface (API) that you use to access the data source. Use OCI for Oracle Database 10g and 11g.
   Data Source Name | The data source name is the name that you configured to connect to the database. This name corresponds to the TNS Service Name.
   Shared logon and User name | Select the Shared logon check box, and enter the correct user and password.

6. Click OK.

7. When prompted to verify the password, enter the database password of OBIEE Data Source.

8. Click OK.

9. Save the repository.

### 7.2.2 Configuring Security

Perform the following steps to configure security for OBIEE 11g configuration.

1. Configure the Repository OID.

   1. In the OBIEE, update the details of the OID instance LDAP_R3 used for OSL.

   2. Launch the security manager using the Manage > Identity option.

   3. Select automatically generated.

   4. Save the repository file.

2. Configure security in Enterprise Manager.

   To configure the authentication provider and application role to system group mapping, perform the following steps:

   1. Log in to the Fusion Middleware Enterprise Manager.

   2. Navigate to Business Intelligence > Core Application.

   3. On the Security tab, click Go to the Weblogic Server Administrator Console to configure the Weblogic security realm.

   4. Configure the Weblogic security realm by adding the OID provider.

      Use the OID information used to configure in `OSL.rpd` repository file.

      The detail steps are available at: `http://download.oracle.com/docs/cd/E21764_01/bi.1111/e10543/privileges.htm#BABCDCFE`.

   5. Select the Security tab.

   6. Click Configure and Manage Application Roles.

   7. Configure the appropriate mapping.

      Ensure that the mapping is configured as shown in Table 7-3, "Configuration of OBIEE Application Roles".

      Table 7-3 Configuration of OBIEE Application Roles

      OBIEE Application Role | System Group
      --- | ---
      Teachers | TeacherGroup
      Students | StudentGroup
      Parents | ParentGroup

3. Deploy the OSL repository and the catalog into OBIEE.

   1. Log in to the Fusion Middleware Enterprise Manager.

   2. Navigate to Business Intelligence > Core Application.

   3. Select the deployment tab and the repository.

   4. Unzip the `OSLCatalog.zip` file from the [OSL Home] > LearningTool > StudentReporting > obiee11g directory.

   5. Deploy the configured OSL repository file and catalog files.

### 7.2.3 Configuring OBIEE

Complete the following steps to configure OBIEE.

1. Configure the refresh time.

   In the file <ORACLE_INSTANCE>/config/OracleBIPresentationServicesComponent/coreapplication_obipsn/instanceconfig.xml, add the following message at the bottom, before </ServerInstance>:

   `<Cache>`

   `<Query>`

   `<MaxExpireMinutes>-1</MaxExpireMinutes>`

   `<MinExpireMinutes>-1</MinExpireMinutes>`

   `<MinUserExpireMinutes>-1</MinUserExpireMinutes>`

   `</Query>`

   `</Cache>`

2. Configure to not use cache.

   1. Log in to the Fusion Middleware Enterprise Manager.

   2. Navigate to Business Intelligence > Core Application.

   3. Navigate to Capacity Management > Performance tab.

   4. Click Lock and Edit Configuration.

   5. Clear the Cache Enabled check box.

   6. Click Apply.

   7. Click Activate Changes.

   8. Restart the BI Server system component before activating it.