Limitations and restrictions in Ad-hoc Report

This section contains information about limits and restrictions of an ad-hoc report.

Report calculation limit

These limitations apply:

An ad-hoc report cannot exceed 2 million values.
The element tree can show maximum of 20000 elements. The maximum number of elements that are displayed in an element tree depends on the number of attributes that are defined within a specific hierarchy. The greater is the number of attributes within a hierarchy, the lesser is the maximum number of elements that are displayed in an element tree.

Note: An error message is displayed when limitation is exceeded.

A report or query that exceeds the limit can be logged as an event in the application logs. The event name is Values Limit Exceeded (Number of values exceeded limit) and is used for all components.

Maximum size of ad-hoc report

Maximum size of a report is 1000 rows and 1000 columns.

Availability

You can have access to the Ad-hoc Report widget only if the application permission Use Ad-hoc is assigned to you. By default, the permission is assigned only to MasterRole. The Use Ad-hoc permission must be added manually to custom application roles.

Functionality

Element and dynamic selections do not work with Microsoft Analysis Services.