1 / 15

PeopleSoft nVision - Overview

PeopleSoft nVision - Overview. Finance Network Chuck Axthelm March 16, 2006. What is nVision. nVision is PeopleSoft reporting tool Excel add-in Extracts cost, lien & effort data from FMS tables Inserts this data into a pre-formatted Excel spreadsheet

meir
Télécharger la présentation

PeopleSoft nVision - Overview

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. PeopleSoft nVision - Overview Finance Network Chuck Axthelm March 16, 2006

  2. What is nVision • nVision is • PeopleSoft reporting tool • Excel add-in • Extracts cost, lien & effort data from FMS tables • Inserts this data into a pre-formatted Excel spreadsheet • Most divisions are using nVision to generate standard financial reports

  3. Advantages • Provides timely, accurate data • No re-keying of FMS data into Excel • Downloads complete quickly • Report formats easily edited and can be saved, updated and reused • Excel formats and formulas are applied to downloaded data

  4. Disadvantages • Can only access data in FMS • Funding and budget data must be manually entered and maintained in Excel report layouts • nVision “language” can appear cryptic & hard to interpret • User must make and save format/formula changes in the layout not in the output • Not recommended for “on the fly” reports

  5. FMS Query nVision Layout nVision Report Request Report Output nVision Reporting 3-Step Process • Modify & Save Format • Update Report Request • Run Report

  6. nVision Home Page

  7. nVision Process Components • FMS Query: • Specifies generic financial data & related dimensions • Contain very little restrictive criteria • Layout contains: • Excel logic: Formats and formulas • nVision logic of what data to download and where to insert it • Non-FMS data such as budgets and funding • Report Request specifies: • Name of Report Output • Name of the Layout to use • “As of” date for financial information

  8. How it Works • nVision criteria added to an Excel spreadsheet transforms it into an nVision report layout • Note: Only 1 layout per Workbook • Cell A1 typically specifies the source FMS query – applies to entire layout • Costs, liens or hours are retrieved at the intersection of row and column criteria

  9. Getting Started with nVision • Must have installed the client version of PS nVision (contact Aurora Pecoraro) • All users copy and modify existing nVision layouts • Very few create layouts from scratch • Dive in and try it • Worse thing that can happen is you don’t get the results you want

  10. Public nVision Layouts & How To Go To: OCFO Website/Financial Policy and Training/Training Materials Note: Save layouts to your desktop

  11. nVision Overview Reference Materials

  12. Decoding nVision Criteria • % - designates the start of an nVision command • ATT, – designates that a description field to be inserted; column is resized for longest value • C – query results column (Resource Amount, Resource Quantity, or Lien Amount) • F – what follows in the data source field name • N – what follows is a specific tree node • Q – what follows is the source query name • S – what follows designates a time span; eg year to data, period 1, etc. • T – what follows is an FMS tree name • V – what follows is the specific value of the source field (multiple values can be listed separated by commas and each preceded with the V prefix)

  13. Time Span Codes • YTD • Current fiscal year thru the last hard close • PER1, PER2,…PER12 • Fiscal accounting period where PER1 represents October • ALLYEAR-1 • Total of 12 months from prior fiscal year

  14. Query: nvZW_PC_RU_RC • Used for Project One-Line Layout • Fields • Project ID • Project Status • B&R • Resource Category • Fiscal Year • Accounting Period • Resource Amount & Effort Hours • Criteria • Analysis Type = ACT

  15. Query: UK_BUDGET_MANAGEMENT_COSTS • Used for BMR Layout • Fields • Resource Category* • Resource Amount & Effort Hours • Criteria • Analysis type = ACT * Note: The layout summarizes res cats using the FMS res cat hierarchy

More Related