Oracle® Student Learning Installation and Deployment Guide Release 3.1.3 Part Number E20664-04 |
|
|
PDF · Mobi · ePub |
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
.
This section describes the configuration steps for OBIEE 10g.
Ensure that OBIEE is installed before configuration.
To configure data source in OBIEE 10g:
Open a command prompt.
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
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.
Update the connection pool of the OSL repository to point to the OSL data source:
Return to Windows.
Copy the OSL.rpd
file from the [OSL Home directory]/LearningTool/StudentReporting
directory to your Windows file system.
Open the Administration Tool by selecting Start > All Programs > Oracle Business Intelligence > Administration.
To open a repository for editing in an offline mode:
OSL.rpd
are correct.Expand the OSLDataSource database object.
Right-click the Connection Pool object and select Properties.
Ensure that the data items listed in Table 7-1, "Data Items" are accurate.
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. |
Click OK.
This step completes the OBIEE data source configuration. All changes are saved in OSL.rpd
.
When prompted to verify the password, enter the password of the OBIEE data source.
Click OK.
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
.
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.
To import OSL Repository into OBIEE:
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.Update the <InstallDrive>/OracleBI/server/Config/NQSConfig.ini
file with this entry:
Star=OSL.rpd, DEFAULT;
Unzip the OSLCatalog.zip
file from the <OSL home directory>/LearningTool/StudentReporting
folder.
Copy the OSL catalog folder from <OSL home directory>/LearningTool/StudentReporting
to the OBIEE folder
<InstallDrive>/OracleBIData/web/catalog
.
Update the
<Install drive>/OracleBIData/web/config/instanceconfig.xml
file
with this entry:
<Catalog Path><Install Drive>/OracleBIData/web/catalog/OSLCatalog</CatalogPath>
To import error messages into OBIEE, copy the OSL_error_messages.xml
file from <OSLHome>/LearningTool/StudentReporting/
to OracleBI/web/msgdb/customMessages
folder.
To configure OBIEE:
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,'idPersonalizationMenu',null,'top')">&nbsp; <sawm:messageRef name="kmsgDashboardPageOptionsMenu"/>&nbsp; <img src="fmap:Views/sortdesc.gif" border="none"/>&nbsp;</a></span><br/> </HTML> </WebMessage>
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>
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('@{pdfURL}[javaScriptString]',@{bNewWindow});"> <sawm:messageRef name="kmsgDashboardPrintPDF"/></a></sawm:if>
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>
Disable the cache.
In the OracleBI/server/Config/NQSConfig.INI
file, set ENABLE
to NO
, like the following message:
[ CACHE ]
ENABLE=NO;
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
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>
This section describes the configuration steps for OBIEE 11g.
To configure the data source in OBIEE 11g for OSL, perform the following steps.
Switch to Windows.
Copy OSL.rpd
from the [OSL home] > LearningTool > StudentReporting > obiee11g to your Windows file system.
Open the Administration Tool by selecting Start > All Programs > Oracle Business Intelligence > BI Administration.
You can open a repository for editing in offline mode.
Verify that the connection pool parameters for the data source OSL.rpd
are correct.
Select File > Open > Offline.
Enter OBIEE the repository password.
Click Open.
The repository layers appear.
Note:
The default OSL repository password iswelcome1
.Expand the database object OSLDataSource.
Right-click the Connection Pool object and select Properties.
Ensure that the data items are accurate as shown in 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. |
Click OK.
When prompted to verify the password, enter the database password of OBIEE Data Source.
Click OK.
Save the repository.
Perform the following steps to configure security for OBIEE 11g configuration.
Configure the Repository OID.
In the OBIEE, update the details of the OID instance LDAP_R3 used for OSL.
Launch the security manager using the Manage > Identity option.
Select automatically generated.
Save the repository file.
Configure security in Enterprise Manager.
To configure the authentication provider and application role to system group mapping, perform the following steps:
Log in to the Fusion Middleware Enterprise Manager.
Navigate to Business Intelligence > Core Application.
On the Security tab, click Go to the Weblogic Server Administrator Console to configure the Weblogic security realm.
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
.
Select the Security tab.
Click Configure and Manage Application Roles.
Configure the appropriate mapping.
Ensure that the mapping is configured as shown in Table 7-3, "Configuration of OBIEE Application Roles".
Deploy the OSL repository and the catalog into OBIEE.
Log in to the Fusion Middleware Enterprise Manager.
Navigate to Business Intelligence > Core Application.
Select the deployment tab and the repository.
Unzip the OSLCatalog.zip
file from the [OSL Home] > LearningTool > StudentReporting > obiee11g directory.
Deploy the configured OSL repository file and catalog files.
Complete the following steps to configure OBIEE.
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>
Configure to not use cache.
Log in to the Fusion Middleware Enterprise Manager.
Navigate to Business Intelligence > Core Application.
Navigate to Capacity Management > Performance tab.
Click Lock and Edit Configuration.
Clear the Cache Enabled check box.
Click Apply.
Click Activate Changes.
Restart the BI Server system component before activating it.