My Oracle Support Banner

OBIEE 11g: How To Run the Administration Tool and Administer Repositories in Automated Mode from the Command Line (Doc ID 1574480.1)

Last updated on APRIL 14, 2021

Applies to:

Business Intelligence Server Enterprise Edition - Version and later
Business Intelligence Suite Enterprise Edition - Version and later
Information in this document applies to any platform.


This note describes how to run the Administration Tool in automated mode from the command line and lists the commands you can use to administer a repository.


This is intended for experienced OBIEE administrators and repository builders.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 BusinessModelConsistencyCheck businessModelName [outputFileName]
 CheckinSubset ModifiedSubsetRepositoryName dummy password [decisionFile [{Yes|No}]]
 Compare FileName [password] [outputFile]
 ConsistencyCheck [outputFileName]
 CreatePatch FileName [dummy] password outputFile
 CreateSubset NewRepositoryName PrimaryRepositoryName numberOfProjects project1 [project2 [project3 [...] [dummy] repositoryPassword
 DeleteObject ObjectType FullyQualifiedObjectName
 DescribeRepository FullyQualifiedOutputFile Encoding
 Drag ObjectType FullyQualifiedObjectName
 Drop {Yes|No} ObjectType FullyQualifiedObjectName
 Drop {Yes|No} {Presentation|"Business Model and Mapping"|Physical}
 ExecuteQuery queryFile queryResultDirectory
 ExternalizeStrings FullyQualifiedOutputFile Encoding [SubjectAreaName_1 [SubjectAreaName_2 [TargetLevelName_1]
 GenerateMetadataDictionary DictRootDirectory
 GenerateQueryTestCases outputFile [random_seed]
 ImportDB {Yes|No} {"OracleWS"|"Siebel OM"|"OracleADF_HTTP"|"OCI 10g/11g"|"ODBC 2.0"|"ODBC 3.5"|"DB2 CLI (Unicode)"|XML|XMLA|AW} other_params
  EssBase DB options:
 ImportDBExecute {Yes|No} {Yes|No}
 ImportDBObject {Database|"Physical Catalog"|"Physical Schema"|"Physical Table"|"Physical Column"|"Physical Cube Table"|"Analytic Workspace"} list_of_names
 ImportDBSetTableType number
 ImportDBSetKeyImportType number
 ImportRepository {Online|Offline} {FileName|DSNname} [user [password]]
 ImportRepositoryObject {Project|"Presentation Catalog"|User|"Security Group"|Variable} {Name|*} [True|False [True|False]]
 LinkToSourceControl path/to/MDS-XML-Repo path/to/SCM-config.xml
 Merge FileName1 FileName2 [DecisionFile] [dummy] password1 [dummy] password2 [{Yes|No}] [resultingFileName]
 MessageBox [message]
 MudCheckoutWholeRpd NewRepositoryName PrimaryRepositoryName repositoryPassword
 New FileName [repositoryPassword]
 OpenOffline Name [repositoryPassword]
 OpenOnline DSN user password repositoryPassword
 Open FileName dummyParameter repositoryPassword
 Patch FileName1 FileName2 [DecisionFile] [dummy] password1 [password2 equalize [dummy dummy] [dummy dummy dummy]] 
 Publish [LockUserFullName]
 RefreshSubset password [decisionFile [{Yes|No}]]
 SaveAs FileName
 SaveAsMdsXml DirectoryName
 SetAutoConnectionPool fqName
 SetIcon ObjectType FullyQualifiedObjectName IconNumber
 SetMUDPath [dir]
 SetProperty ObjectType FullyQualifiedObjectName PropertyName PropertyValue
 SetRowCountFile outputFileName
 SetUserAndComputer userName computerName
 SyncUsingConnectionPool {Yes|No} {Yes|No}
 TestExtender {ADF|Essbase} DBXUDMLFileName
 TestInitBlock initBlockName FullyQualifiedOutputFile Encoding
 TestLdapServer ldapServerName outputFileName
 UpdatePhysical [Database [ConnectionPool]]
 UpdateRowCount ["Physical Column"|"Physical Table"] fqName
 ViewData fqTableName [columnName_1 [columnName_2 ...[columnName_n]]]

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.