Registering a Dimension Type


A dimension type defines the data aggregation dimension such as object type, province, and manufacturer. Only by registering dimension types in Common Data Service can these dimension types be referenced in metric registration to define how the metrics can be aggregated. You can register dimension types in batches by uploading a template file.

Prerequisites


  • You need to be assigned the required asset permission and operation permission, and a menu group containing the Dimension Types menu. If not assigned, contact the application administrator.
  • If you need to specify the enumeration values of a dimension to come from the dimensions or object types in EnOS Configuration Center, Configuration Center needs to be obtained, authorized, and enabled in the current OU and the dimensions or object types to be referenced need to prepared. For more information about dimensions or object types in Configuration Center, see Configuring OU Business Objects.

Procedure


  1. Select Business Object Elements > Dimension Types from the left navigation pane.

  2. Select the Public Dimensions or Private Dimensions tab according to the effective scope of the target dimension type, and click Import. For more information about the difference between public and private dimension types, see Public/Private Dimension Types.

  3. Click Download in the pop-up window and choose to download an Excel and a JSON template file.

  4. Enter the following information in the template file.


    Field Name Identifier Required/Optional Description
    Dimension Identifier dimension Required The identifier of the dimension type, which needs to be unique under the same object type within the same (public/private) effective scope.
    Dimension Chinese/English/Japanese/Spanish Name nameZh/En/Ja/Es English and Chinese names are required The dimension name in different languages.
    Object Type Identifier mdmType Required The identifier of the object type that the dimension belongs to. You can go to Business Object Types to view the object type identifier.
    Object Type Name mdmTypeName Optional The name of the object type that the dimension belongs to. You can go to Business Object Types to view the object type name.
    Dimension Level level Required Fill in child if the dimension is based on the subordinate assets under the current asset and fill in self if the dimension is based on the current asset itself.
    ID Reference Attribute attribute Optional The identifier of the attribute used to describe the dimension identifier. Common Data Service aggregates data according to the enumeration values of this attribute.
    Name Reference Attribute nameAttribute Optional The identifier of the attribute used to describe the dimension name. Common Data Service displays the enumeration name of the dimension according to the name of this attribute.
    Related Object Type Identifier dimensionType Optional If the dimension is an object type, fill in the identifier of the object type.
    Filters filters Optional The supported filtering methods. Use these filters: in, ==, !=, >, >=, <, <=. Separate multiple filters by commas, for example, ==,in.
    Source Dimension Identifier dimensionMapping Optional When the dimension identifier is inconsistent with the original dimension identifier of the data source, the original dimension identifier used by the data source must be filled in; otherwise, the filtering capability of the dimension cannot be used.
    Enum Source Type enumSourceType Required Fill in static if the enumeration values are static. Fill in metricData if the enumeration values are included in the returned results of metrics. Fill in record if the enumeration values come from the records in Common Data Service. Fill in amcDimension if the enumeration values come from the dimensions in Configuration Center. Fill in mdmType if the enumeration values come from the object types in Common Data Service. Fill in amcType if the enumeration values come from the object types in Configuration Center.
    Static Enumerate enumerate Optional For static enumeration values, you need to specify their identifiers and names.
    Dynamic Enum Source ID enumerateSourceID Optional For enumeration values coming from record or amcDimension, you need to specify the identifiers of the record types or dimension tables.
    Dynamic Enum Mapping enumerateMapping Optional For enumeration values coming from record or amcDimension, you need to specify the data fields in the record types or the dimension tables mapped with the identifiers and names of the enumeration values.

    Note

    The “Org ID”, “Org Name”, “Updated On”, and “Updated By” fields in the template file can be left blank and will be filled by the system after upload.

  5. Click Upload in the pop-up window. Select the filled template file and click OK. When you register a private dimension type, if the identifier in the file is the same as a registered public dimension type identifier, the system will return the private dimension type when the duplicate identifier is passed in to query the dimension type.

Results


Once registered, the dimension type appears in the dimension type list. You can view its details and perform the following actions on it.

  • Edit the dimension type: Click Export, modify the template file as required, and import the modified file. The dimension types with the same identifiers will overwrite the existing dimension types, and the dimension types with different identifiers will be added.

  • Delete the dimension type: Click Delete Delete of the target dimension type. Deleted dimension types cannot be restored.

    Note

    If the business object type that the dimension type belongs to has been deleted, you need to contact the system administrator to delete this dimension type.