Rearranging Columns in Oracle BI using nQUDNLGen and nQUDMLExec

Rearranging columns manually in rpd is a boring task along with waste of time. However Oracle BI has provided nQUDMLGen.exe and nQUDMLExec.exe which can be used to convert rpd into text format and back to rpd. We can use these applications to convert rpd to text then rearrange the columns in Excel or any text editor and convert the text file back to rpd.

The process is explained below:
1.Open rpd in Admintool and copy the table.


2. Open notepad/Excel and Paste.

3. Change the order of columns in the way you want it to be and save the file. Similar changes can be made for any object in rpd.

4. In command prompt browse to the OracleBI/server/bin folder and run the following command:

Syntax: nQUDMLExec [-U [userid]] [-P [password]] -I input_script_pathname [-B base_repository_pathname] -O output_repository_pathname [-8]
-8 is for UTF-8
Eg 1: nQUDMLExec -I testudml.txt -O rp1.rpd
create a new repository rp1. textfile should contain complete rpd definition
Eg 2: nQUDMLExec -U administrator -I testudml.txt -B rp1.rpd -O rp2.rpd
modify rp1 and write to rp2

5. Open the rpd in admintool and confirm the changes.

Just like columns we can also reorder Presentation Tables. The complete rpd can be exported to textfile using nQUDMLGen.exe.