1 / 11

Oracle Projects Management Reporting

Oracle Projects Management Reporting. Presented By: Keith Mobley – Verities Solutions. Please silence all cell phones and mobile devices during the session. Thank you. Reporting With Executive Dash. Provides versatility Build real-time reports No special data pre-processing required

callum-rodriquez
Download Presentation

Oracle Projects Management Reporting

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle Projects Management Reporting Presented By: Keith Mobley – Verities Solutions

  2. Please silence all cell phones and mobile devices during the session. Thank you.

  3. Reporting With Executive Dash • Provides versatility • Build real-time reports • No special data pre-processing required • Bring in other data sources as required

  4. Overview of Executive Dash Consists of two components: Query Designer Excel Add-In for Formulas

  5. Overview of Executive Dash • Build queries to access your target data • Design the report layout in Excel • Enter Executive Dash formulas to populate the report

  6. Oracle Projects - Management Reporting DEMO Demonstrate capability of Executive Dash using Oracle Projects Information

  7. Oracle Projects - Management Reporting • Approach • What question(s) are you trying to answer? • What is my projected vs. actual project profitability? • What is committed to spend vs. my budget? • What are my project expenditures by period? • What is my actual project revenue vs. budget? • What are my expenditures by type?

  8. Oracle Projects - Management Reporting • Approach • Identifying the data source - Oracle • Oracle tables, standard Oracle Applications views, custom views, materialized views?

  9. Oracle Projects - Management Reporting • Development • Answering your questions • Make connection in E-Dash • Create queries in E-Dash • Test results in E-Dash • Save queries in E-Dash • Update query catalog • Open Excel (refresh catalog) • Layout your format • Build formulas for Lists (EXD formulas) • Build formulas for Summary cells (EXQ) • Verify results

  10. Oracle Projects - Management Reporting • QUESTIONS?

  11. Oracle Projects - Management Reporting Contact Information: Verities Solutions Keith Mobley Office: 847-265-7865 www.veritiesllc.com keith.mobley@veritiesllc.com

More Related