Example

This sample integration metadata configuration specifies product data at the product part level.
PromotionAndTacticMeasuresWithBOMComponents
{
   "datasources":[
      {
         "name":"PromotionAndTacticMeasuresWithBOMComponents"
      }
   ],
   "dimensions":{
      "accountdimension":{
         "attributes":[
            {
               "label":"ExternalId",
               "name":"externalid"
            },
            {
               "label":"Name",
               "name":"name"
            },
            {
               "label":"AccountNUmber",
               "name":"accountnumber"
            }
         ],
         "key":"externalid",
         "level":""
      },
      "productdimension":{
         "attributes":[
            {
               "label":"Description",
               "name":"description"
            },
            {
               "label":"ExternalId",
               "name":"externalid"
            },
            {
               "label":"Category",
               "name":"category"
            }
         ],
         "key":"externalid",
         "level":"Product"
      },
      "timedimension":{
         "includetotal":false,
         "splitweeks":false,
         "periodtype":"custom"
      },
      "productpartdimension":{
         "attributes":[
            {
               "label":"id",
               "name":"id"
            },
            {
               "label":"quantity",
               "name":"quantity"
            },
            {
               "label":"externalid",
               "name":"externalid"
            }
         ],
         "key":"id",
         "level":""
      },
      "kpidimension":{
         "measures":[
            {
               "label":"Incremental Volume",
               "name":"ProPlanIncrVolume"
            },
            {
               "label":"Tactic Spend",
               "name":"PlanTotalPromoCosts"
            },
            {
               "label":"Lump Sum",
               "name":"FixedAmountLumpSum"
            }
         ]
      },
      "promotiondimension":{
         "attributes":[
            {
               "label":"id",
               "name":"id"
            },
            {
               "label":"datefrom",
               "name":"datefrom"
            },
            {
               "label":"templateName",
               "name":"templateName"
            },
            {
               "label":"accountid",
               "name":"accountid"
            },
            {
               "label":"accountplanrelevant",
               "name":"accountplanrelevant"
            },
            {
               "label":"accountexternalid",
               "name":"accountexternalid"
            }
         ],
         "key":"id",
         "level":""
      },
      "tacticdimension":{
         "attributes":[
            {
               "name":"lifttype",
               "label":"lifttype"
            },
            {
               "name":"name",
               "label":"name"
            },
            {
               "name":"liftvalue",
               "label":"liftvalue"
            },
            {
               "name":"compensationmodel",
               "label":"compensationmodel"
            }
         ],
         "key":"name",
         "level":""
      }
   },
   "exportsettings":{
      "columns":[
         "accountdimension.externalid",
         "promotiondimension.id",
         "promotiondimension.datefrom",
         "promotiondimension.templateName",
         "tacticdimension.name",
         "tacticdimension.compensationmodel",
         "productdimension.externalid",
         "productdimension.category",
         "productdimension.description",
         "productpartdimension.id",
         "productpartdimension.externalid",
         "kpidimension.label",
         "kpidimension.measurecode",
         "timedimension.label"
      ],
      "csvseparator":","
   },
   "exportfilters":{
      "conditions":[
         {
            "operator":"includes",
            "value":[
               "Kroger_Atlanta"
            ],
            "attribute":"externalid",
            "dimension":"accountdimension",
            "name":"cond1"
         }
      ]
   }
}