Selecting, viewing, and sorting data in the PA Explorer sheet view

When you have loaded the data into CICS PA Explorer, you can select and view all, or a subset of, the data in the CICS PA sheet view.

If the data is not yet loaded, follow the steps in the task Loading data in CICS PA Explorer to load csv data, or Connecting to a database to connect to a database, before continuing.

The first time you click a file in the Project Explorer view, CICS PA Explorer performs an analysis of the data. The analysis might take a few seconds to complete. When the analysis is complete, a plus icon (an arrow on Linux) displays next to the file. Clicking the icon, and subsequent icons, expands the file and displays the file contents in the following cascading order:

In the following example, the csv file XPLR_C.csv in Folder 1 contains data summarized by start date and time, and using five minute time intervals. The start time 13:40:00.000 contains one APPLID, PDQSICU, containing two transaction IDs.

A picture of the PA Explorer view showing a folder expanded to show a csv file and all expanded branches.

Viewing a single item of data

To select a single item of data, perform the following steps:
  1. Expand the file in the PA Explorer view by clicking the plus icon (an arrow on Linux) alongside the file. Repeat the action until the data you want to view is displayed.
  2. Right-click the data you want to view.
  3. Click Sheet view in the menu.

The data is displayed in the sheet view in CICS PA Explorer. The details displayed depend on the selection you make:

Viewing multiple rows of data

You can select and view data in any combination of start dates, start times, APPLIDs, or Transaction IDs. To select multiple rows of data, perform the following steps:
  1. Expand the file in the PA Explorer view by clicking the plus icon (an arrow on Linux) alongside the file. Repeat the action until the data you want to view is displayed.
  2. Highlight the first item of data you want to view by left-clicking.
  3. Select subsequent items of data using the shift or Ctrl keys.
  4. When the selection is complete, press the shift or Ctrl key and right-click one of the selections, and click Sheet view in the menu.

Your selection displays in the CICS PA sheet view. You can further refine your data by selecting a subset of the data in the sheet view, right-clicking your selection, and clicking Sheet view in the menu. You selection opens in a new sheet view.

Sorting the data

You can sort the data in the sheet view in ascending or descending order by clicking a column header.

When you click a column header, an up or a down arrow is displayed alongside the column name. The up arrow indicates that the data in the column is sorted in ascending order. The down arrow indicates that the data is sorted in descending order.