Each Quick BI module has recommended values and limits. Exceeding the recommended values can degrade report and system performance.
Product limits
Data source
|
Category |
Description |
Recommended |
Limit |
|
Data source |
Maximum data sources per workspace |
/ |
100 |
|
Maximum file upload size per data source |
/ |
50 MB |
Dataset
|
Category |
Description |
Recommendation |
Limit |
|
Dataset |
Layer depth of the associated model |
/ |
5 |
|
Number of dataset fields |
100 |
/ |
|
|
Number of tables in a dataset |
/ |
100 |
|
|
Number of groups for a grouped field |
10 |
50 |
|
|
Length of calculated field |
/ |
16384 |
|
|
Nesting depth of calculated field |
/ |
5 |
|
|
Length of custom SQL |
/ |
65536 |
|
|
Number of placeholders |
10 |
100 |
|
|
Number of filter conditions |
/ |
100 |
|
|
Number of datasets per workspace |
/ |
1000 |
Data preparation
|
Category |
Description |
Recommended value |
Limit |
|
Data preparation |
Number of data preparation jobs per workspace |
/ |
100 |
|
Number of rows for data preview |
/ |
1000 |
|
|
Number of variables |
/ |
5 |
|
|
Number of components |
/ |
20 |
|
|
Number of fields per component |
/ |
200 |
|
|
Number of input components |
/ |
5 |
|
|
Number of fields per input component |
/ |
200 |
|
|
Number of output components |
/ |
1 |
|
|
Number of join components |
/ |
5 |
|
|
Number of groups per group assignment |
/ |
50 |
Data entry
|
Category |
Description |
Recommended value |
Limit |
|
Data entry |
Data entries per workspace |
/ |
1,000 |
Spreadsheet
|
Category |
Description |
Recommended value |
Limit |
|
Spreadsheet |
Number of sheets per spreadsheet |
100 |
300 |
|
Number of charts per sheet |
20 |
200 |
|
|
Number of floating images per sheet |
50 |
100 |
|
|
Number of rows per download |
/ |
20000 |
|
|
Number of datasets per sheet |
50 |
200 |
|
|
Total number of charts per spreadsheet |
100 |
200 |
|
|
Number of splits in card view |
5000 |
10000 |
|
|
Number of spreadsheets per workspace |
/ |
1000 |
|
|
Number of rows per update in interactive data entry (per sheet) |
/ |
1000 |
|
|
Number of rows per deletion in interactive data entry (per sheet) |
/ |
5000 |
|
|
Number of rows per insertion in interactive data entry (per sheet) |
/ |
5000 |
Dashboard
|
Category |
Description |
Recommended value |
Limit value |
|
Dashboard |
Number of maps per dashboard |
2 |
7 |
|
Number of charts per dashboard |
100 |
200 |
|
|
Number of tabs per dashboard |
50 |
100 |
|
|
Number of fields in a crosstab, details table, metric card, or trend chart |
100 |
300 |
|
|
Number of metrics per trend analysis table |
/ |
300 |
|
|
Number of time periods per trend analysis table |
/ |
1000 |
|
|
Number of dimensions per multidimensional analysis table |
/ |
10 |
|
|
Number of metrics per multidimensional analysis table |
/ |
50 |
|
|
Number of time periods per multidimensional analysis table |
/ |
100 |
|
|
Number of metrics × number of dimension values per multidimensional analysis table |
/ |
200000 |
|
|
Number of cells per multidimensional analysis table |
/ |
2000000 |
|
|
Number of embedded pages per dashboard |
5 |
20 |
|
|
Number of placeholders per dashboard |
10 |
100 |
|
|
Number of dashboards per workspace |
/ |
1000 |
Dashboard
|
Category |
Description |
Recommended |
Limit |
|
Dashboard |
Number of pages per dashboard |
5 |
10 |
|
Number of embedded pages per dashboard |
5 |
30 |
|
|
Number of charts per page |
100 |
200 |
|
|
Number of dashboards per workspace |
/ |
1000 |
Self-service data retrieval
|
Item |
Description |
Recommended value |
Limit value |
|
Self-service data retrieval |
Rows per download (standard) |
/ |
1000000 |
|
Rows per download (crosstab) |
/ |
200000 |
|
|
Retrieval jobs per workspace |
/ |
1000 |
Insight attribution
|
Item |
Description |
Recommended value |
Limit |
|
Business insight |
Number of business insights per workspace |
/ |
100 |
|
Metric insight |
Number of metric insights per workspace |
/ |
1000 |
Ad hoc analysis
|
Specification |
Description |
Recommended value |
Limit |
|
Ad hoc analysis |
Number of ad hoc analyses per workspace |
/ |
1000 |
Data portal
|
Item |
Description |
Recommended value |
Limit |
|
data portal |
Maximum number of menu items per data portal |
/ |
500 |
|
Maximum menu nesting depth |
/ |
5 |
|
|
Maximum number of data portals per workspace |
/ |
100 |
Data query
|
Category |
Parameter |
Recommended value |
Limit |
|
Data query |
number of rows per query |
/ |
10,000 |
|
number of columns per query |
/ |
500 |
|
|
number of cells per query |
/ |
1,000,000 |
|
|
number of manually entered values in a query control |
1,000 |
/ |
|
|
total number of query control elements |
100 |
300 |
|
|
auto-refresh |
60 seconds |
/ |
|
|
query timeout |
/ |
5 minutes |
Organization management
|
Type |
Description |
Recommended value |
Limit |
|
organization user |
Number of organization user groups |
N/A |
1000 |
|
Organization user group hierarchy depth |
N/A |
10 |
|
|
Number of organization user tags |
N/A |
100 |
|
|
Character limit for organization user tags |
N/A |
1000 |
|
|
Number of custom organization roles |
N/A |
100 |
|
|
Number of roles per user |
N/A |
3 |
|
|
workspace |
Number of workspaces |
N/A |
100 |
Workplace collaboration
|
Item |
Description |
Recommended value |
Limit |
|
Office software integration |
Maximum number of office software integrations per organization |
/ |
5 |
|
Push subscription |
Total number of push subscriptions |
/ |
500 |
|
Total number of Xiao Q report subscriptions |
/ |
100 |
|
|
Monitoring and alerting |
Total number of monitoring and alerting rules |
/ |
500 |
|
Maximum number of data points for an alerting metric |
/ |
1,000,000 |
|
|
Maximum number of breakdown dimensions for an alert |
/ |
5 |
Open platform
|
Category |
Description |
Recommended value |
Limit |
|
Data Service |
Number of data services |
/ |
1000 |
|
Number of data service request parameters |
/ |
100 |
|
|
Number of data service response parameters |
/ |
100 |
|
|
Custom Extensions |
Number of custom templates |
/ |
1000 |
|
Number of custom themes |
/ |
50 |
|
|
Number of custom components |
/ |
100 |
|
|
Number of custom menus |
/ |
100 |
|
|
Number of custom GeoJSON maps |
/ |
10 |
|
|
Number of custom geographic areas |
/ |
10 |
|
|
Number of custom basemap images |
/ |
10 |
|
|
Total file size of custom drivers for all data sources |
/ |
1000 MB |
|
|
Maximum file size of a custom driver for a data source |
/ |
100 MB |
|
|
Embedded Analytics |
Number of report embedding configurations |
/ |
10 |
Other
|
Category |
Description |
Recommended value |
Limit |
|
data lineage |
Maximum number of resources displayed per lineage analysis |
/ |
500 |
|
list page |
Maximum nesting depth of a resource list page |
/ |
5 |
|
resource plan |
Maximum number of data products per resource plan |
/ |
500 |
|
request body |
Maximum redirect URL length |
/ |
2800 |
|
intelligent data query |
Maximum number of fields per dataset for the intelligent data query feature |
/ |
200 |