Creating a relationship between the relational dimension and the measure dimension

Creating a relationship - Products to Measures

The relationship command creates a relationship between the Products relational dimension and the Measures measure dimension.

Input JSON data

{
  "parent": "<idCube>",
  "leftMaxCardinality": "one",
  "leftMinCardinality": "one",
  "rightMaxCardinality": "many",
  "expression": [
    {
      "columnName": "PRODUCT_NUMBER",
      "objectRef": "<idDimension>",
      "tableName": "PRODUCT",
      "dataSourceRef": "<idDataSource>"
    },
    "=",
    {
      "columnName": "PRODUCT_NUMBER",
      "objectRef": "<idMeasureDimension>",
      "tableName": "ORDER_DETAILS",
      "dataSourceRef": "<idDataSource>"
    }
  ],
  "rightMinCardinality": "one",
  "rightObjectRef": "<idMeasureDimension>",
  "name": "Products-Measures",
  "leftObjectRef": "<idDimension>"
}
  

Output JSON data

{
  "id": "<relationship>"
}