Limitations and restrictions

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.

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.