Analysis and Report Limits
Limits on analysis and reports prevent long-running queries.
Examples include:
-
Analytics row limits
-
Query time limits
-
Report Memory Guard limits
Note that when you're reporting on HTML content, for example, Message Body of an SR Message is a report column, you can observe that HTML tags are displayed in the report, in addition to the desired content. In order to display the content correctly without the tags, set the Column Properties > Data Format to Treat Text as HTML for the column. Select Save as the system-wide default for that particular column (not the default for this data type). Once you do this, any time a report is created that contains this column, it will automatically display HTML content correctly.
When you export data in a CSV format, dates are exported in raw format and converted to UTC time zone.
This table describes the limits that constrain queries.
|
Application |
Context |
Limit |
Description |
Limit Setting |
|---|---|---|---|---|
|
Analytics Answers |
Analysis |
Query Time Limit - Minutes |
Time (in minutes) allowed for a query to return from the database. |
10 |
|
Analytics Answers |
Analysis |
Rows Retrieved By SQL Query |
Maximum rows retrieved by a logical SQL query. |
75,000 |
|
Analytics Answers |
Analysis |
Rows Exported - CSV/Tab/XML - All Data - Export On Demand |
Maximum data rows exported from the analysis into CSV, Tab Delimited and XML formats. This limit is enforced when the user exports directly from the analysis. |
65,000 |
|
Analytics Answers |
Analysis |
Rows Exported - CSV/Tab/XML - All Data - Export Through Agent |
Maximum data rows exported from the analysis into CSV, Tab Delimited and XML formats. This limit is enforced when you export using a scheduled agent. |
25,000 |
|
Analytics Answers |
Table |
Maximum Rows Used To Populate Table |
Maximum rows that can returned from an analysis query when populating the table. Anything higher than this results in failure to render the table. |
75,000 |
|
Analytics Answers |
Table |
Rows Exported - Excel/PDF - Per View - Export On Demand |
Maximum rows exported from a view to formats like PDF, Excel and Powerpoint. This limit is enforced when the user exports directly from the analysis. |
25,000 |
|
Analytics Answers |
Table |
Rows Exported - Excel/PDF - Per View - Export Through Agent |
Maximum rows exported from a view to formats like PDF, Excel and Powerpoint. This limit is enforced when you export using a scheduled agent. |
25,000 |
|
Analytics Answers |
Table |
Cells |
Maximum number of data cells in a table view. |
1,000,000 |
|
Analytics Answers |
Table |
Sections |
Maximum number of sections available for the view. |
25 |
|
Analytics Answers |
Table |
Default Rows Per Page In View |
Default rows displayed per page in the view. This can be increased in the view properties. |
25 |
|
Analytics Answers |
Table |
Maximum Rows Per Page In View |
Maximum rows that can be displayed per page in the view. |
500 |
|
Analytics Answers |
Table |
Prompt Values |
Maximum number of values allowed in Table Prompt. Exceeding this value results in 'Exceeded configured maximum number' error. |
1,000 |
|
Analytics Answers |
Pivot Table |
Maximum Rows Used To Populate Pivot Table |
Maximum number of rows that can be returned from an analysis query when populating the pivot table. Anything higher than this results in failure to render the pivot table. |
40,000 |
|
Analytics Answers |
Pivot Table |
Rows Exported - Excel/PDF - Per View - Export On Demand |
Maximum rows exported from a view to formats like PDF, Excel and Powerpoint. This limit is enforced when the user exports directly from the analysis. |
25,000 |
|
Analytics Answers |
Pivot Table |
Rows Exported - Excel/PDF - Per View - Export Through Agent |
Maximum rows exported from a view to formats like PDF, Excel and Powerpoint. This limit is enforced when you export using a scheduled agent. |
25,000 |
|
Analytics Answers |
Pivot Table |
Cells |
Maximum populated cells of data in the view. |
1,000,000 |
|
Analytics Answers |
Pivot Table |
Sections |
Maximum sections available for the view. |
25 |
|
Analytics Answers |
Pivot Table |
Default Rows Per Page In View |
Default rows displayed per page in the view. This can be increased in the view properties. |
25 |
|
Analytics Answers |
Pivot Table |
Maximum Rows Per Page In View |
Maximum rows that can be displayed per page in the view. |
500 |
|
Analytics Answers |
Pivot Table |
Prompt Values |
Maximum number of values that can be returned in a Pivot prompt. Exceeding this value results in 'Exceeded configured maximum number' error. |
1,000 |
|
Analytics Answers |
Pivot Table |
Columns In Export |
Maximum exportable columns. |
300 |
|
Analytics Answers |
Chart |
Sections |
Maximum sections available for the view. |
25 |
|
Analytics Answers |
Chart |
Slider Values |
Maximum amount of values available on the slider. |
150 |
|
Analytics Answers |
Chart |
Rows Displayed |
Maximum amount of data points available on the chart. |
2,000 |
|
Analytics Answers |
Chart |
Prompt Values |
Maximum number of values listed in the view prompt. Exceeding this value results in 'Exceeded configured maximum number' error. |
1,000 |
|
Analytics Answers |
Simple Trellis |
Maximum Rows Used To Populate Simple Trellis |
Maximum rows that can returned from an analysis query when populating the simple trellis. Anything higher than this results in failure to render the simple trellis. |
40,000 |
|
Analytics Answers |
Simple Trellis |
Cells |
Maximum populated cells of data in the view. |
1,000 |
|
Analytics Answers |
Simple Trellis |
Sections |
Maximum sections available for the view. |
10 |
|
Analytics Answers |
Simple Trellis |
Default Rows Per Page In View |
Default rows displayed per page in the view. This can be increased in the view properties. |
10 |
|
Analytics Answers |
Simple Trellis |
Maximum Rows Per Page In View |
Maximum rows that can be displayed per page in the view. |
100 |
|
Analytics Answers |
Simple Trellis |
Column In Export |
Maximum exportable columns. |
75 |
|
Analytics Answers |
Simple Trellis |
Prompt Values |
Maximum number of values listed in the view prompt. Exceeding this value results in 'Exceeded configured maximum number' error. |
1,000 |
|
Analytics Answers |
Simple Trellis |
Rows Exported - Excel/PDF - Per View - Export On Demand |
Maximum rows exported from a view to formats like PDF, Excel and Powerpoint. This limit is enforced when the user exports directly from the analysis. |
6,500 |
|
Analytics Answers |
Simple Trellis |
Rows Exported - Excel/PDF - Per View - Export Through Agent |
Maximum rows exported from a view to formats like PDF, Excel and Powerpoint. This limit is enforced when you export using a scheduled agent. |
100 |
|
Analytics Answers |
Advanced Trellis |
Maximum Rows Used To Populate Advanced Trellis |
Maximum rows that can returned from an analysis query when populating the advanced trellis. Anything higher than this results in failure to render the advanced trellis. |
40,000 |
|
Analytics Answers |
Advanced Trellis |
Cells |
Maximum populated cells of data in the view. |
5,000 |
|
Analytics Answers |
Advanced Trellis |
Sections |
Maximum sections available for the view. |
25 |
|
Analytics Answers |
Advanced Trellis |
Default Rows Per Page In View |
Default rows displayed per page in the view. This can be increased in the view properties. |
10 |
|
Analytics Answers |
Advanced Trellis |
Maximum Rows Per Page In View |
Maximum rows that can be displayed per page in the view. |
100 |
|
Analytics Answers |
Advanced Trellis |
Columns In Export |
Maximum exportable columns. |
150 |
|
Analytics Answers |
Advanced Trellis |
Prompt Values |
Maximum number of values listed in the view prompt. Exceeding this value results in 'Exceeded configured maximum number' error. |
1,000 |
|
Analytics Answers |
Advanced Trellis |
Rows Exported - Excel/PDF - Per View - Export On Demand |
Maximum rows exported from a view to formats like PDF, Excel and Powerpoint. This limit is enforced when the user exports directly from the analysis. |
10,000 |
|
Analytics Answers |
Advanced Trellis |
Rows Exported - Excel/PDF - Per View - Export Through Agent |
Maximum rows exported from a view to formats like PDF, Excel and Powerpoint. This limit is enforced when you export using a scheduled agent. |
100 |
|
Analytics Answers |
Treemap |
Prompt Values |
Maximum number of values listed in the view prompt. Exceeding this value results in 'Exceeded configured maximum number' error. |
1,000 |
|
Analytics Answers |
Treemap |
Cells |
Maximum populated cells/tiles of data in the view. |
5,000 |
|
Analytics Answers |
Treemap |
Sections |
Maximum sections available for the view. |
50 |
|
Analytics Answers |
Narrative |
Rows |
Maximum records available in the view. |
40,000 |
|
Analytics Answers |
Ticker |
Rows |
Maximum records available in the view. |
40,000 |
|
Analytics Answers |
Dashboard |
Rows Exported - Excel/PDF - Per View - Export On Demand |
For tables, pivot tables and trellis views, if the view is set to "Fixed headers with scrolling content", rows visible on the dashboard are exported, and no more. For example, if a table is showing five rows before scrolling, five rows are exported, even if the table has more rows. If the view is set to "Fixed headers with scrolling content", an export of the number of rows specified in the view's "Rows Per Page" parameter is attempted. This setting doesn't override other row or cell limits, so setting this to a very high row limit only guarantees the standard view's export limits are honored when exporting from a dashboard. The "Rows Per Page" setting can be higher than the actual limit of rows that can be viewed per page in Analytics Answers. Even if the higher row limit doesn't apply at runtime, it applies at export. For example, if the table limit is 500 rows per page, but you set it to 25,000, an attempt is made to export 25,000 rows. |
|
|
Analytics Answers |
Dashboard |
Rows Exported - Excel/PDF - Per View - Export Through Agent |
The same rules apply as for Export on Demand, but the exports are subject to limits enforced when exporting data through agents. |
|
|
Analytics Publisher |
Memory Guard |
Maximum report data size for online reports |
Maximum data size allowed for online report viewing. When a report data size exceeds the value, the report receives an 'XML Output generated exceeds specified file size limit' error. |
300MB |
|
Analytics Publisher |
Memory Guard |
Maximum report data size for offline (scheduled) reports |
Maximum data size allowed for scheduled reports. When a report data size exceeds the value, the report receives an XML Output generated exceeds specified file size limit error. |
500MB |
|
Analytics Publisher |
Memory Guard |
Free memory threshold |
Minimum value for free JVM space. If the report data size exceeds the threshold, then the report is paused to wait for free memory to become available. The report waits for the time specified in the property Maximum Wait Time for Free Memory to Come Back Above Threshold Value. If the free memory doesn't rise back above the minimum in the wait period specified, the report request is rejected. |
500MB |
|
Analytics Publisher |
Memory Guard |
Maximum report data size under the free memory threshold |
Maximum single report data size allowed when free JVM memory is under the specified threshold value set in Free memory threshold. For example, assuming the default setting of 500MB, if the data generated for a single report exceeds one-tenth of the value set for Free memory threshold, or 50MB, then processing is terminated. |
Free memory threshold/10 |
|
Analytics Publisher |
Memory Guard |
Maximum Wait Time for Free Memory to Come Back Above the Threshold |
Maximum time in seconds that a request to run a report waits for free JVM memory to exceed the threshold value. If the free memory becomes available within the time specified, the request proceeds immediately. If free memory is still below the threshold value after the time specified, the request is rejected. For online requests, the larger this property value, the longer the browser will wait for a request to run. |
30 |
|
Analytics Publisher |
Memory Guard |
Process timeout for online report formatting |
For online reports, the maximum time in seconds that a formatting process is allowed to run. If an online report formatting process exceeds the limit, the report errors. |
600 |
|
Analytics Publisher |
Data Model |
Maximum data size limit for data generation |
Maximum XML data size that can be generated from the execution of a data model. This setting applies to both online and scheduled report requests. When the size of the file generated exceeds the value, execution of the data model is terminated and an exception is generated. |
500MB |
|
Analytics Publisher |
Data Model |
Maximum sample data size limit |
Maximum file size of a sample data file that can be uploaded to the data model editor. |
1MB |
|
Analytics Publisher |
Data Model |
DB fetch size |
20 |
|
|
Analytics Publisher |
Data Model |
SQL Query Timeout (in seconds) |
600 |