我有以下 MDX 查询:
SELECT
NON EMPTY
Measures.[Enrolments] ON COLUMNS,
NON EMPTY
( STRTOMEMBER(@FromISOYear, CONSTRAINED) :
STRTOMEMBER(@ToISOYear, CONSTRAINED) ) ON ROWS
FROM (
SELECT
Filter
(
[Term Start Date].[ISO Year].Children *
[Term Record Creation].[ISO Year].Children *
[Term Record Creation].[ISO Week Number Of Year].Children
,
Cint([Term Record Creation].[ISO Week Number Of Year].CurrentMember.Member_Key) <= Cint( STRTOMEMBER(@ToISOWeekNumberOfYear, CONSTRAINED) )
OR
Cint([Term Record Creation].[ISO Year].CurrentMember.Member_key) < Cint([Term Start Date].[ISO Year].CurrentMember.Member_key)
) ON COLUMNS
FROM [Enrolments]
);
基本上,过滤器表达式在ISO Week Number of Year
不是参数时起作用,例如,如果我更改过滤器表达式以表示[ISO Week Number of Year] <= 7
它提供正确的结果。当我从 SSRS 传递相同的值作为参数时,我得到了不正确的结果 - 似乎没有应用过滤器。
有人可以解释为什么会这样并提供修复吗?
我注意到你在这里缺少 Member_Key。更改以下内容:
Cint( STRTOMEMBER(@ToISOWeekNumberOfYear, CONSTRAINED) )
至:
Cint( STRTOMEMBER(@ToISOWeekNumberOfYear, CONSTRAINED).Member_Key )
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句