slide1
Download
Skip this Video
Download Presentation
Oracle Projects Management Reporting

Loading in 2 Seconds...

play fullscreen
1 / 11

Oracle Projects Management Reporting - PowerPoint PPT Presentation


  • 98 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Oracle Projects Management Reporting' - callum-rodriquez


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

Oracle Projects

Management Reporting

Presented By: Keith Mobley – Verities Solutions

slide3

Reporting With Executive Dash

    • Provides versatility
  • Build real-time reports
  • No special data pre-processing required
  • Bring in other data sources as required
slide4

Overview of Executive Dash

Consists of two components:

Query Designer

Excel Add-In for Formulas

slide5

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
slide6

Oracle Projects - Management Reporting

DEMO

Demonstrate capability of Executive Dash using Oracle Projects Information

slide7

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?
slide8

Oracle Projects - Management Reporting

  • Approach
  • Identifying the data source - Oracle
    • Oracle tables, standard Oracle Applications views, custom views, materialized views?
slide9

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
slide11

Oracle Projects - Management Reporting

Contact Information:

Verities Solutions

Keith Mobley

Office: 847-265-7865

www.veritiesllc.com

[email protected]

ad