This topic outlines the specifications and limitations for each module in Quick BI. For optimal performance of Quick BI reports and systems, it is advisable to adhere to the recommended specification limits.
Product Thresholds
Data Source
Specification classification | Specification description | Suggested value | Limit value |
Data source | Number of data sources (per workspace) | / | 100 |
Data source upload file size | / | 50 (MB) |
Dataset
Specification classification | Specification description | Suggested value | Limit value |
Dataset | Depth of dataset associated model layer | / | 5 |
Number of dataset fields | 100 | / | |
Number of tables in a dataset | / | 100 | |
Number of dataset grouping fields | 10 | 50 | |
Length of dataset calculated field | / | 16384 | |
Depth of dataset calculated field nesting | / | 5 | |
Length of dataset custom SQL | / | 65536 | |
Number of dataset placeholders | 10 | 100 | |
Number of dataset filter conditions | / | 100 | |
Number of datasets (per workspace) | / | 1000 |
Data Preparation
Specification classification | Specification description | Suggested value | Limit value |
Data preparation | Number of data preparations (per workspace) | / | 100 |
Number of data preparation preview rows | / | 1000 | |
Number of data preparation variables | / | 5 | |
Number of data preparation widgets | / | 20 | |
Number of data fields in data preparation widgets | / | 200 | |
Number of data preparation input widgets | / | 5 | |
Number of data fields in data preparation input widgets | / | 200 | |
Number of data preparation output widgets | / | 1 | |
Number of data preparation association widgets | / | 5 | |
Number of data preparation grouping assignments | / | 50 |
Data Reporting
Specification classification | Specification description | Suggested value | Limit value |
Data reporting | Number of data reports (per workspace) | / | 1000 |
Workbook
Specification classification | Specification description | Suggested value | Limit value |
Workbook | Number of sheets in workbook | 100 | 300 |
Number of charts in a single sheet of workbook | 20 | 200 | |
Number of floating images in a single sheet of workbook | 50 | 100 | |
Number of rows for workbook download | / | 20000 | |
Number of datasets in a single sheet of workbook | 50 | 200 | |
Total number of charts in workbook | 100 | 200 | |
Number of splits in workbook card view | 5000 | 10000 | |
Number of workbooks (per workspace) | / | 1000 | |
Number of rows for interactive reporting modification submission (per sheet) | / | 1000 | |
Number of rows for interactive reporting deletion submission (per sheet) | / | 5000 | |
Number of rows for interactive reporting insertion submission (per sheet) | / | 5000 |
Product Thresholds
Data Source
Specification classification | Specification description | Recommended value | Limit |
Data Source | Number of data sources per workspace | / | 100 |
Uploaded file size for data source | / | 50 MB |
Dataset
Specification Classification | Description | Recommended value | Limit value |
Dataset | Dataset-associated model layer depth | / | 5 |
Number of fields in the dataset | 100 | / | |
Number of tables in the dataset | / | 100 | |
Group count by dataset grouping field | 10 | 50 | |
Dataset calculated field length | / | 16384 | |
Nesting depth of a calculated field in a dataset | / | 5 | |
Custom SQL length | / | 65536 | |
Number of dataset placeholders | 10 | 100 | |
Number of dataset filter conditions | / | 100 | |
Number of datasets per workspace | / | 1000 |
Data Preparation
Specification classification | Description | Recommended value | Limit value |
Data preparation | Number of data preparations (per workspace) | / | 100 |
Number of rows for data preparation preview | / | 1000 | |
Number of data preparation variables | / | 5 | |
Number of data preparation components | / | 20 | |
Number of data fields in the data preparation component | / | 200 | |
Number of data preparation input components | / | 5 | |
Number of input data fields for the data preparation component | / | 200 | |
Number of data preparation output components | / | 1 | |
Number of associated components for data preparation | / | 5 | |
Assignment group count for data preparation | / | 50 |
Data Entry
Specification category | Description | Recommended value | Limit |
Data entry | Number of data submissions (single workspace) | / | 1000 |
Workbook
Specification category | Description | Recommended value | Limit value |
Workbook | Number of sheets in the workbook | 100 | 300 |
Charts per sheet | 20 | 200 | |
Number of floating images in a single sheet | 50 | 100 | |
Row count for workbook download | / | 20000 | |
Number of datasets per workbook sheet | 50 | 200 | |
Total workbook charts | 100 | 200 | |
Workbook card view split count | 5000 | 10000 | |
Workbooks per workspace | / | 1000 | |
Number of rows to submit at once in interactive data entry (single sheet) | / | 1000 | |
Number of rows to delete and submit at once for an interactive data entry form (per sheet) | / | 5000 | |
Number of rows to insert per submission in interactive data entry (per sheet) | / | 5000 |
Dashboard
Category | Description | Recommended value | Limit |
Dashboard | Number of maps | 2 | 7 |
Total number of charts | 100 | 200 | |
Total number of tabs | 50 | 100 | |
Number of fields in cross tables, detail tables, and metric card trend charts | 100 | 300 | |
Number of measures in a trend analysis table | / | 300 | |
Number of periods in a trend analysis table | / | 1000 | |
Number of dimensions in a multidimensional analysis table | / | 10 | |
Number of measures in a multidimensional analysis table | / | 50 | |
Number of periods in a multidimensional analysis table | / | 100 | |
Number of measures × Number of dimension values in a multidimensional analysis table | / | 200000 | |
Number of cells in a multidimensional analysis table | / | 2000000 | |
Number of embedded pages | 5 | 20 | |
Number of placeholders | 10 | 100 | |
Number of dashboards (per workspace) | / | 1000 |
Data Dashboards
Specification classification | Specification description | Suggested value | Limit value |
Data dashboards | Number of pages in data dashboard | 5 | 10 |
Number of embedded pages in data dashboard | 5 | 30 | |
Number of charts in a single page of data dashboard | 100 | 200 | |
Number of data dashboards (per workspace) | / | 1000 |
Downloads
Specification classification | Specification description | Suggested value | Limit value |
Downloads | Number of rows for downloads (normal) | / | 1000000 |
Number of rows for downloads (mixed row and column) | / | 200000 | |
Number of downloads (per workspace) | / | 1000 |
Ad Hoc Analysis
Specification classification | Specification description | Suggested value | Limit value |
Ad hoc analysis | Number of ad hoc analyses (per workspace) | / | 1000 |
BI Portal
Specification classification | Specification description | Suggested value | Limit value |
BI portal | Number of menus in BI portal | / | 500 |
Number of menu layers in BI portal | / | 5 | |
Number of BI portals (per workspace) | / | 100 |
Data Query
Specification classification | Specification description | Suggested value | Limit value |
Data query | Queried rows | / | 10000 |
Number of queried columns | / | 500 | |
Number of queried cells | / | 1000000 | |
Number of manually entered values in query control | 1000 | / | |
Total number of elements in query control | 100 | 300 | |
Auto-refresh | Maximum value: 60 seconds. | / | |
Query wait time | / | 5 minutes |
Organization Management
Specification classification | Specification description | Suggested value | Limit value |
Organization user | Number of organization user groups | / | 1000 |
Depth of organization user group layers | / | 10 | |
Number of organization user tags | / | 100 | |
Number of characters in organization user tags | / | 1000 | |
Number of custom roles in organization | / | 100 | |
Number of roles bound to organization users | / | 3 | |
Workspace | Number of workspaces | / | 100 |
Collaborative Office Services
Specification classification | Specification description | Suggested value | Limit value |
Office software integration | Maximum number of OA enterprises that can be bound to an organization | / | 5 |
Subscribe push | Total number of subscribe pushes | / | 500 |
Monitor alert | Total number of monitor alerts | / | 500 |
Number of data points in monitor alert metrics | / | 1000000 | |
Number of split dimensions in monitor alert | / | 5 |
Developer Portal
Specification classification | Specification description | Suggested value | Limit value |
Data service | Number of data services | / | 1000 |
Number of data service request parameters | / | 100 | |
Number of data service return parameters | / | 100 | |
Custom extension | Number of custom templates | / | 1000 |
Number of custom subjects | / | 50 | |
Number of custom widgets | / | 100 | |
Number of custom menus | / | 100 | |
Number of custom GeoJSON maps | / | 10 | |
Number of custom geographic regions | / | 10 | |
Number of custom base map images | / | 10 | |
Total file size of custom drivers for data sources | / | 1000 (MB) | |
Single file size of custom drivers for data sources | / | 100 (MB) | |
Embedding analytics | Number of external embedded report publishing channels | / | 10 |
Others
Specification classification | Specification description | Suggested value | Limit value |
Kinship analysis | Total number of displayed resources | / | 500 |
List Page | Depth of resource models page layers | / | 5 |
Resource plan | Number of data works in resource plan | / | 500 |
Request body | Length of redirect link | / | 2800 |
Intelligent Q&A | Number of fields in a dataset for Q&A learning | / | 200 |