{"id":665,"date":"2010-06-14T11:24:06","date_gmt":"2010-06-14T19:24:06","guid":{"rendered":"http:\/\/www.projectp.com\/weblog\/?p=665"},"modified":"2022-11-23T10:51:11","modified_gmt":"2022-11-23T18:51:11","slug":"using-oracle-project-analytics-within-engineering-and-construction-firms-part-2","status":"publish","type":"post","link":"https:\/\/www.projectp.com\/ppblog\/2010\/06\/14\/using-oracle-project-analytics-within-engineering-and-construction-firms-part-2\/","title":{"rendered":"Using Oracle Project Analytics Within AEC Firms &#8211; Part 2"},"content":{"rendered":"<p>By Robert D. Anderson, CPA<\/p>\n<p>This blog article is a continuation of the June 7 article.<\/p>\n<p><strong>Financial Focus<\/strong><\/p>\n<p>It is essential to note the development of the analytic package was done by the Oracle OBIEE team and did not include the assistance of the Oracle Project Development group. As a result of this development approach, some items viewed as necessary by heavy project users, such as Engineering and Construction firms, are not included in the initial release of Project Analytics.<br \/>\n<!--more--><br \/>\nAs you review the items included in the last graphic from last week&#8217;s blog, note the focus areas all have a financial slant. All the delivered functionality is taken from the core Project Accounting applications of Project Cost and Project Billing. No data elements from Resource Management or Project Management are included. The webinar&#8217;s purpose was to ensure<span style=\"text-decoration: underline;\">\u00a0this can be handled and all the needed information can reside within the OBIEE warehouse. <\/span>Project Partners can help you with this.<\/p>\n<p>Oracle Project Analytics comprehensively analyzes project-based forecasts, budgets, costs, revenue, billing, and profitability data elements. It is integrated with the other OBIEE analytics to deliver a cross-functional analysis of project-related data in areas such as accounts receivable, accounts payable, invoice aging, or status of procurement transactions by the project. The pre-built ETL, DW, Dashboards, Reports, Metrics, KPI, and Business User Tools support the use of data across the active PBIEE installed components.<\/p>\n<div id=\"attachment_667\" style=\"width: 310px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/06\/block_diagram.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-667\" class=\"size-medium wp-image-667\" title=\"Oracle_Project_Analytics_data\" src=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/06\/block_diagram-300x129.jpg\" alt=\"Data provided by Oracle Project Analytics\" width=\"300\" height=\"129\" srcset=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/06\/block_diagram-300x129.jpg 300w, https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/06\/block_diagram.jpg 730w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><p id=\"caption-attachment-667\" class=\"wp-caption-text\">Data provided by Oracle Project Analytics<\/p><\/div>\n<p><strong>What&#8217;s Included<\/strong><\/p>\n<p>Oracle delivers robust dashboards, reports, and metrics across three primary groupings, as shown in the following graphic.<\/p>\n<div id=\"attachment_668\" style=\"width: 310px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/06\/Project_Analytics_Metrics.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-668\" class=\"size-medium wp-image-668\" title=\"Project_Analytics_Metrics\" src=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/06\/Project_Analytics_Metrics-300x182.jpg\" alt=\"Oracle Project Analytics Metrics\" width=\"300\" height=\"182\" srcset=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/06\/Project_Analytics_Metrics-300x182.jpg 300w, https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/06\/Project_Analytics_Metrics.jpg 603w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><p id=\"caption-attachment-668\" class=\"wp-caption-text\">Oracle Project Analytics Includes Over 500 Metrics<\/p><\/div>\n<p><strong>Business Roles of Users<\/strong><\/p>\n<p>Oracle further defines the business roles that use each pre-defined role, as shown in the following graphic.<\/p>\n<p style=\"text-align: center;\">\n<div id=\"attachment_669\" style=\"width: 318px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/06\/Project_Analytics_Users.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-669\" class=\"size-full wp-image-669  \" title=\"Project_Analytics_Users\" src=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/06\/Project_Analytics_Users.jpg\" alt=\"Roles of Oracle Project Analytics Users\" width=\"308\" height=\"179\" srcset=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/06\/Project_Analytics_Users.jpg 641w, https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/06\/Project_Analytics_Users-300x175.jpg 300w\" sizes=\"auto, (max-width: 308px) 100vw, 308px\" \/><\/a><p id=\"caption-attachment-669\" class=\"wp-caption-text\">Roles of Oracle Project Analytics Users<\/p><\/div>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>Interaction with Microsoft(R) Office Suite<\/strong><\/p>\n<p>Oracle Project Analytics offers integration with Microsoft Office Suite. From the perspective of the Projects area, one of the more powerful features is the ability to automate the period updating of the project review decks used across hundreds of firms every cycle (weekly, monthly, quarterly) and by various levels within the organization. To utilize this functionality, there are several steps you must first complete, and I&#8217;ll discuss those in the webinar. For now, take a look at the exciting screenshot below.<\/p>\n<div class=\"mceTemp mceIEcenter\">\n<div id=\"attachment_674\" style=\"width: 622px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/06\/IntegrationWithMicrosoft1.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-674\" class=\"size-full wp-image-674 \" title=\"IntegrationWithMicrosoft\" src=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/06\/IntegrationWithMicrosoft1.jpg\" alt=\"Integrate Microsoft Office and Oracle Project Analytics\" width=\"612\" height=\"445\" srcset=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/06\/IntegrationWithMicrosoft1.jpg 1020w, https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/06\/IntegrationWithMicrosoft1-300x218.jpg 300w\" sizes=\"auto, (max-width: 612px) 100vw, 612px\" \/><\/a><p id=\"caption-attachment-674\" class=\"wp-caption-text\">Integration of Microsoft Office Suite and Oracle Project Analytics<\/p><\/div>\n<\/div>\n<p style=\"text-align: left;\"><strong>\u00a0<\/strong><\/p>\n<p style=\"text-align: left;\"><strong>Learn Much More<\/strong><\/p>\n<p style=\"text-align: left;\">Learn more by attending the free webinar. Register to watch the webinar <a href=\"http:\/\/www.projectp.com\/resources\/webinars.php\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>As you review the items included in the last graphic from last week&#8217;s blog, note the focus areas all have a financial slant. All the delivered functionality is taken from the core Project Accounting applications of Project Cost and Project Billing. No data elements are included. Continue reading the blog: <\/p>\n","protected":false},"author":79,"featured_media":3644,"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,115],"tags":[],"class_list":["post-665","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-industry-trends-standards","category-oracle-ebs"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/posts\/665","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=665"}],"version-history":[{"count":0,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/posts\/665\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/media\/3644"}],"wp:attachment":[{"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/media?parent=665"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/categories?post=665"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/tags?post=665"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}