Oracle BI12c: placing custom images in BI Server and reference using fmap

For Oracle BI 12c custom content such as images or pdf help files needs to be placed in the following directory:

/domains/bi/servers/obips1/tmp/earmanager/analytics/../res/

where /../ is a dynamic folder name such as v-PLM12aFeu7Y.

Within a Report or Dashboard this path may be referenced using the following syntax:

fmap:file_name

or:

fmap:foldername/file_name (if a subfolder “foldername” was created below /res)

the below links provide further information on using fmap or placing custom resources within Oracle BI:
Storing Custom Files Locally and Using the fmap Function to Reference Them
How to configure static content in OBIEE 12c

Advertisements

Bug: creation of Windows service for Oracle BI 12.2.1.2.0 within installation

During the installation of Oracle BI 12c (Version 12.2.1.2.0) a Windows service called “Oracle Business Intelligence [bi]” is automatically created to start & stop the BI services (Weblogic + BI Domain) as a Windows service e.g. to auto startup the BI Services in case the complete windows server is re-booted.

For the current version 12.2.1.2.0 a bug exist which configures the Environment variables incorrectly when the Oracle BI installation is not done to the C:\ drive, but another hard drive within the server, such as D:\ . The issue only applies to starting and stopping the BI Services via the Windows Service method and not to starting/stopping via from the start.cmd command line (as the Windows service points to a different start script located in the oracle.bi.sysman directory and does not use the regular bitools/bin/start.cmd script). The incorrect setting of the Environment variables prevents the Windows service from starting the BI Services and the following error is written to the windows services log file:

BI_PRODUCT_HOME set as c:\windows\system32
ORACLE_HOME set as C:\Windows
[…]
The system cannot find the path specifiedimage
This is caused by an within the start.cmd script which is called from the Windows service “Oracle Business Intelligence [bi]” and located in the following directory:

D:\Oracle\Obiee12c\bi\modules\oracle.bi.sysman\scripts\start.cmd

The script uses the windows shell command pushd and popd to write the current working directory into the session, but doesn’t catch if the installation is done to a different drive from C:\ when performing a cd (change directory) command. This can be seen by the fact that the BI_PRODUCT_HOME and ORACLE_HOME are referencing (pointing) to the patch of the windows cmd tool C:\windows\system32 rather then the correct Oracle BI installation directory.

As a workaround the pushd and popd have been removed from the start.cmd script and the path has been specified for path Environment variables BI_PRODUCT_HOME & ORACLE_HOME.

SET BI_PRODUCT_HOME=D:\Oracle\Obiee12c\bi\
ECHO BI_PRODUCT_HOME set as %BI_PRODUCT_HOME%
SET ORACLE_HOME=D:\Oracle\Obiee12c
ECHO ORACLE_HOME set as %ORACLE_HOME%
SET default_biDomainHome=%ORACLE_HOME%\user_projects\domains\bi


after saving the file like above the Windows service uses the correct environment variable path, as seen by comparing both highlighted areas below:

Oracle BI 12c: File locations

important file locations for Oracle BI 12c:

module location
scripts directory /opt/oracle/obiee/user_projects/domains/bi/bitools/bin
Repository (RPD) /opt/oracle/obiee/user_projects/domains/bi/bidata/service_instances/
ssi/metadata/datamodel/customizations
Web Catalog /opt/oracle/obiee/user_projects/domains/bi/bidata/service_instances/
ssi/metadata/content/catalog
NQSConfig.INI /opt/oracle/obiee/user_projects/domains/bi/config/fmwconfig/biconfig/
OBIS/
instanceconfig.xml /opt/oracle/obiee/user_projects/domains/bi/config/fmwconfig/biconfig/
OBIPS/
tnsnames.ora /opt/oracle/obiee/user_projects/domains/bi/config/fmwconfig/
bienv/core
AdminServer log /opt/oracle/obiee/user_projects/domains/bi/servers/
AdminServer/logs
Managed Server logs /opt/oracle/obiee/user_projects/domains/bi/servers/
bi_server1/logs
BI Server logs /opt/oracle/obiee/user_projects/domains/bi/servers/obis1/logs
Presentation server logs /opt/oracle/obiee/user_projects/domains/bi/servers/obips1/logs

define alias for starting/stopping Oracle BI

For starting and stopping of Oracle BI 11g the OPMN services was used. The usage of OPMN for starting and stopping the Oracle BI 11g services has also been described in a previous posting.

With Oracle BI 12c, OPMN is not used further anymore. The scripts to start Oracle BI can be found in the following directory:

/opt/oracle/obiee/user_projects/domains/bi/bitools/bin

image

To start the Oracle 12c instance the following command can be used:

./start.sh

image

Within linux a alias can be created to call the start script without navigating to the directory each time. To create the alias the bashrc needs to be edited using the following command:

gedit ~/.bashrc

image

this opens the bashrc file using the gedit editor to add the following lines at the bottom of the file:

alias bistart='/opt/oracle/obiee/user_projects/domains/bi/bitools/bin/start.sh'
alias bipsstart='/opt/oracle/obiee/user_projects/domains/bi/bitools/bin/start.sh -i obips1'
alias bistop='/opt/oracle/obiee/user_projects/domains/bi/bitools/bin/stop.sh'
alias bipsstop='/opt/oracle/obiee/user_projects/domains/bi/bitools/bin/stop.sh -i obips1'
alias bistatus='/opt/oracle/obiee/user_projects/domains/bi/bitools/bin/status.sh'

image

after this the file needs to be saved and the bashrc needs to be executed to take effect:

. ~/.bashrc

image