590
社区成员
发帖
与我相关
我的任务
分享
你不都写出来了么??
select
*,
环比增长=(select 销售额 from tb where convert(varchar(7),getdate(),120))/=(select 销售额 from tb where dateadd(mm,-1,convert(varchar(7),getdate(),120))),
同比增长==(select 销售额 from tb where convert(varchar(7),getdate(),120))/=(select 销售额 from tb where dateadd(yy,-1,convert(varchar(7),getdate(),120)))
...
from
tb
2,你要做的:
首先你得建一个时间维度DimTime,假定层次是year-month-day,根据销售额(假定是:SALBI002)做同比:
create member currentcube.[measures].[PM SALBI002]
as
sum([measures].[SALBI002])/
sum(ParallelPeriod([DimTime].[year-month-day].currentmember.parent,[DimTime].[year-month-day].currentmember),[measures].[SALBI002])
做环比:
sum([measures].[SALBI002])/
sum([DimTime].[year-month-day].currentmember.prevmember,[measures].[SALBI002])
空值处理需要注意一下,用IsEmpty函数判断