Skip Headers
Oracle® Student Learning Installation and Deployment Guide
Release 3.1.3

Part Number E20664-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
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.