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 JANUARY 30, 2020

Applies to:

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

Purpose

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.

Scope

This is intended for experienced OBIEE administrators and repository builders.

Details

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
Purpose
Scope
Details
 BusinessModelConsistencyCheck businessModelName [outputFileName]
 CheckinSubset ModifiedSubsetRepositoryName dummy password [decisionFile [{Yes|No}]]
 ClearUserAndComputer
 Close
 Compare FileName [password] [outputFile]
 ConsistencyCheck [outputFileName]
 CreatePatch FileName [dummy] password outputFile
 CreateSubset NewRepositoryName MasterRepositoryName 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
 Exit
 ExternalizeStrings FullyQualifiedOutputFile Encoding [SubjectAreaName_1 [SubjectAreaName_2 [TargetLevelName_1]
 GenerateMetadataDictionary DictRootDirectory
 GenerateQueryTestCases outputFile [random_seed]
 Hide
 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]]
 ImportRepositoryExecute
 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 MasterRepositoryName 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}]]
 Save
 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]]]
References

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