Newer Version Available
Example: Spreading Time Label
This example provides details on the integration metadata JSON with datasource
AccountAndPromotionMeasures (time label spreaded).
1{
2 "datasources": [
3 {
4 "name": "AccountAndPromotionMeasures"
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 "name": "PlanTotalVolumeResult",
57 "label": "Planned Baseline"
58 }
59 ]
60 },
61 "promotiondimension": {
62 "attributes": [
63 {
64 "label": "id",
65 "name": "id"
66 },
67 {
68 "label": "accountid",
69 "name": "accountid"
70 },
71 {
72 "label": "accountplanrelevant",
73 "name": "accountplanrelevant"
74 }
75 ],
76 "key": "id",
77 "level": ""
78 }
79 },
80 "exportsettings": {
81 "columns": [
82 "accountdimension.externalid",
83 "productdimension.externalid",
84 "productdimension.category",
85 "productdimension.description",
86 "kpidimension.label",
87 "kpidimension.measurecode",
88 "...timedimension.label"
89 ],
90 "csvseparator": ","
91 },
92 "exportfilters": {
93 "conditions": [
94 {
95 "operator": "includes",
96 "value": [
97 "Kroger_Atlanta"
98 ],
99 "attribute": "externalid",
100 "dimension": "accountdimension",
101 "name": "cond1"
102 }
103 ]
104 }
105}