get Oracle SmartView plugin

Сбор статистики расчета

 

Для сбора статистки по работе конкретного расчета, можно воспользоваться след. способом – собрать данные с помощью EssCMD и обработать их.


output 1 "RunCalc.log";
login "EssbaseServer" "admin" "password";
updatevariable "CalcMonth" " EssbaseServer " "Application" "" "Aug";
select "Application" "MDB";
getdbstats;
listfiles 3;
runcalc 2 "CalcScript";
getdbstats;
listfiles 3;
output 3 " RunCalc.log";
exit;

Алгебра #Missing

Результат алгебраического выражения с участием #MISSING

Calculation/Operation

Result

X + #MISSING X
X – #MISSING X
#MISSING X -X
X * #MISSING #MISSING
X / #MISSING #MISSING
#MISSING / X #MISSING
X / 0 #MISSING
X % #MISSING #MISSING
#MISSING % X #MISSING
X % 0 #MISSING
X == #MISSING False, unless X is #MISSING
X != #MISSING True, unless X is #MISSING
X <> #MISSING True, unless X is #MISSING
(X <= #MISSING) (X <=0)
(X >= #MISSING) (X >=0) or (X == #MISSING)
(X > #MISSING) (X > 0)
(X < #MISSING) (X < 0)
IF (#MISSING) IF (0)
f (#MISSING) #MISSING for any Essbase function of one variable
f (X) #MISSING for any X not in the domain of f, and any Essbase function of more than one variable (except where specifically noted)