Thursday Aug 08, 2013

How to Generate Your Own RPD from P6 Analytics UDML

Starting in the P6 Analytics 3.1 release we began shipping the UDML that is used to generate the RPD that includes all the Primavera subject areas. If you have the UDML file you can generate your own RPD. This allows for some flexibility with versioning, if there are any changes or releases of Oracle Business Intelligence that might cause conflict with our RPD. Also with the UDML, you can directly edit or update the UDML and generate a new RPD based on your changes. We have seen others take advantage of this to make it easier to add more than 20 codes and udfs. Through the UDML, copy and paste can make it alot easier to add those additional codes and udfs rather than
using the GUI OBI Admin tool for the RPD. 

To generate a new RPD you just need an OBI installation. On that machine copy the UDML file (primavera_analytics_rpd.udml) from the P6_R31_Analytics\obi\rpd folder in the media pack. When generating the new RPD you will be supplying your own password. Open a terminal or cmd line prompt and go to the directory  <OBI HOME>\bifoundation\server\bin
and run the following command (for Windows, adjust the directories as needed for Linux installations) 

nqudmlexec.exe -P prima123vera -I C:\temp\test\primavera_analytics_rpd.udml -O C:\temp\test\PrimaveraAnalytics.rpd

In this example:

-P is the password of the new RPD  

-I is the directory where the UDML file has been copied to  

-O is the directory where your new RPD will be created. 

If there are other options you would like to set you can use the help in this utility to find the parameters. Now that the RPD has been generated you can deploy it through Weblogic like you would the RPD that is shipped with P6 Analytics. 



About

Provide new information on P6 Analytics and Reporting Database.

Search

Categories
Archives
« August 2013 »
SunMonTueWedThuFriSat
    
1
2
3
4
5
6
7
9
10
11
12
13
14
15
16
17
18
19
21
22
23
24
25
26
27
28
29
31
       
Today