SSRS中的MDX参数

debugcn 发表于 Dev

smckechnie

大家好，希望我能帮助我创建以下成员，这是硬编码的代码外观。

WITH MEMBER [Measures].[CoinInRank] AS CASE 
WHEN [Measures].[Total Amount Bet] <= 5100  AND [Measures].[Total Amount Bet] > 0 THEN "Casual"
WHEN [Measures].[Total Amount Bet] > 5100 AND [Measures].[Total Amount Bet] <=  25000 THEN "Frequent"
WHEN [Measures].[Total Amount Bet] > 25000 THEN "Avid"
END MEMBER

现在，我想将数量范围（即5100和25000）作为SSRS的参数传递，我尝试了以下操作，但没有任何运气。

WITH MEMBER [Measures].[CoinInRank] AS CASE 
WHEN [Measures].[Total Amount Bet] <= STRTOSET(@FrequentMinValue,CONSTRAINED)   AND [Measures].[Total Amount Bet] > 0 THEN "Casual"
WHEN [Measures].[Total Amount Bet] > STRTOSET(@FrequentMinValue,CONSTRAINED) AND [Measures].[Total Amount Bet] <=  STRTOSET(@FrequentMaxValue,CONSTRAINED) THEN "Frequent"
WHEN [Measures].[Total Amount Bet] >  STRTOSET(@FrequentMaxValue,CONSTRAINED)  THEN "Avid"
END MEMBER

任何建议将不胜感激。

为什么

StrToSet将字符串转换为集合。度量是一个数字表达式，因此无法与集合进行比较。如果您摆脱了StrToSet，会发生什么？

WITH MEMBER [Measures].[CoinInRank] AS CASE 
WHEN [Measures].[Total Amount Bet] <= @FrequentMinValue   AND [Measures].[Total Amount Bet] > 0 THEN "Casual"
WHEN [Measures].[Total Amount Bet] > @FrequentMinValue AND [Measures].[Total Amount Bet] <=  @FrequentMaxValue THEN "Frequent"
WHEN [Measures].[Total Amount Bet] >  @FrequentMaxValue THEN "Avid"
END MEMBER

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。