OBIEE 10G/11G - BI Server Utilities

Bi Server Architecture With Client

OBIEE 10G/11G - BI Server Utilities


OBIEE have several executables files which permit you to automate some actions.

In 11g, before running any of the Oracle BI Server command-line utilities, you must first run bi-init.cmd (or on UNIX)

To interact with the repository, the Oracle BI Server has two system management API:

that use utilities.


Utility 11G Description Note
nqcmd.exe nQcmd.exe - -
OBIEE - Connection Pool Change (Username, password) 10G/11G Utility to change the passwords -
nqsecudmlgen.exe nQSecUDMLGen.exe - -
nqsshutdown.exe nQSShutDown.exe Utility to shut down the Oracle BI Server -
nqudmlcli.exe nQUDMLCli.exe - -
nqudmlexec.exe nQUDMLExec.exe udml Executor This command line tool can modify the RPD file by combining the fragment you define in the UDML file with the input repository and generate a output repository.
nqudmlgen.exe nQUDMLGen.exe udml Generator can generate the entire repository in a text format
SchConfig.exe SchConfig.exe - You may use the schconfig utility to configure Oracle BI Scheduler.
schshutdown.exe SchShutdown.exe - -
- SASchInvoke.exe launch an Oracle BI Scheduler job from the command line
admintool.exe admintool.exe - -
nqlogviewer - - -
patchrpd 11G Used to generate and apply an XML patch file. This utility is especially useful for patching repository files on Linux or UNIX systems
prunerpd 11G Used to delete unwanted repository objects from your repository file, such as databases, tables, columns, initialization blocks, and variables.
sametaexport 11G Used to exchange metadata (dimension, hierachy) with the Oracle Database and DB2
extractprojects 11G Used to extract projects from a given repository.
equalizerpds 10G/11G Used to equalize objects
nqgenoldverrpd 11G Repository Downgrade utility
XML utilities (11G) Used to leverage the Oracle BI Server XML API
biserverxmlgen 11g generates XML from an existing RPD
biserverxmlexec 11g executes the XML in offline mode to create or modify a repository file
biserverxmlcli 11g executes the XML against the Oracle BI Server
obieerpdpwdchg 11G Change password of connection pool

Where are they located ?

OS Directory 10G Directory 11G
Windows OracleBI_HOME\server\Bin ORACLE_HOME\bifoundation\server\bin


Discover More
Bi Server Architecture With Client
OBIEE - BI Server (OBIS|nqsserver|nqs)

OBI Server is also known as: OBIS (Oracle Business Intelligence Server) or nqsserver (The process name) OBI Server is principally a query and analysis server software: that can integrate data...
Obiee Bi Server Patch
OBIEE - BI Server Patch (automatic update with a patch file)

An alternate way of updating the RPD manually is to script it with an XML patch file. In this approach, you don‟t need to open the RPD through an Admin tool. Instead, the values of the variables...
Bi Server Architecture With Client
OBIEE - nqgenoldverrpd (Repository Downgrade)

Repository Downgrade utility. where the option: P is the repository password I is the path to the original repository O is the path to the created repository V is the downgrade version (302...
Oracle Database Em Dimension
OBIEE 11G - sametaexport utility (Metadata Exchange)

sametaexport is an utility to exchange metadata with DB2 or Oracle Database (Dimension with its Hierarchy) to pre-aggregate the relational data and improve query performance. For DB2, the utility: ...

Share this page:
Follow us:
Task Runner