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

Bi Server Architecture With Client

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

How to

Start

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

BI_ORACLE_HOME/server/Bin

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

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

Inconsistency Check

Diagnostic

Log

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

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..."

Documentation / Reference





Discover More
Obiee Scheduler Configuration Mail
Blog - Obiee 10G – How to configure the Mail server of Oracle BI Scheduler/Delivers

This article talk the configuration of the smtp mail server of Oracle BI Scheduler. To set up the smtp server, you must enter at least this information as : the sender address the smtp server the...
Obi Edition
Diagnostic

Oracle BI Administration Tool nqsadmintool.log The log for the Oracle BI Administration Tool ? JavaHost jh-n.log The JavaHost Server main diagnostic log Yes Oracle BI Scheduler nqscheduler-Agent...
Obiee 10g Administration Utilitites Aggregate Persistence
OBIEE - Aggregate Persistence Wizard (aka Data Mart Automation)

The Aggregate Persistence Wizard is an Admintool utility that help you to create an aggregate persistence script. It allows the administrator to select measures and grains in order to create a set of...
Obiee Relationships Between Oracle Bi Infrastructure Components
OBIEE - Architecture

The Oracle Business Intelligence components consist of: Oracle Business Intelligence Presentation Services The Oracle Business Intelligence Presentation Services provides the framework and interface...
Obi Edition
OBIEE - Client Tools

Oracle Business Intelligence provides the following client tools, which are supported only on 32-bit Windows operating systems: Oracle Business Intelligence ODBC Driver Oracle Business Intelligence...
Logical Business Model
OBIEE - Common Enterprise Information Model (CEIM) - The Logical Business Model (the three-layer metadata model)

The Logical Business Model is the three-layer metadata model of the repository and its aim is to build a known also as a model-centric view (as compared to report-centric view of information). Each layer...
Obiee Webcat Critical Folder
OBIEE - Connection Pool Change (Username, password)

method to change the connection parameter of a connection pool from a rpd file (password, ...) Example: list...
Obiee Administration Tools Logon
OBIEE - How to connect remotely to the servers (BI, Presentation) ?

This article shows you how you can perform a remote connections with the OBIEE client tools Administration Tool and catalog manager to manage respectively : the BI Server and the web catalog Variable...
Obiee Connection Pool Shared Logon
OBIEE - How to define one different database credential for each user (the shared logon) ?

For system architecture reasons, you may want to have one database credential by user. Example : When one schema (of one user) is the logical entity of one company, you may decide to have the same...
Bi Server Architecture With Client
OBIEE - Session Manager

The Oracle BI Administration Tool Session Manager is used in online mode to monitor activity. You can see which users are logged in, disconnect users, and terminate queries.The Session Manager shows all...



Share this page:
Follow us:
Task Runner