Example

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
1{
2   "datasources":[
3      {
4         "name":"PromotionMeasuresWithBOMComponents"
5      }
6   ],
7   "dimensions":{
8      "accountdimension":{
9         "attributes":[
10            {
11               "label":"ExternalId",
12               "name":"externalid"
13            },
14            {
15               "label":"Name",
16               "name":"name"
17            },
18            {
19               "label":"AccountNUmber",
20               "name":"accountnumber"
21            }
22         ],
23         "key":"externalid",
24         "level":""
25      },
26      "productdimension":{
27         "attributes":[
28            {
29               "label":"Description",
30               "name":"description"
31            },
32            {
33               "label":"ExternalId",
34               "name":"externalid"
35            },
36            {
37               "label":"Category",
38               "name":"category"
39            }
40         ],
41         "key":"externalid",
42         "level":"Product"
43      },
44      "timedimension":{
45         "includetotal":false,
46         "splitweeks":false,
47         "periodtype":"custom"
48      },
49      "kpidimension":{
50         "measures":[
51            {
52               "name":"BOMPlanIncrVolAll",
53               "label":"Planned Incremental Volume"
54            }
55         ]
56      },
57      "promotiondimension":{
58         "attributes":[
59            {
60               "label":"id",
61               "name":"id"
62            },
63            {
64               "label":"datefrom",
65               "name":"datefrom"
66            },
67            {
68               "label":"templateName",
69               "name":"templateName"
70            },
71            {
72               "label":"accountid",
73               "name":"accountid"
74            },
75            {
76               "label":"accountplanrelevant",
77               "name":"accountplanrelevant"
78            },
79            {
80               "label":"accountexternalid",
81               "name":"accountexternalid"
82            }
83         ],
84         "key":"id",
85         "level":""
86      }
87   },
88   "productpartdimension":{
89      "attributes":[
90         {
91            "label":"id",
92            "name":"id"
93         },
94         {
95            "label":"quantity",
96            "name":"quantity"
97         },
98         {
99            "label":"externalid",
100            "name":"externalid"
101         }
102      ],
103      "key":"id",
104      "level":""
105   },
106   "exportsettings":{
107      "columns":[
108         "accountdimension.externalid",
109         "promotiondimension.id",
110         "promotiondimension.datefrom",
111         "promotiondimension.templateName",
112         "productdimension.externalid",
113         "productdimension.category",
114         "productdimension.description",
115         "productpartdimension.id",
116         "productpartdimension.externalid",
117         "productpartdimension.quantity",
118         "kpidimension.label",
119         "kpidimension.measurecode",
120         "timedimension.label"
121      ],
122      "csvseparator":","
123   },
124   "exportfilters":{
125      "conditions":[
126         {
127            "operator":"includes",
128            "value":[
129               "Kroger_Atlanta"
130            ],
131            "attribute":"externalid",
132            "dimension":"accountdimension",
133            "name":"cond1"
134         }
135      ]
136   }
137}