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

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 OBIEE 10G/11G - Repository (RPD file) or OBIEE 10G/11G - Repository (RPD file) 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 (<note warning>only for the version 10g</note>)

The admintool is located in this directory BI_ORACLE_HOME/server/Bin

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
    Hide
    GenerateMetadataDictionary {\MetadataDictionaryFolder}
    Close
    Exit

  • 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


Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap