[OBIEE 10g] Automating The Metadata Dictionary Repository Updates

 

 Automating the Metadata dictionary repository updates

step 1: Create a command file

Create a small command file called: nQMetaDataExport.txt (or which ever name you like)

Add the following text:

Open samplesales.rpd Administrator AdministratorPassword

Hide

GenerateMetadataDictionary {\MetadataDictionaryFolder}

Close

Exit

step 2: Create a scheduler command 

Specify: 

{OracleBI}\server\Bin>admintool /command {YournQCommandDirectory}:/nQMetaDataExport.txt