![\"\"](\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2009\/07\/072009-2024-arenewables1.png\")
<\/p>\nYou are implementing Primavera P6 and have determined that the delivered reporting tools are not up to snuff.\u00a0 Before you go out and buy a new report-writing tool, take a step back and look in your enterprise toolbox.\u00a0 You might find you already have a tool that fits the bill.<\/p>\n
At Iberdrola Renewables, we have a large contingent of data consumers who need read-only access to project information stored in Primavera.\u00a0 P6 has proved to be a great and flexible tool for managing vast amounts of project metadata.\u00a0 \u00a0By configuring Project Codes, Project UDFs, and Project Layouts in P6, we have streamlined the process of managing project pipeline data and greatly enhanced data quality.\u00a0 However, the licensing cost and training effort to get dozens of read-only users to access that information in P6 was disconcerting.\u00a0 What was needed was a simple-to-use tool to provide a read-only view of the pipeline data to the casual user.<\/p>\n
To a reporting tool, data is data.\u00a0 Org Publisher (from Aquire) is designed and marketed to chart and display employee and human resource records via an intuitive browser interface.\u00a0 At its core, the tool is architected to display hierarchically structured data from any ODBC data source.\u00a0 As the Project Pipeline data stored in Primavera P6 is also structured hierarchically via the Enterprise Project Structure (EPS), this was a natural fit.<\/p>\n
After creating a custom view that managed the necessary joins to pull a few dozen fields from half a dozen tables into a single row per project, the Primavera data was ready to be pulled into Org Publisher.\u00a0 The Org Publisher tool provides multiple views of the data, including a graphical Chart View (displaying relationships between records), a Summary View (for Counts and Totaling), a Profile View (to view all data associated with a single document), and a List View (to view all data in spreadsheet layout including download to Excel capability).\u00a0 Once created, the chart and views were scheduled to refresh nightly and were made available through a web browser on the Intranet.\u00a0 Below is a sample:<\/p>\n
<\/p>\n
Besides the apparent licensing cost savings associated with not purchasing another tool, there are other advantages to adapting and re-using existing technology. \u00a0End users will be thrilled not to be forced to learn another tool, easing adoption. \u00a0Additionally, the technical resources responsible for supporting the tool will be ready even before day one.<\/p>\n","protected":false},"excerpt":{"rendered":"
You are implementing Primavera P6 and have determined that the delivered reporting tools are not up to snuff.\u00a0 Before you go out and buy a new report-writing tool, take a step back and look in your enterprise toolbox.\u00a0 You might find you already have a tool that fits the bill.<\/p>\n","protected":false},"author":79,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[15,75],"tags":[],"class_list":["post-90","post","type-post","status-publish","format-standard","hentry","category-industry-trends-standards","category-oracle-primavera"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/posts\/90","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/users\/79"}],"replies":[{"embeddable":true,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/comments?post=90"}],"version-history":[{"count":0,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/posts\/90\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/media?parent=90"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/categories?post=90"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/tags?post=90"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}