Business Intelligence (BI) supports selecting a table from connected data sources as a data table using the data source table creation method. The specific operation steps and process are shown below.
Creating a Data Source Table
In the Data Table module under Data, click Create Data Table, select a data source table, and enter the following parameters:
Display name: The display name of the data table in BI.
Folder (optional): Click the drop-down icon to select a created folder.
Select data source: Click the drop-down icon to select a connected data source. Click "Create data source" to open the data source list page in a new window, and a pop-up window for creating a data source will appear. After creation, click the drop-down list again to load the created data source.
Select data table: Click the drop-down icon to select a data table from the selected data source.
Field Selection and Field Configuration
1. After a data table is selected, all fields of the table will be loaded. You can select the fields, and the selected fields will be the fields of the data table. Selecting all fields is supported.
2. The meanings of field configuration items are as follows.
Field value: The name of the field in the data source.
Field Chinese name: The display name of the field in BI. The name defaults to the field name and supports editing.
Field type: Available options are "time", "character", "numeric value", and "associated dictionary". By default, the field format needs to be read. When "time" is selected, you can perform a second-level selection for different granularities of the time format.
Remarks: Used to record the definition of the field. You can use the remarks as the table header definition when configuring a report table component.
Operations: Dictionary table association and field deletion can be performed
. When Associated Dictionary is selected, you can select the dictionary table to be associated for mapping.
Operation Items
View: Click to view the details data in a data table.
Edit: Click to edit a data table, including new data table parameters and field configuration information.
Delete: Click for secondary confirmation to delete a field.
