MDX-基于“记录时间范围"的并发计算? [英] MDX - Concurrent calculations based on a "record time range"?
问题描述
尊敬的MDX专家
-是否可以根据记录的时间范围进行并发计算?
让我说; 开始日期" ,结束日期" ,'在我的事实表中使用了'和'color'....
是否有可能每次获得'used'的并发(在同一范围内发生的'used'的最大总和),如果是的话-每个'color'的并发使用情况如何? ?
Is it possible to get the concurrent of 'used' per time (the biggest sum of 'used' that happened during the same range), if yes - what about concurrent used per 'color'?
推荐答案
To get the sum of all used over a time period, you can use the sum
function.
此外,这将考虑Color
的CurrentMember
,因此将根据每个成员而定,无论您选择哪种选择.
Moreover, this will take into account the CurrentMember
of Color
, so it will be per member, whatever selection you choose.
此MDX是一个起点:
with member [Measures].[TotalUsed] as
sum({[Date].[YQM].&[20090501]:[Date].[YQM].&[20090907]}, [Measures].[Used])
select
{[Measures].[Total Used]}
on columns,
{[Color].[Colors].[All].MEMBERS}
on rows
from [Cube]
我认为这是您要寻找的,但是如果它不满足您的需求,请在评论中进行澄清.
I think this is what you're looking for, but please clarify in comments if it doesn't meet your needs.
这篇关于MDX-基于“记录时间范围"的并发计算?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!