Help Center/ DataArts Studio/ API Reference/ DataArts Architecture APIs/ Derivative Metrics/ Updating a Derivative Metric

Updated on 2024-12-03 GMT+08:00

Online Debugging

CLI Examples

View PDF

Updating a Derivative Metric

Function

This API is used to update a derivative metric.

Calling Method

For details, see Calling APIs.

URI

PUT /v2/{project_id}/design/derivative-indexs

**Table 1** Path Parameters
Parameter	Mandatory	Type	Description
project_id	Yes	String	Project ID. For details about how to obtain the project ID, see Project ID and Account ID.

Request Parameters

**Table 2** Request body parameters
Parameter	Mandatory	Type	Description
id	No	String	Derivative metric ID, which is a string. This parameter is mandatory for update.
name_en	Yes	String	Derivative metric name in English
name_ch	Yes	String	Derivative metric name
create_by	No	String	Creator.
data_type	No	String	Field type
l2_id	No	String	Subject area ID.
l3_id	Yes	String	Business object GUID, which is a string
status	No	String	Release status of an entity. This parameter is read-only and does not need to be set during creation and update. Options: DRAFT: draft PUBLISH_DEVELOPING: to be reviewed PUBLISHED: released OFFLINE_DEVELOPING: to be reviewed OFFLINE: offline REJECT: rejected
atomic_index_id	Yes	String	Atomic metric ID, which is a string
time_condition_id	No	String	Time filter ID, which is a string
time_field_id	No	String	ID of the field associated with the time filter, which is a string
common_conditions	No	Array of CommonConditionVO objects	General filter information.
dimension_groups	No	Array of DerivativeIndexDimensionVO objects	Statistical dimension, which cannot be changed during update
monitor	No	MetricMonitorVO object	Monitor metrics.
l1	No	String	Chinese name of the subject area group. This parameter is read-only and does not need to be set when you create or update a subject area group.
l2	No	String	Chinese name of the subject area. This parameter is read-only and does not need to be set during creation and update.
l3	No	String	Chinese name of the business object. This parameter is read-only and does not need to be set during creation and update.
approval_info	No	ApprovalVO object	Approval information. This parameter is read-only. Latest review information about a business object, including the business details, reviewer information, and review time.
new_biz	No	BizVersionManageVO object	Service version management. This parameter is read-only.

**Table 3** CommonConditionVO
Parameter	Mandatory	Type	Description
name	Yes	String	Name.
field_ids	Yes	Array of strings	Field ID, in the format table_id.field_id.
field_names	No	Array of strings	Field name information. Format: Table name.Field name.
cal_exp	Yes	String	Calculation expression, for example, '${table_id.column_id} > 1', where table_id indicates the ID of the table to which the referenced field belongs and column_id indicates the ID of the referenced field.
cal_fn_ids	Yes	Array of strings	Reference function ID, which is a string
front_configs	No	String	Frontend expression configuration, which is used for front-end data restoration.

**Table 4** DerivativeIndexDimensionVO
Parameter	Mandatory	Type	Description
group_id	Yes	String	Dimension group ID.
role	No	String	Dimension role.
dimension_id	No	String	Dimension ID, which is a string
hierarchies_id	No	String	Dimension level ID, which is a string
group_name	No	String	Name of a dimension group.
group_code	No	String	Dimension group code.
biz_type	Yes	String	Business entity type. Options: AGGREGATION_LOGIC_TABLE: summary table ATOMIC_INDEX: atomic metric ATOMIC_METRIC: atomic metric (new) BIZ_CATALOG: process architecture directory BIZ_METRIC: service indicator CODE_TABLE: code table COMMON_CONDITION: general filter COMPOSITE_METRIC: Compound Metric (new) COMPOUND_METRIC: compound metric CONDITION_GROUP: restriction group DEGENERATE_DIMENSION: degenerate dimension DERIVATIVE_INDEX: derivative indicator DERIVED_METRIC: derivative indicator (new) DIMENSION: dimension DIMENSION_ATTRIBUTE: dimension attribute DIMENSION_HIERARCHIES: dimension level DIMENSION_LOGIC_TABLE: dimension table DIMENSION_TABLE_ATTRIBUTE: dimension attribute DIRECTORY: directory FACT_ATTRIBUTE: fact table attribute FACT_DIMENSION: fact table dimension FACT_LOGIC_TABLE: fact table FACT_MEASURE: fact table measurement FUNCTION: function INFO_ARCH: information architecture (used for modifying themes in batches) MODEL: model QUALITY_RULE: quality rule SECRECY_LEVEL: security level STANDARD_ELEMENT: data standard STANDARD_ELEMENT_TEMPLATE: data standard template SUBJECT: theme Dimension attributes of SUMMARY_DIMENSION_ATTRIBUTE: summary tables SUMMARY_INDEX: summary table indicator attribute SUMMARY_TIME: time period attribute of the SDR table TABLE_MODEL: relationship model (logical model/physical model) TABLE_MODEL_ATTRIBUTE: relationship model attribute (logical model/physical model) TABLE_MODEL_LOGIC: logical entity TABLE_TYPE: table type TAG: tag TIME_CONDITION: time restriction
l2_id	No	String	Subject area ID.
dw_type	No	String	Data connection type.

**Table 5** MetricMonitorVO
Parameter	Mandatory	Type	Description
id	No	String	ID, which is a string
other_metric_ids	No	Array of strings	ID of another metric, which is a string
other_compound_metric_ids	No	Array of strings	ID of another composite index.
expression	No	String	Alarm expression.
metric_id	No	String	Mount pointer ID, which is a string
front_configs	No	String	Frontend expression configuration, which is used for front-end data restoration.
metric_type	No	String	Type of the mounted indicator.

**Table 6** ApprovalVO
Parameter	Mandatory	Type	Description
id	No	String	Application ID, which is a string
tenant_id	No	String	Project ID. For details about how to obtain the project ID, see the API path parameter project_id.
name_ch	No	String	Chinese name of a service.
name_en	No	String	English name of a service.
biz_id	No	String	Business ID, which is a string
biz_type	No	String	Business entity type. Options: AGGREGATION_LOGIC_TABLE: summary table ATOMIC_INDEX: atomic metric ATOMIC_METRIC: atomic metric (new) BIZ_CATALOG: process architecture directory BIZ_METRIC: service indicator CODE_TABLE: code table COMMON_CONDITION: general filter COMPOSITE_METRIC: Compound Metric (new) COMPOUND_METRIC: compound metric CONDITION_GROUP: restriction group DEGENERATE_DIMENSION: degenerate dimension DERIVATIVE_INDEX: derivative indicator DERIVED_METRIC: derivative indicator (new) DIMENSION: dimension DIMENSION_ATTRIBUTE: dimension attribute DIMENSION_HIERARCHIES: dimension level DIMENSION_LOGIC_TABLE: dimension table DIMENSION_TABLE_ATTRIBUTE: dimension attribute DIRECTORY: directory FACT_ATTRIBUTE: fact table attribute FACT_DIMENSION: fact table dimension FACT_LOGIC_TABLE: fact table FACT_MEASURE: fact table measurement FUNCTION: function INFO_ARCH: information architecture (used for modifying themes in batches) MODEL: model QUALITY_RULE: quality rule SECRECY_LEVEL: security level STANDARD_ELEMENT: data standard STANDARD_ELEMENT_TEMPLATE: data standard template SUBJECT: theme Dimension attributes of SUMMARY_DIMENSION_ATTRIBUTE: summary tables SUMMARY_INDEX: summary table indicator attribute SUMMARY_TIME: time period attribute of the SDR table TABLE_MODEL: relationship model (logical model/physical model) TABLE_MODEL_ATTRIBUTE: relationship model attribute (logical model/physical model) TABLE_MODEL_LOGIC: logical entity TABLE_TYPE: table type TAG: tag TIME_CONDITION: time restriction
biz_info	No	String	Serialized service details. The type is string.
biz_info_obj	No	Object	Service details. The type is object.
biz_version	No	Integer	Service version.
biz_status	No	String	Release status of an entity. This parameter is read-only and does not need to be set during creation and update. Options: DRAFT: draft PUBLISH_DEVELOPING: to be reviewed PUBLISHED: released OFFLINE_DEVELOPING: to be reviewed OFFLINE: offline REJECT: rejected
approval_status	No	String	Service approval status. This parameter is read-only. Options: DEVELOPING: being reviewed APPROVED: approved REJECT: rejected WITHDREW: approval cancellation
approval_type	No	String	Service review type. Options: PUBLISH: released OFFLINE: offline
submit_time	No	String	Submitted At
create_by	No	String	Creator.
l1	No	String	Chinese name of the subject area group. This parameter is read-only and does not need to be set when you create or update a subject area group.
l2	No	String	Chinese name of the subject area. This parameter is read-only and does not need to be set during creation and update.
l3	No	String	Chinese name of the business object. This parameter is read-only and does not need to be set during creation and update.
approval_time	No	String	Review time.
approver	No	String	Reviewer.
email	No	String	Email address of the reviewer.
msg	No	String	Review information.
directory_path	No	String	Directory tree.

**Table 7** BizVersionManageVO
Parameter	Mandatory	Type	Description
id	No	String	Field ID, which is a string
biz_type	No	String	Business entity type. Options: AGGREGATION_LOGIC_TABLE: summary table ATOMIC_INDEX: atomic metric ATOMIC_METRIC: atomic metric (new) BIZ_CATALOG: process architecture directory BIZ_METRIC: service indicator CODE_TABLE: code table COMMON_CONDITION: general filter COMPOSITE_METRIC: Compound Metric (new) COMPOUND_METRIC: compound metric CONDITION_GROUP: restriction group DEGENERATE_DIMENSION: degenerate dimension DERIVATIVE_INDEX: derivative indicator DERIVED_METRIC: derivative indicator (new) DIMENSION: dimension DIMENSION_ATTRIBUTE: dimension attribute DIMENSION_HIERARCHIES: dimension level DIMENSION_LOGIC_TABLE: dimension table DIMENSION_TABLE_ATTRIBUTE: dimension attribute DIRECTORY: directory FACT_ATTRIBUTE: fact table attribute FACT_DIMENSION: fact table dimension FACT_LOGIC_TABLE: fact table FACT_MEASURE: fact table measurement FUNCTION: function INFO_ARCH: information architecture (used for modifying themes in batches) MODEL: model QUALITY_RULE: quality rule SECRECY_LEVEL: security level STANDARD_ELEMENT: data standard STANDARD_ELEMENT_TEMPLATE: data standard template SUBJECT: theme Dimension attributes of SUMMARY_DIMENSION_ATTRIBUTE: summary tables SUMMARY_INDEX: summary table indicator attribute SUMMARY_TIME: time period attribute of the SDR table TABLE_MODEL: relationship model (logical model/physical model) TABLE_MODEL_ATTRIBUTE: relationship model attribute (logical model/physical model) TABLE_MODEL_LOGIC: logical entity TABLE_TYPE: table type TAG: tag TIME_CONDITION: time restriction
biz_id	No	String	Business ID, which is a string
biz_info	No	String	Business object information.
status	No	String	Release status of an entity. This parameter is read-only and does not need to be set during creation and update. Options: DRAFT: draft PUBLISH_DEVELOPING: to be reviewed PUBLISHED: released OFFLINE_DEVELOPING: to be reviewed OFFLINE: offline REJECT: rejected

Response Parameters

Status code: 200

**Table 8** Response body parameters
Parameter	Type	Description
data	data object	Number of successfully updated derivative metrics

**Table 9** data
Parameter	Type	Description
value	DerivativeIndexVO object	Result of updating derivative metrics

**Table 10** DerivativeIndexVO
Parameter	Type	Description
id	String	Derivative metric ID, which is a string. This parameter is mandatory for update.
name_en	String	Derivative metric name in English
name_ch	String	Derivative metric name
description	String	Description, which is read-only.
create_by	String	Creator.
data_type	String	Field type
l1_id	String	Subject area group ID, which is a read-only string
l2_id	String	Subject area ID.
l3_id	String	Business object GUID, which is a string
status	String	Release status of an entity. This parameter is read-only and does not need to be set during creation and update. Options: DRAFT: draft PUBLISH_DEVELOPING: to be reviewed PUBLISHED: released OFFLINE_DEVELOPING: to be reviewed OFFLINE: offline REJECT: rejected
atomic_index_id	String	Atomic metric ID, which is a string
time_condition_id	String	Time filter ID, which is a string
time_field_id	String	ID of the field associated with the time filter, which is a string
time_field_name	String	Name of the field associated with the time filter. This parameter is read-only.
common_conditions	Array of CommonConditionVO objects	General filter information.
dimension_groups	Array of DerivativeIndexDimensionVO objects	Statistical dimension, which cannot be changed during update
monitor	MetricMonitorVO object	Monitor metrics.
atomic_index	AtomicIndexVO object	Atomic metric information, including the name and unit. This parameter is read-only.
time_condition_name	String	Time filter name. This parameter is read-only.
create_time	String	Creation time, which is read-only. The format complies with RFC3339 and is accurate to seconds. The UTC time zone is yyyy-mm-ddTHH:MM:SSZ, for example, 1970-01-01T00:00:00Z.
update_time	String	Update time, which is read-only. The format complies with RFC3339 and is accurate to seconds. The UTC time zone is yyyy-mm-ddTHH:MM:SSZ, for example, 1970-01-01T00:00:00Z.
l1	String	Chinese name of the subject area group. This parameter is read-only and does not need to be set when you create or update a subject area group.
l2	String	Chinese name of the subject area. This parameter is read-only and does not need to be set during creation and update.
l3	String	Chinese name of the business object. This parameter is read-only and does not need to be set during creation and update.
summary_table_id	String	Summary table ID, which is a read-only string
approval_info	ApprovalVO object	Approval information. This parameter is read-only. Latest review information about a business object, including the business details, reviewer information, and review time.
new_biz	BizVersionManageVO object	Service version management. This parameter is read-only.

**Table 11** CommonConditionVO
Parameter	Type	Description
name	String	Name.
field_ids	Array of strings	Field ID, in the format table_id.field_id.
field_names	Array of strings	Field name information. Format: Table name.Field name.
cal_exp	String	Calculation expression, for example, '${table_id.column_id} > 1', where table_id indicates the ID of the table to which the referenced field belongs and column_id indicates the ID of the referenced field.
cal_fn_ids	Array of strings	Reference function ID, which is a string
front_configs	String	Frontend expression configuration, which is used for front-end data restoration.
id	String	General filter ID, which is a read-only string

**Table 12** DerivativeIndexDimensionVO
Parameter	Type	Description
group_id	String	Dimension group ID.
role	String	Dimension role.
dimension_id	String	Dimension ID, which is a string
hierarchies_id	String	Dimension level ID, which is a string
ordinal	Integer	Sequence number, which is read-only.
group_name	String	Name of a dimension group.
group_code	String	Dimension group code.
biz_type	String	Business entity type. Options: AGGREGATION_LOGIC_TABLE: summary table ATOMIC_INDEX: atomic metric ATOMIC_METRIC: atomic metric (new) BIZ_CATALOG: process architecture directory BIZ_METRIC: service indicator CODE_TABLE: code table COMMON_CONDITION: general filter COMPOSITE_METRIC: Compound Metric (new) COMPOUND_METRIC: compound metric CONDITION_GROUP: restriction group DEGENERATE_DIMENSION: degenerate dimension DERIVATIVE_INDEX: derivative indicator DERIVED_METRIC: derivative indicator (new) DIMENSION: dimension DIMENSION_ATTRIBUTE: dimension attribute DIMENSION_HIERARCHIES: dimension level DIMENSION_LOGIC_TABLE: dimension table DIMENSION_TABLE_ATTRIBUTE: dimension attribute DIRECTORY: directory FACT_ATTRIBUTE: fact table attribute FACT_DIMENSION: fact table dimension FACT_LOGIC_TABLE: fact table FACT_MEASURE: fact table measurement FUNCTION: function INFO_ARCH: information architecture (used for modifying themes in batches) MODEL: model QUALITY_RULE: quality rule SECRECY_LEVEL: security level STANDARD_ELEMENT: data standard STANDARD_ELEMENT_TEMPLATE: data standard template SUBJECT: theme Dimension attributes of SUMMARY_DIMENSION_ATTRIBUTE: summary tables SUMMARY_INDEX: summary table indicator attribute SUMMARY_TIME: time period attribute of the SDR table TABLE_MODEL: relationship model (logical model/physical model) TABLE_MODEL_ATTRIBUTE: relationship model attribute (logical model/physical model) TABLE_MODEL_LOGIC: logical entity TABLE_TYPE: table type TAG: tag TIME_CONDITION: time restriction
hierarchies	Array of DimensionHierarchiesVO objects	Level attribute, which is read-only.
l1	String	Subject area group, which is read-only.
l2	String	Subject area, which is read-only.
l3	String	Service object, which is read-only.
l1_id	String	Subject area group ID, which is a read-only string
l2_id	String	Subject area ID.
l3_id	String	Business object ID, which is a read-only string
dw_type	String	Data connection type.
id	String	Level ID, which is a read-only string

**Table 13** DimensionHierarchiesVO
Parameter	Type	Description
id	String	ID, which is a string
name	String	Level name.
attrs	Array of HierarchiesAttrVO objects	Attributes contained in a hierarchy.
create_time	String	Creation time, which is read-only. The format complies with RFC3339 and is accurate to seconds. The UTC time zone is yyyy-mm-ddTHH:MM:SSZ, for example, 1970-01-01T00:00:00Z.
update_time	String	Update time, which is read-only. The format complies with RFC3339 and is accurate to seconds. The UTC time zone is yyyy-mm-ddTHH:MM:SSZ, for example, 1970-01-01T00:00:00Z.
create_by	String	Creator.
update_by	String	Person who updates the information.

**Table 14** HierarchiesAttrVO
Parameter	Type	Description
id	String	ID, which is a string
hierarchies_id	String	Level ID, which is a string
attr_id	String	Attribute ID, which is a string
level	Integer	Indicates the layer.
attr_name_en	String	Referenced attribute code.
attr_name_ch	String	Referenced attribute name, which is read-only.
detail_attr_ids	Array of strings	Details attribute ID, which is a string
detail_attr_name_ens	Array of strings	Details attribute in English.
detail_attr_name_chs	Array of strings	Details attribute in Chinese, which is read-only.
attr	DimensionAttributeVO object	Referenced attribute field, which is read-only.
detail_attrs	Array of DimensionAttributeVO objects	Details field, which is read-only.

**Table 15** DimensionAttributeVO
Parameter	Type	Description
id	String	ID, which is a string
dimension_id	String	Dimension ID, which is a read-only string
code_table_field_id	String	Lookup table attribute ID, which is a string
name_en	String	Field name.
name_ch	String	Service attribute.
description	String	Description.
create_by	String	Creator.
data_type	String	Field type
domain_type	String	Domain to which a field type belongs. Options: NUMBER: number STRING: character type DATETIME: date type BLOB: large object (BLOB) OTHER: other types
data_type_extend	String	Extended field of the data type.
is_primary_key	Boolean	Indicates whether a key is a primary key.
is_biz_primary	Boolean	Indicates whether it is a service primary key.
is_partition_key	Boolean	Indicates whether to partition.
ordinal	Integer	Sequence number.
not_null	Boolean	Indicates whether the value is empty.
stand_row_id	String	ID of the associated data standard, which is a string
stand_row_name	String	Name of the associated data standard. This parameter is read-only.
quality_infos	Array of QualityInfoVO objects	Quality information, which is read-only.
secrecy_levels	Array of SecrecyLevelVO objects	Confidentiality
status	String	Release status of an entity. This parameter is read-only and does not need to be set during creation and update. Options: DRAFT: draft PUBLISH_DEVELOPING: to be reviewed PUBLISHED: released OFFLINE_DEVELOPING: to be reviewed OFFLINE: offline REJECT: rejected
create_time	String	Creation time, which is read-only. The format complies with RFC3339 and is accurate to seconds. The UTC time zone is yyyy-mm-ddTHH:MM:SSZ, for example, 1970-01-01T00:00:00Z.
update_time	String	Update time, which is read-only. The format complies with RFC3339 and is accurate to seconds. The UTC time zone is yyyy-mm-ddTHH:MM:SSZ, for example, 1970-01-01T00:00:00Z.
alias	String	Alias
self_defined_fields	Array of SelfDefinedFieldVO objects	User-defined item.

**Table 16** QualityInfoVO
Parameter	Type	Description
id	String	ID, which is a string
table_id	String	Table ID, which is a read-only string
attr_id	String	Attribute ID, which is a read-only string
biz_type	String	Business entity type. Options: AGGREGATION_LOGIC_TABLE: summary table ATOMIC_INDEX: atomic metric ATOMIC_METRIC: atomic metric (new) BIZ_CATALOG: process architecture directory BIZ_METRIC: service indicator CODE_TABLE: code table COMMON_CONDITION: general filter COMPOSITE_METRIC: Compound Metric (new) COMPOUND_METRIC: compound metric CONDITION_GROUP: restriction group DEGENERATE_DIMENSION: degenerate dimension DERIVATIVE_INDEX: derivative indicator DERIVED_METRIC: derivative indicator (new) DIMENSION: dimension DIMENSION_ATTRIBUTE: dimension attribute DIMENSION_HIERARCHIES: dimension level DIMENSION_LOGIC_TABLE: dimension table DIMENSION_TABLE_ATTRIBUTE: dimension attribute DIRECTORY: directory FACT_ATTRIBUTE: fact table attribute FACT_DIMENSION: fact table dimension FACT_LOGIC_TABLE: fact table FACT_MEASURE: fact table measurement FUNCTION: function INFO_ARCH: information architecture (used for modifying themes in batches) MODEL: model QUALITY_RULE: quality rule SECRECY_LEVEL: security level STANDARD_ELEMENT: data standard STANDARD_ELEMENT_TEMPLATE: data standard template SUBJECT: theme Dimension attributes of SUMMARY_DIMENSION_ATTRIBUTE: summary tables SUMMARY_INDEX: summary table indicator attribute SUMMARY_TIME: time period attribute of the SDR table TABLE_MODEL: relationship model (logical model/physical model) TABLE_MODEL_ATTRIBUTE: relationship model attribute (logical model/physical model) TABLE_MODEL_LOGIC: logical entity TABLE_TYPE: table type TAG: tag TIME_CONDITION: time restriction
data_quality_id	String	Quality ID, which is a string
show_control	Integer	Indicates whether to display the regular expression.
data_quality_name	String	Quality name.
alert_conf	String	Configure alarms.
expression	String	Regular expression configuration in regular expression-related validation rules.
extend_info	String	Indicates the extension information.
from_standard	Boolean	Indicates whether the data comes from the data standard quality configuration. This parameter is read-only.
result_description	String	Result description.
create_by	String	Creator, which is read-only.
update_by	String	Updater, which is read-only.
create_time	String	Creation time, which is read-only. The format complies with RFC3339 and is accurate to seconds. The UTC time zone is yyyy-mm-ddTHH:MM:SSZ, for example, 1970-01-01T00:00:00Z.
update_time	String	Update time, which is read-only. The format complies with RFC3339 and is accurate to seconds. The UTC time zone is yyyy-mm-ddTHH:MM:SSZ, for example, 1970-01-01T00:00:00Z.

**Table 17** SecrecyLevelVO
Parameter	Type	Description
id	String	Security level ID, which is a string
uuid	String	Data security primary key.
name	String	Confidentiality name.
slevel	Integer	Confidentiality level.
description	String	Confidentiality description.
create_by	String	Creator.
update_by	String	Person who updates the information.
create_time	String	Creation time, which is read-only. The format complies with RFC3339 and is accurate to seconds. The UTC time zone is yyyy-mm-ddTHH:MM:SSZ, for example, 1970-01-01T00:00:00Z.
update_time	String	Update time, which is read-only. The format complies with RFC3339 and is accurate to seconds. The UTC time zone is yyyy-mm-ddTHH:MM:SSZ, for example, 1970-01-01T00:00:00Z.
new_biz	BizVersionManageVO object	Service version management. This parameter is read-only.

**Table 18** SelfDefinedFieldVO
Parameter	Type	Description
fd_name_ch	String	Chinese name of a user-defined item.
fd_name_en	String	English name of a customized item.
not_null	Boolean	Whether a parameter is mandatory.
fd_value	String	Attribute value

**Table 19** MetricMonitorVO
Parameter	Type	Description
id	String	ID, which is a string
other_metric_ids	Array of strings	ID of another metric, which is a string
other_metric_names	Array of strings	Name of another indicator. This parameter is read-only.
other_compound_metric_ids	Array of strings	ID of another composite index.
other_compound_metric_names	Array of strings	Name of another compound metric.
expression	String	Alarm expression.
metric_id	String	Mount pointer ID, which is a string
front_configs	String	Frontend expression configuration, which is used for front-end data restoration.
metric_type	String	Type of the mounted indicator.

**Table 20** AtomicIndexVO
Parameter	Type	Description
id	String	ID, which is a string
name_en	String	Indicates the English name of an atomic metric.
name_ch	String	Indicates the English name of an atomic metric.
description	String	Description.
create_by	String	Creator.
cal_exp	String	Calculation expression, for example, 'sum(${fact_column_id})', where fact_column_id indicates the ID of the referenced field in the fact table
cal_fn_ids	Array of strings	Reference function ID, which is a string
l1_id	String	Subject area group ID, which is a read-only string
l2_id	String	Subject area ID.
l3_id	String	Business object GUID, which is a string
table_id	String	Fact table ID, which is a string
tb_name	String	Name of a fact table.
dw_type	String	Data connection type. This parameter is read-only.
field_ids	Array of strings	Field ID, which is a string
field_names	Array of strings	Field name.
status	String	Release status of an entity. This parameter is read-only and does not need to be set during creation and update. Options: DRAFT: draft PUBLISH_DEVELOPING: to be reviewed PUBLISHED: released OFFLINE_DEVELOPING: to be reviewed OFFLINE: offline REJECT: rejected
biz_type	String	Business entity type. Options: AGGREGATION_LOGIC_TABLE: summary table ATOMIC_INDEX: atomic metric ATOMIC_METRIC: atomic metric (new) BIZ_CATALOG: process architecture directory BIZ_METRIC: service indicator CODE_TABLE: code table COMMON_CONDITION: general filter COMPOSITE_METRIC: Compound Metric (new) COMPOUND_METRIC: compound metric CONDITION_GROUP: restriction group DEGENERATE_DIMENSION: degenerate dimension DERIVATIVE_INDEX: derivative indicator DERIVED_METRIC: derivative indicator (new) DIMENSION: dimension DIMENSION_ATTRIBUTE: dimension attribute DIMENSION_HIERARCHIES: dimension level DIMENSION_LOGIC_TABLE: dimension table DIMENSION_TABLE_ATTRIBUTE: dimension attribute DIRECTORY: directory FACT_ATTRIBUTE: fact table attribute FACT_DIMENSION: fact table dimension FACT_LOGIC_TABLE: fact table FACT_MEASURE: fact table measurement FUNCTION: function INFO_ARCH: information architecture (used for modifying themes in batches) MODEL: model QUALITY_RULE: quality rule SECRECY_LEVEL: security level STANDARD_ELEMENT: data standard STANDARD_ELEMENT_TEMPLATE: data standard template SUBJECT: theme Dimension attributes of SUMMARY_DIMENSION_ATTRIBUTE: summary tables SUMMARY_INDEX: summary table indicator attribute SUMMARY_TIME: time period attribute of the SDR table TABLE_MODEL: relationship model (logical model/physical model) TABLE_MODEL_ATTRIBUTE: relationship model attribute (logical model/physical model) TABLE_MODEL_LOGIC: logical entity TABLE_TYPE: table type TAG: tag TIME_CONDITION: time restriction
create_time	String	Creation time, which is read-only. The format complies with RFC3339 and is accurate to seconds. The UTC time zone is yyyy-mm-ddTHH:MM:SSZ, for example, 1970-01-01T00:00:00Z.
update_time	String	Update time, which is read-only. The format complies with RFC3339 and is accurate to seconds. The UTC time zone is yyyy-mm-ddTHH:MM:SSZ, for example, 1970-01-01T00:00:00Z.
l1	String	Chinese name of the subject area group. This parameter is read-only and does not need to be set when you create or update a subject area group.
l2	String	Chinese name of the subject area. This parameter is read-only and does not need to be set during creation and update.
l3	String	Chinese name of the business object. This parameter is read-only and does not need to be set during creation and update.
approval_info	ApprovalVO object	Approval information. This parameter is read-only. Latest review information about a business object, including the business details, reviewer information, and review time.
new_biz	BizVersionManageVO object	Service version management. This parameter is read-only.

**Table 21** ApprovalVO
Parameter	Type	Description
id	String	Application ID, which is a string
tenant_id	String	Project ID. For details about how to obtain the project ID, see the API path parameter project_id.
name_ch	String	Chinese name of a service.
name_en	String	English name of a service.
biz_id	String	Business ID, which is a string
biz_type	String	Business entity type. Options: AGGREGATION_LOGIC_TABLE: summary table ATOMIC_INDEX: atomic metric ATOMIC_METRIC: atomic metric (new) BIZ_CATALOG: process architecture directory BIZ_METRIC: service indicator CODE_TABLE: code table COMMON_CONDITION: general filter COMPOSITE_METRIC: Compound Metric (new) COMPOUND_METRIC: compound metric CONDITION_GROUP: restriction group DEGENERATE_DIMENSION: degenerate dimension DERIVATIVE_INDEX: derivative indicator DERIVED_METRIC: derivative indicator (new) DIMENSION: dimension DIMENSION_ATTRIBUTE: dimension attribute DIMENSION_HIERARCHIES: dimension level DIMENSION_LOGIC_TABLE: dimension table DIMENSION_TABLE_ATTRIBUTE: dimension attribute DIRECTORY: directory FACT_ATTRIBUTE: fact table attribute FACT_DIMENSION: fact table dimension FACT_LOGIC_TABLE: fact table FACT_MEASURE: fact table measurement FUNCTION: function INFO_ARCH: information architecture (used for modifying themes in batches) MODEL: model QUALITY_RULE: quality rule SECRECY_LEVEL: security level STANDARD_ELEMENT: data standard STANDARD_ELEMENT_TEMPLATE: data standard template SUBJECT: theme Dimension attributes of SUMMARY_DIMENSION_ATTRIBUTE: summary tables SUMMARY_INDEX: summary table indicator attribute SUMMARY_TIME: time period attribute of the SDR table TABLE_MODEL: relationship model (logical model/physical model) TABLE_MODEL_ATTRIBUTE: relationship model attribute (logical model/physical model) TABLE_MODEL_LOGIC: logical entity TABLE_TYPE: table type TAG: tag TIME_CONDITION: time restriction
biz_info	String	Serialized service details. The type is string.
biz_info_obj	Object	Service details. The type is object.
biz_version	Integer	Service version.
biz_status	String	Release status of an entity. This parameter is read-only and does not need to be set during creation and update. Options: DRAFT: draft PUBLISH_DEVELOPING: to be reviewed PUBLISHED: released OFFLINE_DEVELOPING: to be reviewed OFFLINE: offline REJECT: rejected
approval_status	String	Service approval status. This parameter is read-only. Options: DEVELOPING: being reviewed APPROVED: approved REJECT: rejected WITHDREW: approval cancellation
approval_type	String	Service review type. Options: PUBLISH: released OFFLINE: offline
submit_time	String	Submitted At
create_by	String	Creator.
l1	String	Chinese name of the subject area group. This parameter is read-only and does not need to be set when you create or update a subject area group.
l2	String	Chinese name of the subject area. This parameter is read-only and does not need to be set during creation and update.
l3	String	Chinese name of the business object. This parameter is read-only and does not need to be set during creation and update.
approval_time	String	Review time.
approver	String	Reviewer.
email	String	Email address of the reviewer.
msg	String	Review information.
directory_path	String	Directory tree.

**Table 22** BizVersionManageVO
Parameter	Type	Description
id	String	Field ID, which is a string
biz_type	String	Business entity type. Options: AGGREGATION_LOGIC_TABLE: summary table ATOMIC_INDEX: atomic metric ATOMIC_METRIC: atomic metric (new) BIZ_CATALOG: process architecture directory BIZ_METRIC: service indicator CODE_TABLE: code table COMMON_CONDITION: general filter COMPOSITE_METRIC: Compound Metric (new) COMPOUND_METRIC: compound metric CONDITION_GROUP: restriction group DEGENERATE_DIMENSION: degenerate dimension DERIVATIVE_INDEX: derivative indicator DERIVED_METRIC: derivative indicator (new) DIMENSION: dimension DIMENSION_ATTRIBUTE: dimension attribute DIMENSION_HIERARCHIES: dimension level DIMENSION_LOGIC_TABLE: dimension table DIMENSION_TABLE_ATTRIBUTE: dimension attribute DIRECTORY: directory FACT_ATTRIBUTE: fact table attribute FACT_DIMENSION: fact table dimension FACT_LOGIC_TABLE: fact table FACT_MEASURE: fact table measurement FUNCTION: function INFO_ARCH: information architecture (used for modifying themes in batches) MODEL: model QUALITY_RULE: quality rule SECRECY_LEVEL: security level STANDARD_ELEMENT: data standard STANDARD_ELEMENT_TEMPLATE: data standard template SUBJECT: theme Dimension attributes of SUMMARY_DIMENSION_ATTRIBUTE: summary tables SUMMARY_INDEX: summary table indicator attribute SUMMARY_TIME: time period attribute of the SDR table TABLE_MODEL: relationship model (logical model/physical model) TABLE_MODEL_ATTRIBUTE: relationship model attribute (logical model/physical model) TABLE_MODEL_LOGIC: logical entity TABLE_TYPE: table type TAG: tag TIME_CONDITION: time restriction
biz_id	String	Business ID, which is a string
biz_info	String	Business object information.
status	String	Release status of an entity. This parameter is read-only and does not need to be set during creation and update. Options: DRAFT: draft PUBLISH_DEVELOPING: to be reviewed PUBLISHED: released OFFLINE_DEVELOPING: to be reviewed OFFLINE: offline REJECT: rejected
biz_version	Integer	Service version, which is read-only.
create_time	String	Creation time, which is read-only. The format complies with RFC3339 and is accurate to seconds. The UTC time zone is yyyy-mm-ddTHH:MM:SSZ, for example, 1970-01-01T00:00:00Z.
update_time	String	Update time, which is read-only. The format complies with RFC3339 and is accurate to seconds. The UTC time zone is yyyy-mm-ddTHH:MM:SSZ, for example, 1970-01-01T00:00:00Z.

Status code: 400

**Table 23** Response body parameters
Parameter	Type	Description
error_code	String	Error code, for example, DS.6000, indicating that the request fails to be processed.
error_msg	String	Error message
data	Object	Returned data information.

Status code: 401

**Table 24** Response body parameters
Parameter	Type	Description
error_code	String	Error code, for example, DS.6000, indicating that the request fails to be processed.
error_msg	String	Error message
data	Object	Returned data information.

Status code: 403

**Table 25** Response body parameters
Parameter	Type	Description
error_code	String	Error code, for example, DS.6000, indicating that the request fails to be processed.
error_msg	String	Error message
data	Object	Returned data information.

Example Requests

Update a derivative metric based on input parameters.

PUT https://{endpoint}/v2/{project_id}/design/derivative-indexs

{
  "id" : "1300493984245886976",
  "name_en" : "sum_total_amount",
  "name_ch" : "Total fare(supplier,stroke order.fare)",
  "data_type" : "STRING",
  "l3_id" : "1169309252771299328",
  "atomic_index_id" : "1170005876631875584",
  "time_condition_id" : null,
  "time_field_id" : null,
  "common_conditions" : [ ],
  "dimension_groups" : [ {
    "ordinal" : 1,
    "biz_type" : "DIMENSION",
    "group_id" : "1169322847009742848",
    "dimension_id" : "1169322847009742848",
    "role" : null,
    "hierarchies_id" : null
  }, {
    "ordinal" : 2,
    "biz_type" : "DEGENERATE_DIMENSION",
    "group_id" : "1169329693619625984.1169329693695123463",
    "dimension_id" : null,
    "role" : null,
    "hierarchies_id" : null
  } ],
  "monitor" : null,
  "description" : ""
}

Example Responses

Status code: 200

The operation succeeds. DerivativeIndexVO is returned.

{
  "value" : {
    "id" : "1300493984245886976",
    "name_en" : "sum_total_amount",
    "name_ch" : "Total fare(supplier,stroke order.fare)",
    "description" : "",
    "create_by" : "test_user",
    "data_type" : "STRING",
    "l1_id" : null,
    "l2_id" : null,
    "l3_id" : "1169309252771299328",
    "status" : "DRAFT",
    "atomic_index_id" : "1170005876631875584",
    "time_condition_id" : null,
    "time_field_id" : null,
    "time_field_name" : null,
    "common_conditions" : [ ],
    "dimension_groups" : [ {
      "group_id" : "1169322847009742848",
      "role" : null,
      "dimension_id" : "1169322847009742848",
      "hierarchies_id" : null,
      "ordinal" : 1,
      "group_name" : null,
      "group_code" : null,
      "biz_type" : "DIMENSION",
      "hierarchies" : null,
      "l1" : null,
      "l2" : null,
      "l3" : null,
      "l1_id" : null,
      "l2_id" : null,
      "l3_id" : null,
      "dw_type" : null,
      "id" : null,
      "from_public" : null
    }, {
      "group_id" : "1169329693619625984.1169329693695123463",
      "role" : null,
      "dimension_id" : null,
      "hierarchies_id" : null,
      "ordinal" : 2,
      "group_name" : null,
      "group_code" : null,
      "biz_type" : "DEGENERATE_DIMENSION",
      "hierarchies" : null,
      "l1" : null,
      "l2" : null,
      "l3" : null,
      "l1_id" : null,
      "l2_id" : null,
      "l3_id" : null,
      "dw_type" : null,
      "id" : null,
      "from_public" : null
    } ],
    "monitor" : null,
    "atomic_index" : null,
    "time_condition_name" : null,
    "create_time" : "2024-10-28T16:18:48+08:00",
    "update_time" : "2024-10-28T17:40:14.903+08:00",
    "l1" : null,
    "l2" : null,
    "l3" : null,
    "summary_table_id" : null,
    "approval_info" : null,
    "new_biz" : null
  }
}

Status code: 400

{
  "error_code" : "DS.60xx",
  "error_msg" : "The user request is illegal."
}

Status code: 401

{
  "error_code" : "DS.60xx",
  "error_msg" : "User authentication failed."
}

Status code: 403

{
  "error_code" : "DS.60xx",
  "error_msg" : "The user does not have permission to call this API."
}

Status Codes

Status Code	Description
200	The operation succeeds. DerivativeIndexVO is returned.
400	BadRequest
401	Unauthorized
403	Forbidden

Parent Topic: Derivative Metrics

Previous topic: Creating a Derivative Metric

Next topic: Deleting Derivative Metrics

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.

Chatbot