Quick BI:Replace Dataset

Prerequisites

You have logged on to the Quick BI console and are on the dashboard editing page. For more information, see Create a dashboard.

Global dataset replacement

Procedure

1. On the dashboard editing page, click the Replace Dataset icon in the top menu bar to view a list of all datasets in the current dashboard.

2. Click a dataset under Used Datasets to view all the fields used from that dataset. These fields include Dataset Fields and New Fields in Report.

   Note

   1. Dataset Fields include original fields, calculated fields created in the dataset, and grouped dimensions.

   2. New Fields in Report include calculated fields and grouped dimensions created in the report.

   

3. Click the icon to view the list of widgets that use the dataset.

4. If a dataset in the Used Datasets list needs to be replaced, select an existing dataset from your workspace from the Replace with Dataset list on the right.

   

5. After you select a dataset, you must match the Dataset Fields and New Fields in Report between the two datasets.

   

   1. Dataset field matching

      1. Dataset fields with the same field name and field type are automatically matched.

      2. You can manually match dataset fields that have different names but the same type.

         

      3. The field matching process only shows fields of the same type. If the target dataset does not contain fields of the same type, a match cannot be made. In this case, you can either choose a different dataset for replacement or remove the fields from the report.

         

   2. New fields in report matching

      This supports Full Replacement and Split and Replace.

      1. Full Replacement: The matching logic is the same as for dataset field matching.

         

      2. Split and Replace: The system parses the expression of the new field created in the report. You need to match the fields and placeholders used in the expression. The system then automatically creates a field in the target dataset using the same expression.

         

         If a new field created in the report uses a placeholder, you can select Create and Replace. A new placeholder with the same name is automatically created in the target dataset.

         

         Note

         If a field, such as "Profit Amount", already exists in Dataset Fields, it is automatically matched during the Split and Replace process for New Fields in Report. You cannot modify this match.

6. After all fields are matched, click OK to complete the dataset replacement.

   

Widget-level data replacement

Scenarios

• When you copy widgets or reference cards from other dashboards, you must reconfigure all fields and field-related settings. This process is costly.

• Widget-level dataset replacement is designed for scenarios where a widget in a report needs a different dataset. This feature improves the efficiency of widget configuration and reduces the cost of switching datasets.

Procedure

1. Replacement entry point

   

2. Click the switch box to switch between used datasets and all datasets. This action also clears the field configurations.

   

3. If you want to replace the dataset but keep the field configurations, click the icon to the right of the dataset name.

   

   Select Replace Current Dataset to replace the dataset.

   

   Note

   In addition to the configurations on the Fields tab, settings on the Analysis tab are also replaced. These settings include conditional formatting, auxiliary lines, monitoring and alerts, and annotations.

Notes

• Special widgets

  • Query controls and query controls within tabs do not support widget-level data replacement. Clicking them defaults to Switch Dataset and Clear Field Configurations.

    

  • For a Rich Text widget, if it references fields from multiple datasets, subqueries are displayed on the widget dataset replacement page. You must replace each subquery separately.

• Special configurations

  If your chart is configured with remarks or endnotes that reference fields from multiple datasets, subqueries are also displayed on the widget dataset replacement page. You must replace each subquery separately.

FAQ