OBIEE - nqudmlgen.exe

Bi Server Architecture With Client

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);

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





Discover More
Bi Server Architecture With Client
OBIEE 10G - Universal Database Markup Language (UDML)

UDML is the abbreviation for Universal Database Markup Language. It is an undocumented and unsupported API for the Oracle BI Server 10G. For 11g, see The simplest way to get the UDML definition...
Bi Server Architecture With Client
OBIEE 10G/11G - BI Server Utilities

OBIEE have several executables files which permit you to automate some actions. bi-init.cmd (or bi-init.sh on UNIX) To interact with the repository, the Oracle BI Server has two system management API:...



Share this page:
Follow us:
Task Runner