Reference: Report Performance Log Fields
Report Summary
Log Field | Description |
|---|---|
Log Name
| The log name you entered on the Edit Report Performance Log
Settings task. |
Report Definition
| The report selected for logging. |
Report Type
| A 3-letter abbreviation for the type of report logged. Possible
values:
|
Executed by User
| The user who ran the report. |
Data Source
| Data source of the logged report. |
Execution Status
| Displays if the report ran successfully. If you select the Notify me
later check box when you run the report, the original
report log displays a status of Failed and creates another report
log for the report when it runs in the background. |
Data Source Processing Mode
| Displays how the report processed the data source: as standard,
indexed, or hybrid. This field doesn’t display for composite reports.
Possible values:
|
Filter Processing Mode
| Displays how the report processed the fields used for filtering: as standard, indexed,
or hybrid. Possible values:
|
Grouping Processing Mode
| Displays how the report processed the fields used for grouping: as
standard, indexed, or hybrid. Possible values:
|
Report Execution Date and Time
| Date and time when the report finished running. |
Maximum Report Processing Time (s)
| Maximum time a report runs before timing out. By default, a report run by a user
runs for 30 minutes. A report that ran in the background runs for 6
hours. A report that ran as a worklet runs for 30 seconds. |
Subreport Count
| (Composite reports only.) Number of subreports run as part of the composite
report. |
Data Source Instance Count
| Number of business object instances the data source returns. This
field displays a count of zero if the:
|
Data Source Instance Count (Post Security
Processing)
| Number of business object instances remaining after security
processing. This field displays a count of zero if the:
|
Report Instance Count
| Number of business object instances the report returns after security, filter, and
other processing. This field displays a count of zero if the report is a
matrix report:
If the report is a matrix report that's Optimized for
Performance , a unique instance count of all groups
displays in the Matrix Summarization section of
the:
If the Report Instance Count is much
less than the Data Source Instant Count , consider
using a more focused data source to improve report
performance. |
Report Performance Metrics
Log Field | Description |
|---|---|
Total Execution Time (ms)
| Time spent running the report. A high value might indicate performance issues.
Review the other timing log fields to identify a problem
area. |
Total CPU Execution Time (ms)
| Total time of each concurrent thread for each time bucket. This value doesn’t
contribute to Total Execution Time (ms) . This field
is only available if you enable Parallel
Processing . |
Initialization Time (ms)
| Time spent building the report definition model. During this time, the
report evaluates parameter processing and static filters. |
Data Source Time (ms)
| Time spent identifying the data source and retrieving the business object instances
that the report uses. To reduce the data source time, you can use the
Data Sources report to find a more targeted
and efficient data source for your report. |
Data Source Security Time (ms)
| Time spent evaluating security access to the data source. This field displays zero
if the data source contains no security. If the data source is
secured to an unconstrained security group while some instances of the
business object are secured to a constrained security group, this field
displays the time spent evaluating security access for the constrained
security group. |
Top Level Filter Time (ms)
| Time spent applying all filters in the report definition, including filters at the
data source, field, and subfilter levels. This field displays zero if
there's no filtering on the data source. To reduce the filter
time, you can:
|
Contextual Security Filter Time (ms)
| Time spent evaluating contextual security access to the data source. This field
doesn't display if there's no contextual security on the data
source. |
Top Level Sort Time (ms)
| Time spent applying all sort options in the report definition. This field displays
zero if the report:
To reduce the sort time, you can sort by simple field types, such as
text fields, instead of by single instance or multi-instance field
types. |
Processing Time (ms)
| Time spent processing all calculations and fields and delivering all business object
instances in the report results. Includes time for generating data for
fields and columns. This field displays zero if the report ran for the
first time and contains paginated results. |
Subreport Invocation Time (ms)
| (Composite reports only.) Time spent running subreports, including time starting and
ending each subreport request. |
Filter Tree Time (ms)
| Time spent building the filter tree while initializing the report definition. This
field displays zero if:
|
Report Parameters Evaluation Time (ms)
| Time spent evaluating all user-entered prompt values while initializing the
report. This field displays zero when:
|
Failure Information
This section only displays if the report fails to run.
Log Field | Description |
|---|---|
Failure Info Exception Message
| Description of why the report failed to run. |
Failure Info Fail Type
| Report failure type. |
Failure Info Main Stats Bucket
| The process running at time of report failure. |
Failure Info Sub Stats Bucket
| The subprocess running at time of report failure. |
Report Prompts
The report prompts in this section can come from the data source and data source filters.
Log Field | Description |
|---|---|
Prompt Field
| Prompt fields that the report evaluates. |
Prompt Value(s)
| Values for the prompt field. |
Count
| (Workday Support only.) Count of how many instance prompt values are
selected. Possible values:
|
Hash Code
| (Workday Support only.) Hash code used to recreate the instance prompt selected
values. |
Field Performance Metrics
Log Field | Description |
|---|---|
Field
| Name of the field in the report, data source, or data source
filter. |
Parent Field
| The parent field for the child calculated field. All child fields below the second
level roll up to the second-level child field. In some cases, a
field that is either referencing itself or another field is the
Parent Field . In some composite
reports, there are parents fields due to report nesting. |
Field Type
| Type of field in the report. Possible values:
|
Total Field Security (ms)
| Time spent evaluating the security for the field. |
Total (ms)
| Time spent processing this field, not including Total Field
Security time. The total time is the sum of the
Data Source Processing time and the
Report Processing time. |
Initialization (ms)
| Time spent initializing static values. Example: Effective
moment. |
Data Source (ms)
| Time spent evaluating the field in the data source. This field displays zero when
the data source:
|
Data Source Security (ms)
| Time spent evaluating the field security in the data source. This
field displays zero when the field isn’t used for data source
security. |
Contextual Security Filter (ms)
| Time spent filtering logic for the data source that calls this field
during execution. This field displays zero when there’s no contextual
security. |
Report Processing (ms)
| Time spent filtering, sorting, processing, and so on. This field displays zero when
the report field is only in the data source. |
Times Executed
| Number of times the field executes, including when the field nests under other
fields. |
Subreports
This section is only available for composite reports.
Log Field | Description |
|---|---|
Subreport
| Name of the subreport in the composite report. |
Referenced in Composite Entries
| Where the composite report references the subreport. |
Report Performance Log
| The link to the report performance log for the subreport. |
Advanced Metrics
This section is for Workday Support use only.