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
Articles Related
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);
................