回溯计算度量中的列
如何追溯计算度量中使用/加入的实际列？ 我问这个问题的原因是，我试图编写等效的 TSQL 查询来验证计算度量的结果。 到目前为止，我的方法是查找度量属性并找到表/视图和使用的列名称。 连接栏一直是一个困难的部分（可以说这对我来说是不可能的），因为 DSV 看起来非常混乱并且很难遵循线条。
任何建议表示赞赏！
How do I trace back the actual columns used/joined in calculated measure? THe reason I am asking this question is, I am trying to write the equivalent TSQL query to verify the result with that of calculated measure.
So far, my approach has been a look up into the measure properties and find the table/view and the column name used. The joining column has been a difficult part (let s say it impossible for me), because the DSV looks very messy and is hard to follow the lines.
Any suggestions appreciated!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我想没有希望联系创建该多维数据集或当前维护该多维数据集的人？ 如果您不熟悉多维数据集来自的数据仓库，我可以理解为什么这感觉像一场噩梦。 可能有各种进程/作业加载数据。
我上一份工作中持续出现的一个问题是，客户对立方体总数与我们 Web 应用程序中其他位置的数字不匹配感到不安。 每周，OLAP 团队和 Web 团队都会进行一场辩论，以决定哪个值是“正确的”以及我们如何解释其中的差异！
I suppose there is no hope of contacting the person who created the cube, or currently maintains it? If you are not familiar with the data warehouse the cube comes from, I can see why this would feel like a nightmare. There may be various procs/jobs which load data in.
One on-going problem in my last job was a customer upset that the cube totals did not match with the figures from other places in our web application. Each week there would be a debate between the OLAP team and the web team, to decide which value ws "right" and how we could explain the difference!