关于请问MDX语句的where子句的条件应该怎么写

答案:1 悬赏:0

解决时间 2021-01-11 15:34

提问者网友：欲望失宠
2021-01-10 20:07

最佳答案

二级知识专家网友：洒脱疯子
2021-01-10 20:28

给个例子:
with
member [Measures].[回归用户] as ([Dim
User Type].[User Type Key].&[25],[Measures].[Count])
member [Measures].[回归账号] as ([Dim
User Type].[User Type Key].&[26],[Measures].[Count])
member [Measures].[活跃用户] as ([Dim
User Type].[User Type Key].&[10],[Measures].[Count])
member [Measures].[活跃账号] as ([Dim
User Type].[User Type Key].&[13],[Measures].[Count])
member [Measures].[用户回归率] as
[Measures].[回归用户]*100/[Measures].[活跃用户],format_string="0.0"
member [Measures].[账号回归率] as
[Measures].[回归账号]*100/[Measures].[活跃账号],format_string="0.0"
select {[Measures].[回归用户],[Measures].[回归账号],[Measures].[用户回归率],[Measures].[账号回归率]} on columns,
[Dim Date].[Full
Date].&[2014-10-21T00:00:00]:[Dim Date].[Full
Date].&[2014-10-28T00:00:00] on rows
from [Navinfo Statistics V2DB]
where ([Dim
Games].[Games Key].&[1],[Dim Channel].[Channel Key].[ALL])

我要举报

如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！