{"id":644,"date":"2010-06-07T14:32:35","date_gmt":"2010-06-07T22:32:35","guid":{"rendered":"http:\/\/www.projectp.com\/weblog\/?p=644"},"modified":"2022-11-23T10:54:54","modified_gmt":"2022-11-23T18:54:54","slug":"using-oracle-project-analytics-within-engineering-and-construction-firms-part-1","status":"publish","type":"post","link":"https:\/\/www.projectp.com\/ppblog\/2010\/06\/07\/using-oracle-project-analytics-within-engineering-and-construction-firms-part-1\/","title":{"rendered":"Using Oracle Project Analytics within AEC Firms &#8211; Part 1"},"content":{"rendered":"<p>By Robert D. Anderson, CPA<\/p>\n<p>On <strong>June 22, 2010,<\/strong> I delivered an <em>encore\u00a0<\/em>of my OAUG Collaborate 10 Presentation titled\u00a0<strong>Using Oracle Project Analytics within Engineering and Construction Firms. <\/strong>You can watch the webinar <a href=\"http:\/\/www.projectp.com\/resources\/webinars.php\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n<p>The webinar was packed with information; you&#8217;ll get more out of the session if you do a little pre-reading first. Therefore, I will cover some introductory material via blog articles published over the next two weeks.<br \/>\n<!--more--><br \/>\n<strong>Defining OBIEE<\/strong><\/p>\n<p>Oracle Business Intelligence Enterprise Edition (OBIEE) is a data warehouse solution comprising a comprehensive suite of enterprise Business Intelligence (BI) products that deliver a full range of BI capabilities. These include interactive dashboards, full ad hoc, proactive intelligence and alerts, enterprise-level reporting, real-time predictive and actionable intelligence, disconnected analytics, and more.<\/p>\n<p>The following graphic shows that nine items comprise the core of the OBIEE solution.<\/p>\n<div id=\"attachment_648\" style=\"width: 413px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/06\/OBIEE_Chart1.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-648\" class=\"size-full wp-image-648\" title=\"OBIEE_Chart\" src=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/06\/OBIEE_Chart1.jpg\" alt=\"Oracle OBIEE Components\" width=\"403\" height=\"201\" srcset=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/06\/OBIEE_Chart1.jpg 403w, https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/06\/OBIEE_Chart1-300x149.jpg 300w\" sizes=\"auto, (max-width: 403px) 100vw, 403px\" \/><\/a><p id=\"caption-attachment-648\" class=\"wp-caption-text\">Oracle OBIEE Components<\/p><\/div>\n<p>These tools deliver all the dashboards, reports, drill-down features, printing, sharing, downloading, ad hoc analysis tools, publishing tools, and data presentation schemes from tables to bubble charts.<\/p>\n<p>This functionality resides in multiple applications across three primary Tech Stack levels. These areas are, from bottom to top:<\/p>\n<ol>\n<li>Physical Layer<\/li>\n<li>Semantic Object Layer<\/li>\n<li>Presentation Layer<\/li>\n<\/ol>\n<p>The architecture layers and components are shown in the following graphic.<\/p>\n<p style=\"text-align: center;\">\n<div id=\"attachment_650\" style=\"width: 449px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/06\/OBIEE_Architecture.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-650\" class=\"size-full wp-image-650 \" title=\"OBIEE_Architecture\" src=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/06\/OBIEE_Architecture.jpg\" alt=\"Oracle OBIEE Architecture\" width=\"439\" height=\"294\" srcset=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/06\/OBIEE_Architecture.jpg 731w, https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/06\/OBIEE_Architecture-300x201.jpg 300w\" sizes=\"auto, (max-width: 439px) 100vw, 439px\" \/><\/a><p id=\"caption-attachment-650\" class=\"wp-caption-text\">Oracle OBIEE Architecture<\/p><\/div>\n<p>We will address the changes needed to the various levels when adding new data metrics and updating reports and dashboards. This structure supports all the analytic models, and the changes discussed in this whitepaper also apply to the other analytical models.<\/p>\n<p><strong>Analytics<\/strong><\/p>\n<p>The primary analytic packages are shown in the following image.<\/p>\n<p style=\"text-align: center;\">\n<div id=\"attachment_653\" style=\"width: 530px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/06\/Oracle_BI_Suite.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-653\" class=\"size-full wp-image-653 \" title=\"Oracle_BI_Suite\" src=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/06\/Oracle_BI_Suite.jpg\" alt=\"Oracle Business Intelligence Suite\" width=\"520\" height=\"293\" srcset=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/06\/Oracle_BI_Suite.jpg 866w, https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/06\/Oracle_BI_Suite-300x169.jpg 300w\" sizes=\"auto, (max-width: 520px) 100vw, 520px\" \/><\/a><p id=\"caption-attachment-653\" class=\"wp-caption-text\">Oracle Business Intelligence Suite<\/p><\/div>\n<p><strong>Focus<\/strong><\/p>\n<p>Our\u00a0webinar will focus on\u00a0the first column\u00a0in the above chart: Projects.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oracle Business Intelligence Enterprise Edition (OBIEE) is a data warehouse solution comprising a comprehensive suite of enterprise Business Intelligence (BI) products that deliver a full range of BI capabilities. Continue reading part one of two of this blog series to learn more: <\/p>\n","protected":false},"author":79,"featured_media":3648,"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],"tags":[],"class_list":["post-644","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-industry-trends-standards"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/posts\/644","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=644"}],"version-history":[{"count":0,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/posts\/644\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/media\/3648"}],"wp:attachment":[{"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/media?parent=644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/categories?post=644"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/tags?post=644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}