Menu

Dimension Management

What is a Dimension

In Senselink Analytics, a Dimension refers to the conditions that can be used to filter and group data when querying metrics. It is a business entity with semantic meaning that can be combined with metrics for analysis in "Metric Analysis". The filtering relationships supported by Dimensions depend on the data type of the Dimension.

In Dimension Management, analysts can build a unified Dimension system without development and support permission distribution.


Explanation of Related Terms

Term

Meaning/Usage

Source

DimensionDimensions refer to the conditions that can be used to filter and group data when querying metrics.Created by users in Dimension Management through event properties, user properties, tags, and data table fields.
Dimension GroupDimension Groups can be used to identify the category of a Dimension, such as country, province, etc., which can all belong to the geographical group.Selected by users when creating Dimensions.
Dimension Display NameThe Chinese name of the Dimension.Entered when creating the Dimension.
Dimension NameThe English name of the Dimension.Dimension created when filled

Data bucketing

Data bucketing is the classification of data based on a certain quantity or ratio, such as the range of order transaction amounts can be divided into 0-100, 100-500, 500-1000, etc.


Configured when creating a dimension

If a dimension is created based on number and datetime data, data bucketing needs to be configured. The configured data bucketing determines the data type of the dimension, and the data type of the dimension determines the available filtering relationships for the dimension.

Dimension sourceThe creation method of the dimension, for example, when created based on event attributes, the dimension source is: event attributesGenerated based on the creation method
Dimension statusThe status of the dimension, including normal and abnormal. Abnormal usually means that the dimension contains invalid metadata due to the absence of the metadata, etc., which determines whether the dimension is available.Determined based on the data of the dimension source
Available metrics

All metrics that can be used to filter and group by this dimension

Generated based on the relationship between metric calibration and dimension. The basis for judging whether it is available is:
    • Metrics created in event analysis:
      • All events included in the metric contain the attributes corresponding to this dimension
    • Metrics created in retention:
      • Both user attributes and user tags can be used
    • Metrics created in data tables:
      • Dimension and metric correspond to fields from the same table or related metrics.

How to create a dimension

In the dimension management, support event properties, user properties, user tags, data table fields, and rule creation dimensions. After selecting a creation method, you will enter the dimension creation page.

The process of creating dimensions for event properties, user properties, user tags, and data tables:

  1. Select the dimension to add
    1. To ensure the uniqueness of dimensions under the project, based on data type, non-bucketing data (string, bool, list) can only be added once, and the selectable options will filter out these data types that have already been created as dimensions. Data requiring bucketing (number, datetime) can be added as multiple dimensions, but duplicate bucketing will be checked when submitted. For example, if a dimension of the number type, such as age, has already been saved as a discrete bucket dimension, it cannot be added again.
    2. For the added dimension, to further confirm its correctness, the "Value Preview" of the dimension will be displayed, and the "Value Preview" result is the top 30 candidate values (candidates can have an index).
  2. Configure the dimension display name
    1. The dimension display name is a required field, and the dimension display names under the project are unique, including not being able to duplicate the metric display name. Whether it is case-insensitive for duplicates or not.
    2. The dimension display name will default to the display name of the dimension's source data, such as event display name, and supports input in Chinese and English (as well as traditional Chinese, Thai, Japanese supported by the system), numbers, and underscores. If the display name of the source data contains characters other than underscores, they will be replaced uniformly with underscores. The display name supports a maximum of 50 characters.
  3. Configure the dimension name
    1. The dimension name is a required field, and the dimension names under the project are unique, including not duplicating the metric name. Whether it is case-insensitive for duplicates or not.
    2. The dimension name will default to the name of the dimension's source data, such as event name, and supports input in English, numbers, and underscores. If the name of the source data contains special characters, they will be replaced uniformly with underscores. The name supports a maximum of 50 characters.
  4. Configure the dimension grouping
    1. Select the group to which the dimension belongs, and "Predefined Dimension Group" cannot be selected.
  5. Submit
  6. Submit and allocate permissions
    1. If you need to assign the created dimensions to be selected, you can also directly select "Submit and allocate permissions", which will directly open the permission allocation page, where you can uniformly allocate permissions for dimensions under the project.


Dimension Rule Creation

  1. Specific Creation Process:

 

    1. Configure Dimension Display Name and Dimension Name
    2. Select the data type of the dimension
    3. Select a group
    4. Select the source of the dimension
      1. The options are event properties, user properties, or data tables
    5. Define dimension rules, including defining multiple sets of dimension rules and the dimension value when each set of dimension rules is satisfied.
  1. Query logic: When analyzing dimensions created by rule creation in metric analysis, it will be judged sequentially according to the condition groups to determine if it meets any of the condition groups. If it meets the conditions of a group, the dimension value will be set as the corresponding dimension value for that group.

Dimension Management

Dimension Management List

The dimension management list is displayed in order by default. Dimensions are displayed by display name, name, data type, source, status, available metrics, reference list, dimension group, last update time, creator, and supported operations. The table supports configuring specific display columns for easier dimension management.

  1. Dimension status: The dimension status determines whether a dimension is available, that is, whether it can be queried in metric analysis and whether the business model that contains this dimension can be scheduled normally. When the source data of a dimension is hidden or deleted in metadata management, such as a dimension created through event property "city", the dimension will also report an exception and indicate the corresponding exception reason.
  2. Available metrics: All metrics that can be filtered and grouped by this dimension are generated based on the lineage relationship between the data source included in the metric and the dimension.
  3. Reference list: All upstream products that directly reference this dimension and form new data assets are currently only referred to as business models that use this dimension. The reference list allows administrators to know clearly which published business data reports will be affected when editing this dimension, and also allows timely cleaning of rarely used metrics.
  4. Operations: View, Edit, Delete
    1. View dimension details. Clicking "View" will open the dimension details drawer, which sequentially displays the display name, name, data type, group, source of the dimension, specific source values, and the dimension's historical update records, up to 30 update records can be retained.
    2. Edit dimension: Support editing the display name, name, dimension group, and dimension source values. Switching the source type, such as switching from event property to user property, is not supported, and switching the data type is not supported.
    3. Delete Dimension: Except for the built-in dimensions, all dimensions created by users can be deleted. In order to prevent you from deleting dimensions by mistake, when you delete a dimension, it will prompt the dimension's reference relationship and support secondary confirmation.


Dimension Group Management

For different business types or processes of the enterprise, dimensions can be systematically classified and managed through group management, making it possible to unify data scattered in various departments.

Process of Dimension Group Management:

  1. Open the group management page
  2. In the group management page, support adding and moving groups, including bulk movement of dimensions under this group
    1. The group name supports Chinese, various languages, and underscores, with a length of no more than 20 characters
    2. The group name does not support duplication
    3. Up to 50 groups can be added, including the system's built-in "Built-in Dimension Group" and "Ungrouped"
  3. The "Built-in Dimension Group" is a system-preset dimension group that cannot be deleted, edited, or moved


Permission Explanation

There are two points regarding the permissions of dimensions that you need to pay attention to:

1. What kind of permissions need to be enabled to use which functions in the dimension management

First, there are three permission points for dimensions, and their scope of control for functions is as follows:

View Dimension Management

Allows access to the dimension management page to view the dimension list and details

Manage all dimensions

Can create dimensions and manage (including "edit, delete, authorize, use") all dimensions (recommended for admins only)

Manage dimension groups

Allow managing dimension groups

Note:

  • After enabling "View Dimension Management", "View Metric Management" is checked by default; after canceling "View Metric Management", "View Dimension Management" is unchecked by default; after enabling "Manage All Dimensions", "View Dimension Management" is enabled by default and after canceling "View Metric Management", "Manage All Dimensions" is unchecked by default; after enabling "Manage Dimension Groups", "View Dimension Management" is enabled by default and after canceling "View Metric Management", "Manage Dimension Groups" is unchecked by default (recommended for admins only)
  • When creating dimensions using "Event Properties" and "User Properties", only metadata for which the current user has been granted permission can be selected
  • Only projects with "User Tags" enabled have the option to create dimensions using "User Tags"; and only users with permissions for "View User Tags", "Create User Tags", or "Manage User Tags" can create dimensions using tags, otherwise the option to create dimensions using user tags will be disabled
  • Only users with permissions for "View Data Tables", "Manage Data Tables", "View Metadata", or "Manage Metadata" can create dimensions using data tables, otherwise the option to create dimensions using data tables will be disabled


2. Dimension data permissions, i.e. the dimensions you can use and how to grant permissions to use dimensions


In "Assign Dimension Permissions", you can specify which members can use which dimensions in the project, support creating permission object groups for specified members, roles, and positions, and grant consistent dimension permissions to users under this permission object group in batches, up to 50 permission object groups can be added at the same time

  • The "Time" dimension by default is available to all members and does not support additional authorization


Preset Dimension List

Preset dimension refers to the dimensions that are preconfigured by the system when the metrics platform is initialized, and they belong to the "Preset Dimension Group" by default. They cannot be deleted or modified.

Preset Dimension List

Dimension Display NameDimension NameDimension Source
Event Time$time

Event occurrence time in the Events table, as well as time-related fields in all tables

Event Name$event_name

Field "event" in the Events table





Last modified: 2024-12-27