October 2014 PCM 14 and P6 Version 8.4 D R McNatty
www.drmcnatty.com
XML Data Retrieval for Working in BI RTF Tool Summary:
When working in the RTF (Word) template tool, you need to save a copy of your Data
Model as an XML copy that you’ll load to work with the form. If you make changes to
the Data Model in BI, you need to re-export the data model to a new XML file to load
when you open the RTF tool.
Methods to Retrieve XML output:
Two methods—one is to use the retrieval arguments found in your existing “Sample
Data” stored on the BI server and the second is to get the retrieval arguments from a
new record in PCM.
Using Sample Data
1. Open the Data Model in BI web.
2. In the main tab, Attachment section, click on “sample.xml.” (see next page)
3. Scroll the window that opens and find your retrieval arguments (usually
“master_key”, “project_name”, “vendor_type”) and highlight and copy. (see
next page)
4. Open Notepad or a text editor and click paste to store.
5. Close the window.
6. Next, in the Data Model click the “XML” icon. (see page 3)
7. Enter your retrieval arguments, and then click “Run.” (see page 3)
8. Click on the Actions dropdown and select “Save as Sample Data.” (see page 4)
9. Click on “XML” icon, re-enter the retrieval arguments and click “Run.”
10. Click on the Actions dropdown and select “Export XML” and save file to your local
computer. (see page 4)
a. This is the XML file you will use when modifying the RTF layout.
These tech tips are offered free of charge in the spirit of sharing knowledge with others. T hey do not include technical support, should you have a problem with them. We are always interested in how they can be improved, please do not hesitate to email us your comments. T hese tips have been thoroughly tested by our consultants in a variety of environments. Please read these tech tips thoroughly and be sure that you understand them before trying to use them. We can not be responsible for issues that develop because of the configuration of your hardware, technical environment or application of the tech memos. If you are not sure, then we urge you to contact Oracle technical support or your local support consultant for assistance. Platinum
Partner
Specialized
Primavera(Unifier
Primavera(P6(EPPM
Primavera(Contract(Management
1
2
XML Data Retrieval for Working in BI RTF Tool Item #2
Item #3
Page 2
1
2
XML Data Retrieval for Working in BI RTF Tool Item #6
Item #7
Page 3
1
2
XML Data Retrieval for Working in BI RTF Tool Item #8
Item #10
Page 4
1
2
XML Data Retrieval for Working in BI RTF Tool Using PCM to retrieve new sample data:
1. In PCM, open the appropriate log for the records, and right click on one record
and select “Copy Shortcut.” (see below)
2. Paste this shortcut into Notepad or a text editor.
3. You can extract the master_key and project_name/vendor_type arguments from
this URL. (see page 6)
4. Open the Data Model in BI web.
5. Next, in the Data Model click the “XML” icon.
6. Enter your retrieval arguments, and then click “Run.”
7. Click on the Actions dropdown and select “Save as Sample Data.” (see page 7)
8. Click on “XML” icon, re-enter the retrieval arguments and click “Run.”
9. Click on the Actions dropdown and select “Export XML” and save file to your local
computer. (see page 7)
a. This is the XML file you will use when modifying the RTF layout.
Item #1
Page 5
1
2
XML Data Retrieval for Working in BI RTF Tool Item #3
Page 6
1
2
XML Data Retrieval for Working in BI RTF Tool Item #7
Item #9
Page 7
1
2
XML Data Retrieval for Working in BI RTF Tool Retrieving the RTF layout
1. In BI Web, open the form/report in question and click “Edit” on the layout.
2. Save the RTF to your local computer.
Working with the RTF Layout
1. Open the RTF layout in Word, and on the BI toolbar click “Sample XML” in the
Load Data, browse to the XML you saved and click ok.
2. Make changes to your layout and Save.
a. NOTE: be sure to keep the layout as RTF—do NOT save as DOC or
DOCX.
3. Best practice is to rename the layout using the date of change.
Upload the new RTF Layout to BI
1. Open BI Web and navigate to the form/report you modified.
2. Click “Add New Layout” and select the “Upload” to find the RTF you just
modified.
3. Once uploaded, click on “View a List” in the BI Web screen, and assign the new
RTF file as the “Default Layout” and uncheck the “Active” and “View Online” on
the other, older layouts.
4. SAVE the form/report.
Page 8