OBIEE 11G - Installation Sample Application version 825

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics) > OBIEE - Admin > OBIEE - Admin 11g

1 - About

Step by step installation of the complete (and not lite) sample application for OBIEE 11G.

This article was made with the help of the installation documentation of the sample app. You can find the link in the reference / documentation section.

It's not the lastest version of BI sample application. You have now the version V107

Demonstrations:

  • Action Framework (webcat folder 4) Actionable Intelligence.
  • Essbase (webcat folder 8)
  • OLAP (webcat folder 8)
  • Mapviewer (webcat folder 3)
  • OLTP (FOD)
  • Datamining (webcat folder 8)
Advertising

3 - Prerequisites

3.1 - Shiphome Build

  • This SampleApp build has been developed using Shiphome build June 11th
  • RPD is upgraded to Encryption model (RPD pwd = Admin123)

SampleApp builds must be deployed on RC5 or RC4 Shiphome builds. Deploying a SampleApp build on an old platform build will result in high risk of failure, or at best, of not having all content functional.

3.2 - Oracle Database

It is required that you have a connection to an 11g Oracle database and to use an Entreprise Edition in order to have the following options:

  • Spatial (for Geographical mapping),
  • Datamining
  • and OLAP options

4 - Steps

4.1 - Deploying SampleApp Core (Required)

4.1.1 - Copy Files

4.1.1.1 - Presentation Service

The root directory is:

\MiddelWareHome\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\

The conf directory is:

\MiddelWareHome\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1

Copy the following files:

  • Webcat : Copy the content of the file SampleApp_webcat to this subfolder: Rootdirectory\catalog
  • analyticsRes folder : Copy all the content within the analyticsRes folder to the Rootdirectory\analyticsRes

This contains all the custom files (custom images, writeback templates) that are consumed by SampleApp dashboards and reports. If some of the sub-folders already exist within analyticsRes folder on your system, increment their content with the files from this SampleApp deployment.

  • Userpref_currencies.xml : Copy the Userpref_currencies.xml file into the configuration directory.

This file contains currency code setup examples for SampleApp currency showing reports

Advertising
4.1.1.2 - BI Server

Copy:

  • the “SampleAppFiles” sub-folder and all its content to the directory in your BIEE install :
\InstallHome\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\sample\

This contains the XML extra datasource that is used in the SampleApp Federation example.

  • About the RPD file: The SampleApp.rpd file that is in the install directory does NOT need to be moved into your BIEE install. It will be used directly by EM administration process, and needs to be copied to the machine where you will run EM browser from. Otherwise, you can still copy it on this location:

MiddelwareHome\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository

4.1.2 - Creating Main SampleApp Oracle Data source

The connect string is db11gr2. You must change it according to your installation.

  • Creating BISAMPLE USER
  • Verification BI Sample Connection
  • Import dictionary and data
  • Verification Import
cd path_to_sample_app\SampleApp_810_Core\2_SampleApp_810_Core
sqlplus system/[email protected]
@BISAMPLE_USER.SQL
exit
sqlplus BISAMPLE/[email protected]
exit
imp BISAMPLE/[email protected] file=BISAMPLE\BISAMPLE.dmp FULL=Y
SELECT * FROM SAMP_CHANNELS_D;

The BISAMPLE user creation script defaults with the password “BISAMPLE‟ (same as user name) within the script. It is recommended that you keep this value unchanged, to simplify configuration. Should you change this password to something different, be aware that you will need to edit following configurations :

  • RPD connection pools password value (for respective Connection Pools impacted) need to be updated with the correct password value
  • In webcat, some objects of type Action (example “Annotate” action) contains the connection information to the database in its setups, including hardcoded password value. This needs to be updated as well.
Advertising

4.1.3 - AnalyticsRES

This step allows to point WLS to the file folder location where you have pasted custom files for SampleApp (Images, styles, messages…).

  • Domain Structure > bifoundation_domain > Deployment
  • Unlock and press the Install button
  • Locate deployment to install and prepare for deployment: Enter the path: MiddelwareHome\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1

  • Select the analyticsRes directory > Next
  • Choose targeting style: Install this deployment as an application > Next
  • Select deployment targets: Choose bi_server1 as the deployment target > Next

  • Optional Settings: Select “I will make the deployment accessible from the following location” > Finish
  • Click on the Activate Change button
  • Start the AnalyticsRes WebApplication by selecting the application and choosing Start > Servicing all request

4.1.4 - Import FMW Security users (Weblogic users)

BIEE installation to log in).

  • From home screen, click on Security Realms link.
  • Drill on the myrealm link
  • Go to the migration Tab > Import tab
  • Point the directory to SampleApp_825_Core\SampleApp_825_Core\FMW_Users_Definition
  • Click on Save and you must get as return message:
The security provider DefaultCredentialMapper successfully imported security data.
The security provider XACMLAuthorizer successfully imported security data.
The security provider XACMLRoleMapper successfully imported security data.
The security provider DefaultAuthenticator successfully imported security data.
Settings updated successfully.
  • Verify that you can see the new users (like abell, etc) created in the User and Group Tab. You should be able to login in OBIEE using any of this user using the password Admin123.

Passwords for all SampleApp users imported, as well as the RPD encryption password is uniquely set to : Admin123

4.1.5 - OBIEE Configuration

4.1.5.1 - NQSConfig.ini

Open the BI Server configuration file NQSConfig.ini file from the following location :

\InstallHome\instances\instance1\config\OracleBIServerComponent\coreapplication_obis1
  • USER_REF_GUIDS

Make sure the following tag is set as shown below in your NQConfig file and save it :

->[SERVER]
...
FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES;
  • USAGE TRACKING

The following entry is not mandatory, but will allow the usage tracking SampleContent to show data, it is advised that you set these tags as described :

->[USAGE_TRACKING]
ENABLE = YES;
...
DIRECT_INSERT = YES;
PHYSICAL_TABLE_NAME = "09 - System DB (ORCL)"."Catalog"."dbo"."S_NQ_ACCT";
CONNECTION_POOL = "09 - System DB (ORCL)"."UT Connection Pool"; 
4.1.5.2 - Instanceconfig.xml

Open the presentation service configuration file Instanceconfig.xml file from the following location :

\InstallHome\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1

Make sure you have all the following tags within the existing <ServerInstance> tag.

<ServerInstance>
  ...
  <SpatialMaps><LayerDataLayout><MaxRecords>1000</MaxRecords></LayerDataLayout></SpatialMaps>
  <LightWriteback>true</LightWriteback>
  ...
  <ps:Catalog xmlns:ps="oracle.bi.presentation.services/config/v1.1">
    <ps:UpgradeAndExit>false</ps:UpgradeAndExit>
    <ps:UpdateAccountGUIDs>UpdateAndStartNormally</ps:UpdateAccountGUIDs>
  </ps:Catalog>
  ...
</ServerInstance>

4.1.6 - RPD

You need to have access to offline editing of your RPD to edit necessary changes for connectivity to your database system. There are two alternative ways provided below to complete necessary RPD edits for your configuration

  • Option 1 (general case) : Use Admintool to edit your RPD file
  • Option 2 : use RPD XML patching to update your RPD file

Use one of the above options according to your convenience.

On the RPD click on Manage→Variables and update the following variables:

  • BI_EE_HOME repository variable value : update the default initializer string from its current value to the correct full path of the following directory on your BIEE install :
\InstallHome\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1
  • DB_HOST - This variable holds the value of the database host machine.
  • DB_PORT - This variable holds the value of the port.
  • DB_SID - This variable holds the SID information.
  • DB_USERNAME - This variable holds the database username. (Must be BISAMPLE)

If you have not changed the OOB password for BISAMPLE user (pwd = „BISAMPLE‟), then there should be no edit needed in the RPD otherwise you need to change the password values in the database Connection Pool entries.

4.1.7 - Removing drop-shadow effect on graphs

By default, whenever a chart is created, there is a drop-shadow effect on it. This property makes it difficult to read some of the SampleApp charts. In order to turn it off this property:

  • edit the file dvt-graph-skin.xml from the following location on your installation.
\InstallHome\Oracle_BI1\bifoundation\web\msgdb\s_blafp\viewui\chart

for my installation

E:\MiddelwareHome\Oracle_BI1\bifoundation\web\msgdb\s_blafp\viewui\chart
  • edit the <Graph> tag, add the attribute visualEffects=“NONE” so it looks like the following
<Graph visualEffects="NONE">
<SliceLabel> 
   <!-- decimalDigitUsed is false here so that non-percentage pie slices do not pick up this value
        The DVTChartProcessor sets decimalDigitUsed to true if this is a percentage pie slice -->
   <ViewFormat decimalDigit="2" decimalDigitUsed="false"/> 
</SliceLabel> 
</Graph>
  • Save the file.

4.1.8 - Setting online configuration through EM (default rpd and webcat paths)

  • Login to the EM administration screen using the url http://localhost:7001/em
  • Expand 'Business Intelligence' > Coreapplication > Deployment > Repository
  • Click on 'Lock and Edit Configuration' to enable you to change the default settings.
  • In the 'Upload BI Server Repository' section, click on the Browse button and locate the SampleApp.rpd
  • Enter Admin123 as the password
  • Update the webcat path at the bottom of the same screen, with this location:
$ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/$COMPONENT_NAME/catalog/SampleApp
  • Click on Apply
  • Click on 'Activate Changes

EM screen also offers you the possibility of turning OBIEE cache on or off. Leaving cache set to off will allow to see physical SQL logs for every query. Performance should not be of issue with the low data volume in the sample database. To Switch Cache off, click on tab “Capacity Management”, sub-tab “Performance”. Disable cache there and click on Activate changes.

4.1.9 - Deploying SampleApp BIP Content

4.1.9.1 - Sample schema OE

The Oracle Sample OE schema (Order Entry) needs to be installed as part of the database samples in order for some of the BIP examples to work.

ALTER USER OE account UNLOCK;
ALTER USER OE IDENTIFIED BY OE;
4.1.9.2 - Data Sources

From the web UI – http://localhost:9704/analytics – logged in with the user biadmin (with Admin permissions), click on the Administration link > Manage BI Publisher > Data Sources:

  • JDBC Connection.
    • For the demo connection enter your parameters for the connnection string (e.g. jdbc:oracle:thin:@WINDOWS11G:1521:DB11GR2)) and be careful that the case of the password and user is important.
    • Create also a BISAMPLE connection for the BISAMPLE user
    • Test the “Oracle BI EE” JDBC connection
  • File Connection
    • Verify that you have files in the demo files directory
4.1.9.3 - Grant access to data sources

For users to be able to see data when they run BIP reports, the BI Author & BI Consumer roles must be granted access to data sources.

  • Under Administration URL in OBIEE web interface, click on “Manage BI Publisher” > “Security Center” > Roles and Permissions.
  • In the Add Data Sources column, click the “key” icon for the BI Author role & BI Consumer to add access to the database connection and to the demo files.

5 - Deploying SampleApp Action Framework Content (Optional)

Verify that you can login with the credentials abell/Admin123 otherwise you must repeat the user import step (FMW_Users_Definition)

In the folder 3_SampleApp_XXXX_Actions/ Actions_Definitions, you find tree files:

  • ActionSamples.ear. The application
  • ActionsSamples V3 (Jdev_project).zip. The application source code
  • CreateCred.py

5.1 - Deploying Sample Actions services in WLS

  • Copy the file ActionsSamples.ear in the folder \FMWHome\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\sample\SampleAppFiles\Actions
  • Deployments link in Domain Structure > Lock & Edit button > Install button
  • Locate: Choose the application file ActionsSamples.ear > Next
  • Targeting style: Install this deployment as an application > Next
  • Target: bi_server1 > Next
  • Optional Settings: Name ActionsSample > Next > Finish
  • Activate Changes
  • Deployment > Choose the Application ActionsSamples > Start : Servicing all request
  • Confirm that you get a wsdl definition on this address http://localhost:9704/ActionSamples/OrderProcessPort?wsdl

If the port of the analytics application has changed (is not 9704), you must change the following entries in the files below. They are all located in the same directory : /InstallHome/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/ActionSamples/XXXX XX/war/

5.2 - Adding Required Credentials

With WLST, run this command

wlst "CreateCred.py" username password t3://localhost:7001

where:

  • “CreateCred.py” is located in the same directory that the application ear file
  • username and password are the admin credential of the weblogic server.

5.3 - Actions configurations files

If the ports of the weblogic server (AdminServer and bi_server) have changed, open the file ActionFrameworkConfig.xml and change them.

Copy the XML files:

  • ActionFrameworkConfig.xml
  • ActionsSAMLPolicy.xml
  • wss_username_token_policy.xml

into the following directory:

/FMWHome/user_projects/domains/bifoundation_domain/config/fmwconfig/biinstances/coreapplication

Copy the file:

  • default-keystore.jks

into the following directory:

/FMWHome/user_projects/domains/bifoundation_domain/config/fmwconfig

5.4 - Restart and test

6 - Mapviewer

6.1 - Mapviewer Configuration

  • Run the script OBIEE_NAVTEQ_USER.SQL to create the Navteq user
-- USER SQL
CREATE USER obiee_navteq IDENTIFIED BY obiee_navteq DEFAULT TABLESPACE USERS QUOTA UNLIMITED ON USERS ;
 
-- ROLES
GRANT "CONNECT" TO obiee_navteq;
GRANT "RESOURCE" TO obiee_navteq;
imp obiee_navteq/[email protected] file=c:\obiee_navteq.dmp FULL=Y

If you import it in an other schema:

imp obiee_navteq/[email protected] file=c:\obiee_navteq.dmp FROMUSER=obiee_navteq TOUSER=YourUser
  • As user obiee_navteq, run the script OBIEE_NAVTEQ_INSERT.SQL to insert data into the user_sdo views.
INSERT INTO user_sdo_maps SELECT * FROM my_maps;
INSERT INTO user_sdo_themes SELECT * FROM my_themes;
INSERT INTO user_sdo_styles SELECT * FROM my_styles;
INSERT INTO user_sdo_cached_maps SELECT * FROM my_tile_cache;
commit;

Replace the security_config node with this content:

  <security_config>
    <!-- if you wish to disable direct XML based info requests from 
         MapViewer's requests web page, set the following value to true. 
     --> 
    <disable_direct_info_request> true </disable_direct_info_request>
   <disable_info_request> true </disable_info_request>
   <disable_csf>true</disable_csf>
   <enforce_security_role> true </enforce_security_role>
 
    <!-- Add remote URLs that this MapViewer's built-in proxy servlet
         is allowed to communicate with. URLs should be separated by a comma.
    -->
    <proxy_enabled_hosts>
localhost.com,http://www.localhost.com,http://localhost:9704/mapviewer,http://localhost:9704/,
http://192.168.2.247:9704/,http://192.168.2.247:9704/mapviewer,http://windows11g:9704/mapviewer,
http://windows11g:9704/,http://10.10.10.10:9704/,http://10.10.10.10:9704/mapviewer
    </proxy_enabled_hosts>
 </security_config>

Add this Predefined Data Sources at the end of the file

<map_data_source name="OBIEE_NAVTEQ_Sample"
jdbc_host="10.10.10.10" 
jdbc_sid="db11gr2" 
jdbc_port="1521" 
jdbc_user="obiee_navteq"
jdbc_password="!obiee_navteq" 
jdbc_mode="thin"
number_of_mappers="3"
allow_jdbc_theme_based_foi="false"
/>
  • Click the button “Save and Restart”
  • On the Data sources link, you should now see OBIEE_NAVTEQ_Sample.
  • To confirm that the Mapviewer configuration is working, in the page Manage Map Tile Layers > Manage, choose the Map Tile Layer called OBIEE_WORLD_MAP and click on 'View Map / Manage tiles' option. In the window that opens up, click on the 'Show Map' button. This should display the world map.

6.2 - OBIEE Configuration

Login to Answers > Go to Administration > Manage Map Data and verify that the source OBIEE_NAVTEQ_Sample, the map and images are present

7 - Support

7.1 - You must select an application before continuing

You can get this error when you try to deploy the analyticsRes application and if you have copied the file in this directory:

MiddelwareHome\instances\instance1\OracleBIPresentationServicesComponent\coreapplication_obips1

instead of this one:

MiddelwareHome\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1

Did you notice the difference ? Copy the files in the good location and retry your deployment.

7.2 - No application files exist at

When attempting to restart the ActionSample Appliation, you can get this error:

weblogic.management.DeploymentException: [Deployer:149003]Unable to access application source information in
'E:\MiddelwareHome\user_projects\domains\bifoundation_domain\servers\bi_server1\stage\ActionSamples\ActionSamples.ear'
for application 'ActionSamples'. The specific error is: [Deployer:149158]No application files exist at 
'E:\MiddelwareHome\user_projects\domains\bifoundation_domain\servers\bi_server1\stage\ActionSamples\ActionSamples.ear'..

Solution: Restart the managed server (bi_server1)

8 - Documentation / Reference

dat/obiee/admin/11g/sample_app.txt · Last modified: 2018/03/26 11:24 by gerardnico