ParallelPeriod没有日期层次结构 [英] ParallelPeriod without date hierarchy
问题描述
您好 - 可以在不使用层次结构的情况下使用parallelperiod函数吗?我需要计算去年同期(12个月)的销售额。我使用以下MDX并且它可以工作,但是我需要使用不在层次结构
中的日期列进行另一次计算。谢谢。
(ParallelPeriod(
[Date]。[Calendar]。[Year],
1,
[Date]。[Calendar] .CurrentMember
),
[Measures]。[Sales]),
不,这是不可能的。 ParallelPeriod通过"行走"来工作。上下指定的层次结构。实际上甚至可以在非日期层次结构上使用ParallelPeriod(尽管在Product.Categories
之类的内容上执行ParallelPeriod的结果可能没有多大意义)。但ParallelPeriod需要一个层次结构才能工作。
如果你想建议你在其他计算中尝试做什么,我们可能会建议一些替代方法。
Hello - s it possible to use parallelperiod function without using hierarchy? I need to calculate sales for the same period last year (12 months). I am using the following MDX and it works, but i need to use date columns that are not in the hierarchy for another calculation. thank you.
(ParallelPeriod( [Date].[Calendar].[Year], 1, [Date].[Calendar].CurrentMember ), [Measures].[Sales]),
No it's not possible. ParallelPeriod works by "walking" up and down the specified hierarchy. You can actually even use ParallelPeriod over non-date hierarchies (although the result of doing ParallelPeriod over something like Product.Categories may not make much sense). But ParallelPeriod needs a hierarchy to work.
If you want to advise what you are trying to do in your other calc we might be able to suggest some alternative approaches.
这篇关于ParallelPeriod没有日期层次结构的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!