OBIEE 11G - Sample App V107

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics)

In Progress

1 - About

Installation steps for the sample app versie V107.

Advertising

3 - The files

To unzip, use:

  • 7-zip (on windows)
  • or unzip command (on Linux)
$ cat SampleApp_10722.zip.* > SampleApp_10722_Full.zip
$ dir
SampleApp_10722_Full.zip  SampleApp_10722.zip.002
SampleApp_10722.zip.001   SampleApp_10722.zip.003
$ unzip SampleApp_10722_Full.zip

After successful unzipping of install files, you will have the following sub-directories and files under the installation folder named “SampleApp_10722”.

  • 1.) Actions
  • 2.) Core
  • 3.) DataSources
  • 4.) Essbase
  • 5.) Others
  • 6.) installSA.bat
  • 7.) installSA.sh

4 - InstallSa script

In installSa file (.bat or.sh), set the variable:

  • OBIEE_INSTALL_HOME to the Fusion Middleware home
  • OBIEE_INSTANCE to the name of you instance (standard=instance1

Example:

#--------------------Set env variables--------------------
#IMPORTANT: Key in correct values for the following environment variables

OBIEE_INSTALL_HOME="/u01/app/oracle/product/fmw"
OBIEE_INSTANCE="instance1"

Advertising

4.1 - The errors

The errors come from the fact that no directory analytics_11.1.1 exists in the directory _WL_USER.

This is because the installation is of type Enterprise and not Simple. In the case of an Enterprise installation, the path must go in the bi_server1 and not in the adminserver.

Copy the file installSA, rename it (for instance installSA_biserver) and in the copy file section, leave only the below commands:

echo "[INFO] Copying files for Actions"
cp -rf $SA_INSTALL_DIR/Actions/CommentaryArtifacts/*.gif $OBIEE_INSTALL_HOME/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/7dezjl/war/res/b_mozilla/actions
cp -rf $SA_INSTALL_DIR/Actions/CommentaryArtifacts/*.gif $OBIEE_INSTALL_HOME/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/7dezjl/war/res/s_blafp/images
 
cp -rf $SA_INSTALL_DIR/Actions/CommentaryArtifacts/UserScripts.js $OBIEE_INSTALL_HOME/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/7dezjl/war/res/b_mozilla/actions
cp -rf $SA_INSTALL_DIR/Actions/CommentaryArtifacts/UserScripts.js $ORACLE_HOME/bifoundation/web/app/res/b_mozilla/actions

And start the file:

$ chmod +x installSA_biserver.sh
$ ./installSA_biserver.sh

5 - The database

If the schema exist, they must be dropped before importation.

Schema Password Remarks
BISAMPLE BISAMPLE Main schema that houses data for SampleApp analyses
OBIEE_NAVTEQ obiee_navteq NAVTEQ copyrighted data used for map views
BIFOD BIFOD OLTP 3NF model for FOD (Oracle Fusion Order Demo) data model.
BIBPM BIBPM BPM (SOA) Business Process Monitoring model to show how BIEE semantic layer can deliver analytics on BPM context
DEV_ODI_REPO DEV_ODI_REPO This supports the SampleApp Oracle Data Integrator content
ODI_STAGING ODI_STAGING This supports the SampleApp Oracle Data Integrator content

As sysdba, creation of the import directory:

CREATE OR REPLACE directory datapumpdir AS '/tmp/';

Get the version of the oracle database and replace it in the command line below

impdp "'"sys/[email protected] as sysdba"'" directory=datapumpdir dumpfile=SASchemas.dmp version=11.2.0.2.0 
schemas=BISAMPLE,OBIEE_NAVTEQ,BIFOD,BIBPM,DEV_ODI_REPO,ODI_STAGING LOGFILE=SASchemas_imp.log

As sysdba:

ALTER USER BISAMPLE IDENTIFIED BY BISAMPLE;
ALTER USER OBIEE_NAVTEQ IDENTIFIED BY obiee_navteq;
ALTER USER BIFOD IDENTIFIED BY BIFOD;
ALTER USER BIBPM IDENTIFIED BY BIBPM;
ALTER USER DEV_ODI_REPO IDENTIFIED BY DEV_ODI_REPO;
ALTER USER ODI_STAGING IDENTIFIED BY ODI_STAGING;

As obiee_navteq/obiee_navteq

INSERT INTO user_sdo_maps SELECT * FROM obiee_navteq.my_maps;
INSERT INTO user_sdo_themes SELECT * FROM obiee_navteq.my_themes;
INSERT INTO user_sdo_styles SELECT * FROM obiee_navteq.my_styles;
INSERT INTO user_sdo_cached_maps SELECT * FROM obiee_navteq.my_tile_cache;
commit;
Advertising

6 - Weblogic

6.1 - Importing User

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 Core\FMW_Users_Definition on the OBIEE server such as /tmp/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

6.2 - AnalyticsRES and metadata

This step allows to point the Weblogic server to a file folder location for:

You have then to repeat two times this procedure.

  • Domain Structure > bifoundation_domain > Deployment > Install button
  • Locate deployment to install and prepare for deployment: Enter the path of the files > Next
Files for Location
Skin MiddelwareHome\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1 \analyticsRes
Metadata dictionary MiddelwareHome\instances\instance1\metadatadict

  • 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|metadatadict) WebApplication by selecting the application and choosing Start > Servicing all request

7 - Support

7.1 - ORA-39142: incompatible version number 3.1

Import: Release 10.2.0.5.0 - Production on Monday, 12 September, 2011 15:56:44

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39142: incompatible version number 3.1 in dump file "/tmp/sampleapp/SASchemas.dmp"

You need to have an Oracle Database 11gR2 to be able to import the dump file.

8 - Documentation / Reference