我有一个 Cube:
维度:
[时间]
[渠道]
[市场]
事实数据:
[销量]
希望从 Cube 检索出这样的结果集:
(筛选条件: 某个时间点, 比如 2008年1月 )
渠道 ¦ 销量 ¦ 去年同期销量 --(即2007年1月的销量)
------------------------
A ¦ 32 ¦ 28
B ¦ 30 ¦ 25
C ¦ 31 ¦ 30
说明的是[时间] 里有year ;month; yearmonth 数据挖掘实验室
需要做这个去年同期销量的计算成员
我做的计算成员 filter([Measure].[sales].Members,[Period].[year]=[Period].[year]-1)不行
请教各位高手~~应该怎样做..
member [Measures].[去年] as ' ( ParallelPeriod([时间].[年] ), [Measure].[sales])
从我程序里给你一个例子吧.
==============================================
with set [贸易时间] as 'Filter( { Descendants ( [时间].[所有 时间].[2007年], [时间].[月] ) } , Not IsEmpty([金额] ) )'
member [Measures].[本季本月金额] as '[金额]'
member [Measures].[上季本月金额] as ' ( ParallelPeriod([时间].[季度] ), [金额]) '
member [Measures].[本季本月比上季本月] as ' [本季本月金额] - [上季本月金额]'
member [Measures].[同比] as ' ([本季本月金额] - [上季本月金额])/[上季本月金额]', 数据挖掘论坛
FORMAT_STRING='00.000%',
FORE_COLOR = 'iif([Measures].[同比] < 0, 255, 0)'
select [贸易时间] on rows,
{ [本季本月金额], [上季本月金额], [本季本月比上季本月] ,[同比] } on Columns
from [DataCube]
cell properties VALUE, FORMATTED_VALUE, FORE_COLOR 上面是季中的月比较.
下面去年月同期比.
==================
with set [贸易时间] as 'Filter( { Descendants ( [时间].[所有 时间].[2007年], [时间].[月] ) } , Not IsEmpty([金额] ) )'
member [Measures].[本年本月金额] as '[金额]'
member [Measures].[上年本月金额] as ' ( ParallelPeriod([时间].[年] ), [金额]) '
member [Measures].[本年本月比上年本月] as ' [本年本月金额] - [上年本月金额]' 数据挖掘研究院
member [Measures].[同比] as ' ([本年本月金额] - [上年本月金额])/[上年本月金额]',
FORMAT_STRING='00.000%',
FORE_COLOR = 'iif([Measures].[同比] < 0, 255, 0)'
select [贸易时间] on rows,
{ [本年本月金额], [上年本月金额], [本年本月比上年本月] ,[同比] } on Columns
from [DataCube]
cell properties VALUE, FORMATTED_VALUE, FORE_COLOR Create By Any-Extract(WL-AE) 数据挖掘工具
|
