Example

This sample integration metadata configuration specifies product data at the product part level.
PromotionAndTacticMeasuresWithBOMComponents
1{
2   "datasources":[
3      {
4         "name":"PromotionAndTacticMeasuresWithBOMComponents"
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      "productpartdimension":{
50         "attributes":[
51            {
52               "label":"id",
53               "name":"id"
54            },
55            {
56               "label":"quantity",
57               "name":"quantity"
58            },
59            {
60               "label":"externalid",
61               "name":"externalid"
62            }
63         ],
64         "key":"id",
65         "level":""
66      },
67      "kpidimension":{
68         "measures":[
69            {
70               "label":"Incremental Volume",
71               "name":"ProPlanIncrVolume"
72            },
73            {
74               "label":"Tactic Spend",
75               "name":"PlanTotalPromoCosts"
76            },
77            {
78               "label":"Lump Sum",
79               "name":"FixedAmountLumpSum"
80            }
81         ]
82      },
83      "promotiondimension":{
84         "attributes":[
85            {
86               "label":"id",
87               "name":"id"
88            },
89            {
90               "label":"datefrom",
91               "name":"datefrom"
92            },
93            {
94               "label":"templateName",
95               "name":"templateName"
96            },
97            {
98               "label":"accountid",
99               "name":"accountid"
100            },
101            {
102               "label":"accountplanrelevant",
103               "name":"accountplanrelevant"
104            },
105            {
106               "label":"accountexternalid",
107               "name":"accountexternalid"
108            }
109         ],
110         "key":"id",
111         "level":""
112      },
113      "tacticdimension":{
114         "attributes":[
115            {
116               "name":"lifttype",
117               "label":"lifttype"
118            },
119            {
120               "name":"name",
121               "label":"name"
122            },
123            {
124               "name":"liftvalue",
125               "label":"liftvalue"
126            },
127            {
128               "name":"compensationmodel",
129               "label":"compensationmodel"
130            }
131         ],
132         "key":"name",
133         "level":""
134      }
135   },
136   "exportsettings":{
137      "columns":[
138         "accountdimension.externalid",
139         "promotiondimension.id",
140         "promotiondimension.datefrom",
141         "promotiondimension.templateName",
142         "tacticdimension.name",
143         "tacticdimension.compensationmodel",
144         "productdimension.externalid",
145         "productdimension.category",
146         "productdimension.description",
147         "productpartdimension.id",
148         "productpartdimension.externalid",
149         "kpidimension.label",
150         "kpidimension.measurecode",
151         "timedimension.label"
152      ],
153      "csvseparator":","
154   },
155   "exportfilters":{
156      "conditions":[
157         {
158            "operator":"includes",
159            "value":[
160               "Kroger_Atlanta"
161            ],
162            "attribute":"externalid",
163            "dimension":"accountdimension",
164            "name":"cond1"
165         }
166      ]
167   }
168}