This sample integration metadata configuration specifies product data at the product
part level, and defines the fields from the sObjects to be exported along with the
KPIs.
PromotionMeasuresWithBOMComponents
{
"datasources":[
{
"name":"PromotionMeasuresWithBOMComponents"
}
],
"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"
},
"kpidimension":{
"measures":[
{
"name":"BOMPlanIncrVolAll",
"label":"Planned Incremental Volume"
}
]
},
"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":""
}
},
"productpartdimension":{
"attributes":[
{
"label":"id",
"name":"id"
},
{
"label":"quantity",
"name":"quantity"
},
{
"label":"externalid",
"name":"externalid"
}
],
"key":"id",
"level":""
},
"exportsettings":{
"columns":[
"accountdimension.externalid",
"promotiondimension.id",
"promotiondimension.datefrom",
"promotiondimension.templateName",
"productdimension.externalid",
"productdimension.category",
"productdimension.description",
"productpartdimension.id",
"productpartdimension.externalid",
"productpartdimension.quantity",
"kpidimension.label",
"kpidimension.measurecode",
"timedimension.label"
],
"csvseparator":","
},
"exportfilters":{
"conditions":[
{
"operator":"includes",
"value":[
"Kroger_Atlanta"
],
"attribute":"externalid",
"dimension":"accountdimension",
"name":"cond1"
}
]
}
}