Data Dictionary

Version

Function Description

Sometimes, the fields stored in the original data may not be suitable for display in reports. In other cases, you may find it difficult to modify the data during data query, yet specific display values are required in reports. Or different values need to be displayed in reports based on different original data. In these cases, you can use Data Dictionary to perform flexible conversions on the data

As shown in the following figure, the encoded data CustomerID is stored in the original data. However, you need to display the meaningful actual values of Company_name during data presentation.

Four types of data dictionaries are available, namely, Database Table, Data Dictionary, Custom, and Formula, each corresponding to different application scenarios.

Database Table

You can select Database Table for Type, select the corresponding database and table, and enter the actual value and the value that you want to display, as shown in the following figure.

Column Name represents the field names in the database table, while Column Index represents the left-to-right serial numbers of the fields in the database table.

If the data to be displayed in comparison comes from one table without being processed by the SQL statement, you can select Database Table for Type directly. The original data comes from the Client table, Actual Value of cell A1 is CustomerID in the Client table, and Display Value is Company_name in the Client table, as shown in the following figure.

Data Query

You can select Data Query for Type, select the corresponding dataset, and enter the actual value and the value that you want to display, as shown in the following figure.

Column Name represents the field names in the dataset, while Column Index represents the left-to-right serial numbers of the fields in the dataset.

If the data to be displayed in comparison comes from the dataset processed by the SQL statement, you can select Data Query for Type. The original data comes from the dataset ds1, Actual Value of cell A1 is the CustomerID field in ds1, and Display Value is the Company_name field in ds1, as shown in the following figure.

Custom

You can select Custom for Type and customize Display Value according to the values in the current cell, as shown in the following figure.

Custom is usually used to display values of the same type. Actual Value of cell C1 is the Region field in the dataset ds2, and Display Value is customized according to different regions to represent different sources of goods, as shown in the following figure.

Formula

You can select Formula for Type and modify values in the current cell by a formula, which is similar to Formula Form in Display, as shown in the following figure.

Formula is usually used to set special display formats for some cells. Actual Value of cell B1 is the Company_name field in dataset ds1, and the formula is used to add [Important Client] to L Brands, as shown in the following figure.