| 配置内容 | 需要遵循这个格式定义, 需要注意看下面对字段注释说明： [
{
"id": "1", // 随意，没用的
"dataSourceId": "DS.nnorthwind",
"schema": "",
"name": "agg_1_orderdetails", //名称要唯一
"modelId": "be0d8c420bc41401276ee5f3fb4788dc",--模型ID
"viewName": "orderdetails", --事实表名字
"define": {
"dimensions": [{
"dimension": "CategoryName", //维度名称
"column": "CategoryName" //对应聚合表的列名
}, {
"dimension": "ProductName",
"column": "ProductName"
}, {
"dimension": "ShipRegion",
"column": "ShipRegion"
}, {
"dimension": "ShipCity",
"column": "ShipCity"
}, {
"dimension": "viewId",
"column": "viewId"
}],
"measures": [ {
"measure": "$fact_count$", // 内置，这个写死的
"column": "fact_count",
"aggregator": "COUNT" //唯一计数、平均值不支持
}, {
"measure": "Quantity_m", //度量名称
"column": "Quantity", //对应预聚合对应的列
"aggregator": "Count" //聚合方式
}, {
"measure": "UnitPrice_m",
"column": "UnitPrice",
"aggregator": "SUM"
}, {
"measure": "Discount_m",
"column": "Discount",
"aggregator": "SUM"
}]
}
}
]
|
