Newer Version Available
Example
This example provides details on the integration metadata JSON with data source.
PromotionMeasures
1{
2 "datasources": [
3 {
4 "name": "PromotionMeasures"
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": "ProPlanIncrVolume",
53 "label": "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 "exportsettings": {
89 "columns": [
90 "accountdimension.externalid",
91 "promotiondimension.id",
92 "promotiondimension.datefrom",
93 "promotiondimension.templateName",
94 "productdimension.externalid",
95 "productdimension.category",
96 "productdimension.description",
97 "kpidimension.label",
98 "kpidimension.measurecode",
99 "...timedimension.label"
100 ],
101 "csvseparator": ","
102 },
103 "exportfilters": {
104 "conditions": [
105 {
106 "operator": "includes",
107 "value": [
108 "Kroger_Atlanta"
109 ],
110 "attribute": "externalid",
111 "dimension": "accountdimension",
112 "name": "cond1"
113 }
114 ]
115 }
116}