研发提效：想快速定制一个OLAP应用？你可以这么做！
京
供应链 樊思国约 5 分钟
供应链 樊思国约 5 分钟本文通过OLAP多维度多指标自由组合诊断分析场景，讲述了利用可配置化的方式快速实现OLAP应用的解决方案，达到了提升研发效能的目的。通过本文可以了解面向应用的OLAP分析引擎的设计和建模过程，在遇到类似场景时可以实现快速构建一个OLAP应用。欢迎文末参与有奖评论！
【本文目录】
背景
架构设计
详细设计
系统集成
总结
SELECT 维度，指标FROM 模型WHERE 一级过滤器GROUP BY 维度HAVING 二级过滤器ORDER BY 排序LIMIT 排序
{"cbj_amount": {"expression": "sum(cbj_amount)","name": "cbj_amount","desc": "损失分布-仓报价金额"},"sale_qtty": {"expression": "sum(sale_qtty)","name": "sale_qtty","desc": "销量"},"loss_amount": {"expression": "sum(loss_amount)","name": "loss_amount","desc": "损额"}}
{"list-overall-lossCategory": {"moduleName": "整体诊断结果-损失类别","tableName": "logis_loss_reason_nume_denom_month_dis","measureList": ["dakuru_loss_ratio","dakuru_loss_ratio_yoy_chg","dakuru_loss_ratio_mom_chg","peisongru_loss_ratio","peisongru_loss_ratio_yoy_chg","peisongru_loss_ratio_mom_chg","shouhouru_loss_ratio","shouhouru_loss_ratio_yoy_chg","shouhouru_loss_ratio_mom_chg","dakupyk_loss_ratio","dakupyk_loss_ratio_yoy_chg","dakupyk_loss_ratio_mom_chg","bjkpyk_loss_ratio","bjkpyk_loss_ratio_yoy_chg","bjkpyk_loss_ratio_mom_chg"],"displayType": "table","page": {"pageNo": 1,"pageSize": 1}}}
{"chart-lossType-trend-lossRatio": {"moduleName": "损失类别走势-损率","tableName": "logis_loss_reason_nume_denom_month_dis","dimList": ["mt"],"measureList": ["dakuru_loss_ratio","peisongru_loss_ratio","shouhouru_loss_ratio","bjkpyk_loss_ratio","dakupyk_loss_ratio"],"displayType": "chart","page": {"pageNo": 1,"pageSize": 13},"chart": {"categoryName": "损失类别走势","categoryKey": "mt","seriesList": [{"key":"大库入","value": "dakuru_loss_ratio"},{"key": "配送入","value": "peisongru_loss_ratio"},{"key": "售后入","value": "shouhouru_loss_ratio"},{"key": "备件库盘盈亏","value": "bjkpyk_loss_ratio"},{"key": "大库盘盈亏","value": "dakupyk_loss_ratio"}]}}}
{"export-lossType-trend": {"moduleName": "损失类别-损失类别走势-导出","tableName": "logis_loss_reason_nume_denom_month_dis","dimList": ["mt","loss_reason1"],"measureList": ["distribute_loss_ratio", "loss_amount","loss_qtty"],"filterList": [{"lossReason1": {"expr": "is not null","value": ""}}],"headList": ["mt","loss_reason1","distribute_loss_ratio","loss_amount","loss_qtty"],"fileName": "损失类别走势信息","displayType": "file","page": {"pageNo": 1,"pageSize": 1000,"orderList": [{"orderField": "mt","orderType": "DESC"},{"orderField": "loss_reason1","orderType": "DESC"}]}}}
<dependency><groupId>com.jd.netsim</groupId><artifactId>triage-framework-core</artifactId><version>1.0-SNAPSHOT</version></dependency>
【聊聊研发提效那些事儿】
- END -