Newer Version Available

This content describes an older version of this product. View Latest

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}