View and analyze
After a process runs, the result for each reference date appears on the process analysis screen. The same process can generate multiple results: reconciliations, tables, and exports. This article explains how to open this screen, choose what you want to view, and work with the data.
Open the process
In the Processes menu, open the list of processes and click the process you want to analyze. The analysis screen opens in the folder you are in. To return to the list, click Close in the upper-left corner.
The process header
At the top of the screen, you can see the process name, code, and stage (Testing or Production). On the right:
Reference date: the date whose result is displayed on the screen (see the section below).
Prepare: opens the result approval workflow for that date. It only appears when the date has a run.
Settings: brings together the process settings, such as editing the workflow, Information, Owners, Automation Rule, Data Lake, Dashboards, and Source Directory.
Run: runs the process for a date. See Run a process.
?: opens the help.
Choose the reference date
Each run loads data for a reference date. Choose the date in the Reference date calendar, or use the arrows next to it to go to the previous or next date.
If the selected date does not have a run yet, the screen displays "No results to display". In this case, run the process for that date.
Choose the result
The button at the top of the data area shows the name of the open result. Click it to see all the process results, grouped by type:
Reconciliations: one row for each reconciliation in the process, using the name it has in the workflow.
Tables: one row for each analysis table.
Exports: one row for each export.
Only the groups included in the process appear. Choose the result by name: when it is open, the button displays that name, so you always know which result you are working with, even when the process has multiple reconciliations.
If two reconciliations in the same process have the same name, they appear as two identical rows in the list. Give the reconciliations different names in the workflow to distinguish them.
Filter and sort
There are two ways to filter what appears in the grid:
Filters: the button shows in parentheses how many filters are active. In New filter, you give the filter a name, set up the conditions, and save it for later use.
Column filter: the funnel icon in each column header filters only that column. Choose a condition (such as Is equal to, Is different from, Contains, Does not contain, or Is empty) or select the values in the list, then click APPLY. CLEAR removes the column filter.
To sort, open the column header menu and choose Ascending or Descending. Clear sorting restores the original order, and Pin column keeps the column visible while you scroll the grid horizontally.
The grid footer shows how many items are on the screen and how many are selected. In tables, the top of the grid shows the total number of rows and columns.
Actions
The Actions button brings together what you can do with the data:
Download XLSX and Download CSV: download the data in Excel or text format. They are available for all results.
Justify, Reconcile, and Unreconcile: appear only in reconciliations and apply to the selected rows. Changes remain pending until you click Save; Cancel discards them all.
Create task: creates a task from the selected reconciliation rows.
Actions that require a selection remain disabled until you select at least one row.
In the reconciliation
When you open a reconciliation, the screen provides specific features:
Top totals: Side A, Side B, and Difference show the reconciliation totals for that date. They do not change when you filter the grid.
Sum above the grid: when you filter a column or apply a filter using the Filters button, a bar appears above the grid showing the sum of Side A, Side B, and the difference for all filtered rows, without requiring you to select them. When you select rows, the bar sums only the selected rows. If the filter leaves no rows, the bar shows zero.
Statistics: in the menu on the left, shows the value and number of rows for each status (Not found, Reconciled, Reconciled with tolerance, and others). The switches for each status determine which records appear in the grid; when the screen opens, only Not found is enabled.
Display: shows the records in a single table or with Side A and Side B separated. See Side-by-side view.
Activities
The menu on the left side of the screen also includes the explanatory Note, Attachments, Linked tasks, and Comments for the reference date. See Activities on the analysis screen.
Embedded dashboards
A process can also have an embedded Power BI dashboard. In this case, you analyze the data using charts and indicators built for that process. The configuration is described in the Dashboards article.
Standard processes
In Standard processes, the analysis screen displays the workflow tables in the same way, with Actions for downloading the data. Reconciliation is different: instead of the grid, the screen displays the message "Your reconciliation is ready" and the Go to reconciliation analysis button, which opens the reconciliation in its dedicated reconciliation analysis screen. That is where you reconcile, justify, and approve.
Related articles
Reconciliation step (Turbo AI processes)
Reconciliation step (Standard processes)
Dashboards