OBIEE - nqudmlgen.exe

About

With nqudmlgen.exe, you can generate the complete content of a file repository in a text file in the udml format.

You can use it to :

  • retrieve UDML syntax
  • automate some tasks
  • migrate a repository from a newer to an older version (from 184 to 180 for instance). You create the UDML file with nqudmlgen.exe an recreate a repository in the good version with the nQUDMLExec of the lower version of OBIEE

Syntax

E:\>e:\product\oraclebi\server\bin\nqudmlgen.exe
nQUDMLGen  
       -U userid (only for 10g)
       [-P [password]] (user password for 10g, repository password for 11g)
       -R repository_pathname 
       -O output_script_pathname 
       [-8]
       [-N]
       [-Q]
       [-S]
                     -h Display this usage information and exit.
                     -8 is for UTF-8
                     -N is for not generating upgrade id
                     -Q is for generating script without security objects
                     -S is for generating script for only security objects
                     Q and S override each other if both are present

Example

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Nicolas>cd C:\OracleBI\server\Bin

C:\OracleBI\server\Bin>nQUDMLGen -U Administrator -P Administrator -R C:\OracleBI\server\Repository\sh.rpd 
-O C:\OracleBI\server\Repository\sh.udml

C:\OracleBI\server\Bin>

And you obtain the complete UDML command in the sh file :

DECLARE REPOSITORY PROPERTIES (
	'CustomPresentationLayer' = '01',
	'PersistedNextUpgradeID' = 'C81B0000');
VERSION 1.1.184;
DECLARE SUBJECT AREA "SH" AS "SH" UPGRADE ID 311
	DIMENSIONS (
		   "SH"."ProductsDim",
		   "SH"."ChannelsDim",
		   "SH"."PromotionsDim",
		   "SH"."TimesDim",
		   "SH"."CustomersDim" )
	LOGICAL TABLES (
		   "SH"."Salesfacts",
		   "SH"."Channels",
		   "SH"."Customers",
		   "SH"."Products",
		   "SH"."Promotions",
		   "SH"."Times",
		   "SH"."Demographics",
		   "SH"."Salesfacts CurrentMonth",
		   "SH"."Sales With Fragmentation",
		   "SH"."SalesFact Tommy",
		   "SH"."StoredProcedure",
		   "SH"."Dummy Table" ) SUBJECT AREA AVAILABLE
	PRIVILEGES ( READ);

................

Powered by ComboStrap