Dimension Dictionary

What is a dimension dictionary?

For existing event attributes and user attributes, you can create virtual attributes to map reported attribute values. Attributes with dimension dictionaries can be used in filtering and grouping. As shown in the following figure, there is a dictionary identifier to the right of the attribute of the dimension dictionary.

In Sensors Analytics 3.0 and above:

• Common Attributes:
  • Common properties of existing dictionaries: support for updating and deleting dictionaries, the dictionary cannot be uploaded again after it is deleted.
  • Common attribute without dictionary: Upload dictionary is not supported.
• Virtual Attribute:
  • You can upload, update, and delete a dictionary. After deleting a dictionary, you can upload it again.

Use Example

The dimension dictionary is uploaded on the page

Create virtual properties and add dictionaries

1. Select in turn Data Fusion > Metadata Management > User table/Event table > Virtual attribute.
2. Click on the top right corner Create Virtual Properties button.
3. Fill in the additional information for virtual properties and click Virtual attribute computing logic below add button.
4. Creation mode choose Copy a value from the common property and select Common Attribute.
5. Download Dimension Dictionary Template file, fill in the mapping relationship.
6. Click Upload File button to upload the dictionary file.
7. Click on the top right corner Save button.

• Only pairs < are supported. The string String> , < Number> , < Boolean Bool> Type attributes upload dimension dictionary;
• Yes. Number> < Boolean Bool> After the attributes of the type are uploaded to the dictionary, the created virtual attributes are automatically changed to < The string String> Type.

Edit dictionary

The dictionary file can be edited on the virtual Properties editing page.

If you want to directly overwrite the previously uploaded dictionary file, in the virtual properties edit page delete the current dictionary choose Yes, then upload a new dictionary file; If you want to keep a previously uploaded dictionary, add or update a map of some attribute values, then delete the current dictionary choose No, and upload a new dictionary file.

Cleat Dictionary

When editing virtual properties, delete the current dictionary choose Yes, if no new dictionary file is uploaded, the dictionary in the virtual property is cleared.

Upload dimension dictionary API

Support for < via API The string String> , < Number> , < Boolean Bool> Type attribute upload dictionary, see Dimension Dictionary API .

Download Dimension Dictionary

For an attribute that has a dimension dictionary, you can download an existing dimension dictionary on the attribute details page. The dictionary is saved as an xlsx file by default.

Result Presentation

Using event analysis as an example, query the total number of purchases from 2023-5-23 to 2023-10-26, where the items areMiniso hair card P000239.

If you select the original common attribute, the original value reported by the attribute is displayed in the filter criteria and result group list.

If a virtual attribute is copied and a dimension dictionary is uploaded based on this common attribute, you can select the created virtual attribute in event analysis. In this case, the value mapped to the dictionary is displayed in the filter condition and result group list. The use is similar in functions such as funnel analysis, retention analysis, etc.