OBIEE 10G/11G - Administration Tool (admintool, datamodel)

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics) > OBIEE - BI Server (OBIS|nqsserver|nqs)

1 - About

admintool.exe is the Administration tool to manage OBIEE server and have some capabilities to automate some repetitive tasks and principally his embedded tools.

Oracle Business Intelligence Administration Tool is available only for Windows operating systems.

The Administration Tool is a Windows application that allows the BI Server administrator to create and edit repositories.

Repositories can be edited with the administration tool in either online or offline mode.

The Administration Tool also includes a session manager and a cache manager which are available in online mode. The Cache Manager displays what queries have been cached and how frequently they have been accessed. You can also select and delete items in cache


3 - How to

3.1 - Start

3.1.1 - 10G

You can start it in two ways :

  • with the Windows Menu : Start > All Programs > Oracle Business Intelligence > Administration
  • by starting the executable file admintool.exe (only for the version 10g)

The admintool is located in this directory


3.1.2 - 11G

You can start it in two ways :

  • with the Windows Menu : Start > All Programs > Oracle Business Intelligence > Administration
  • launch the Administration Tool from the command line using bi-init.cmd.

Do NOT open the RPD by simply double clicking on the RPD file or typing Admintool.exe in a command line. The resulting Administration Tool window is not initialized to your Oracle instance, and errors will result later in your session. Ignoring this will lead to creating inconsistencies in the RPD file.

The admintool is located in this directory

BI_ORACLE_HOME/bifoundation/server/bin (\MiddelwareHome\instances\instance1\bifoundation\server\bin

4 - OBIEE - Metadata dictionary Automatic Export

How to automate the creation of the metadata dictionary.

  • Create a command file BiServerMetaDataExport.txt
    Open repository.rpd AdministratorLogin AdministratorPassword
    GenerateMetadataDictionary {\MetadataDictionaryFolder}
  • Create a scheduler command
{OracleBI}\server\Bin>admintool /command /BiServerMetaDataExport.txt

More command : OBIEE 11g: How To Run the Administration Tool and Administer Repositories in Automated Mode from the Command Line

5 - Inconsistency Check

6 - Diagnostic

6.1 - Log

  • 11g Client: ORACLE_BI_HOME\oraclebi\orainst\diagnostics\logs\OracleBIServerComponent\coreapplication\Administrator_NQSAdminTool.log

6.2 - The import wizard Metadata shows nothing

Be sure to have in your bi-init script the path set to the good directory bin of an Oracle Client.

SET PATH=C:\toTheOracleDatabaseHome\BIN;%PATH%

See Oracle Schemas Not Visible In OBIEE 11g Metadata Import Wizard And Admin Tool Log Shows Error: "[nQSError: 93001] ...Cannot load library, oracore11.dll..."


7 - Documentation / Reference