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}