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}