Reference: Reporting Limits

Data Sources

Workday limits the number of returned instances based on the type of report data source (RDS) you use and whether filtering applies. Filtering includes:

Drill down filters.

RDS filters.

RDS security.

Report filters.

Prefiltering refers to the limit Workday imposes before applying any filters to the report. Postfiltering refers to the limit Workday imposes after applying filters or grouping.

Report Criteria	Returned Instances Limit
Indexed RDS Prefiltering	3 million
Indexed RDS Postfiltering	3 million
Nonindexed RDS Prefiltering	3 million
Nonindexed RDS Postfiltering Pregrouping	1 million (for grouping only)
Nonindexed RDS Postfiltering Indexed report fields	3 million

If your report displays an error, consider using a different data source filter for indexed data sources or a different data source type. Example: When you use a nonindexed RDS, try using an indexed RDS instead.

For reports that use a Prism data source, Workday returns up to 1 million rows for these report types you run in the background:

Advanced

Matrix

Simple

Transposed

Prism data sources can return up to 512 MB of data. Indexed data sources (non-Prism) can return up to 2 GB of data.

Prism Data Sources

Workday limits from where you can query a Prism data source created from a Prism Analytics table that is enabled for analysis.

If the table contains more than 2,000,000,000 rows, then you can't use the Prism data source in a discovery board viz or a custom report as a worklet on a dashboard. You can use the Prism data source in a custom report that you run in the browser or in the background.

Financial Modeled Data Source

Workday limits the data it puts in the financial modeled data source when you set up the financial reporting data model.

Description	Limit
Time duration of journal line data	Up to 3 years, rolling (current year plus 2 years prior)
Maximum number of optional dimensions	15
Maximum number of values per dimension	100,000

Workday returns up to 1,000,000 cells that contain data in the query response.

Processing

Workday limits report processing to:

30 minutes for all reports before displaying an error. After 20 seconds, Workday enables you to schedule the report to run as a background process.

6 hours for background reports, scheduled reports, and web services. Workday terminates the scheduled background report if processing time takes longer.

You can enable all custom report types, except simple, to run in the background. When you create or edit a custom report, select the

Background Only

check box in the

Report Performance

section on the

Advanced

tab. You can also access the

All Background Only Custom Reports

report to view all custom reports in your tenant with the

Background Only

check box selected.

Discovery Board Visualizations

Workday limits viz query processing to 45 seconds and limits the returned viz data size to 50 MB. Workday displays an error in the viz if the viz query times out at 45 seconds or if the amount of data returned exceeds 50 MB. Example: A table viz fails to display if Workday returns 500 rows and each row of data contains 1 MB of data. This might happen if field values for a text field in a drop zone contain a lot of information, such as survey result data.

Viz Type	Results
Area Chart	Workday returns up to: 100 values on the x-axis. 250 color groupings per x-axis value, plus the Other group. 40 million cells, whether or not the cell contains data. Empty cells don't display in a chart viz like they do in a pivot table viz. However, this limitation still applies.
Bar Chart	Workday returns up to: 100 values on the x-axis. 250 color groupings per x-axis value, plus the Other group. 40 million cells, whether or not the cell contains data. Empty cells don't display in a chart viz like they do in a pivot table viz. However, this limitation still applies.
Chart	Workday returns up to: 100 values on the x-axis. 250 color groupings per x-axis value, plus the Other group. 40 million cells, whether or not the cell contains data. Empty cells don't display in a chart viz like they do in a pivot table viz. However, this limitation still applies.
Donut Chart	Workday returns up to 250 color groupings, plus the Other group.
Heatmap	Workday returns up to: 100 values on the x-axis, plus the Other group. 100 values on the y-axis, plus the Other group.
Line Chart	Workday returns up to: 100 values on the x-axis. 250 color groupings per x-axis value, plus the Other group. 40 million cells, whether or not the cell contains data. Empty cells don't display in a chart viz like they do in a pivot table viz. However, this limitation still applies.
Pivot Table	Workday returns up to: 50,000 data rows. 12,000 row groupings (rows displayed in the pivot table). 250 column attribute groupings. 40 million cells, whether or not the cell contains data.
Scatterplot	Workday returns up to 250 color groupings, plus the Other group.
Table	Workday returns up to 50,000 data rows.

When you filter on a field that contains more than 5,000 values, Workday returns up to 5,000 distinct values in the

Filter panel

.

Scheduled Report Output

Access the

Schedule a Report

task to set up a schedule to run custom reports and deliver them to

My Reports

. You can also schedule reports to run as a single unit by grouping and bursting up to:

200 report groups that use an Excel template.

2,500 report groups that don't use an Excel template, such as a report that's in PDF or a nontemplate XLS format.

The limitation refers to the number of reports generated by the report group.

You can select 1 of these output types for the report:

Excel
.

Report (PDF)
.

Text (CSV)
.

View in Browser
for composite and matrix reports only.

Workday might deliver a file type other than your selected

Output Type

depending on the file size, Workday Markup Language (WML) size, or number of rows returned.

If an Excel or PDF report exceeds a WML size of 1GB, Workday generates a CSV file. Workday displays this warning message when this occurs: 'Workday generated a CSV file because the report exceeded the limits for the selected format. For large reports, Workday recommends selecting the CSV output option.
' You can select CSV as the preferred output format for future runs of the report.

Number of Rows	Supported Formats	Results
Fewer than 10,000	Excel , Report (PDF) , and Text (CSV)	Workday generates the report in the selected Output Type format.
Between 10,000 and 500,000	Excel and Text (CSV)	If you select Excel as the Output Type format, Workday generates the report in Excel . If you select Report (PDF) or Text (CSV) , Workday generates the report in Text (CSV) format.
Between 500,000 and 1 million	Text (CSV)	Workday generates the report in Text (CSV) format.
More than 1 million	Text (CSV)	Workday generates the report in Text (CSV) format provided the total Text (CSV) file size remains under 15 GB.

You can use the

Process Monitor

report to determine if Workday switched to another supported format, or if Workday didn't generate the report.

Reports Run in the Browser

Report Type	Results
All	The file size limit for report results is 50 MB and 15 GB for scheduled reports. Workday limits report results to 50 MB for composite reports and matrix reports with a scheduled report output of View in Browser . The XML string limit is 2 GB. Workday limits tabular data processing to 5 seconds.
Advanced	Workday returns up to: 1,000 instances. 10,000 rows for nonsupported pagination. 50,000 rows for reports with drill to details or supported pagination. Workday processes the Group by Field only for reports with column or row grouping if there are 1 million or fewer post-filter instances. The limit doesn't affect indexed fields.
Composite	The file size limit for composite results with a scheduled report output of View in Browser is 50 MB. Workday returns up to: 100,000 cells. 1,000 columns. 16,000 rows. For reports with drill-down, Workday returns up to: 50,000 rows for supported pagination. 10,000 rows for nonsupported pagination.
Matrix	The file size limit for matrix results with a scheduled report output of View in Browser is 50 MB. Workday returns up to: 250 columns. 12,000 rows. In the report definition, you can add up to 15 summarization rows. For reports with drill-down, Workday returns up to: 50,000 rows for supported pagination. 10,000 rows for nonsupported pagination. 80,000 drill-down cells. For reports using Prism data sources, Workday returns up to: 1 million instances for count distinct aggregations. Workday can process up to 1 million rows for reports with aggregations and up to 40 million rows for: Background reports. Scheduled reports. Web services. Workday processes the Group by Field only for reports with column or row grouping if there are 1 million or fewer post-filter instances. The limit doesn't affect indexed fields.
nBox	Workday enables up to 100 images for each nBox cell. For reports with drill-down, Workday returns up to: 50,000 rows for supported pagination. 10,000 rows for nonsupported pagination.
Search	Workday returns up to 2,000 instances. The limit doesn't affect mass actions within search reports. There is a limit of 300,000 instances for a single facet for search reports.
Simple	Workday returns up to: 1,000 instances. 50,000 rows.
Transposed	Workday returns up to: 1,000 instances. 50,000 rows.
Trending	For reports with drill-down, Workday returns up to: 50,000 rows for supported pagination. 10,000 rows for nonsupported pagination. 80,000 drill-down cells. Workday can process up to: 1 million rows for reports with aggregated rows. 40 million rows for background reports, scheduled reports, and web services. Workday processes the Group by Field only for reports with column or row grouping if there are 1 million or fewer post-filter instances. The limit doesn't affect indexed fields.

Displaying Report Designer in the Browser

Workday limits the number of:

Cells for multi-instance columns and fields to 1 million for composite, matrix, and trending reports.

Top-level rows to 50,000 for all reports.

Your composite report can have an unlimited number of columns and rows. Adding more columns or rows might affect the response time of the report designer. These browser limits restrict what you see in the report designer:

Browser	Rows Displayed	Columns Displayed
Internet Explorer 11	50	20
All other browsers	200	50

Exporting to Excel

Workday adheres to these Microsoft Excel 2007 or newer limitations when exporting a composite report with outlining:

Type	Limit
Columns	16,384
Rows	1,048,576

Report Performance Logs

You can use report performance logs to troubleshoot performance issues in your reports.

Mobile Devices

You can enable dashboards and reports for mobile so that it's easier to view reporting data on Android, iPad, and iPhone devices. Managers and executives can also view metrics and key performance indicators on mobile applications.

Workday designs mobile apps for self-service, so not all reporting features are available. To access all features, sign in on a browser or desktop.

Your tenant configuration determines how dashboards and reports display. For custom reports and worklets on iPads, Workday doesn't support:

Hiding table borders and column headings.

Manually refreshing data. The data refreshes every time you access the report or worklet.

Maximizing reports.

Using 3D chart options.

For mobile devices, Workday doesn't support:

Creating composite reports.

Creating custom dashboards.

Saving custom prompt values for worklets.

Using dual-axis and combination charts.

Viewing all or conditional formatting styles for composite reports.

Workday doesn't support these reports on mobile:

Calendars.

XpressO reports with 2 tabs.

XpressO reports that use data pulled from the related business object.

Dashboard availability depends on your security configuration, but we support many Workday-delivered dashboards on mobile. To determine if Workday enables a dashboard for mobile devices:

Access the

Maintain Dashboards

report.

From the related actions menu of a dashboard, click

Dashboard

Edit

.

Access the

Settings

tab.

View the enabled

Device Type

in the

Task Information

section.