Warning: Trying to access array offset on value of type bool in /volume1/web/wordpress/wp-content/plugins/select-core/post-types/slider/shortcodes/slider.php on line 62
Call Stack:
0.0005 360880 1. {main}() /volume1/web/wordpress/index.php:0
0.0006 361192 2. require('/volume1/web/wordpress/wp-blog-header.php') /volume1/web/wordpress/index.php:17
3.5542 18766064 3. require_once('/volume1/web/wordpress/wp-includes/template-loader.php') /volume1/web/wordpress/wp-blog-header.php:19
3.5785 18742496 4. include('/volume1/web/wordpress/wp-content/themes/ayro/full-width.php') /volume1/web/wordpress/wp-includes/template-loader.php:106
4.3494 20733560 5. get_template_part($slug = 'slider', $name = ???, $args = ???) /volume1/web/wordpress/wp-content/themes/ayro/full-width.php:11
4.3494 20734032 6. locate_template($template_names = [0 => 'slider.php'], $load = TRUE, $load_once = FALSE, $args = []) /volume1/web/wordpress/wp-includes/general-template.php:206
4.3495 20734128 7. load_template($_template_file = '/volume1/web/wordpress/wp-content/themes/ayro/slider.php', $load_once = FALSE, $args = []) /volume1/web/wordpress/wp-includes/template.php:745
4.3495 20734424 8. require('/volume1/web/wordpress/wp-content/themes/ayro/slider.php') /volume1/web/wordpress/wp-includes/template.php:812
4.3498 20734424 9. do_shortcode($content = '[qodef_slider slider=\'video-presentation\']', $ignore_html = ???) /volume1/web/wordpress/wp-content/themes/ayro/slider.php:4
4.3500 20745896 10. preg_replace_callback($pattern = '/\\[(\\[?)(qodef_slider)(?![\\w-])([^\\]\\/]*(?:\\/(?!\\])[^\\]\\/]*)*?)(?:(\\/)\\]|\\](?:([^\\[]*+(?:\\[(?!\\/\\2\\])[^\\[]*+)*+)\\[\\/\\2\\])?)(\\]?)/', $callback = 'do_shortcode_tag', $subject = '[qodef_slider slider=\'video-presentation\']') /volume1/web/wordpress/wp-includes/shortcodes.php:273
4.3500 20746552 11. do_shortcode_tag($m = [0 => '[qodef_slider slider=\'video-presentation\']', 1 => '', 2 => 'qodef_slider', 3 => ' slider=\'video-presentation\'', 4 => '', 5 => '', 6 => '']) /volume1/web/wordpress/wp-includes/shortcodes.php:273
4.3501 20747040 12. QodeCore\PostTypes\Slider\Shortcodes\Slider->render($atts = ['slider' => 'video-presentation'], $content = '', 'qodef_slider') /volume1/web/wordpress/wp-includes/shortcodes.php:434
Warning: Trying to access array offset on value of type bool in /volume1/web/wordpress/wp-content/plugins/select-core/post-types/slider/shortcodes/slider.php on line 102
Call Stack:
0.0005 360880 1. {main}() /volume1/web/wordpress/index.php:0
0.0006 361192 2. require('/volume1/web/wordpress/wp-blog-header.php') /volume1/web/wordpress/index.php:17
3.5542 18766064 3. require_once('/volume1/web/wordpress/wp-includes/template-loader.php') /volume1/web/wordpress/wp-blog-header.php:19
3.5785 18742496 4. include('/volume1/web/wordpress/wp-content/themes/ayro/full-width.php') /volume1/web/wordpress/wp-includes/template-loader.php:106
4.3494 20733560 5. get_template_part($slug = 'slider', $name = ???, $args = ???) /volume1/web/wordpress/wp-content/themes/ayro/full-width.php:11
4.3494 20734032 6. locate_template($template_names = [0 => 'slider.php'], $load = TRUE, $load_once = FALSE, $args = []) /volume1/web/wordpress/wp-includes/general-template.php:206
4.3495 20734128 7. load_template($_template_file = '/volume1/web/wordpress/wp-content/themes/ayro/slider.php', $load_once = FALSE, $args = []) /volume1/web/wordpress/wp-includes/template.php:745
4.3495 20734424 8. require('/volume1/web/wordpress/wp-content/themes/ayro/slider.php') /volume1/web/wordpress/wp-includes/template.php:812
4.3498 20734424 9. do_shortcode($content = '[qodef_slider slider=\'video-presentation\']', $ignore_html = ???) /volume1/web/wordpress/wp-content/themes/ayro/slider.php:4
4.3500 20745896 10. preg_replace_callback($pattern = '/\\[(\\[?)(qodef_slider)(?![\\w-])([^\\]\\/]*(?:\\/(?!\\])[^\\]\\/]*)*?)(?:(\\/)\\]|\\](?:([^\\[]*+(?:\\[(?!\\/\\2\\])[^\\[]*+)*+)\\[\\/\\2\\])?)(\\]?)/', $callback = 'do_shortcode_tag', $subject = '[qodef_slider slider=\'video-presentation\']') /volume1/web/wordpress/wp-includes/shortcodes.php:273
4.3500 20746552 11. do_shortcode_tag($m = [0 => '[qodef_slider slider=\'video-presentation\']', 1 => '', 2 => 'qodef_slider', 3 => ' slider=\'video-presentation\'', 4 => '', 5 => '', 6 => '']) /volume1/web/wordpress/wp-includes/shortcodes.php:273
4.3501 20747040 12. QodeCore\PostTypes\Slider\Shortcodes\Slider->render($atts = ['slider' => 'video-presentation'], $content = '', 'qodef_slider') /volume1/web/wordpress/wp-includes/shortcodes.php:434
Business Objectives
A leading utilities company in UK with a large Oracle footprint and over 600 users needed to re-architect its data warehouse solution for the Capital Delivery, and HR data marts. As part of the initial go live, they wanted to implement their CD data mart for Ofgem/RIIO reporting.
Under RIIO, National Grid faces significant capital efficiency improvement challenges in order to outperform the unit cost allowances set for network development investments. Capital Delivery needs to contribute directly to these efficiency improvements by delivering projects to scope, on time and more efficiently than ever before. In addition, Ofgem’s new and much more onerous regulatory data quality standards mean an unprecedented level of data accuracy needs to be achieved in the annual reporting of construction project costs.
At present, Capital Delivery has limited project management reporting tools to achieve these outcomes. National Grid’s Project Capital Delivery faces following challenge(s)
- The most problematic gap is limited capability around of Earned Value Management (EVM); which is typically deployed on high value, long duration construction projects or major capital works programmes and without EVM, it is very difficult to ascertain whether expenditure over time, in partially complete major works is efficient and economic or not.By the time works are completed, it is too late to address poor performance.
Hence EVM is both a ‘reasonable, proportionate and necessary’ tool in providing proper oversight and control of project expenditures, especially when these expenditure levels reach in excess of £2bn pa.
- Capital Delivery current reporting solution is based on COBRA reports which is manual and it takes a lot of resources to compile monthly reports.
- Reports preparation is a manual process which is prone to error.
- Current reporting solution doesn’t provide data trending, forecasting and/or data drilling.
Challenges
The client wanted to have the following as part of the project
- To maintain historical data.
- To setup a migration process for Oracle Data Integrator (ODI) and Oracle Business Intelligence Enterprise Edition (OBIEE)
- To schedule ODI jobs using an external scheduler
Oracle Business intelligence Enterprises Edition Consulting Company in Dallas | Lahore | Nottingham
Oracle OBIEE offers a full range of analytical and reporting capabilities that includes interactive dashboards, enterprise, and financial reporting and real-time predictive OLAP and precious scorecard practical solutions. At MIAZ-TECH, an OBIEE Consulting Company, we understand the complexity of delivering enterprise data warehouse solutions based on your long-term vision.
Contact Us
Reporting Process
The below diagram shows the complete data flow process
Figure – Diagram of Data Flow for BIP and DataMart/OBIEE
The data for the above business processes would be:
- Planning & Scheduling
- Cost
- Planned Value
- Earned Values
- Actual Cost
- Upper Sanction Value
- Current Baseline Budget (CBB)
- Original Baseline Budget(OBB)
- Monthly Spread Cost
All Cost related data would be supplied by COBRA system as flat files which would be initially loaded manually into staging area through PL/SQL ETL.
Project level information will be provided by Capital Delivery’s Reporting Team.
Planning & Scheduling related data would be extracted directly from P6 DB using PL/SQL procedure.