Hyperion Essbase 之 #MISSING 与零的区别

gaoyiming

在Essbase中，如果维度的交叉没有值，则会给个 #MISSING ， 和0不同，0是有值的，有block的。
在脚本计算过程中，

计算结果
X + #MISSINGX
X – #MISSING#MISSING – XX-X
X * #MISSING#MISSING
X / #MISSING#MISSING / XX / 0#MISSING#MISSING#MISSING
X % #MISSING#MISSING % XX % 0#MISSING#MISSING#MISSING
X == #MISSINGFalse, unless X is #MISSING
X != #MISSINGX <> #MISSINGTrue, unless X is #MISSINGTrue, unless X is #MISSING
(X <= #MISSING)(X <=0)
(X >= #MISSING)(X >=0) or (X == #MISSING)
(X > #MISSING)(X > 0)
(X < #MISSING)(X < 0)
X AND #MISSING:1 AND #MISSING*0 AND #MISSING#MISSING AND #MISSING
#MISSING0#MISSING
X OR #MISSING:1 OR #MISSING0 OR #MISSING#MISSING OR #MISSING
1#MISSING#MISSING
IF (#MISSING)IF (0)


f (X)

liulina_00

#missing也有可能是有block的啊

zdyctd

脚本计算过程中看不懂，我只知道维度的交叉没有值，刷出来的 #MISSING