All Products
Search
Document Center

Quick BI:Replace Dataset

Last Updated:Jun 06, 2024

When you apply templates in the template market or need to replace the data fields of all components in a dashboard at a time, it is inefficient to manually update data one by one if there are a large number of components in the report. You can use the Quick BI data replacement feature to replace page-level data and widget-level data. This feature improves the efficiency of building dashboards and reduces the cost of dataset switching. This topic describes how to replace a dataset.

Prerequisites

You are logged in Quick BI console and go to the dashboard edit page. For more information, see Create a dashboard.

Page-level data replacement

Procedure

  • On the dashboard editing page, click imagein the top navigation bar to view all datasets of the dashboard. image

  • Click Used Datasets to view all the fields in the dataset. Click image.pngicon to view the widgets that use the dataset. image.png

  • If you want to replace a dataset in the Used Datasets section, you can select an existing dataset from the Replace Dataset drop-down list. After you select the fields that you want to match, you must select the fields in the two datasets. Untitled.gif

Note

If one of the following conditions occurs, the error icon: No matching field exists or the field type is inconsistent.

image.png

Component-level data replacement

Scenario

  • When you copy components and card references from other dashboards, all fields and field-related configurations need to be reconfigured, which is costly.

  • Component-level dataset replacement is used to replace datasets for report components. This improves the efficiency of component configuration and reduces the cost of dataset switching.

Procedure

  • Replace Entry image.png

  • Click the switch box to switch between the used dataset and all datasets, and clear field configurations. Untitled.gif

  • If you want to replace the dataset and retain the field configurations, clickimage.png. image.png

    Select Replace Current Dataset to replace the dataset. Untitled.gif

Note

In addition to the configuration in the Fields panel, the Conditional Formats, Auxiliary Lines, Monitoring Alerts, and Labels in the Analysis panel are also replaced.

Precautions

  • Special Components

    • Component-level data replacement is not supported for query controls and tab-based query controls. If you click Switch Dataset and clear the field configuration.

      image

    • If fields that reference multiple datasets are used in a rich text component are replaced, the subquery is displayed on the Dataset Replacement page of the component. You must replace the subquery separately. Untitled.gif

  • Special Configuration

    If your chart is configured with remarks and endnotes and references multiple fields in multiple datasets, subqueries are displayed on the Component Dataset Replacement page. You must replace the subqueries separately. Untitled.gif

FAQ

What can I do if the target dataset is not found in the drop-down list?

  1. On the dashboard edit page, click the image.pngicon in the upper-left corner. image.png

  2. In the left-side navigation pane, click Datasets.

  3. In the Datasets list, check whether the specified dataset exists.

    If the dataset does not exist, create the dataset again. For more information, see Create and Manage Datasets.