加快运行Total MDX计算的度量值? [英] Speed up Running Total MDX calculated measure?

问题描述

我正在使用Follow mdx将我的多维数据集中的期间余额"度量值保持总计:

I'm using the follow mdx to keep a running total of the Period Balance measure in my cube:

SUM({[到期日].[日期] .CurrentMember.Level.Item(0):[到期日].[日期] .CurrentMember}，[度量].[定期余额]

SUM({[Due Date].[Date].CurrentMember.Level.Item(0):[Due Date].[Date].CurrentMember}, [Measures].[Period Balance])

效果很好，但是随着显示数据量的增加，它真的很慢.我不能使用MTD或YTD，因为用户可能正在分析重叠多年的数据.有什么办法可以加快速度吗?

It works great, however it's really slow as the amount of data displayed increases. I can't use a MTD or YTD because the users may be analyzing data that overlaps years. Any way I can speed this up?

谢谢.

推荐答案

我认为您看到了吗? http:///sqlblog.com/blogs/mosha/archive/2006/11/17/performance-of-running-sum-calculations-in-sp2.aspx

I take it you've seen this? http://sqlblog.com/blogs/mosha/archive/2006/11/17/performance-of-running-sum-calculations-in-sp2.aspx

否则，还有另一个示例，该示例使用了将父母的先前总数和父母的当前孩子从同级兄弟中获取到当前兄弟姐妹的技术-因此，您先汇总前几个月的总和，然后将本月的天数相加-这只会起作用如果您有日期层次结构，则:

Failing that, there is another sample which uses the technique of taking the parent's prior totals and the parent's current child from first sibling to current - So you'd sum the prior months and then this month's days - That'll only work if you have a date hierarchy though:

我认为那里的图片对它的求和增量"部分有更好的解释.

I think the pictures there explain it better, its the "Summing Increments" section.

您是否正在查询日志并进行基于使用情况的聚合?

Are you query-logging and doing usage-based aggregations?

这篇关于加快运行Total MDX计算的度量值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！