PS/nVision retrieves information from your PeopleSoft database and places it into a Microsoft Excel spreadsheet, in a form that helps you see the big picture, explore details, and make decisions. You use familiar Excel commands to format and analyze the data. With PS/nVision, you spend your time analyzing results rather than summarizing data and entering it into a spreadsheet.


PS/nVision works within spreadsheets. You access PS/nVision features from a special PS/nVision menu within Microsoft Excel to create templates (layouts) for data retrieval. Once you create a report layout (XNV file), you can use it to format data automatically.


The PS/nVision interface is similar to a Web browser, with customizable buttons and displays. You can also create a custom front-end macro sheet for point-and-click access to reports and reporting functions.


PS/nVision selects data from your PeopleSoft database using ledgers, trees, and queries. Queries are useful for extracting data from sources other than ledgers, so you should be familiar with PeopleSoft Query concepts, especially query result sets, before working with PS/nVision. Also, tree data is used to limit the query results, so you should be familiar with nodes and detail values.


On the Web version, PS/nVision works closely with Process Scheduler and Distribution Agent and forms a report server with them in a Windows NT machine. When running and drilling a PS/nVision report, Process Scheduler is the bridge between nVision engine and PeopleSoft Pure Internet Architecture applications that launch nVision engine and communicates the report running status back to the applications. PS/nVision uses Distribution Agent to transfer the report instances between nVision file server and the report repository. The report repository servlet in the web server enables users to access PS/nVision reports in Report Manager.


Upon completion of this module, you will be able to:

•Use layouts.

•Use report scopes.

•Use DrillDown.

•Use nPlosion.

•Run PS/nVision reports on the web.

•Run PS/nVision reports in the Microsoft Windows Client.

Table of Contents