初学分析服务,求解惑
wylcy 2013-11-22 11:27:27 看了微软网站的一个简单教程,前面还算能理解,看到讲解kpi相关的内容
http://technet.microsoft.com/zh-cn/library/ms166869.aspx
里面有一段说到走向表达式
Case
When IsEmpty
(ParallelPeriod
([Date].[Calendar Time].[Calendar Year],1,
[Date].[Calendar Time].CurrentMember))
Then 0
When (
KpiValue("Reseller Revenue") -
(KpiValue("Reseller Revenue"),
ParallelPeriod
([Date].[Calendar Time].[Calendar Year],1,
[Date].[Calendar Time].CurrentMember))
/
(KpiValue ("Reseller Revenue"),
ParallelPeriod
([Date].[Calendar Time].[Calendar Year],1,
[Date].[Calendar Time].CurrentMember)))
>=.02
Then 1
When(
KpiValue("Reseller Revenue") -
(KpiValue ( "Reseller Revenue" ),
ParallelPeriod
([Date].[Calendar Time].[Calendar Year],1,
[Date].[Calendar Time].CurrentMember))
/
(KpiValue("Reseller Revenue"),
ParallelPeriod
([Date].[Calendar Time].[Calendar Year],1,
[Date].[Calendar Time].CurrentMember)))
<=.02
Then -1
Else 0
End
完全看不懂是在说啥啊。KpiValue是获取kpi上定义的度量表达式,ParallelPeriod是指去年的环比定义吧,但是
(KpiValue ( "Reseller Revenue" ),ParallelPeriod([Date].[Calendar Time].[Calendar Year],1,[Date].[Calendar Time].CurrentMember))
这个括号里面逗号分隔的到底是什么意思
而且还
(KpiValue ( "Reseller Revenue" ),
ParallelPeriod
([Date].[Calendar Time].[Calendar Year],1,
[Date].[Calendar Time].CurrentMember))
/
(KpiValue("Reseller Revenue"),
ParallelPeriod
([Date].[Calendar Time].[Calendar Year],1,
[Date].[Calendar Time].CurrentMember)))
完全一样的做了一下除法
求解惑