Creating mappings for the level attributes

Mappings are created for the four level attributes: Product Line Code, Product Line En, Product Type Code, and Product Type En.

Creating a query item mapping - PRODUCT_LINE_CODE

The query_item_mapping command creates a query item mapping.

Input JSON data
{
  "parent": "<idDimension>",
  "columnName": "PRODUCT_LINE_CODE",
  "queryItem": "<idProductLineCode>",
  "table": "<idTableLine>"
}
Output JSON data

{
  "id": "<query_item_mapping_1>"
}

Creating a query item mapping - PRODUCT_LINE_EN

The query_item_mapping command creates a query item mapping.

Input JSON data
{
  "parent": "<idDimension>",
  "columnName": "PRODUCT_LINE_EN",
  "queryItem": "<idProductLine>",
  "table": "<idTableLine>"
}
Output JSON data
{
  "id": "<query_item_mapping_2>"
}

Creating a query item mapping - PRODUCT_TYPE_CODE

The query_item_mapping command creates a query item mapping.

Input JSON data
{
  "parent": "<idDimension>",
  "columnName": "PRODUCT_TYPE_CODE",
  "queryItem": "<idProductTypeCode>",
  "table": "<idTableType>"
}
Output JSON data
{
  "id": "<query_item_mapping_3>"
}

Creating a query item mapping - PRODUCT_TYPE_EN

The query_item_mapping command creates a query item mapping.

Input JSON data
{
  "parent": "<idDimension>",
  "columnName": "PRODUCT_TYPE_EN",
  "queryItem": "<idProductType>",
  "table": "<idTableType>"
}
Output JSON data
{
  "id": "<query_item_mapping_4>"
}