Example

1{
2  "datasources": [
3    {
4      "name": "PromotionAndTacticMeasures"
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          "label": "Incremental Volume",
53          "name": "ProPlanIncrVolume"
54        },
55        {
56          "label": "Tactic Spend",
57          "name": "PlanTotalPromoCosts"
58        },
59        {
60          "label": "Lump Sum",
61          "name": "FixedAmountLumpSum"
62        }
63      ]
64    },
65    "promotiondimension": {
66      "attributes": [
67        {
68          "label": "id",
69          "name": "id"
70        },
71        {
72          "label": "datefrom",
73          "name": "datefrom"
74        },
75        {
76          "label": "templateName",
77          "name": "templateName"
78        },
79        {
80          "label": "accountid",
81          "name": "accountid"
82        },
83        {
84          "label": "accountplanrelevant",
85          "name": "accountplanrelevant"
86        },
87        {
88          "label": "accountexternalid",
89          "name": "accountexternalid"
90        }
91      ],
92      "key": "id",
93      "level": ""
94    },
95    "tacticdimension": {
96      "attributes": [
97        {
98          "name": "lifttype",
99          "label": "lifttype"
100        },
101        {
102          "name": "name",
103          "label": "name"
104        },
105        {
106          "name": "liftvalue",
107          "label": "liftvalue"
108        },
109        {
110          "name": "compensationmodel",
111          "label": "compensationmodel"
112        }
113      ],
114      "key": "name",
115      "level": ""
116    }
117  },
118  "exportsettings": {
119    "columns": [
120      "accountdimension.externalid",
121      "promotiondimension.id",
122      "promotiondimension.datefrom",
123      "promotiondimension.templateName",
124      "tacticdimension.name",
125      "tacticdimension.compensationmodel",
126      "productdimension.externalid",
127      "productdimension.category",
128      "productdimension.description",
129      "kpidimension.label",
130      "kpidimension.measurecode",
131      "...timedimension.label"
132    ],
133    "csvseparator": ","
134  },
135  "exportfilters": {
136    "conditions": [
137      {
138        "operator": "includes",
139        "value": [
140          "Kroger_Atlanta"
141        ],
142        "attribute": "externalid",
143        "dimension": "accountdimension",
144        "name": "cond1"
145      }
146    ]
147  }
148}