在 Report Builder 2.0 中使用 MDX 参数
我目前有一个如下所示的查询:
SELECT
NON EMPTY([测量].[总计])ON 0,
NON EMPTY (([注册日期].[日历].[年份].["
+ 参数!EnrollDate.Value +
"] * [DIM ENROLLMENT].[ENROLLMENT].[ENROLLMENT PROG].ALLMEMBERS)) ON 1
FROM (SELECT (([DIM ENROLLMENT].[ENROLLMENT].[终止原因].[仍然已注册])) ON 0 FROM [NapaCHI]);
粗体部分来自参数部分,我在其中使用 Label = 2006 和 Value = 2006
手动指定了参数代码>. 我已经尝试了几乎所有可接受的语法,并阅读了有关此问题的每一篇文章,但无论我自己定义值还是使用单独的 MDX 语句来选择不同的非空年份和 (NULL) 作为聚合,似乎都无法使其工作。
请帮忙,这让我发疯了! 谢谢。
I currently have a query that looks like this:
SELECT
NON EMPTY ([Measures].[TOTAL]) ON 0,
NON EMPTY (([ENROLL DATE].[CALENDAR].[YEAR].["
+ Parameters!EnrollDate.Value +
"] * [DIM ENROLLMENT].[ENROLLMENT].[ENROLLMENT PROG].ALLMEMBERS)) ON 1
FROM (SELECT (([DIM ENROLLMENT].[ENROLLMENT].[TERMINATION REASON].[Still Enrolled])) ON 0 FROM [NapaCHI]);
The bold section comes from the parameters section where I manually specified the parameters with Label = 2006 and Value = 2006
. I have tried just about every acceptable syntax and read about every article about this and cannot seem to get it to work whether I define the values myself or use a separate MDX statement that selects distinct non-empty years and (NULL) for the aggregate.
Help please, it's driving me insane!
Thanks.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
您的表达式看起来不完整,您需要以 and = 符号开头并正确引用它。 类似以下内容
您可能还遇到数据类型问题,您可能想要使用参数的 .Label 属性或将值显式转换为字符串。 如果这些都不起作用,那么了解您遇到的错误会很有帮助。
Your expression looks incomplete, you would need to start it with and = sign and quote it propertly. Something like the following
You may also have issues with datatypes, you might want to either use the .Label property of the parameter or explicitly convert the value to a string. If none of this works it would be helpful to know what error you are getting.
我认为这个 MDX 需要:
或者你可以像这样使用实际的 MDX 语言:
其中任何一个都应该可以工作。
I think this MDX is requiring:
Or you could you the actual MDX language like so:
Either of those should work.