Configuring nVision

Access the nVision tab.

Use this tab to specify where PS/nVision should look for files and how it should operate. PeopleSoft Query Link, the feature that enables you to send PeopleSoft Query output to a spreadsheet, also uses these settings.

Space between Query Columns

This parameter sets the number of blank Microsoft Excel characters that PeopleSoft Query Link places between query output columns. To eliminate column spacing, set Space between Query Columns to zero.

Directory Paths

Specify the locations of directories associated with PS/nVision jobs.

Note:

When specifying nVision directory locations, consider the location of your PS_APP_HOME.

Field or Control Description

Customization Macros

Enter the directory containing macros for PS/nVision and PeopleSoft Query Link. It is usually PS_HOME\excel.

Report Layouts

Enter the location of PS/nVision layout fields.

Drilldown Layouts

Enter the location of PS/nVision drilldown files, for example, c:\user\nvision\layout\drilldn.

Report Instance

Enter the directory in which PS/nVision places report instances; for example, c:\user\nvision\instance.

Query Templates

Enter the directory to look for the QUERY.XLT file, which defines the Microsoft Excel styles used to format output. The default is PS_HOME\excel.

Style Sheets

Enter the directory where the NVSUSER style wizard locates nPlosion style sheets.

Trace Level

Indicate whether you want PS/nVision to generate independent trace log files of two-tier activity, and at what level, for each nVision process. Select one of the following values:

  • 0: Disable tracing. This is the default value.

  • 1: Generate basic high level information.

    This setting can be used to check whether nVision has successfully launched and is able to connect to Excel and process the request. Some of the key entries in a level 1 trace log are:

    • Command Line Arguments.

    • Trace Level.

    • Excel Pid.

    • Run Control Name.

    • Report Id.

    • Business Unit.

    • Drill Layout.

    • Report Id.

    • Instance Name.

  • 2: Generate level 1 tracing plus high level code flow.

  • 3: Generate level 2 tracing plus runtime SQL statements.

  • 4: Generate level 3 tracing plus most function calls and output values.

    Use this setting to identify problems that are intermittent and hard to predict.

The trace log files are generated in the c:\temp directory, named with the format psnvs_process_id.nvt, for example, psnvs_1024.nvt. You can view these log files in a text editor.

See Process Scheduler: Viewing Process Detail Actions.

Note: Extensive tracing will affect PS/nVision performance. Two-tier log files aren't automatically purged by PS/nVision. Users must manually delete them from the temp directory to save disk space.

Related Topics