Aggregation Consistency Errors in Semantic Layers and How to Avoid Them

Author:

Huang Zezhou1ORCID,Damalapati Pavan Kalyan1ORCID,Wu Eugene2ORCID

Affiliation:

1. Columbia University

2. DSI, Columbia University

Funder

Adobe Systems

National Science Foundation

Amazon

Publisher

ACM

Reference39 articles.

1. 2012. Joins cause incorrect values with aggregated measures. https://community.tableau.com/s/question/0D54T00000C5aT5SAJ/joins-cause-incorrect-values-with-aggregated-measures-can-i-specify-aggregation-before-i-calculate-a-sum. 2012. Joins cause incorrect values with aggregated measures. https://community.tableau.com/s/question/0D54T00000C5aT5SAJ/joins-cause-incorrect-values-with-aggregated-measures-can-i-specify-aggregation-before-i-calculate-a-sum.

2. 2014. Aggregate after join without duplicates. https://stackoverflow.com/questions/26799813/aggregate-after-join-without-duplicates. 2014. Aggregate after join without duplicates. https://stackoverflow.com/questions/26799813/aggregate-after-join-without-duplicates.

3. 2017. Merge two tables while summing values from subtable. https://community.powerbi.com/t5/Desktop/Merge-two-tables-while-summing-values-from-subtable/m-p/201112. 2017. Merge two tables while summing values from subtable. https://community.powerbi.com/t5/Desktop/Merge-two-tables-while-summing-values-from-subtable/m-p/201112.

4. 2020. Blend Your Data. https://help.tableau.com/current/pro/desktop/en-us/multiple_connections.htm. 2020. Blend Your Data. https://help.tableau.com/current/pro/desktop/en-us/multiple_connections.htm.

5. 2020. Looker data modeling. https://www.looker.com/platform/data-modeling/. 2020. Looker data modeling. https://www.looker.com/platform/data-modeling/.

Cited by 1 articles. 订阅此论文施引文献 订阅此论文施引文献,注册后可以免费订阅5篇论文的施引文献,订阅后可以查看论文全部施引文献

1. JoinBoost: Grow Trees over Normalized Data Using Only SQL;Proceedings of the VLDB Endowment;2023-07

同舟云学术

1.学者识别学者识别

2.学术分析学术分析

3.人才评估人才评估

"同舟云学术"是以全球学者为主线,采集、加工和组织学术论文而形成的新型学术文献查询和分析系统,可以对全球学者进行文献检索和人才价值评估。用户可以通过关注某些学科领域的顶尖人物而持续追踪该领域的学科进展和研究前沿。经过近期的数据扩容,当前同舟云学术共收录了国内外主流学术期刊6万余种,收集的期刊论文及会议论文总量共计约1.5亿篇,并以每天添加12000余篇中外论文的速度递增。我们也可以为用户提供个性化、定制化的学者数据。欢迎来电咨询!咨询电话:010-8811{复制后删除}0370

www.globalauthorid.com

TOP

Copyright © 2019-2024 北京同舟云网络信息技术有限公司
京公网安备11010802033243号  京ICP备18003416号-3