Data Volume Description

  • Last update:July 08, 2024
  • Overview

    Version

    FineBI Version

    Functional Change

    6.0

    -

    6.0.2

    Changed the logic of simplest tables. 

    For details, see section "Notes."

    6.0.8

    Changed the logic of switching the limit on the data volume.

    For details, see section "Notes."

    6.1

    1. Limited the source table of all resources in a subject only by the data volume of the current subject, not by the update status of the parent table (in which case data may be empty).

    2. Changed the data volume setting entry from the data editing 

    page to the top of the analysis subject page.

    Update compatibility: The initial data volume limit of a subject is 10 million by default.

    Application Scenario

    Some users may engage in improper operations when using FineBI, which may affect other users' use or the system performance stability.

    FineBI allows you to limit the data volume on the data editing page of analysis subjects to avoid such issues, ensuring the normal FineBI use.

    Function Entry

    You can set the number of data rows for calculation when editing data in an analysis subject, as shown in the following figure.

    微信图片_20240628140834.png

    Function Description

    Data Volume Limit Tier

    You can set the data volume for calculation when editing an analysis subject. The following table shows the number of records for calculation that can be switched to in different data volumes.


    Data VolumeData Volume Configuration Item
    Extraction
    < 10 million rowsFirst 100K/10 million rows or full volume
    ≥ 10 million rowsFirst 100K/10 million rows or full volume
    Direct Connection

    Full volume of data records are used for calculation for all 

    resources.

    First 100K rows or full volume

    The following table shows the effects corresponding to different data volumes.


    Configuration Item Name

    First 100K Rows or Full Volume

     (High Performance)

    Default Subject Configuration

    (More Data as Possible, More Accurate the Result)

    ExtractionDataset

    The upper limit of the data volume 

    for calculation is 100K rows.

    A maximum of 10 million rows can be used for calculation.

    Component

    Not updated: 

    The upper limit of the data volume 

    for calculation is 100K rows.

    Updated:

    The upper limit of the data volume 

    for calculation is 100K rows.


    Not updated: 

    The upper limit of the data volume for calculation is 10 

    million rows. 

    Full-volume data is accessible after update. 

    (orange background).

    Updated:

    The upper limit of the data volume for calculation is full 

    volume (green background).

    Dashboard

    Not updated: 

    The upper limit of the data volume 

    for calculation is 100K rows.

    Updated:

    The upper limit of the data volume 

    for calculation is 100K rows.

    Not updated: 

    The upper limit of the data volume for calculation is 10 

    million rows. 

    Full data volume is accessible after update

    (orange background).

    Updated:

    The upper limit of the data volume for calculation is full volume (green background)

    Direct ConnectionDataset

    The upper limit of the data volume 

    for calculation is 100K rows.

    Full-volume data is used for calculation.
    Component

    The upper limit of the data volume 

    for calculation is 100K rows.

    Full-volume data is used for calculation.
    Dashboard

    The upper limit of the data volume 

    for calculation is 100K rows.

    Full-volume data is used for calculation.

    Data Volume Limit of the Source Table

    The source table of all resources in a subject is limited only by the data volume of the current subject, not by the update status of the parent table. 

    The row quantity of the source table in the dataset is limited. 

    For example, B and C are the source tables of A.

    If the dataset is directly connected, the data volume of B and C for calculation is limited to full volume.

    If the dataset is extracted, the data volume can be switched to only 100K/10 million rows.

    Notes

    In 6.0.8 and later versions, if the source table (parent table) of the edited data is currently not extracted, the switching option will be grayed out, allowing you to only use the first 10 million rows of data for calculation, as shown in the following figure.

    e35ae271ee715233268bd4208ffde82.png

    The following content shows the scenarios where the source table is not extracted:

    1. The source table is a non-simplest table that is currently not extracted.

    2. The source table is the simplest table that is never extracted. The simplest table must be a published and self-service dataset uploaded not through Excel and meet the following two conditions:

    No association is established.

    Only the table selection step or the step of field settings (excluding field type conversion) is performed on the table.

    附件列表


    主题: Adding and Editing Data
    • Helpful
    • Not helpful
    • Only read

    滑鼠選中內容,快速回饋問題

    滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。

    不再提示

    10s後關閉

    Get
    Help
    Online Support
    Professional technical support is provided to quickly help you solve problems.
    Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
    Page Feedback
    You can provide suggestions and feedback for the current web page.
    Pre-Sales Consultation
    Business Consultation
    Business: international@fanruan.com
    Support: support@fanruan.com
    Page Feedback
    *Problem Type
    Cannot be empty
    Problem Description
    0/1000
    Cannot be empty

    Submitted successfully

    Network busy