1. Overview

In data collection, data such as ID and type values are usually numeric (such as ad type 1, 2 and 3), which are not easy to understand. Taking item ID as an example, each ID may correspond to lots of properties, such as item name, item type, item price, attack value, defense value, etc. With only the ID value, it is impossible to analyze these related properties.

Therefore, dimension properties are designed to resolve the problem. They are based on existing properties, meaning their property values can be connected with the primary one. In this way, publishers can analyze the data all together.

Dimension Properties support you to:

Further understand property values: For example, you can use dimention properties to identify type values like 1, 2, and 3 into understandable terms such as "Attack," "Defense," and "Both."
Extend existing properties: For instance, extend properties like item name and item type based on the item ID.

Dimension properties can be used in analysis models, such as metric calculations, filtering, and result grouping. The usage is the same as that of event properties.

2. Usage Method

2.1 Create Event Dimension Properties

Users with permissions can click "Create Property - Dimension Property" in the upper-right corner of the Event Property Management page to open the primary property selection popup. After that, click "Next" to proceed to the dimension property creation page.

Only properties of string, numeric, or boolean types can have dimension properties added, and the type of the created dimension properties can only be string, numeric, or boolean.
A maximum of 20 dimension properties can be created under the same primary property. They can be created in batches, but the properties created earlier will be ranked higher in order.

After saving the dimension properties, you can manage them by selecting the event property list or entering the dimension property list.

2.2 Dimension Property Management

After a dimension property is created, it will be visible under its primary property in Event Property List.

Clicking "Dimension Properties" in the operation column of the primary property will take you to the Dimension Property List page, where you can manage all dimension properties under that primary property.

You can directly delete unused dimension properties from the Event Property List page or delete from the Dimension Property Management page.
On the Dimension Property Management page, you can also click "Add Dimension Property" to create new dimension properties.

2.3 Dimension Value Management

The relationship between dimension properties and primary properties is established through the correspondence between dimension property values (referred to as dimension values) and primary property values. Therefore, after creating a dimension property, dimension values must be maintained before the dimension property can be used for analysis.

You can open the Dimension Value Management page under a primary property by clicking "Dimension Values" in the operation column on the Event Property List page, or by clicking "Manage Dimension Values" in the upper-right corner of the Dimension Property Management page.

You can choose to batch "Add Dimension Values" or upload dimension values via a "Upload Dimension Values" file.
When adding dimension values in bulk or uploading a file, ensure that the column order in the uploaded file matches the order in the dimension value list. Additionally, the property types of the primary property and dimension properties in the uploaded content must align with the system's property types. For example, uploading string-type dimension values under a numeric-type dimension property will result in a failure to save data.
If the primary property value in the uploaded list already exists in the database, the uploaded dimension values will be used to update and replace the existing ones.
Click "Delete" in the operaion column to delete a single dimension value record. Click "Clear" to remove all dimension values under the primary property.
Click "Download" to download all dimension values.

2.4 Calculation of Dimension Values

The association between dimension properties and primary properties is established through the correspondence of their property values. We can understand this concept as follows:

Suppose a batch of user battle events is reported, and the events include information about the items used during the battle. If no item is used, the item ID will be empty; if an item is used, the item ID will be reported.

Event Name	Unique Event ID	Item ID (prop_id)
user_pk	eid1
user_pk	eid2	1
user_pk	eid3	3
user_pk	eid4	4
user_pk	eid5	5
user_pk	eid6	10

In the actual data analysis process:

The item ID is not easily readable and is typically analyzed using the item name.
Each item also has other attributes, such as item type and values, which are valuable for analysis and require extended properties.

Therefore, dimension properties are created under the primary property "Item ID," such as: Item Name (prop_name) and Item Type (prop_type).

Then, the dimension values are uploaded as follows:

Item ID（prop_id）	Item Name（prop_name）	Item Type（prop_type）
1	Iron Armor	Defense
2	Bronze Shield	Defense
3	Silver Hook	Attack
4	Golden Blade	Attack
5	Mystic Sword	Comprehensive

Subsequently, new properties will be virtually extended on the event: Item Name and Item Type.

Original Property			Extended Property
Event Name	Unique Event ID	Item ID (prop_id)
user_pk	eid1
user_pk	eid2	1	Iron Armor	Defense
user_pk	eid3	3	Silver Hook	Attack
user_pk	eid4	4	Golden Blade	Attack
user_pk	eid5	5	Mystic Sword	Comprehensive
user_pk	eid6	10
user_pk	eid7	1	Iron Armor	Defense

By using extended properties, such as Item Name and Item Type, the challenge of existing properties not meeting business requirements in actual analysis can be addressed.

Dimension properties can be used in various analytical models in the same way as event properties. They can be utilized for property metric calculations, filtering, grouping, and more.

3. Permission Description

Operation Permissions: Super Admin, Group Admin, Roles with Event Property edit permissions.

Entry: SolarEngine - Product - Data Management - Metadata - Event Property