590
社区成员
发帖
与我相关
我的任务
分享
SELECT ( STRTOMEMBER([成品分析].["+@From实际出室时间年月日 + "]") :
STRTOMEMBER([成品分析].["+@To实际出室时间年月日] + "]")
ON COLUMNS FROM [成品分析]) ,
看看这个小例子:
1、统计昨日的销售额
WITH MEMBER mydate as now()
SELECT {[Measures].[销售额]} on COLUMNS,
{StrToMember("[时间维].[日].&[" + Format(DateAdd('d',-1,CDate(mydate)), "yyyy年MM月dd日") + "]")} on ROWS
from [产品销售专题]
也可以写成:
WITH MEMBER mydate as now()-1
SELECT {[Measures].[销售额]} on COLUMNS,
{StrToMember("[时间维].[日].&[" + Format(mydate, "yyyy年MM月dd日") + "]")} on ROWS
from [产品销售专题]
2、统计最近三个月的销售额(这个也可以用mdx的函数实现)
WITH MEMBER mydate as now()
SELECT {[Measures].[销售额]} on COLUMNS,
{StrToMember("[时间维].[月].&[" + Format(DateAdd('m',-2,CDate(mydate)), "yyyy年MM月") + "]"):StrToMember("[时间维].[月].&["+ Format(mydate, "yyyy年MM月") +"]")} on ROWS
from [产品销售专题]
不懂,帮顶,学习,蹭分.