IBM Cognos TM1 V1010npublic.dhe.ibm.com/software/data/cognos/documentation/...TM1 53MT\`SDEv .....49...
Transcript of IBM Cognos TM1 V1010npublic.dhe.ibm.com/software/data/cognos/documentation/...TM1 53MT\`SDEv .....49...
-
IBM Cognos TM1V10.1.0
Yw8O
���
-
"
Z9C>JO0d'VDz7.0,kDAZ 1813D:yw;PDE"#
z7E"
>D5JCZ IBM Cognos TM1 V10.1.0,"R9I\JCZsx"Pf#*i4>D5D|_f>,kCJ IBM CognosE"PD (http://publib.boulder.ibm.com/infocenter/cogic/v1r0m0/index.jsp)#
Microsoft z7A;lUh- Microsoft DJmE\9C#
Licensed Materials - Property of IBM
© Copyright IBM Corporation 2007, 2012.
http://publib.boulder.ibm.com/infocenter/cogic/v1r0m0/index.jsp
-
?<
ri . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ix
Z 1 B BvZ] . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1V10.1.0 PDBv&\ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
Cognos TM1 Operations Console . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1tm1xfer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1odbc_test $_ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
V10.1.0 PDQ|D&\. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1,OhCK"P;%"PT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16Cognos TM1 Yw8O7DD5|D . . . . . . . . . . . . . . . . . . . . . . . . . . 2
Z 2 B TM1 53M&\dC . . . . . . . . . . . . . . . . . . . . . . . . . . . 3TM1 53M&\dCEv . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3&\Vd . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
Cognos TM1 Application Web \& . . . . . . . . . . . . . . . . . . . . . . . . . . . 6hC&\ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6Kb&\VdPUWD'{ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
9CVC}]SXLr . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79CVC}]SXLr#f}] . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79C}]SXLr^D`,}]/Dfr . . . . . . . . . . . . . . . . . . . . . . . . . 8&mQF5r_Q''D}]SXLrD~ . . . . . . . . . . . . . . . . . . . . . . . . 8
Z TM1 73PdCM\m3d . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93dMvK$wxDZf9C?"bBn . . . . . . . . . . . . . . . . . . . . . . . . . 9\m3dDD~MD~P . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93dD TM1 Server dCN} . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9Kb;, TM1 Client .d3dDnl . . . . . . . . . . . . . . . . . . . . . . . . . 10
+"P;%k Cognos TM1 Server dO9C . . . . . . . . . . . . . . . . . . . . . . . . 10"P;%DnQ9C6} . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11
Z 3 B TM1 Admin Server Yw . . . . . . . . . . . . . . . . . . . . . . . . 17TM1 Admin Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17Z Windows Yw53OKP TM1 Admin Server . . . . . . . . . . . . . . . . . . . . . . . 18+ TM1 Admin Server w* Windows OD&CLrKP . . . . . . . . . . . . . . . . . . . 19
KP UNIX OD TM1 Admin Server . . . . . . . . . . . . . . . . . . . . . . . . . . . 20i4 Admin Server 4,(f. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
8(\mwzD;C . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 208(`v\mwz . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
Z 4 B 6L TM1 Server Yw . . . . . . . . . . . . . . . . . . . . . . . . . 216L~qwYwEv . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21hC6L TM1 Server Tw*&CLrKP . . . . . . . . . . . . . . . . . . . . . . . . . 22hC6L TM1 Server Tw* Windows ~qKP . . . . . . . . . . . . . . . . . . . . . . . 2320 TM1 Server Tw* Windows ~qKP . . . . . . . . . . . . . . . . . . . . . . . 23}%w* Windows ~qKPD TM1 Server . . . . . . . . . . . . . . . . . . . . . . . . 23
t/6L TM1 Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24t/hC* Windows &CLrD TM1 Server . . . . . . . . . . . . . . . . . . . . . . . 24t/w* Windows ~q20D TM1 Server . . . . . . . . . . . . . . . . . . . . . . . . 24t/ UNIX TM1 Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
,S=6L~qw . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26"B6L~qwPm . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26
© Copyright IBM Corp. 2007, 2012 iii
-
XBhC\mwz . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26XBhC>X~qw!n . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27
S6L~qwO*,S . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27XU Windows TM1 Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27XUw*~qKPD Windows TM1 Server . . . . . . . . . . . . . . . . . . . . . . . . 27
XU UNIX TM1 Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28XUZs(==BKPD UNIX TM1 Server . . . . . . . . . . . . . . . . . . . . . . . 28
GG< . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30i4BqU> . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30hCQwx(^F . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31SBqU>V4G< . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31>}ELODU>D~ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32
`S~qwT\ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32\mM'z,S . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33rM'zc%{" . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33S~qwO*M'zD,S . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 336LXU~qw . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
6L~qwZf\m . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34XZGES< . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35
Tz?SX#=9C TM1. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35PX9Cz?SX#=D"bBn . . . . . . . . . . . . . . . . . . . . . . . . . . . 36TM1 C API . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36TurboIntegrator xL|n . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37
Z 5 B TM1 2+TEv . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39O$Ev . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39TM1 Ts2+T . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39
Z 6 B \mC'Mi . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41TM1 C'Mi2+TEv . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 415) TM1 2+=8 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41TM1 C'Mi2+T>} . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42
Kb\miM(^ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42\mi . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 422+\mi . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43}]\mi . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44
mSM>}C'Mi . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44mSC' . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45mSi . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45>}C' . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46>}i . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46
+C'Vd=i . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46`viPDI1Jq . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46
#$ TM1 }] . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46^FT}]?
-
TM1 53MT\`SDEv . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 499C\m~qwU> . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50
Admin Server U>G . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56{"OXT6p . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57TM1 GtTD~ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57dCMtC~qw{"U> . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58i4 TM1 Server {"U> . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61
M'zU> . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 629CsKU> . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63KbsKU>B~ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64dCsKU> . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65|BsKU>nBB~ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 669CsKU>0Z/@U>{" . . . . . . . . . . . . . . . . . . . . . . . . . . . . 66
9CX~`,}]/`S~qwT\ . . . . . . . . . . . . . . . . . . . . . . . . . . . 69tCT\`S . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70{CT\`S . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70i4M'z"`,}]/M~qwDT\3FE" . . . . . . . . . . . . . . . . . . . . . . 70
9C TM1 Top 5CLr . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71Z TM1 Top PT>C'{ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71dC Tm1top.ini D~ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71KP TM1 Top . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73i4MKb TM1 Top T> . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74TM1 Top |n . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78!{_L&m . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79
9C TM1 T\F}w . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 80PXKP TM1 T\F}w$_DX*"bBn . . . . . . . . . . . . . . . . . . . . . . 80ICD TM1 T\F}w . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 809C TM1 PerfMon 5CLri4 TM1 T\F}w . . . . . . . . . . . . . . . . . . . . . 819C Microsoft Windows T\`Swi4 TM1 T\F}w . . . . . . . . . . . . . . . . . . 83
6qKD*"TxP TM1 Server @#Vv . . . . . . . . . . . . . . . . . . . . . . . . . 84CZ Windows DwT$_ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8420MKP ADPlus . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 84KP Dr. Watson . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 88Z TM1 Server @#.sU/D~TxPVv . . . . . . . . . . . . . . . . . . . . . . . 89+D~+dA Cognos . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 89
Z 8 B Cognos TM1 $_M5CLr . . . . . . . . . . . . . . . . . . . . . . 91tm1xfer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91
tm1xfer o( . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 919C tm1xfer 9u?< . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 929C tm1xfer b9?< . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93tm1xfer 5w . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 94tm1xfer Dms{" . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 95tm1xfer C>5w . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 96
?< v
-
odbc_test $_ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 97
Z 9 B 9C Cognos TM1 Operations Console . . . . . . . . . . . . . . . . . . 99T>C'{ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 994( Operation Group TxP`S . . . . . . . . . . . . . . . . . . . . . . . . . . . . 99r TM1 Operations Console mS\mwzM Cognos TM1 Server {F . . . . . . . . . . . . . . . . 99hCU>D~M~qw}VN} . . . . . . . . . . . . . . . . . . . . . . . . . . . . 100BXrOXdCD~ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1009C`S!nKP/,(f . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 101KP4vli8>{ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 101hC}Kw . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1022EU>D~ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 102BXU>D~ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 103i4U>D~ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 103
Z 10 B \m IBMCognos TM1 Web . . . . . . . . . . . . . . . . . . . . . . 105IBM Cognos TM1 Web Ev . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105S IBM Cognos TM1 Web \m TM1 Server . . . . . . . . . . . . . . . . . . . . . . . . 105\mxL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 106\mSn . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 107hCM'ztT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 108hC`,}]/tT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 109hC,HtT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 109
|D\k . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 109dC IBM Cognos TM1 Web DT(ew3 . . . . . . . . . . . . . . . . . . . . . . . . 110*wvC'dC;,w3 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 110*yPC'dC2Cw3 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 112
^D IBM Cognos TM1 Web dCN} . . . . . . . . . . . . . . . . . . . . . . . . . . 115`- Web.Config D~ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 115dC TM1 $wwN} . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 116T>T(e$_8 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 118T>T(e$_8DZ] . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 118|DT(e$_8D_H . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 118T>r~X“
-
@5X53d|D . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 137e}`,}]/D@5X5 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1394(`,}]/@5X5 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1399C AddCubeDependency 4("@5X5 . . . . . . . . . . . . . . . . . . . . . . . . . 139wTMj6`,}]/@5X5 . . . . . . . . . . . . . . . . . . . . . . . . . . . 139
Z 12 B 4F`,}]/. . . . . . . . . . . . . . . . . . . . . . . . . . . . 1414FEv . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1414F4(DX5 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 142yhDCJ(^ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 145Admin Server "bBn . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 145dC Tm1s.cfg D~T'V4F . . . . . . . . . . . . . . . . . . . . . . . . . . . 146
,$4F,S . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1464(4F,S . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 146^D4F,S . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 147>}4F,S . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 147
4FxL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1484F`,}]/ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1488(PX4FD`,}]/DE" . . . . . . . . . . . . . . . . . . . . . . . . . . . 149TM1 4F`,}]/1+vVDiv . . . . . . . . . . . . . . . . . . . . . . . . . 150
,=xL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1504h,= . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 151F.,= . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 151Z;H(Dxgrcrx,SO,= . . . . . . . . . . . . . . . . . . . . . . . . . . 152
=< A. WCJT&\ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 153|Ll]| . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 153IBM 0(z&\!n . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 154
=< B. X~`,}]/ . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1552+TX~`,}]/ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 155
}CellSecurity_CubeName . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 155}ChoreSecurity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 156}ClientSecurity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 156}CubeSecurity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 157}DimensionSecurity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 157}ElementSecurity_DimensionName . . . . . . . . . . . . . . . . . . . . . . . . . . . 158}ProcessSecurity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 159
M'zMi\mX~`,}]/ . . . . . . . . . . . . . . . . . . . . . . . . . . . . 159}ClientsGroups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 159}ClientProperties . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 160
TstTMXTX~`,}]/ . . . . . . . . . . . . . . . . . . . . . . . . . . . . 160}ConnectionProperties . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 161}CubeProperties . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 161}DimensionProperties . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 162}DimensionAttributes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 162}ElementAttributes_DimensionName . . . . . . . . . . . . . . . . . . . . . . . . . . 163}HierarchyProperties . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 163
T\`SX~`,}]/ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 164}StatsByClient . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 164}StatsByCube. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 165}StatsByCubeByClient . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 165}StatsForServer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 166
d{X~`,}]/ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 167}Hold_UserName_CubeName . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 167
?< vii
-
=< C. X~,H . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 169}Chores . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 169}ClientProperties . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 169}Clients . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 169}ConnectionProperties . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 170}Connections . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 170}CubeFunctions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 171}CubeProperties . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 171}Cubes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 172}DimensionAttributes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 172}DimensionProperties . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 172}Dimensions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 173}ElementAttributes_DimensionName . . . . . . . . . . . . . . . . . . . . . . . . . . . 173}Groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 174}Hierarchies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 174}HierarchyProperties . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 174}Hold . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 174}PerfClients . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 175}PerfCubes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 175}Processes. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 175}StatsStatsByClient . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 176}StatsStatsByCube . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 176}StatsStatsByCubeByClient . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 177}StatsStatsForServer. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 177}TimeIntervals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 178
=< D. I TM1 &mD Excel B~ . . . . . . . . . . . . . . . . . . . . . . . 179
yw . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 181
w} . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 185
viii IBM Cognos TM1 V10.1.0: Yw8O
-
ri
>D5(E*9C IBM® Cognos® TM1® xa)#
>D5hvK TM1 e5a9"~qwYw"O$Mi~2+T#
IBM Cognos TM1 /IK5qf."('b?MKw}],by,^[+>DXm;C
ra9gN,5q'JMM'%/xPE/#TM1 a)K}]D1SI{
T"-w}LPDpNM;BDE"Sy&CL
rD>y}]#b)ibG}&CLrD>}}]#}CDz7{F
I\GdwTyP_DLj#4-Z(,;C4F#
WCJT&\
Kz7?0P;'VozmPPO(}g,P/;crS&O-)DC'9CCz7
DWCJT&\#ICJ IBM Cognos TM1 Operations Console#PX|`E",kN
D“(z&\!n”wb#
00yw
>D5hvKz7D10&\#I\|,T10;ICn?D}C#kpFO5>N
N44ICT#K`}C;Gd5"P5r(IpN,rK;aa)NNJO"zk
r&\#IBM TPv(&\r&\TD*"""
-
x IBM Cognos TM1 V10.1.0: Yw8O
-
Z 1 B BvZ]
>Z|,K"PfPDBv&\"Q|D&\MQ}%&\DPm#
|+ozzTzD}6M&CLr?p=TT0zDC'`5*sxPf.#
*iRnBDz7D5,kCJ IBM Cognos TM1 E"PD,x7*:http://
publib.boulder.ibm.com/infocenter/ctm1/v10r1m0/index.jsp
V10.1.0 PDBv&\BfPvK IBM Cognos TM1 PTON"
-
6Cognos TM1 Yw8O7DD5|DQ+;5PdCwbS>8OPFvT|CXi/K"PfDD5#
Q+BPwbS6IBM Cognos TM1 Yw8O7FA IBM Cognos TM1 Installation and
Configuration Guide:
v Cognos TM1 53e5a9v Tm1s.cfg ~qwdCD~MN}v Tm1p.ini M'zdCD~MN}v Cognos TM1 O$G
-
Z 2 B TM1 53M&\dC
>ZhvKgNdC IBM Cognos TM1 Server MM'z#
TM1 53M&\dCEv9CBPi~M&\4dC IBM Cognos TM1 Server MM'z#
dC hv
Tm1s.cfg D~ ;vdCD~,CZ8( TM1 Server D73E"#
zIT`- Tm1s.cfg D~T43`X*~qwD73#
PXyPN}Dj8E"Mj{Pm,kND IBM Cognos TM1
Installation and Configuration Guide#
Tm1p.ini D~ bG;vdCD~,CZ8( T M 1 C l i e n t( T M 1
Perspectives"TM1 Architect M Client) D73E"#
PXyPN}Dj8E"Mj{Pm,kND IBM Cognos TM1
Installation and Configuration Guide#
&\Vd bG\m1IT4C'itCr{CD;i&\#
b)&\9z\;\m;)!n,}g,vK$wxX4=="
3d"}]#tT0TZ~qw/@wDCJ(^#
PXj8E",kNDZ 43D:&\Vd;#
VC}]SXLr bG;vN},IT9C}]SXLr4uL`,}]/(Hd
GG)_Pm`4SD}]SXLrFcD`,}]/)DXB
0k1d,4,#f}]SXLr,;sZ~qwt/1+|G
XB0k,x;CXBFcb)}]SXLr#
PXj8E",kNDZ 73D:9CVC}]SXLr;#
3d bG;v&\?~,9C'\;4(|GT:D}]x,Sx@
"Zy!}]Zb)}]xP$w#
\m1kTK&\?~4PDNq|(:KbK&\?~0dZ
f9Civ"tCXhDdCN}T0\m`XD~MD~P#
PXj8E",kNDZ 93D:Z TM1 73PdCM\m3
d;#
© Copyright IBM Corp. 2007, 2012 3
-
dC hv
"P;% bG;nk~qw`XD&\,9CTZ,;`,}]/TsD
A/4Yw_P|_D"PT#"P;%PzZ9`,}]/D
4k_;a;h9,rK;XH}C`,}]/DA!_jI{
GDAYw#
PXj8E",kNDZ 103D:+"P;%k Cognos TM1
Server dO9C;#
}]#t bG;nk~qw`XD&\,Jmz*wvC'dCTZ`,
}]/DwvxrD%b4kCJ(^#;)#tK3vxrP
D}],M;PTCxr_P@“~qwK%”,"!q&\Vd#
,OivB,yPVd
-
1JmvK$wxX4==1:
– C'ZG1SX4ivBYw,Tc{GITZ+}]5a)xgxd{C'9
C.0,TPw{}]/#JmvK$wxX4==19CDXb3dcZ"T
;,D}]|D,x;aP8(3dD4SYw#
– |DD}]C;,DU+T>,TaQC'C|DP4&C=y!}]P#;)
a;KvK$wxPD}]|D,%*qU+V4=Z+,T7(d*y!}]
D;?V#
– C'XkV/a;d}]|D,E\9dTd{C'IC#g{C';0_9C
3d,}g,g{{G0_Z TM1 Ogf>D-d1SX4==,G4{Ga"
V\QG!*V/4“a;”4%4a;d|D#
– (#ivB,9CvK$wx==H9C1SX4==|_',r*y!}]"
z|DD5JH?v}]|D
-
}]#t (DR) G;nk~qw`XD&\,Jmz*wvC'dCTZ`,}]/
DwvxrD%b4kCJ(^#;)#tK3vxrPD}],M;PTCxr
_P@
-
KbvK$wxPDXBFcMa;
BmT>KZ“vK$wx”PESM;ESxP“a;”M“XBFc”D;,'{#
X4 Yw "M}]
1S A! --> XBFc
4k --> XBFc
S“y! TM1 ==”#
=“y! TM1 ==”#
vK$wx A! --> XBFc
4k --> XBFc
S“y! TM1 ==”#
=vK$wx#
vK$wx a; +vK$wx}]"M=“y
! TM1 #M”#
ESDvK$wx a; +“vK$wx”"M=SP
1yPJ4
-
~#b+GZ PersistentFeeders=T DivBZ}]?}yPVC}]SXLr#
Z0k1,a+ .feeders D~D^D1dky!`,}]/D~D^D1dxPHO#
g{`,}]/D~H .feeders D~|B,G4aO* .feeders D~^'"+d>}#
IZ}yPQ#fD}]SX
Lr,"R~qw+Kv"ZU>D~Pa)J1D{"#
ZbVivB,zXkXBt/~qwTXB0kMXBFcyP}]SXLr#U
>PD{"+ICTBq=:
27660 ERROR 2010-05-14 19:10:26.455 TM1.Server +>}yPVC}]SXLrD~,
~qw+XU
27660 ERROR 2010-05-14 19:10:26.455 TM1.Server XBt/~qwTXB0k}]b#
ZBPivBaO*}]SXLrD~“^'”:}]SXLrD~PPq=ms;}
]SXLrD~DUZ/1dgZ`&D`,}]/D~ (.CUB),g{C'"T+}]S
XLrD~r`,}]/D~S;v}]?D~,CZ
5wO*K}]SXLrD~^'D7P-r#K{"ICTBq=:
8 IBM Cognos TM1 V10.1.0: Yw8O
-
ERROR 2010-05-14 19:00:22.987 TM1.Server lb=`,}]/“xxxx”D^'}]SX
LrD~ -r:...
(ZIC`_L0kDivB,r_Zt/}LPag0kD`,}]/"zmsD
ivB)K{"(#";?|D~)2,xG;Z0krPDP?#Z{"U>PQ
w“ERROR”+T>ms#
Z TM1 73PdCM\m3dw* TM1 \m1,1zZ TM1 73P9C3dMvK$wx1,&CKb;)ms{"#
IT(}w{ TM1 Server dCD~ Tm1s.cfg PD MaximumUserSandboxSize N}4XF?vC'D3dy9CDZf?#PX|`j8E",kND IBM Cognos TM1
Installation and Configuration Guide PDN}Pm#
\m3dDD~MD~P
?v TM1 Server
-
PX Tm1s.cfg D~Mb)N}D|`j8E",kND IBM Cognos TM1 Installa-
tion and Configuration Guide#
v &\Vd
“vK$wx”r“3d”D9CI“~qw/@w”D“~qw”K%PICD“&\Vd”
!nXF#PX|`E",kND IBM Cognos TM1 Operation Guide PD“System
Configuration”;B#
Kb;, TM1 Client .d3dDnlk TM1 Perspectives "~qw/@wT0 TM1 Web DIM'K`H,3d&\Z
Cognos TM1 Application Web PD$w==TP;,#
CE"kT9Cb)M'ziODC'r\m1#
,O3dMy!}]
^[d{dChCgN,Z Cognos TM1 Application Web M'KP,,O3dF*
default#
K!nDYwkd{M'KP“3d”&\DYw`,#;\Z Cognos TM1 Applica-
tion Web M'KPr*vK$wx#Cognos TM1 Application Web 2;Jm1S4X,
rKzZ9C Cognos TM1 Application Web 1^(1S&my>}]#
Cognos TM1 Application Web C'vI+{GD3d}]a;Ay>}],w* Cognos
TM1 Application Web $ww}LD;?V#
;, TM1 Client P3dDIST
4UhF,Cognos TM1 Application Web ;T>Z TM1 Perspectives "~qw/@w
r TM1 Web P4(DNN3d#
}g,Z TM1 Web P4(D3d;aT>Z Cognos TM1 Application Web M'K
D3dB-PmP#
+"P;%k Cognos TM1 Server dO9C"P;%Gk IBM Cognos TM1 Server `XD&\,|\;|sLHa)T,;`,
}]/Ts4PDA4YwD"PT#
(}9C"P;%,`,}]/D4k_;a;h9TH},;`,}]/DA!_
jI|GDAYw#}g,Z;P"P;%&\DivB,TZ*+}]4k`,}
]/DC',g{m;vC'}ZTC`,}]/4P\/AYw(}g,}ZXB
Fc;vsxR4SDS
-
Zf9C"bBn
kZ4tC"P;%DI==B9C TM1 `H,ZtCKK&\1 TM1 I\a9C
|`Zf#
y] TM1 Server P9CDX(`,}]/T0Zb)`,}]/P4PDA/4n/}
?;,,y9CZfD
-
;Yh9d{4Lr4k,;`,}]/(0y@5D`,}]/);rK,Cognos
TM1 Server KDIZ_"PT1dN&m|`Bq#
M'"V,kH0f>D Cognos TM1 `H,Z_A/4"PT1dN9C Cognos TM1
"P;%asyvS CPU {CJ#
g{ Cognos TM1 Server KD]?;c,G4I\aT"P;%x4D1ZT\EF
zz:f0l#SH0f>}6A Cognos TM1 9.5.2 D CognosTM1 M'Z9C"P
;%1&`S Cognos TM1 Server CPU {CJ,T7#~qwKD4“%M”(~qw
{CJ;N1dr$1d,} 80% 18>KVs)#g{9C"P;%
-
g{CxL}Z4P*}],$,G4F* synchronized() DB TurboIntegrator /}I
CZ7#CxL;a;9Cz&m|BDivBT\|Q#rK,ZtCK"P;%DivB,nC;
Z TurboIntegrator xLP9Cz&m|B#
TZXUK"P;%D;A73,z&m|Bt//z&m|BjIH}a#tnQ6
}(9C,=}]0k TurboIntegrator xL4a_}]0kT\)#
"P;%T Cognos TM1 Server ZfD0l
+ Cognos TM1 9.5.1 kxP"P;%D TM1 9.5.2 `HDZ?bTT> Cognos TM1
9.5.2 ~qwVdD RAM H Cognos TM1 9.5.1 ~qw` 10% = 30%#vSD;)
ZfC?Gr*"P;%4(DZ?a9D Cognos TM1
`f. 30% ZfC?#
-
@5X5tThCh9T`,}]/ B Dn/)#;)("`,}]/@5X5,
G4C@5X5Z~qwa0Vx1d#VP',}GfrD~r,H,$9d'
'#
Z~qw0kZd,Cognos TM1 +y]frD~PD}]SXLrod("`,}
]/@5X5#xP@5}]D`,}]/}CrfrD~(|, ATTRN r ATTRS
/})D}]SXLrodZ~qw0kZd;a("`,}]/@5X5;b)
@5X5GZwCb);f`,}]/frDWNi/r}]|BZd("D#
*DFKiv,k4( TurboIntegrator xL,CxL(}TIfr("D?v@5`
,}]/DX59C AddCubeDependency /}Z#MP("yP1Z`,}]/@
5X5#|,b)T=`,}]/@5X5/}DxL&Z TM1 Server t/s"f
rD~|DsT0,H,$s"44P#Kn/I8Y("~qw6'D`,}]
/@5X5,"E}$1dKPDi/rxLZC'n/1dN%"`,}]/@
5X5(bI\ah9Ts"
-
|Bp{tT
-
16 IBM Cognos TM1 V10.1.0: Yw8O
-
Z 3 B TM1 Admin Server Yw
>Za)K IBM Cognos TM1 Admin Server DEv"hvKZ Windows M UNIX 5
3OKP Admin Server DdM\m1Nq#
PX TM1 53e5a9Dj8E",kND IBM Cognos TM1 Installation and Con-
figuration Guide#
TM1 Admin ServerTM1 Admin Server G;vxL,CZG
-
XkHKP Admin Server,;sE\t/ TM1 Server#g{QZ Tm1s.cfg D~r~
qw|nPP8(K“\mwz”,G4 TM1 Server +"TkCwzOD Admin Server
,S#;\IZNV-r,g{ TM1 Server ^(k Admin Server ,S,G4|+^
(t/#
g{P48(“\mwz”,G4 TM1 Server a"T,S=>XzwOD Admin Server#
g{10>XzwO4KP Admin Server,G4 TM1 Server at/;vBD Admin
Server "kd,S#
Admin Server (}l}~qw"vD(*46pxgPD TM1 Server#(#,TM1
Server a4L(1ddt(F*“v/EEdt”)"MfZ(*,,O1ddtG 60
k#1 Admin Server lb= TM1 Server 1,C~qwad*Q"a4,,"ICZ
xgODM'z#;x,g{;N1d(HZv/EEdt1dD}6)}s,Admin
Server 4lb=fZQ"aD TM1 Server,G4C TM1 Server aSxgOICD~
qwPmP}%#rK,C TM1 Server +;ICZxgPDM'z#
,OivB,Admin Server 9CKZ 5495#g{KZ 5495 QZ9C,G4IT(}
4({* Tm1admsrv DB~q4VdBDKZE#yP TM1 &CLr
-
9C Cognos Configuration Z Windows O\m TM1 Admin Server
PX9C IBM Cognos Configuration 5CLrZ Microsoft Windows Yw53O\m
TM1 Admin Server Dj8E",kND6IBM Cognos TM1 20MdC8O7#
+ TM1 Admin Server w* Windows OD&CLrKP*+ Admin Server w*&CLrKP,k9C Tm1admsrv.exe I4PD~#
20 TM1 1,KD~;ECZ install_dir\bin ?
-
z^(i4w* Windows ~qKPD Admin Server D4,#
KP UNIX OD TM1 Admin ServerZ UNIX 53O20 TM1 \m~qw.s,IT(}V/==r(}9C IBM
Cognos Configuration 5CLrt/"#9M\mC\m~qw#
Z UNIX OV/t/ Cognos TM1 Admin Server
*Z UNIX 53OV/KP TM1 \m~qw,kS install_dir/bin ?D TM1 Server#
PX~qwdCN}DE",kND IBM Cognos TM1 Installation and Configura-
tion Guide PPX Tm1s.cfg D~Dwb#
8(`v\mwz
zIT(}9CVEVtwz{,+ TM1 Client hC*}C`v“\mwz”#
8(`v“\mwz”DM'zITCJr8(wzO“\m~qw”"aDNN TM1
Server#
20 IBM Cognos TM1 V10.1.0: Yw8O
-
Z 4 B 6L TM1 Server Yw
>ZhvK IBM Cognos TM1 6L~qwgN$w,T0C'gN\mb)~qwD
Yw#
PX TM1 53e5a9Dj{j8E",kND IBM Cognos TM1 Installation and
Configuration Guide#
PX9C IBM Cognos Configuration 5CLr4\m Windows r UNIX 53OD TM1
6L~qwDj8E",kND IBM Cognos TM1 Installation and Configuration Guide#
6L~qwYwEv
B
-
v 1SM'zSU=B51,TM1 Server a+GD~s=S;vUZ/1dA4TdxPX|{#Tm1s.log D~#fZ~qwD}]?<
PTKv}]Bq(gZ 313D:SBqU>V4GD~k1d/UZA+;p#f,R)
9{|D* .rej#IT(} TurboIntegrator &m Tm1syyyymmddhhmmss.rej D~TV
4Bq#
v *Z;XU TM1 Server DivBf1#f~qwO}]DyP|D,kZ“~qw/@w”PR|%w~qw,;s%w#f}]#Tm1s.log D~PDyPG} TM1 Server .s,I
9C IBM Cognos Configuration 5CLr+?v>}~qww* Microsoft Windows ~
qKP#r_,z2ITV/hC TM1 Server Tw*&CLrKP#
}L
1. Z Windows Internet Explorer Pr* install_dir\bin ?
-
8. %w7(#fl]==#
zI\h*+l]==F/=@f,T=c9C#
hC6L TM1 Server Tw* Windows ~qKPIT9C tm1sd.exe D~D|nP!nV/20 TM1 Server Tw* Windows ~qK
P,r}%VP~qw#tm1sd.exe D~20Z TM1 install\bin ?ZPDwbhvKgNdC TM1 Server Tw* Windows ~qKP#
20 TM1 Server Tw* Windows ~qKP*20 TM1 Server Tw* Windows ~qKP,k9CTB|nPq=:tm1sd.exe
-install parameters
BmPvKICDN}#
N}
X!/I!
hv
-n Xh
TM1 Server D{F#b+I*ZzT>Q20~qDtT1yT>D Win-
dows ~q{F#
-z Xh
|, tm1.cfg D~D TM1 }]b}]?
-
}g,TB|nP+}% sdata TM1 Server DVP~q#
tm1sd.exe -remove -n sdata
t/6L TM1 Server>ZPDwbhvKgNt/yPf>D TM1 Server#
t/hC* Windows &CLrD TM1 ServerITt/hC* Windows &CLrD6L~qw#
}L
+w“TM1 z[}]”XzwOD\m~q
w#g{“\m~qw”104Z>XFczOKP,G4^[w*~q9G&CL
r,TM1 Server
-
t/ UNIX TM1 Server*ozzt/ UNIX TM1 Server,Z TM1_install_dir/bin or /bin64 ?}E>#
TK>}E>xP8&!D^Ds,MIT9C|4t/ UNIX TM1 Server#19CC
E>t/~qw1, TM1 +9C8(}]?^D76N}TT(e startup_tm1s.sh E>#
}L
1. 9CD>`-wr*CD~#
2. + tm1_path N}hC*|, tm1s.exe ~qwI4PD~D? ./startup_tm1s.sh "../samples/tm1/SData"
G4,XUE>Xk2IC`,D`T76:
> ./shutdown_tm1s.sh "../samples/tm1/SData"
z^(Zt/MXU`,}]b.dlCk%d76D5w=(#
Zs(==BKP UNIX TM1 ServerIT(}+N} RunningInBackground mS= tm1s.cfg D~"+CN}hC* T,Z
s(==BKP TM1 Server#
RunningInBackground=T
XkV/+ RunningInBackground N}mS= Tm1s.cfg#CN};GZ20 TM1 Server
14(Dj< tm1s.cfg D~DiI?V#PX~qwdCN}Dj8E",kND IBM
Cognos TM1 Installation and Configuration Guide#
Z 4 B 6L TM1 Server Yw 25
-
Zs(==BKP TM1 Server 1,Xk9C shutdown_tm1s.sh 4XU~qw#kN
DZ 283D:XUZs(==BKPD UNIX TM1 Server;#
,S=6L~qw
*,S=6L TM1 Server,M'zXk8r}ZKP Admin Server D\mwz#Admin
Server ,$XZIZxgO9CD6L TM1 Server DE",|({F"-i"X7M
KZE#M'z9CD\mwzZ Tm1p.ini D~P8(#
}L
1. CJ~qw/@w#
2. +w*,SD~qwD
-
XBhC>X~qw!nBmhvKzIT(}“TM1 !n”T0r|DD“>X~qw”!n#
>X~qw!n hv
}]?< >X~qw}]D~D?X~qw !qre}“t/1,S=>X~qw”4!r
ITXF TM1 Client GqZt/1T/,SA
>X~qw#
S6L~qwO*,S
zITS6L~qwO*,S#
}L
1. Z~qw/@wP,!q*O*,SD~qwD
-
PX Microsoft XU~qD=(Dj8E",r_PXvs Windows *~qXUVd
D1d?Dj8E",kND Microsoft 'Vx>#
XU UNIX TM1 ServerzITXUZ0(KPD~qw#
}L
1. Zzt/~qwD0ZP4 Ctrl+C#
2. ZKv0,~qwaa>z+yP}]#f=EL#4 ENTER(r RETURN)|
#fyP}]#|k No "4 ENTER |TZ;#f}]DivBXU~qw#
XUZs(==BKPD UNIX TM1 Server*XUZs(==BKPD TM1 Server,kKP;Z install_dir/bin ?
-
}g,TB|nPJm{* Admin RP“\m1”\kDC'XUZ;Z 207.110.100.206
D“\mwz”O"aD{* TM1SERV D TM1 Server#C|nP8>Z"v|nMX
U~qw.dP 30 kD1ddt#~qwZ4#f}]DivBXU#
./startup_tm1s.sh -n TM1SERV -v 207.110.100.206 -user ADMIN-pwd Administrator -time 30 -unsave T
k"b,g{9CxT764t/~qw,G4Xk9CxT764#9C~qw#
kK`F,g{9C`T764t/~qw,G4Xk9C`T764#9C~q
w#}g,g{9C:
> ./startup_tm1s.sh "../samples/tm1/SData"
G4,XUE>Xk2IC`,D`T76:
> ./shutdown_tm1s.sh "../samples/tm1/SData"
z^(Zt/MXU`,}]b.dlCk%d76D5w=(#
G
-
1dA yyyymmddhhmmss zmXU~qw1D10qV~NjD~{* Tm1s20020102143000.log#
1~qwl#XU1,TM1 +T/V4}],"+ Tm1s.log D~#tZELO#BN
t/~qw1,TM1 I9CTB=V==DNb;V4V4|D:
v T/V4|D -- + TM1 Server w* Windows ~qKP1,9CK==v a>V4|D -- + TM1 Server w*&CLrKP1,9CK==
g{zJbXU TM1 Server x;#f}],G4 TM1 +#fxP1dADBqU>
"+D~)9{|D* .rej#}g,Tm1s20020102143000.rej#.rej U>D~I7#z\
G5P}]BqDGG<
,OivB,TM1 +BqGGG”PM`,}]/{F;f&D%*q#
TM1 Z4!r|, X 1tCU>GGITi/BqU> (Tm1s.log) Ti410 TM1 Server }]?DG1, TM1 +yPU>D~O"=;vzci/N}D_-D~P#
}g,g{i/qV~Nj#
+r*“BqU>i/”T0r#
30 IBM Cognos TM1 V10.1.0: Yw8O
-
3. %wN}VNPDR}7ThCCZi/DN}#
zIThCDvN}:
N} hv
*O4Pn/#,OivB,
U>aQw 5000 P,;sY1MEx(,Tcd{C'ICJU>#
IT9C TM1s.cfg D~PhCD LogReleaseLineCount N}|DZY1MEx(.0QwDP}#PX|`E",kND IBM Cognos TM1 Installation and Configura-
tion Guide PD Tm1s.cfg D~wb#
SBqU>V4G<
Zi/BqU>s,zIT9C“BqU>i/a{”T0rV4Bq#1zV4Bq
1,OLDVALUE PPD5+f; NEWVALUE PPD5#
}L
1. ;vT>*V4DG%vG
-
*;vT>`v`ZDG
-
g{*Z?v~qwa0t/1tCT\`S,ITZ Tm1s.cfg D~PhC
PerformanceMonitorOn N}TZ~qwt/1T/*
-
3. !qO*M'z,S#
4. 8(VSdt,T7(+ZN1O*M'z,S#
5. %w!qM'z#
S/`-w+r*,dP|,~qwOfZDyPM'zDS/#CS/;G10
,SDyPM'zDS/#
6. !q*O*,SDM'z,"%w7(#
+ryP!(M'z;u,/fD{",Z]G+ZzZ=h 4 P8(DdtsO
*,S#
7. g{*r!(M'zc%|j8D{",zIT!q“r!(M'zc%{"”!
n,"Z“c%{"”rPdk{"#
8. Z“M'z{"PD”P%w7(#
6LXU~qwITS TM1 Client 6LXU~qw#
}L
1. Z~qw/@wDs0qP,!q*XUD~qw#
2. @N%w~qw"~qw\mw#
+r*“M'z{"PD”T0r#
3. !qXU~qw#
4. 8(VSdt,T7(+ZN1XU~qw#
5. %w7(#
10,S=~qwDyPM'z
-
yPD6L~qw=(}|(:
v h*V/4P,$YwD TM1 \m1#v *0ks?}]D9d1dN#
TM1 (#T`C'==KP;ZK==B,`vC'"SnMxLIT+?,1KP"
CJ TM1 }]#Zz?SX#=B,TM1 Server +(}TB=(4h9""n/:
Y1]Rd{C'"SnMxL,"{}`C'73yhD*z#
Z 4 B 6L TM1 Server Yw 35
-
z?SX#=";af}"zC',;G]Rb)C'k TM1 D;%#;)jIKz
?SX#=,MaXB$nH0QG
-
v TM1P G9C TM1ValPoolCreate qCDXdz#v TM1Server G10~qwDdz#
TurboIntegrator xL|nITZ TI xLD“rT”r“ao”?VtCz?SX#=#*Ka_'J,(iZxL
D“rT”?VPDZ;vodr_G#S|Z;vodD;CtCz?SX#=#
ZxLPtCz?SX#=.s,;\Z“ao”?VDns;P{CK==#g{z
"TZKxLPDNNd{;C{Cz?SX#=,G4+;a`kKxL#
g{Z;v TI xLPtCKK==,G4ZzT={C|r_jISn.0,K==
+;1#VtC4,#bb6EzITZ;vSnPDxLPtCK==,;sZ{
CK==.0KP;5P TI xL#z9IT44xk;sKvz?SX#=,Sxv
T;vSnD3)X|?V9CK==#
9CBP TI |nZ TI xLPtCM{Cz?SX#=#
EnableBulkLoadMode()
DisableBulkLoadMode() - 9Cz?SX#=1,;\Z TI xLD“ao”?VPDn
s;P9CK/}#
Z 4 B 6L TM1 Server Yw 37
-
38 IBM Cognos TM1 V10.1.0: Yw8O
-
Z 5 B TM1 2+TEv
zITXFT~qwDCJMO$#
IBM Cognos TM1 PD2+T&\JmzXFO$MTs2+T#ba(eG
-
40 IBM Cognos TM1 V10.1.0: Yw8O
-
Z 6 B \mC'Mi
>Z5wgNZ IBM Cognos TM1 P\mC'Mi#Z TM1 P,2+TyZC'y
tZDi#
TM1 C'Mi2+TEvTM1 (}+ TM1 C'i/=wviP4\m2+T#TM1 |(;i}v$(eD\
mi,,1Jm4(T:DT(ei#C'ITtZ;vr`vi#
TM1 _P=Vw*DC'i`M:
v \mi - v|($(ei:“\mi”"“}]\mi”M“2+\mi”#PX|`j8E",kND“Kb\miM(^”#
v C'i - |(yPC'4(Di,(#|,G\m TM1 C'#
zIT9C TM1 D“M'z/i”T0r,\m TM1 C'Mi#“M'z/i”T0rVp
i/iMC'#
w* TM1 \m1,zXkZzwOKP TM1 Architect r TM1 Perspectives 4\m
IBM Cognos TM1 Server OD2+T#
5) TM1 2+=8zIT5) TM1 2+=84#$6L~qwODTs,==gB:
}L
1. (e2+Ti#
2. *b)iVdCJ(^#
3. (e TM1 C'#
4. +C'Vd=i#
zIT4PD2+T6pP:
v `,}]/62+T - XFT`,}]/DCJ#v *X62+T - XFTI*Xj6D%*qDCJ#v ,H62+T - XFZ,HPmS"}%MXE*XD\K`2+T@"Z`,}]/62+TM*X62+T(C'T,H;_PCJ(^Div}
b)#
v %*q62+T - XFT%*qDCJ#
":TM1 M'zM~qw9C TM1 C'{M\k(}xg1S(E#K2+Tj
+@"Zj
-
TM1 C'Mi2+T>}*K5w IBM Cognos TM1 2+T"Jmz"T9C2+T&\,f IBM Cognos TM1
Server ;p20D TM1 >}}] (Sdata) f=K;i$(eDiMC'#
*i4b)iMC',kR|%w~qw/@wPD Sdata ~qw,;s@N%w2+
T > M'z/i#
+aT> TM1 D“M'z/i”T0r#
Bm|(K>}C'D\k#
":\k~XZ“M'z/i”0ZP,"RT>*“Q(e”r“4(e”#
C'{ \k iI1Jq
Admin apple \m
Usr1 red 1@i
Usr2 orange O@i
Usr3 blue 1@iMO@i
Kb\miM(^
TM1 (}+\mC'VITB$(eD\m1i,'VVk TM1 PD\mNqkG
+#
v \mi - \miDI1ITCJ TM1 DyPxr,"zm_PyP(^D,6C'#
v }]\mi - }]\miPDI1_PTk2+T^XD;PBqD\m(^#KiITi4"`-M#f TM1 Ts,}g`,}]/",H"frMxL#KiP
DI1IT;A==i42+ThC,+;Jm^D2+ThC#
v 2+\mi - 2+\mi;\4P TM1 PD2+TYw#b|(4("`-M>} TM1 C'Mi#KiIT\md{C'T TM1 Ts(}g`,}]/",HM
fr)DCJ(^,+GKi;\i4G)y> TM1 TsPD}]#
b}v\mC'D2+TVd;?F`k"R;I^D#
zIT9Cb)$(eD\m1i4XFMVk;,C'D TM1 \mG+,TzcZ
?rb?2+ThsMfr#
":TM1 PD4FM,=Yw;\I\miDI14P#}]\mM2+\miI1;
Pc;CZ4PCYwyhDCJ(^#
TBZa)Kw\miDji#
\mi
\miGvkT\m?Dx4(D,&C;|,;!iEND TM1 \m1#
42 IBM Cognos TM1 V10.1.0: Yw8O
-
\miI1
-
b)^F@92+T\mI1;mS=d{DixqC2+\miI1;Jm5PD
}]CJMYw(^#
+2+\mik TM1 C API dO9CTM1 C API ;Jm`LK1*2+\midC2PDI1Jq#M'ziVd&\\
xNN{+2+\miI1E=d{iD"T#
mSC'=\miD^Fu~
;Jm+2+\miDI1+C'mS=\mi#;Pj{\miPDI1IT+d
{C'mS=\mi#b+@92+\miZ\miP4(_P+?\m(^DC'
J'#
}]\mi
}]\miPDI1_PTk2+T^XD;PBqD\m(^#KiPDC'IT
i4"`-M#f TM1 Ts(|(`,}]/",H"frMxL)#}]\mi\
T;A==i42+T==,+;Jm^DNN2+ThC#
}g,w*}]\miDI1,zITr* TM1 Ts(`,}]/",HMxL)D
“M'z/i”0ZrN;“2+Vd”0Z,;x,b)0ZvT;A==T>,Rz;
\xP|D#
C'iI1Jq
JmO"}]\miMNNd{C'iPDI1Jq#;x,KO"S*}]\m
i#C'iDCJ^FI;}]\mCJ(^2G#
}g,g{C'_P}]\miMC'iDm],xRC'i;Pi4`,}]/D
2+T(^,C'T;\(}}]\m (^i4`*}]/#
2+T\mM}]\miDI1Jq
;crZ+}]\miPDI1Jqk2+\miPDI1JqO"#
g{C',1tZ}]\miM2+\mi,G4CC'D2+T(^;G2+T\
m#,1_P2+T\mM}]\miI1m]DC'Jmi4M`-C'Mi2+
ThC#
4FM,=D^Fu~
}]\miDI1;PC4Z TM1 P4P4FM,=YwyhDyPCJ(^,rK
;&C"T4Pb)Yw#
2+TX~`,}]/frD^Fu~
}]\m^(Z2+TX~`,}]/O4(fr#C^Fu~@9}]/\m4(
IT^D2+TX~`,}]/o%*qDfr#
mSM>}C'Mi
zITZ TM1 Server OmSM>}C'Mi#
44 IBM Cognos TM1 V10.1.0: Yw8O
-
mSC'
*mSC',kjITB=h#
}L
1. r*~qw/@w#
2. !qz}Z9CD~qwD
-
>}C'
*mSC',kjITB=h#
}L
1. Z~qw/@wP,R|%w~qw M'z/i#
2. ZM'z/iT0rP,%w*>}DC'#
3. %wM'z > >}M'z#
4. %wG7O>}#
>}i
*>}i,kjITB=h#
}L
1. Z~qw/@wP,R|%w~qw M'z/i#
2. ZM'z/iT0rP,%wzmz*>}DiDG;PPD%*q#
3. %wi > >}i#
4. %wG7O>}#
+C'Vd=i
IT+C'Vd=i#
}L
1. Z~qw/@wP,R|%w~qw M'z/i#
2. ZM'z/iT0rP,%wC'{Mi{;f&D4!r#
3. %w7(#
`viPDI1Jq
,1tZ`viDC'_PyPiPn_6pD(^#
}g,Z>}}]P,Usr3 G=viDI1#
v 1@i,T Region ,HPD*X Canada"Mexico M United States _P4kCJ(^,T Region ,HPDd{*X_PA!CJ(^#
v O@i,T Region ,HPD*X Argentina"Brazil"Chile M Uruguay _P4kCJ(^,TRegionPDd{*X_PA!CJ(^#
TM1 a)T Region ,HPD Argentina"Brazil"Canada"Chile"Mexico"United States
M Uruguay *XD Usr3Write CJ(^,"a)TC,HPd{*XDA!CJ(^#
#$ TM1 }]r*zD+>9C TM1 xP_6f.MVv,yT TM1 }]GtPRz\D#
TM1 *za)#$}]yh*DyP$_,+GTZNN2+53,5JD2+;!v
Zz5)D}L#RG(iz5)TB}L4v? TM1 2+T:
46 IBM Cognos TM1 V10.1.0: Yw8O
-
^FT}]?
-
}L
1. Z~qw/@wP,R|%w~qw M'z/i#
2. ZM'z/iT0rP,!q“\k”PMC'{;f&D%*q#
3. %wM'z > e}\k#
TM1 a*sz7OGq75*e}\k#
4. %wG#
TM1 ae}\k,"Z%*qPT>54(e#
5. %w7(#
":e}\ks,C'ITZBNG
-
Z 7 B 53MT\`S
P;)U>D~"$_M5CLrICZ`S IBM Cognos TM1 Server D53T\#
TM1 53MT\`SDEvTM1 |,;i$_,CZTzi/PD TM1 Server xPU>M51T\`S#
zIT9CTB$_`S TM1 DT\Mn/#
v {"G<– Admin Server U>
|, TM1 Client"Admin Server Mwv TM1 Server .d(E{"DU>D~#
– BqU>
CZzYIG< TM1 Server DM'zxPD}]BqDU>D~#G
-
9C\m~qwU>
ZoO9C_PT(e$ir Microsoft Windows $ibP$iD TM1 2+WSVc
(SSL) yv=D,SJb1,,TM1 Admin Server U>G#PC#
KU>|,PXZ TM1 Client"TM1 Admin Server Mwv TM1 Server .d(ED
{"#
KU>PDs`}{"GZM'zM~qwDt/}LP4(D#TBB~"z1a
GGtTD~P9C,T+U>dC*X(6p#
N} hv
DEBUG j8D&CLrDxH"(f&CLrZD}#*;#
+U>dC*C6ps,+G< INFO M ERROR {"#
ERROR z&C"bDmsiv#&I!Yw4^4Jb,r_+CJb(fx
M''Vz9#
+U>dC*C6ps,+vG< ERROR {"#
dC Admin Server U>G<TM1 Admin Server U>G
-
log4j.logger.TM1=INFO
*INFO G{"6p#
v dvw?V
>}:
XFGdCG6pf; INFO:
log4j.rootLogger=DEBUG, R1
log4j.logger.TM1=DEBUG
":,OU>dC)U#9C,(#;h*xPw{#g{h*dCU>tTD~T
xPJOoO,k*5M''Vz90soz#
tC Admin Server U>,OivB,20 TM1 1atC TM1 Admin Server DU>G
-
20+ tm1admsrv-log.properties D~M TM1 Admin Server LrD~ tm1admsrv.exe E
C= TM1_install_dir\bin ?D~G ASCII D>D~,IT9CNND>`-w(}g Microsoft Windows G
B>)r*#
}L
1. + tm1admsrv.log D~ECZ TM1_install_dir\bin ?`-w(}g Microsoft Windows GB>)r*"i4U>D~#
U>D~PD?;Pyzm;u4TBq=EPD(;{":
_Lj6 {"6p UZM1d TM1 Si~{F {"D>
3948 INFO 2 0 0 7 - 0 1 - 1 9
19:10:22,128
TM1.Comm.SSL ,S=6Lzw
1vm
1260 DEBUG 2 0 0 7 - 0 1 - 1 9
19:14:04,396
TM1.Server Qu
-
U>D~GC:EVtD ASCII D~,gB}y>:
"19980602212741","19980602212741","Admin","N","380.","250.","salescube",
"Budget","Belgium","LSeries 1.6 L Sedan","Units","Jun",""
"19980602212744","19980602212744","Admin","N","430.","600.","salescube",
"Budget","Belgium","LSeries 1.6 L Sedan","Units","Sep",""
"19980602212749","19980602212749","Admin","N","610.","800.","salescube",
"Budget","Belgium","LSeries 1.6 L Sedan","Units","Oct",""
}]8]MV4}#XU~qw1,TM1 +(}ZU>D~sf=S1dA4X|{CD~,"9CT
B|{D~I7#z\
G5P}]BqDG”PM`,}]/{F;f&D%*q#
TM1 Z4!r|, X 1tCU>GG
-
i4BqU>ITi/BqU> (Tm1s.log) Ti410Z TM1 Server }]?G1, TM1 a+yPU>D~O"=;vzci/N}D_-D~P#}
g,g{i/qV~Nj
-
SBqU>V4G<
Zi/BqU>s,zIT9C“BqU>i/a{”T0rV4Bq#
1zV4Bq1,OLDVALUE PPD5+f; NEWVALUE PPD5#
}L
1. ;vT>*V4DG%vG
-
Z UNIX 53OKPrw* Microsoft Windows ~qKPD TM1Server#
g{zZ UNIX 53OKP TM1 Server r+dw* Microsoft Windows ~qKP,
G4Z"TXBt/~qw1,TM1 a!{T/V4,"+/f{"4k TM1 Server
{"U> tm1server.log P#K{"8>BqU>QF5#BmT>“TM1 Server {"”
U>P8>F5DBqD~D{">}M/f{"#
_Lj6 {"6p UZM1d TM1 Si~{F {"D>
4076 FATAL 2 0 0 7 - 1 0 - 3 0
18:20:10,203
TM1.Server msBqU>G
zV4|D#
g{!qq,~qw+LxKP,+GTB/f{",R9a4UTOyv+{"4k TM1
Server {"U>P#
!q7(TXU TM1 Server#
bv;F5DBqU>D~
*bvKJb,k+BqU>D~ tm1s.log S TM1 Server }]?GD$_#
56 IBM Cognos TM1 V10.1.0: Yw8O
-
":U>{"vT"DT>#
{"OXT6p
U>53+{"V`*`VOXT6p#
N} hv
DEBUG j8D}ZfPD SQL ,S”
INFO N}:“~qwQ
-
?v TM1 Server tTD~,"Z?Nt/~qw1liCD~#
t/.s,~qwaliTtTD~D|B,"y]h*w{GX~qwvZt/1EliU>tTD~ tm1s-log.properties#PXj8E
",kNDZ 533D:tCM{CBqG} TM1 }]b?tTD~#>} TM1 }]b
20ZTB;CP:
v Windows 53:TM1_install_dir\samples\tm1\TM1_sample_dirv UNIX 53:TM1_install_dir/samples/tm1/TM1_sample_dir
dP TM1_sample_dir G>} TM1 }]bD?}}]:TM1_install_dir\samples\tm1\PlanSamp
– >}}]:TM1_install_dir\samples\tm1\SData
TBGU>tTD~D>}:
Log4j.rootLogger=INFO, S1
Log4j.logger.TM1=INFO
# S1 is set to be a SharedMemoryAppender log4j.appender.S1=org.apache.log4j.
SharedmemoryAppender
#Specify the size of the shared memory segment log4j.appender.S1.MemorySize=5MB
#Specify the max filesize log4j.appender.S1.MaxFileSize=10MB
Specify the max backup index log4j.appender.S1.MaxBackupIndex=3
dCMtC~qw{"U>9CU>tTD~ tm1s-log.properties D1>,TdCMtCX( TM1 Server D{"
GG<
1 TM1 Server Z~qwdCD~ Tm1s.cfg yZD?tTD~1,a
tCU>G}U>tTD~ tm1s-log.properties D1>,TdCU>{"6pMdvhC,
gZ 593D:dCU>{"6p;MZ 593D:dCU>dv;Pyv#
2. +U>tTD~ tm1s-log.properties ECZ*`SD TM1 Server dCD~ Tm1s.cfg
yZD?
-
":TM1 >X~qwvZt/1EliU>tTD~ tm1s-log.properties#t/.s,
>X~qw;aliU>tTD~PD|D,rK>X~qwU>tTD~PDy
PhCX~qwDNbU>tT,rXkXBt/~
qwE\&CBDU>hC#
3. *Y1XUU>GtTD~PTB=vodw*j:
TM1 logger=Message level, Appender
dP:
v TM1 G
-
BmhvK?vN}#
N} hv
MemorySize 8(2mZfNDs!#CZfm4kU>D~.0+U>{""
M=D53Zfxr#
,O5* 5 MB#
9CTBq=:
log4j.appender.S1.MemorySize=s! %;
dP:
v Size(s!)Gm>Zfs!D}5#v %;ITG KB r MB#
}g,*+ MemorySize hC* 5 MB,kdkTB5:
log4j.appender.S1.MemorySize=5 MB
MaxFileSize 8(U>D~ID~s!D}5#v %;ITG KB"MB r GB#
}g,*+U>D~s!^F* 10 MB,kdkTBZ]:
log4j.appender.S1.MaxFileSize=10 MB
g{ MaxBackupIndex N}hC* 1 r|s,G4U>GD~o= MaxFileSize 1T/4(8]D~#8]D~D\}?
I MaxBackupIndex !n7(#
MaxBackupIndex ;v}5,8(#f`Y8]D~sEe}ngDU>D~#
,O5* 20#
v g{hC* 0 - ;#f8]U>D~,"2G10DU>D~RZd?No= MaxFileSize 1XB*
-
N} hv
TimeZone 8(U>D~P{"1dAD1d6'#9CTBq=:
log4j.appender.S1.TimeZone=Zone
dPIT+“6'”hC* GMT r1X1d#
v g{hC*“1X1d”,G4U>{"D1dA+yZKP TM1Server DzwD1X1d#
v g{hC* GMT,rU>{"D1dA+yZqV~Nj#
+r*“{"U>”0Z#
Bm(eK{"U>VN#
{"VN hv
_Lj6 zIU>G}:2488
{"6p (fD{"DOXT6p:DEBUG"INFO"WARN"ERROR r
FATAL#
UZM1d Gdv;#
(fDq=*:yyyy-mm-dd hh:mm.ss,milliseconds
>}:2006-10-02 16:49.01,925
TM1 G $(eDD>{",CZhvy(fDmsrn/#
Z 7 B 53MT\`S 61
-
3. g{U>PD{"T>K4PDxLr4FDms4v,zIT+wC{"Ti4
n/zzmsDj8-r#
Z{"U>PQwD>
zITZ{"U>PQwD>#
}L
1. @N%w`-"iRr4 Ctrl+F iO|#
+r* Find(iR)T0r#
2. dk*iRDD>,;s%wiRB;v#
g{R=KD>,|,%dD>DP+;vT>,"T>Z“{"U>”0ZP#
S{"U>4FD>
zITS{"U>4FD>#
}L
1. !q*4FDD>P#
2. @N!q`-"4Fr4 Ctrl+C iO|xP4F#
10!qDP;4F= Microsoft Windows tyeP,;sI3y=d{&CLr
P#
M'zU>
S V9.5.1 *
-
log4j.logger.ExcelReportPrintDPage=DEBUGlog4j.logger.CTM1Connector=DEBUGlog4j.logger.ExcelReportPrintIncludedSheetsPage=DEBUGlog4j.logger.CAutoExcel=DEBUGlog4j.logger.SubsetEditorIntLog=DEBUG#Perspectiveslog4j.logger.TM1Perspectives=DEBUGlog4j.logger.TM1AF=DEBUGlog4j.logger.TM1ExcelAPI=DEBUGlog4j.appender.R1=org.apache.log4j.RollingFileAppenderlog4j.appender.R1.File=c:\\ClientDebugLog.loglog4j.appender.R1.MaxFileSize=10 MBlog4j.appender.R1.MaxBackupIndex=50log4j.appender.R1.layout=org.apache.log4j.PatternLayoutlog4j.appender.R1.layout.ConversionPattern=%X{pid}%t %p %d{%Y-%m-%d %H:%M:%S,%Q} %c %m%nlog4j.appender.R1.layout.TimeZone=GMT
*r*M'zU>,kZM'zD53zwOD C:\Documents and Settings\
Administrator\Application Data\Applix\TM ;CP4(;v{* tm1p-
log.properties DD~# TM1p.ini Xk;Z`,D~PP#
k7#ZU>D~D log4j.appender.R1.File=c:\\ClientDebugLog.log ;PP2hC
KC;C#
g{+U>D~1SEZ c: }/wP,g>} log4j.appender.R1.File=c:\\
ClientLog.log Py>,
G4qX*9C41\ \\#
g{zk9C temp ?
-
1(Ir(f,g Sarbanes-Oxley,h*TNqX*m~PD3)n/xPsK1,C
U>ICZpN5w?D#
?v TM1 Server #\m1IT9C~qwDsKU>
Xpb)Jb:
v |DKDvTs?v gN^DCTs?v -wD|D?v N1wD|D?
zIT(}9C TM1 Server /@wPa)D“sKU>”0Z4i/Mi4sKU>#
":,OivB,sKU>;{C,zXk*k*`SD?(~qwV/tCC&
\#PXj8E",kNDZ 653D:dCsKU>;#
KbsKU>B~sKU>|,w* TM1 TsM536'n/D|DG
-
,HErB~DsKU>{"
1Z,HPxPErr|D*X3r1,sKU>PG”0Z+T>TB{":
,H“account”D SortElementsSense tThC*“DESCENDING”#
V/,HEr
9C,H`-wZV/==B`-,H3r1,sKU>vG”0Z+T>TB{":
,H“account”Q|B#
dCsKU>
,OivB,sKU>;{C#zXk9C TM1 Server dCD~ (Tm1s.cfg) PDs
KU>N}V/dCsKU>#
*tCX( TM1 Server DsKU>,kjITB=h#
}L
1. r*C~qwD Tm1s.cfg D~#
2. Z Tm1s.cfg D~PhCBPN}:
AuditLogOn=T
AuditLogUpdateInterval=60
3. XBt/~qw#
":|D AuditLogOn N}D5.s,XkXBt/ TM1 Server E\&CB5#
PX Tm1s.cfg D~MsKU>N}D|`j8E",kND IBM Cognos TM1
Installation and Configuration Guide#
Z 7 B 53MT\`S 65
-
|BsKU>nBB~
1tCsKU>1,TM1 aZs(KPU>GB~#
3. %wG7O|BxL#
VZ,sKU>|,KnBsKB~G0Z/@U>{"IT(} TM1 Server /@wPa)D“sKU>”0Z4CJsKU>DZ]#
(}sKU>0Zi/sKU>M/@i/lw=DsKU>B~{"#
sKU>0Z|,TB=vw*Dfe:
v “i/fe” - 9Ci/fe4(i/Ti/3vX(1dNrB~`MDsKU>#v “a{fe” - 9Ca{fei4M/@(}i/lw=DG0Z
ITr*“sKU>”0Z#
}L
1. Z“~qw/@w”P!q TM1 Server#
2. @N%w~qw"i4sKU>#
+r*“sKU>”0Z#
;s,IT!qyh*Di/N},"%wKPi/4% Tlwi/G”0ZD“i/”feP9CQwN}Iu!Qw6'#
}L
1. hCUZM1d!n#
!n|($(eD1d\Z(,ql),n| 10 l,30 l,60 lM 90 l#
g{z}Z0RX(B~dtDB~,G4S1dNB-r!qT(e1dN#d
k*
-
K!n+/JJb“-}pKB~?”#bITG5J TM1 C'rF.DSn#
v %w+?,TQwINNC'rNNF.DSn}pDB~#v %wM'z,TQw;IC'}pDB~#v %wF.DSn,TQw;IF.DSn}pDB~#
*!qX(C'rF.DSn,k%w`XVNT_D“!q”4% #
+r*!qM'zr!qSnT0r#
v t*!q%vC'rSn,%wCn?4I#v t*!q`Z6'ZD`vC'rSn{F,%wC6'PDZ;vn?,;s4! Shift |"%wC6'PDns;vn?4I#
v t*!q`v;`ZDC'rSn{F,4! Ctrl |"%wwvn?4I#3. hCB~`M!n#
9CK!n,T!qz*QwD7PB~`M#}g,“iR'\DG
-
}g:xr:bs{
4. %wKPi/4% #
i/lwa{T>Za{fexqP#
i4a{
a{fexq+i/sKU>G”M“sKU>j8E"”0Z9C4F&\#
}L
*4FB~}],k;vT>“a{”xqPD%v%*q,;s%w“a{”$_8OD
4F4% #
9CiR&\
“a{”fe|,“iR”$_,C4Qw“a{”xqPD8(D>#
68 IBM Cognos TM1 V10.1.0: Yw8O
-
}L
1. %w“a{”$_8PDiR #
“iR”T0rf4vV#
2. dk*iRDD>
3. %wiRB;v#
g{R=D>,+Za{xqP;vT>|,%dD>D%*q#
-
X~`,}]/{F hv
}StatsByCubeByClient zY~qwO?vM'zM`,}]/D%*q|B}?MDC
1d"%*qlw"S
-
":T\`Sw;a|BT43Z|KP14(DNNB`,}]/rmSDNN
BC'#XBt/T\`Sw,9CymSDn?|B|#
9C TM1 Top 5CLrTM1 Top 5CLr9z\;/,`SZ TM1 Server D5}PKPD_L#TM1 Top
9IT>PXX(~qwD3dMw5SPDE"#
K5CLr`FZ UNIX“top”5CLr,s_Jm/,`SZx(53OKPDxL#
TM1 Top G%z5CLr,Z Microsoft Windows 53ODXF((|n)0ZZK
P#|hF*+T TM1 Server M'Vxgk53D*s5An!#
}C't/DGD TM1 P+T"oT
>#
Z TM1 Top PT>C'{MaskUserNameInServerTools N}7(Z TM1Top XF(T>wPT>9GZZC'{#
Z Tm1s.cfg PhC MaskUserNameInServerTools=TRUE s,vZ2+?D,ZTM1 Top
PaZZC'{#*!{ZZ{F,\m1IT9C V(i$)|nT\m1m]GC'{#
dC Tm1top.ini D~ZKP TM1 Top .0,IT`-u
-
exportadminsvrsslcert=
adminsvrsslexportkeyid=
g{dC TM1 T9C SSL xP2+T}]+d,G4XkZ Tm1top.ini D~PdC
SSL N}#PX+ TM1 Top dC*9C SSL Dj8E",kNDZ 713D:dC
Tm1top.ini D~;#
`- Tm1top.ini D~1,kpZN}{MN}5.d|,NNUq#
BmhvK Tm1top.ini D~PDN}#
N} hv
AdminHost KP Admin Server DFczDzw{Fr IP X7#,O5*
localhost#
LogFile 8(+U>E"4kD76MD~#fE TM1 Top KP,IT+4,
P,x4kK ASCII D~,SxI`SVxDn/#
q=*:logfile=path-to-log-file
dP,path-to-log-file Xk8(j{D76"D~{MD~)9{#;a
),ODD~{MD~)9{#
LogPeriod 8(+4kU>D~D|B.dD1ddt#C5&C* Refresh 1d
N}D6}#
KN}Dq=*:logperiod=nn
dP,nn GU>D~|B.d{DDk}#+dhC*ca{CU>#
}g,g{+A;"BdthC* 2 k,rI+ LogPeriod hC* 10
k,Sx9A;?T>eNcdv;NTuY4kD~D}]?#
,O5* 2 k#
LogAppend 8(Gq+U>}]=S=9C LogFile N}hCDU>D~,r_G
qZt/Ba012GCD~#g{4hC LogAppend N},G4VP
DU>D~+;2G#
P'5* T M F,gB}y>:
g{hC LogAppend=T,G4U>}]+=S=I LogFile N}8(D
U>D~#
g{hC* LogAppend=F,G4VPDU>D~+;2G#
,O5* F,2GVPU>D~#
72 IBM Cognos TM1 V10.1.0: Yw8O
-
N} hv
"B "B TM1 Top T>D1ddt#q=*:
refresh=nn
dP nn GTk*%;D1ddt#
,O5* 2 k#
ServerName TM1 Server {F#bG~qwdCD~ Tm1s.cfg PD ServerName#
":z2ITZt/ TM1 Top 1Z|na>{&dkb)5,b+2G Tm1top.ini D
~PD5#PXj8E",kND:9C|nP!nKP TM1 Top;#
KP TM1 Top*KP TM1 Top,k`- Tm1top.ini D~ThC*9CDN},;sKP .exe |n#
}L
1. y]“Z 713D:dC Tm1top.ini D~;”PDhv,`-u
-
v -logappend T r F
}g,*Z ServerName N}hC* sdata R refresh N}hC* 5 kDivBKP
TM1 Top,kdkTB|n:
tm1top.exe -servername sdata -refresh 5
":TZ|,UqDN}5&9C}E,gBy>:
tm1top.exe -servername "planning sample"
*T>ICN}DPm,k9C /? !n,gBy>:
tm1top.exe /?
PX TM1 Top N}D|`j8E",kNDZ 713D:dC Tm1top.ini D~;#
i4MKb TM1 Top T>Z TM1 Top KP1,aT>;iVNM4,E"#
T>D?;P}Z`SD TM1 Server PKPD;v(;_L#XF(0ZDj
b8T> AdminHost"ServerName M Refresh N}D105#
":*i4|`Pr|mDT>,ITw{XF(0Zs!r_9CO!DVes
!#g{T>Z]dzK{vXF(0Z,IT9C|LODOB=r|xkXF(
0ZPDB;3r0;3#
TM1 Top I(}ZLrKP14`X|4ICBP;,T>==KP:
v }# (n)v 3d (s)v SP (q)
}#T>==
Z}#T>==B,4,VNI TM1 Top T>#
VN{ hv
j6 TM1 Server PWc53_LD_Lj6#
C'{ t/_LDC'rxLD{F#|ITGTB}V_L`M.;#
v C'_L - GC'{;
v Sn_L - TM1 Server OKPDSn#Sn_LD{F4TBq=T>:
C:Sn{F
74 IBM Cognos TM1 V10.1.0: Yw8O
-
VN{ hv
C'{(x)SnBKPDxL{FT>Z Function(/})VNP#
v 53_L - TM1 Server OKPD TM1 53xL#T>Dq=*:
Th:53_LD{F
v Th:Pseudo - Pseudo _LCZemC'(eDO" (UDC) Ts#v Th:Stats - Stats _LzmC'Z TM1 Architect M“~qw/@w”P!q“t/T\`Sw”!n1t/DT\`S&\D_L#
v Th:DynamicConf - K_L/,A!M|B TM1 Server dCD~ tm1s.cfgPDN}#
4, X(_LD10&m4,#C5ITGTBw5.;:
v UPv KPv a;v Xvv H}v G<
PX|`E",kNDZ 773D:Kb TM1 _L&m4,;#
/} _L10}Z4PD API /}#
g{_L}ZKPSn,k;%=C'D/}`4,“/}”VN+T>
SnB104PDxL{F#
Tsx(4, ONx(DTsDx(4,#
T>Dq=*:R# IX# W#
dP:
v R"IX M W zmTsD;,x(==#PX|`E",kNDZ 763D:Kb TM1 x(==;#
v # G?VX(x(==BDx(}?#
"::TsD{FT>Z“4,”VNP#
C'x(4, ;v_L9CDyPTsD\x(4,MF}#
T>Dq=*:R# IX# W#
dP:
v R"IX M W zmTsD;,x(==#PX|`E",kNDZ 763D:Kb TM1 x(==;#
v # G?VX(x(==ByPTsD\x(}?#
1d 10 API /}rSnxLQ&mD\1d(Tk*%;)#
API /}rSnxLD{FT>Z“/}”VNP#
Z 7 B 53MT\`S 75
-
3dT>==
IT+ TM1 Top P;=3d==#
Z TM1 Top KP14B s |aP;=3d==#4B n a5X=}# TM1 Top T>#
}K“j6”M“C'{”VNTb,TBVNZ3d==Pd*IC:
VN hv
n/3d 10n/3dD{F#
\3dZf C'*yP3dDCD“\3dZf”#
3d} KC'D3d}#
SPT>==
IT+ TM1 Top P;=SP==#
Z TM1 Top KP14B q |aP;=SP==#4B n a5X=}# TM1 Top T>#
}K“j6”M“C'{”VNTb,BPVNZSP==P+dCIC:
VN hv
{F SPP3dD{F#
Zc{ SPP3dDZc{#
4, q!SPP3dD4,1DUZ"1dM4,#
SPPD1d Z&m3d.0,|fZZSPPD1d$H#
Kb TM1 x(==TM1 9C;ix(==(2}V==)4XFT TM1 }]DCJ#
1 TM1 Server }ZKP1,a+b)x(&CZ;CJDwvTs,}g`,}]/"
S}Z TM1 Server PKPD10_Ly9CDTsDb)x(4,#
TM1 Top +x(4,T>Z“4,”"“Tsx(4,”M“\x(4,”VNBf#
BmhvK TM1 TsDx(==#
x(== hv
R R x((A!x()- 2mx(,JmtI_L,1S;vTsA!Z],+G;Jmm;v_L^Dr4kCTs,1= R x(;ME#
76 IBM Cognos TM1 V10.1.0: Yw8O
-
x(== hv
IX IX x((4k?Dx()- 1yP R x(?v_LD10&m4,#
_LITGTB&m4,.;#
4, hv
UP _L104&m#
KP mw_L}ZKP#,14TBq=T>x(==M_LCJDTs:
KP:x(==-(Ts{F)-Ts`M
dP:
v x(==G;VI\DTsx(==;R"IX r W#PX|`E",kNDZ 763D:Kb TM1 x(==;#
v “Ts{F”G“/}”VNPT>D API /}&mDns;v TM1 TsD{F#
v “Ts`M”G;vzm TM1 Ts`MD}5#
a; _L10}ZTdyCJDTsa;|D#
Xv 8>_LZa;1v=e;R^(Lx#_L+T/XB"T,1=e;
;bv#
Z 7 B 53MT\`S 77
-
4, hv
H} _L10}ZH}jIX(Div#T>Dq=*:
H}:“H}”4, - (Ts{F) - Ts`M
dP:
v “H}4,”ITGTBiv.;:– WR - (WaitForWriterEvent) _L}ZH}ME R x(,SxITqCTsD W x(#
– IXR - (WaitForIXReaderEvent) _L}ZH} W x(jI,SxITqCTsD R x(r IX x(#
– IXC - (WaitForIXConflictEvent) _L}Zks IX x(,+Gh*H}m;v_P,;TsD IX x(D_LjI"MECx(#
– IXCur - (WaitForIXCurrentEvent) _L}ZksTsD IX x(,+Gh*H}_P,;TsD R x(D_LMEdx(#
– WC - (WaitForCompletionEvent) _L}ZH}m;v_LjI"MEdx(#
– DRR -(ME}]#t)_L}ZH}ME}]#t#
v Ts{FG“/}”VNPT>D API /}&mDns;v TM1 TsD{F#
v Ts`MG;vzm TM1 Ts`MD}5#
G< C'10}ZG{4k5CLrxP;%#
ITZIsOGD Cmd:_ j6D TM1 Top |na>{&dkTB|n:
|n hv
N T> TM1 Top }#(_L4,)==#
S T> TM1 Top 3d==#
Q T> TM1 Top SP==#
W +10 TM1 Top E"4AD~#
X Kv TM1 Top 5CLr#
H T>ozD>#
V i$ TM1 Top \m1a0#
T>C'{M\ka>,Tc TM1 \m1IG
-
|n hv
K !{w5SPPT&X(w5j6`ED3da;#
h*\m19C V(i$)|nxPG
-
Admin User Name:
2. dk\m1C'DGTBa>:
Verify Admin Access
Admin Password:
3. dk\m1C'D\k#
g{dkD\m1C'{M\kP',r+T>TB7OE":
Admin access verified
Press any key to continue:
4. i$Ca0s,dk C t/“!{”xL#
+T>TBa>:
Cancel processing of a thread
Thread-id:
5. dk*!{D_LDj6#ITZ TM1 Top T>DZ;PPiR_Lj6#
9C TM1 T\F}wTM1 T\F}wG,x|BD5D/O,Ia)T TM1 Server T\D51`S#
b)5I51vsMu!,TzYX( TM1 tTM`,}]/"ST>,Z Microsoft WindowsM UNIX 53ODXF(0ZPKP#TM1 PerfMon 5CLr;\`S>X TM1
Server#
v Microsoft Windows T\`Sw - ;V Microsoft Windows $_,a) TM1 T\F}wD;%=,T`S>XM6L Windows TM1 Server#
PXKP TM1 T\F}w$_DX*"bBn*Z Microsoft Windows 53OKP TM1 PerfMon,zh*_PkKP Microsoft Win-
dows T\`Sw`,D\m1(^#
v C'XkG>X\m1iDI1E\KP TM1 PerfMon r Microsoft Windows T\`Sw#
v C'Xk,1G>XM6L53OD\m1iDI1,E\9C Microsoft WindowsT\`Sw4`S6L TM1 Server#
64 ; Intel Itanium II 53;'V9C Microsoft Windows T\`Sw4i4 TM1 T
\F}w#9CKdCKP TM1 1,k9C TM1PerfMon XF(5CLr4i4 TM1
T\F}w#
ICD TM1 T\F}wTM1 a) 30 `VT\F}wD/O,iItIi,}g“`,}]/”"“,H”"“S
/”"“Zf”"“_L”M“S
-
TM1 T\F}wD>}|(:
v 4(D_Lv 4(MF5DS}DS/v A!x(ksMH}
":*i4IC TM1 T\F}wDQ|Bj{PmT0hv,k9C“Microsoft Win-
dows T\`Sw”,gZ 833D:Z Microsoft Windows T\`SwPmSMi4 TM1
T\F}w;Pyv#
9C TM1 PerfMon 5CLri4 TM1 T\F}wTM1 PerfMon GCZ Microsoft Windows M UNIX 53DXF(5CLr,Ia)
TM1 T\F}wDD>T>#
KP TM1PerfMonS Microsoft Windows r UNIX 53D|nPPKP tm1perfmon.exe D~#
9CTBq=MN}:
tm1perfmon -servername Name -loop LoopCount -sleep SleepTime
dP:
v Name G*`SD TM1 Server D{F#1~qw{F|,Uq1,k9C}E#}g:
-servername "planning sample"
v LoopCount GX4r"BF}w5T>DN}#,O5* 1,;-7#C5GI!D#
5* 0 a{#
v SleepTime G-7.dD1d(Tk*%;)#,O5* 5 k#C5GI!D#
}g,TB|nP+VxKP TM1 PerfMon,T`S{F* planning sample D TM1
Server#T>Z]+#V? 5 k(9C sleep !nD,O5)"B;N,1=z4
Ctrl+Break iO|Kv#
tm1perfmon -servername "planning sample" -loop 0
TB|nP+KP TM1 PerfMon T`S salesdata TM1 Server,2-7 10 N,|B
T>.dD"BJ* 5 k#
tm1perfmon -servername salesdata -loop 10 -sleep 5
":g{;|( loop M sleep !nD5,gTB>}Py>,G4 TM1 PerfMon +
;KP"T> TM1 T\F}w;N#
tm1perfmon -servername salesdata
Z 7 B 53MT\`S 81
-
i4 TM1 PerfMon T>dvITi4 TM1 PerfMon DT>dv#
CT>dv4p4`FZTBZ]:
C:\>tm1perfmon -server cdata
TM1 Version: 9.0.3.226
Output data and time Tue Dec 05 17:36:42 2006
Counter Name/ Value
Threads: Threads created 6
Threads: Threads Creation Retry Attemtps 0
Threads: Thread Creations Failures 0
Views: Views Created 23
Views: Empty Views Created 0
Views: Views Destroyed 0
Dimensions: Dimensions Created 0
Dimensions: Dimensions Destroyed 119
Cubes: Cubes Invalidated 0
Cubes: Dependent Cubes Invalidated 1
Subsets: Subset Create Empty 0
Subsets: Subset Calculated by Expression 0
Subsest: Subset Calculated with Empty Expression 0
Subsets: Subset Calculated by Expression 0
Subsets: Subset Created by Expression 0
Subsets: Subset Created by MDX Expression 0
Subsets: Subset Duplicated 0
Subsets: Subsets destroyed 0
Subsets: Subsets Deleted 0
KT>PDjbVN|(:
VN hv
F}w{F ?v TM1 T\F}wDi{FMF}w{F#
T>Dq=*:GroupName:CounterName
}g:Threads:Threads Created
5 TM1 T\F}wZX(dvUZM1dD}5#
Kv TM1 PerfMonITZ TM1 PerfMon T4P-71KvC5CLr#
}L
f14 Ctrl+Break |#
82 IBM Cognos TM1 V10.1.0: Yw8O
-
9C Microsoft Windows T\`Swi4 TM1 T\F}wIT9C Microsoft Windows T\`Sw,TvJCZ Windows TM1 Server D==4i4 TM1 T\F}w#
Microsoft Windows T\`Swf10f>D Microsoft Windows a),"w* Microsoft
\mXF(DSXnKP#
r* Microsoft Windows T\`SwITr* Microsoft Windows T\`Sw#
}L
@N%w*“mSF}w”T0r#
": r*rXU“mSF}w”T0r1,Microsoft Windows P1aT>TB{"#
“AYP;v}]>}*'#}]U/y9C1d$Z$Z#zIT(}vS>}
1ddt4\bK{"#ZKa0ZdK{"+;YT>#”
K{"v)N#%w7(T
e}C{"#
2. S“T\Ts”PmP!q IBM Cognos TM1#
ICDT\F}wT>ZT\F}wPmP#
3. SICDF}wPmP!q;vT\F}w#
9IT%w“5w”4i410y!F}wDD>hv#
4. !q*`SD~qwD5}#
5. %wmS+y!F}wmS=T\T>P#
6. %wXUTXU Add Counters(mSF}w)T0r"5XT\`Sw#
“T\`Sw”a+ TM1 T\F}wmSA`SxL"|BT>,gB#
Z 7 B 53MT\`S 83
-
6qKD*"TxP TM1 Server @#Vvz#{7#Z TM1 Server @#1yPh*DZ]
-
2. r*|na>{0Z,"KP cd |nP;= Debugging Tools for Windows ?{0Z#Microsoft Console Debug-
ger (cdb.exe) +ZK0ZPKP,gB#
`S TM1 Server:
g{z}Z`X~qw,G4;hLx4PU#n/#
1~qw@#1,aZ Crash_Mode_DateStamp_TimeStamp S?
-
IT?F~qw@##
Z cdb.exe |na>{0ZPdk Ctrl-C#
qCD*"D~ (.dmp) D{F+|( ...1st_chance_CONTROL_C_OR Debug_Break...
V{.# bG IBM wT TM1 Server 1h*DD~#
q!10~qw4,DlU:
ITq!10~qw4,DlU,",1C TM1 Server #VKP:
}L
1. t/ TM1 Server#
2. r* Windows Nq\mw,"GB Tm1s.exe(g{+ TM1 Server w*&CLr
KP)r Tm1sd.exe(g{+ TM1 Server w*~qKP)DxLj6 (PID)#
3. r*|na>{0Z,"KP cd |nP;= Debugging Tools for Windows ?{&,dk adplus –hang –p #
}g,adplus –hang –p 492
":49 adplus Q-ZT -crash ==KP,2ITKP -hang |n#
avV;u/f{",8v4hC73d?#z;Xy]K/fx4PNNYw#
5. %w7(TvTK/f#
avVm;u{",8v ADPlus }ZT HANG ==KP#K{"98v+Z
Debugging Tools for Windows ?
-
C:\Program Files\Debugging Tools for Windows (x86)\remote.exe /s "cmd.exe"
remoteshell
3. S|na>{&dkTBP:
101d.s 2 VS,IC 24 !1F C:\Program Files\Debugging Tools for Win-
dows (x86)\remoteshell.cmd
}g,g{531ST>* 4:45 PM,G4Z|na>{&dkTBP:
at 16:47 C:\Program Files\Debugging Tools for Windows (x86)\
remoteshell.cmd
K|n+ZBg 4:47 KP remoteshell.cmd z&mD~
4. -}y8(D1d.s,Z|na>{&KP at |n#k;*TK|nmSNNN
},vdk at#
g{I&KPK remoteshell.cmd z&mD~,G4z&14=;](f,(fP
PvK4,"UZ"1dM|nPPm,}g,“c:\Program Files\Debugging Tools for
Windows\remoteshell.cmd”#
PX at |nD|`j8E",kND http://technet2.microsoft.com/windowsserver/
en/library/40b9beb1-3578-48f9-93e1-7ca6760c1c151033.mspx#
5. r* Windows Nq\mw,"GB Tm1s.exe(g{+ TM1 Server w*&CLr
KP)r Tm1sd.exe(g{+ TM1 Server w*~qKP)DxLj6 (PID)#S
TM1 Client KP ADPlus 1,zh**@ PID#
S TM1 Client KP ADPlus:
ITS20K TM1 Client DFczPKP ADPlus#
}L
1. S TM1 Server FczODwT$_20?
-
6. S|na>{&,KP cd |nP;= TM1 Server FczODwT$_20?
-
}L
1. S Windows Nq8P,%w* (Tm1s.log),qrk;*U/KU>#
+D~+dA Cognos;)U/KyPXhDD~,MXk+b)D~"Mx Cognos 'Vz9xPVv#
IT!q`V==4"MD~#
Z 7 B 53MT\`S 89
-
*+D~"Mx IBM,nlD=(G+|GOX= IBM FTP ~qwO#ITS|na
>{&CJ IBM FTP ~qw,2ITS Web /@wPCJ#
S|na>{&OX
ITS|na>{&+D~OX= IBM FTP ~qw#
}L
1. (}4P cd |nP;=zk*OXDD~yZD?{&,dk ftp testcase.boulder.ibm.com#
3. 153a>zdkC'{1,kdk anonymous#
4. 153a>zdk\k1,kdkzDgSJ~X7#
Qd{G
-
Z 8 B Cognos TM1 $_M5CLr
+BP$_M5CLrk IBM Cognos TM1 dO9C#
m 2. IBM Cognos TM1 $_M5CLr
$_ hv
TM1Top CZ`S TM1 Server n/D|nP$_#kNDZ 713D:9C TM1
Top 5CLr;#
TM1 Opera t ions
Console
_PmS&\T0
-
m 3. tm1xfer N} (x)
N} hv
-? T>rLozT0r,dP|(9Co(Mf>E#
;PN} T>rLozT0r(k -? `,).
9C tm1xfer 9u?<*+ IBM Cognos TM1 }]bD~9u,kZsS|, Cognos TM1 }]bD~D
?
-
C:\Users\obaluch\Documents\dbfile>dir
Volume in drive C has no label.Volume Serial Number 4C9A-1CE1
Directory of C:\Users\obaluch\Documents\dbfile
05/11/2011 05:54 PM .05/11/2011 05:54 PM ..05/11/2011 06:11 PM sales_planning05/11/2011 06:24 PM 43,611,174 sales_planning.zip
1 Files(s) 43,611,174 bytes(s)3 Dir(s) 91,038,346,202 bytes free
tm1xfer $_+6pv sales_planning G_P}]bD~D?
-
"v|n
bash-3.2$ lsaix64 tests sales_planning.zip
bash-3.2$ tm1xfer sales_planning.zip
.s:
bash-3.2$ lsaix64 tests sales_planning sales_planning.zip
tm1xfer $_a6pv sales_planning.zip G9uD~,;sLx+}]bD~b9u"
^DD~{MD~,T&mlOs!4DTsM Unicode `k#bGZ10=(Mxr
hCOjID#
tm1xfer 5wZ9C tm1xfer 1,kG!TBd{Bn#
tm1xfer $_+;Z}]bD~PPDs`}D~9uMb9u,+TB`M}b:-<
LjM,Hnl#
*c:g{fZ-B~...”CZC Cognos TM1 Server
D|n#
9C} tm1xfer $_bDm;v&CLr4(D58b#
tm1xfer $_ICZ+}]bD~r|,"+}]bD~Z,`=(OKPD=v Cognos
TM1 Server .dF/,}g,S Windows FA Windows#ZK}P,D~T tm1xfer
q=9u,;sTWindows T010xrb9u#kqXG!,tm1xfer a}Kt;)
D~`M#b)|(-
-
tm1s.cfg PD~qw{F
Z+}]b+dAm;vwzs,g{ Cognos TM1 Server D{F;,((#avV
Kiv),G4XkZ tm1s.cfg D~PV/|D~qw{F#tm1xfer ;aT/xPK
|D#
$w>PD~qw{F
T(e&CLr(#|,m`$w>,b)$w>|,T Cognos TM1 Server {FD
}C#1Zl9=((Windows = UNIX r`4).d+d Cognos TM1 }]bs,
Xk|DK{F,K{FZ,;=(OD~qw.dF/1a-#|D#TZ|D$
w>PD~qw{F,tm1xfer ;a)NNoz#
tm1xfer Dms{"BmPvKzZ9C tm1xfer 1I\av=Dms{"#
m 4. tm1xfer Dms{"
{" hv 9Hk)
zD Java 20f>;'VKx
rhC
KLr;'VD~53`k# |BzD Java 20f>,T9
d'VD~53`k
;fZ Z|nPN}Pa)DD~r
? Zbvy>?
tm1xfer ;PT}]b? tm1xfer +li1'DD~;+
G, J a v a h*
FileNotFoundException U>{
"#
9C{"PDX(E"47(
JbD44#
: ;GP'D58b fZ+]DN},+;G
tm1xfer 4(DP'58b
7#|nPPDD~{}7#
Z 8 B Cognos TM1 $_M5CLr 95
-
m 4. tm1xfer Dms{" (x)
{" hv 9Hk)
A! zip D~vm: A!KD~1vVJb# 7# tm1xfer _PTCD~D
A!(^#
ZA!&CLru?,H1v
m
A!}]bPD
}ApplicationEntries.dim 1v
m#
g{^(9C Cognos TM1 r
* }ApplicationEntries.dim,
G4D~I\Qp5#g{D
~4p5,G47#D~(^
T tm1xfer xhACJ(^#
tm1xfer C>5wWN9C tm1xfer 1,b)5wI\aPoz#
v Z Microsoft Windows O,K|nZ CMD.EXE(rf]D|n&mw)P4P#ZUNIX P,9CNNOJD shell(}g,C shell r Bash)#
v j< Cognos TM1 20f>;+ Cognos TM1 Server bin ?
-
~4F=?j=(,G4&ZICZ|, Data D~P1>T0d{yP}+dD~
D3&4(Y1D~P#;s,I9C tm1xfer +CY1D~Pr|#
v =vdMDC}ivG:(a) + Cognos TM1 }]b(T0&CLr}])FAd{~qw (b) +Z;v=((}g Windows)O*"D Cognos TM1 }]b?p=d
{=((}g Linux r AiX)#Ziv (a) P,zI\*(F .log D~"tm1s.cfg
HyPD~;Ziv (b) P,zI\v*4F Data D~P#Ziv (a) P,zI\
h*|D tm1s.cfg(}g,Z?jFczO,L{r76+Pyd/)#Ziv (b)
P,IZ76C'T7({GGq&Lx#
odbc_test $_odbc_test $_CZoOMbT UNIX OD IBM Cognos TM1 ODBC ,S#
ICk Cognos TM1 Server 9CKzkj+`,D==49C odbc_test bT ODBC
CJzk#dP;vxL*XG Cognos TM1 Server dCD~?
-
user_passwd:
sql_query:
sql_query:+O"PMyPsxPTxP SQL i/#
98 IBM Cognos TM1 V10.1.0: Yw8O
-
Z 9 B 9C Cognos TM1 Operations Console
Z20MdCs,S Web /@wKP Cognos TM1 Operations Console#
WN9C1,zh*hC;)i/a9Tj6\`SD~qw#
T>C'{
MaskUserNameInServerTools N}7(Z Cognos TM1 Operations Console T>wPG
T>9GZZC'{#
Z Tm1s.cfg PhC MaskUserNameInServerTools=TRUE s,vZ2+?D,Z Cognos
TM1 Operations Console PaZZC'{#*!{ZZ{F,\m1ITZ Cognos TM1
Operations Console PR|%w~qw,;s%wO$Ti$\m14,#
,OivB,CN}hC* FALSE#g{4TT===+KN}hC* TRUE,G44
9ZP4i$\m1CJ(^1,Cognos TM1 Operations Console 2aT>C'{#
4( Operation Group TxP`S;PH**`SD~qw(e_-is,EIT9C TM1 Operations Console `S
Cognos TM1 Server#
}g,zI\P8(*“*"”"“zI”r“bT”D~qwi#
*mSBYwi:
1. S$_8%wYwi D~!n4hF~qwD`S==#
r TM1 Operations Console mS\mwzM Cognos TM1 Server {F*r TM1 Operations Console j6 Cognos TM1 Server,k+dmSA}]b5}#
XZKNq
ZmS}]b5}.s,ITj6\mwz#
}L
1. Z}]b5}O%wsjR|,;s!qmS\mwz
2. dk\mwzDj
-
3. %w7(
a{
j6K\mwz#\mwzvVZwP1,IT!qC\mwz"%wR|TmS}
ZCwzOKPDz*`SD Cognos TM1 Server D{F#
hCU>D~M~qw}VN}
9C“dC”!n4hC}VN},b)N}(eU>D~}V0d{~qwN}DU
/==#
T?vU>D~n4TBN}#
U>\Z
8(+4kU>D~D|B.dD1ddt#
}g,g{+A;"BdthC* 2 k,rI+ LogPeriod hC* 10 k,S
x9A;?T>eNcdv;NTuY4kD~D}]?# ,O5* 2 k#
U>7S
,OivB,53;a7SBU>D~,xGCBU>D~2GVPU>#!
q True T+BU>D~7SAVPU>#
"B\Z
,OivB,U>H} 2 kE\"B}]#IZK&dk|$r|LD"B1
d(TkF)#
]trS
,OivB,}]GBD (0)#*JmU>PD}]#tB4,kZK&dk}
V(TkF)4m>}]I#t`CEh*BDV/#
,1 ,OivB,"T,SA~qwDYw+Z 2 ksU9#I|DK}?TuL
rS$Ez.0U>#V"TD1d#
g{ TM1 Operations Console ~qw4\ZK&8(Dk}ZqC“updated”4
,,G4+"MI}](g{fZ)"8>"zK,1#
BXrOXdCD~
*|D tm1operationsconsole.xml D~,I9C“OX”!nM“BX”!n#
9CdCD~nd“Cognos TM1 73”0qs,I9C“OX”!nM“BX”!n4|D
dC#9IT9CTB|n4|(dCD~D>}}]#
!qOX 1,I/@AdCD~D;C"%w7(#
!qBX Ti4 XML D~N=DdCD~,IZ>XzwO#fCD~#
100 IBM Cognos TM1 V10.1.0: Yw8O
-
9C`S!nKP/,(f
Cognos TM1 Operations Console OD“`S”!n+r*/,"BD~qwn/DT>
Z],I9C“}Kw”hC4TCT>Z]x;=[9#
“`S”!n+y]z!qDU>D~N}/,T>;c4,"3dr3dSPE"#
9IO"b)0ZT,1`S;,V`Dn/#9C“}K”T0r+T>Z][9Z
X(V`Dn/,}g,v&ZKP4,DxL#
T>;)xLs,IR|%w;vxLT!qU9xL4U9CxL#
*4X(PTT>Z]Er,k%wPjb,b+T>}7#rO}78>4CPj
bEr;rB}78>,OEr#
KP4vli+a)~qw4,D418>#
4,
,OivB,“4,”!nT>yP4,"P>“j6”"“C'”"“4,”"“/}
”"“Tsx(4,”"“C'x(4,”M“1d”#
TZ“_L”,I`S“}Z9CD_L}”"“SPnH”"“=ySP1d”"“v
Sd/?”"“SP1dd/?”M“API wCd/?”#
3d ,OivB,“3d”P>“j6”"“C'”"“n/3d”"“3d\Zf”M“3d
}”#
3dSP
,OivB,“3dSP”P>“j6”"“{F”"“C'”"“Zc{”"“4,”M“
SPPD1d”#
KP4vli8>{
KP4vli8>{Ia)8u41D~qw4,4!#
TBPmPvKICD8>{:
*z
~qw*z#
~qw}ZKP#
t/
~qw}Zt/#
z?SX#=
~qw&Zz?SX#=#
&5
~qw}
Z 9 B 9C Cognos TM1 Operations Console 101
-
~qwI\}Zt/"#9r&Zz?SX#=,r_4S~qwSU=NN
l
Qz ~qwQz/^(*5#
K~qw4KPrQ^(,S= Cognos TM1 Operations Console#
#9
~qw}Z#9#
~qw;\'V#
KP4vliTKPMZ 10.1.0 "PfD Cognos TM1 f>D~qw;IC#
KP4vli9aT>~qwPD_L}MH}Zhx(D_L}#
IZKP4v4,? 10 k|B;N,rKE"43DGn$ 10 kZ(b!vZTO
N"BT4~qw4,|DD1d)D10E"#
g{(f|,"BJ,G4+4*C(f8(D"BJ|B}]#
hC}Kw
“}Kw”T0rJmz+9cEZ“4,”A;PT>Dn/D`MO#
Iy]X(_LrX(4,4}KT>,TlYj6n/#
,OivB,yP4,+T>Z4,A;P#!qBPdP;vr`v!nT+9c
EZT>D4,O:UP"KP"d5"Xv"H}"GD~
I(eU>D~DKP1dm#
*2EBDU>D~B~,kZ“Cognos TM1 73”0qPR|%w~qw"!qU>
wHLr#
,OivB,U>hC*{CU>#T/U>+Z`Sw0Zr*D1dNZ*"z
DNNn/zIU>D~#
*lir4(T(eU>1dm,k%w$(U>"9CU>1dmDt/1dM#
91dDj8E"n4T0r#
U>`M
!q4,"3dr3dSP
102 IBM Cognos TM1 V10.1.0: Yw8O
-
VpG<
,OivB,4,"3dM3d4,D?vU>GVp,$D#!q false T+
yPb)U>iOI;v+2D~#
PG:“VpG!na)C`MDU>D~#“VpG
D~#
U>Vx1d
%w“*U>KP1dDN}#
2EU>B~s,I9CKT0r4`-r>}CU>B~#
BXU>D~
“BX”!nzI`F TM1Top dvDU>D~DDVf#
!q*BXDU>D`M:4,"3dr3dSP#
i4U>D~
“i4U>”!na)U>D9u2,lU#
!q*i4DU>D`M:4,"3dr3dSP#
Z 9 B 9C Cognos TM1 Operations Console 103
-
104 IBM Cognos TM1 V10.1.0: Yw8O
-
Z 10 B \m IBMCognos TM1 Web
ITdC IBM Cognos TM1 T(} Web xP$w#
IBM Cognos TM1 Web EvIBM Cognos TM1 Web (}JmzZ Web /@wPjITBNq,)9K TM1 D
Vv&\:
v Vv`,}]/}]v &mq=/D Excel (fv j!"8S"!qM}K}]v 9(
-
g{zGNNd{C'iDI1,G4“\m”ZcaT>“|D\k”!n#“xL”M“
Sn”!nI\2IC,b!vZzT~qwODxLMSny_PD2+T(^#g
{zT~qwODNNxLy_P Read (^,G4“xL”!nIC#,y,g{zT
~qwODNNSny_P Read (^,G4“Sn”!nIC#
}L
1. T TM1 \m1m]G}xLtT:
}LN} `M
PVersion FY 2003 Budget V{.
PStartDate 2003 j 1 B V{.
PEndDate 2003 j 12 B V{.
106 IBM Cognos TM1 V10.1.0: Yw8O
-
":g{zDxL49CN},G4;aT>“xLN}”r#
4. *|DxLtT,k9C TM1 Server /@w#PXj8E",kND IBM Cognos
TM1 User Guide#
5. *KPxL,kZPmP%wxL,;s%w4PxL #
\mSn
IT\m TM1 Server ODSn#
}L
1. Z“\m”0qP,%wSn#
IBM Cognos TM1 Web +T>zZ TM1 Server O("DSnPm#
2. *T>X~Sn,k!PT>X~Sn4!r#*~XX~Sn,ke}T>X~
Sn4!r#
3. %wSnT+d!P#
IBM Cognos TM1 Web +T>PXSnDTBE":
v xLPm - PvKZz4PSn1KPD TM1 xL#xL4|GZPmPvVD3rKP#
v y>SnN} - 8wSnDF.Gq&Zn/4,"SnPDxL}"ONt/1dT0SnKPD5J#
v SnF. - T>F.ZD)lKPSnT0SnKPD5J#v ON4P1d - T>SnONKPD1d#
Z 10 B \m IBMCognos TM1 Web 107
-
TM1 9Z3fD%?T>“Sn\m”$_8#
“Sn\m”$_8|,TB4%#
4% 4%{F hv
#fSn #fTSnyvD|D#
4PSn KPSn#IBM Cognos TM1 Web +a>
zdkSnyhDNNN}#
$n $nSn $nSnT48(DF.KP#
#C #CSn #CSn,T9d;Y4F.KP#TI
(}%w“4PSn”4%V/KP#CD
Sn#
`-Sn T>“SnxLPm`-w”T0r#
9CT0rIT^DMEP4PSn1K
PDxLDPm#
%w &C#fxLPm#
XU XU“SnxLPm`-w”T0r#
4. *$nSnT4hCF.KP,k!qSn,;s%w$n#
5. *#CSnT9|;Y4F.KP,k!qSn,;s%w#C#
6. *`-Sn,k!qSn,;s%w`-Sn #
IBM Cognos TM1 Web +T>SnxLPm`-wT0r#
v 9C}7IT9(MEP4PSn1KPDxLDPm#v %w&C#fxLPm#
v %w#f T#fzD|D#
7. *KPSn,k!qSn,;s%w4PSn #
hCM'ztTIT4iMhCM'K(C')tT#
}L
1. Z“\m”0qP,%wM'KtT#
IBM Cognos TM1 Web +T>zZ TM1 Server O("DM'zPm#
2. *T>3M'zDtT,k%wPmPDM'z#
IBM Cognos TM1 Web +T>CM'zDtT5#
108 IBM Cognos TM1 V10.1.0: Yw8O
-
}ns,S}M\k}ZtTb,yPd{tTy*;A#
3. *hCIT(}!(M'zZ TM1 Server O("Dns,S},k;vT>ns,
S}5"dk;vB}V#
4. *hCM'z\kDP'l},k;vT>\k}Z5"dk;vB}V#
\k}Z5* 0 b6E\kP4}Z#
5. %w#f T#fM'ztT|D#
hC`,}]/tT
zITi4MhC`,}]/tT#
}L
1. Z“\m”0qP,%w`,}]/tT#
IBM Cognos TM1 Web +T> TM1 Server ODIC`,}]/Pm#
2. *9X~`,}]/|(ZPmP,k!PT>X~`,}]/4!r#*9Pm
;|(X~`,}]/ke}T>X~`,}]/4!r#
3. *i43`,}]/DtT,kZPmP%wC`,}]/#
IBM Cognos TM1 Web +T>;vr,dP|,y!`,}]/DtTM`&5#
zIT|D4h0kMG
-
}L
1. %ws`“DZ]#
g{3w3Q-}dC,G4|+T>Z IBM Cognos TM1 Web PDZ;v!n(O,
"RC';\+dXU#dC1,aZ IBM Cognos TM1 Web DjbxrT>;vw
34S,I9C'aI5Xw3#
I(}TB=V==DdP;VdC IBM Cognos TM1 Web w3:
v kT;, IBM Cognos TM1 Web C'D;,w3 - 9C TM1 Architect M“~qw/@w”PD“M'zhC”T0r* IBM Cognos TM1 Web D;,M'K(C
')dCt/w3#
v yP IBM Cognos TM1 Web C'D+Vw3 - 9C web.config D~PDHomePageObject N}dCJCZyP IBM Cognos TM1 Web C'D+Vw3#
":g{Z web.config D~D HomePageObject N}PhCK AllowOverwrite=true,
G49C“M'zhC”T0rVdDNNw3yIT2G web.config PD+VhC#
*wvC'dC;,w3
Architect M“~qw/@w”PD“M'zhC”T0rIT*;,D IBM Cognos TM1
Web M'K(C')dCt/w3#
}g,zIT*z[?D IBM Cognos TM1 Web C'Vd;vw3,"*Fq?DC
'Vdm;vw3#
":IT9CM'zhCT0r*X(C'Vdw3,b+2G web.config D~PD
HomePageObject N}D+Vw3hC#
}L
1. Z Architect r“~qw/@w”P,Z~qwO%wsjR|;s@N!q2+T"
M'z/i#
110 IBM Cognos TM1 V10.1.0: Yw8O
-
+r*“M'z/i”T0r#
2. %whC#
+r*“M'zhC”T0r#
3. S+&Cw3hCD10M'zPmP!qM'z#
4. *w3dk Web mq"`,}]/S:
v *T> URL,kZ“w3”rPdk URL X7(|( http:// -i)#ITdkx>D URL,2ITdkvpD~D URL#
v *!q;v Web mqr`,}]/S
-
*yPC'dC2Cw3
web.config D~PD HomePageObject N}+tC;vTyP IBM Cognos TM1 Web
C'T>D+Vw3#
":zIT(}9C“M'zhC”T0r*wv TM1 Client Vd;,Dw342G+
V HomePageObject N}#PXj8E",kNDZ 1103D:*wvC'dC;,w
3;
HomePageObject N}ICZ}V`MDTs:
v `,}]/i4wv Web mqv URL
C'I&Gw3Ts#
9C HomePageObject N}gN9C HomePageObject N}#
HomePageObject N}9CTBq=:
-
"b:zXk|(;v PUBLIC 5r PRIVATE 5T}76p*r*DX(`,}]
/S
-
2. 9CTBq=hC5N}:
value="TM1://ServerName/blob/PUBLIC/.\}Externals\TM1_Filename
dP:
v ServerName G Excel D~yZD TM1 Server D{F#v TM1_Filename G TM1 VdxQOXD Excel D~D{F#
}g:
value="TM1://sdata/blob/PUBLIC/.\}Externals\Report_2006.xls_20070123212746.xls
j{D HomePageObject N}P&gBy>:
++V IBM Cognos TM1 Web w3hC* URLIT+ HomePageObject N}hC*;v URL#
9CTBq=:
value="URL_Path
dP,URL_Path IT8r;vx>rvpx3D~#
}g:
v *+w3h*;v8r3D~D URL:
v *+w3h*;v8r3x>D URL:
114 IBM Cognos TM1 V10.1.0: Yw8O
-
^D IBM Cognos TM1 Web dCN}Web.config \mD~G;v;Z IBM Cognos TM1 Web ib?
-
":web.cofig D~G XML D~,;\9C XML `MD`-wr*#9C#fD
>`-w(}g,Microsoft Wordpad)r*|I\z2GCD~#%wG7O2GD~#
7. G< IBM Cognos TM1 Web Ti4`-a{#
dC TM1 $wwN}IT^D IBM Cognos TM1 Web P“TM1 $ww”$_8Db[#
9C Web.config PDTBN}#
N}
,OhC/
hv
DisplayCustomToolbar N
T>r~X“TM1 $ww”$_8#,O5* N#+K5hC
* Y TT>“TM1 $ww”$_8#
CustomToolbarUrl TM1WebPlanManToolbar.aspx
T(e$_8I4PD~D{F#K&T>D,O5G(
;'VD$_8#
CustomToolbarHeight 28
“TM1 $ww”$_8D_H(TqX*%;)#
PM_ToolbarCaption TM1 $ww
“TM1 $ww”$_8ODV{.jb#
PM_ToolbarCaptionWidth 120
“TM1 $ww”$_8jbODV{.jbmH#
PM_VersionCaption xL
“TM1 $ww”PD“xL”PmDjb#
PM_VersionCaptionWidth 70
“TM1 $ww”$_8PD“f>jb”PmDmH#
PM_VersionListWidth 150
“TM1 $ww”P“f>”PmDmH#
116 IBM Cognos TM1 V10.1.0: Yw8O
-
N}
,OhC/
hv
PM_TaskCaption Nq
“TM1 $ww”$_8P“Nq”PmDjb#
PM_TaskCaptionWidth 50
“TM1 $ww”$_8PNqPmjbDmH#
PM_TaskListWidth 200
“TM1 $ww”$_8PNqPmDmH#
PM_ActionCaption Yw
YwPmDjb#
PM_ActionCaptionWidth 55
YwPmjbDmH#
PM_ActionListWidth 120
YwPmDmH#
PM_AllTasksCaption ,O*UV{.#
yPNqPmDjb#
PM_AllTasksCaptionWidth 30
yPNqPmjbDmH#
PM_StatusCaption ,O*UV{.#
f>4,4%Djb#
PM_StatusCaptionWidth 30
f>4,4%jbDmH#
PM_CustomizeCaption ,O*UV{.#
T(e4%Djb#
PM_CustomizeCaptionWidth 30
T(e4%jbDmH#
PM_LoadCaption ,O*UV{.#
0k4%Djb#
Z 10 B \m IBMCognos TM1 Web 117
-
N}
,OhC/
hv
PM_LoadCaptionWidth 30
0k4%jbDmH#
T>T(e$_8
IT(}^D Web.config PD DisplayCustomToolbar N},4T>r~X IBM Cognos
TM1 Web PDT(e$_8#
":Z TM1 9.x P,TM1WebPlanManToolbar.aspx G(;\'VDT(e$_8#
}L
1. `- IBM Cognos TM1 Web ib?IT~XT(e$_
8,gBy>:
3. *T>T(e$_8,k+ DisplayCustomToolbar 5|D* Y#k7#9Cs4V
8#
4. #f Web.config D~#
5. %w/@wPD"B4%#
T(e$_8+T>Z IBM Cognos TM1 Web 3f%?DuyP#
T>T(e$_8DZ]
g{+ Web.config PD DisplayCustomToolbar N}hC* Y,G4 IBM Cognos TM1
Web +4P CustomToolbarURL N}y8>D#iPDzk#
":CustomToolbarURL N}(;'VDhCG TM1WebPlanManToolbar.aspx#kp|
DKhC#
|DT(e$_8D_H
zIT|DT(e$_8D_H#
}L
1. `- IBM Cognos TM1 Web ib?
-
|D IBM Cognos TM1 Web a0,1IT|D,Oa0UP,1#
,OivB,IBM Cognos TM1 Web &C5* 120 VSDa0UP,1#g{zG<
= IBM Cognos TM1 Web,"R IBM Cognos TM1 Web #VUP 120 VS,G4
zaT/"z#
}L
1. `- Web.config#
2. iRTBzk:
3. |D,15(TVS*%;)#
4. #f Web.config#
5. G< IBM Cognos TM1 Web#
bb,1
1|DK,ON}1,r_1hCDEH3r
-
web.config D~PDhCEHZ IIS M machine.config PDUP,1#g{ web.config
P1Y,1,G4 machine.config PDhC+EH#
*KqCnQa{,k;*|D,OhC#*K@9 TM1 Web a0,1,1z|D,
OhC1,&
-
CubeViewerColumnPageSize
3. |DPM/rP3fs!D5#
4. #f Web.config#
5. G< IBM Cognos TM1 Web#
}g,g{+P3fs!h* 10,r Cube Viewer aT>EP}]YSO,HP#
hC*S Cube Viewer P
-
hC TM1ExcelServicePortNumber N}IT`-CZ8( TM1 Excel Services }Zl}DKZED TM1ExcelServicePortNumber
N}#
TM1 Excel Services GZs(KPD&CLr,C4&m*s+ Excel D~*;* XML
q=D IBM Cognos TM1 Web ks#
IT9CTBq=Z Web.config D~P`- TM1ExcelServicePortNumber N}:
dP,PortNumber Xkh*P'DKZE,gTB>}y>:
9C AdminHostName M TM1ServerName dCGKE"#
AdminHostName N}
KN}8(KP TM1 Admin Server D\mwzD{F#9CTBq=Z Web.config
D~P`- AdminHostName N}:
dP HostName I*TB5.;:
v g{ HostName *U(,O5),G4G Admin Host a>#v g{ HostName hC*P'D TM1 \mwzD{F,G4 IBM Cognos TM1 Weba+C\mwzCZG
-
C'dkP'DC'{M\k.s,IBM Cognos TM1 Web +G#
dC IBM Cognos TM1 Web t/Mb[hC1C'G
-
value I* true 2I* false#
v g{+5hC* false,G41C'G`v!n("R;N;\r*;vTs#
KN}1049C AllowOverwrite !n#
HideWebsheetToolBar N}HideWebsheetToolBar N}7(C'r* Web mq1GqT> Web mq$_8#
HideWebsheetToolBar N}Z web.config D~P9CTBq=:
dP,value I* true 2I* false#
v g{+5hC* false,G4+Z IBM Cognos TM1 Web PT> Web mq$_8#
Z 10 B \m IBMCognos TM1 Web 125
-
v g{+5hC* true,G4+;Z IBM Cognos TM1 Web PT> Web mq$_8#
KN}1049C AllowOverwrite !n#
HideCubeviewerToolBar N}HideCubeviewerToolBar N}7(C'r*`,}]/S Cube Viewer $
_8#
HideCubeviewerToolBar N}Z web.config D~P9CTBq=:
dP,value I* true 2I* false#
v g{+5hC* false,G4+Z IBM Cognos TM1 Web PT> Web mq$_8#v g{+5hC* true,G4+;Z IBM Cognos TM1 Web PT> Web mq$_8#
KN}1049C AllowOverwrite !n#
9C CustomLink N}r*d{ URL Mx3CustomLink N}CZZ IBM Cognos TM1 Web $_8PT>;v4S,C4SIr
* URL X7r Web 3f#
IT9C4ST(eD>M URL dCKN}#1z%w4S1,+a9C53D,O
Web /@wZ;B0Zr* URL ?j#
{CKN}D,OhC - CN}DyP5K4
S#
t*dC CustomLink N},9CTBq=`- web.config D~#
dP
v LinkTitle GZ$_8OT>D4SD>#v LinkTooltip G1sj|#Z4SO1T>DozD~#v LinkURL G%w4S1*r*D URL#
}g:
":+ URL mS=yZ XML D web.config D~1,Xkq- XML Dj
-
ExcelSheet M UserTempDir ?:
Url M AbsolutePath N}Xkbv=`,D;C#
v Url Gz#{ IBM Cognos TM1 Web Cw_Y:f?
-
}L
1. r* Web.config D~"(; P#
2. *tC Web mqV3&\,k+ WebsheetPaging N}hC* Enabled=true,g
By>:
3. (}dC PageSize N},hC*Z IBM Cognos TM1 Web PISD Web mq
DsEP}#}g:
4. *{C Web mqV3&\,k+ WebsheetPaging N}5hC* Enabled=false,
gBy>:
5. #f"XU web.config D~#
9C TM1 Web PageResetMode N}1zZ Web mqP4P3)Yw(}g,XBFc"X(r|Dn/mqDjb,H
*X)1,IBM Cognos TM1 Web PageResetMode N}JmzXF Web mqP3f
=rD3)P*#
N19C PageResetMode N}
r* Web mqZDTs(}g,V3MP#KP*!vZ Web mqPDX
(Z]M4PDYw#
1zF.Z Web mqP4P3)Yw(}g,XBFc"X(r|Dn/mqDjb
,H*X)1,g{k*XF W e b mqPD3f=rD;)P*,k9C
PageResetMode N}#
PageResetMode N}GS TM1 Web V9.5.2 *}
4PTBYw1,9C PageResetMode N}4XF Web mqD3f=rDP*:
v XBFc Web mqv X(|,n/mqD Web mqv u
-
IZ TM1 Web web.config D~DTB?VPdC PageResetMode N}:
TB5Ik PageResetMode N}dO9C#
m 5. PageResetMode N}5
5 hv
0 +3==#Web mq3fS
-
*Jm3y= Web OQi$D Microsoft Excel %*q,kZKN}P+C5hC*
Mode=1 "#f web.config D~#
Z`,}]/STqCnQb
[#,OivBhC* 200#
WidthOfWrapCellhCZT>xrDXF?VP9CDV{}#,OivBhC* 240#
Z web.config D~P9CTBq=(*e~9V,TBPmP,PX5,+Gz;&d
kX5)#
PG:CubeviewerStringWrap ;&CZ Web mq#
4P Web D~P,$IBM Cognos TM1 Web 9C=v Web D~P4fEY1D~#&C(Z`Sb)D
~P"Z53#zZdeUb)D~P#
nQv(G,`SBPD~P"ZD~Pdz1Z53#zZd>}dPOIDZ
]#
v Excelsheet - 1zi4 Excel mq1,IBM Cognos TM1 Web a+`vY1D~4kCD~P#
,O;C*:C:\Program Files\IBM\cognos\tm1\tm1webex
v UserTempDir - |,S IBM Cognos TM1
-
,O;C*:C:\Program Files\IBM\cognos\tm1\tm1webex
9C IBM Cognos TM1 Web U>IBM Cognos TM1 Web \m1I9CTB=vU>D~4Kb IBM Cognos TM1 Web
D4,MJOoO#U>D~PDOXT6pPzZi/{"#
v Web.config - IBM Cognos TM1 Web U>D~v TM1ExcelService.exe.config - IBM CognosTM1 Excel Services U>D~
IBM Cognos TM1 Web U>GtTD~P9C,T+U>dC*X(6p#
N} hv
DEBUG j8D&CLrDxH"(f&CLrZD}#*;#
+U>dC*C6ps,+G< INFO M ERROR {"#
ERROR z&C"bDmsiv#&I!k)4^4Jb,r_+CJb(fx TM1
M''Vz9#
+U>dC*C6ps,+vG< ERROR {"#
IBM Cognos TM1 Web U>IBM Cognos TM1 Web U>G< IBM Cognos TM1 Web n/MmsD{"#
U>D~G ASCII D>D~,IT9CNND>`-w(}g Microsoft Windows G
B>)r*CD~#
dC"tC IBM Cognos TM1 Web U>IT|D IBM Cognos TM1 Web U>DU>{"6p#
U>6pf"Z Web.config D~DU>tT?VP#
1 web.config D~PDU>tTQ}7dC**tU>1,U>c;tC#,Oiv
B,20 IBM Cognos TM1 Web 1adC IBM Cognos TM1 Web DU>#
web.config D~20Z TM1 Web install_directory P#g{Q+ IBM Cognos TM1 Web
20=,OD20;C,G4 web.config D~+;Z?< C:\Program Files\IBM\
cognos\tm1\tm1web#
Z 10 B \m IBMCognos TM1 Web 131
-
,O Web U>dC)U#9C,(#;h*xPw{#g{h*dCU>tTTxP
JOE},k*5 IBM Cognos M''V0soz#
BfG web.config D~PU>tT?VDy>#
dP:
{"6pI 8>
U>D~{I 8>
"b: ,OivB,aZ Web ~qwDy?D~#rK,|II4-Z
(DK1CJ#kD~4A2+;C#CN}IS
\`T76rDV76#
n!Mns{"6p6'm>*:
}L
1. ZD>`-w(}g Microsoft Windows GB>)Pr* web.config D~#
2. iRTBzk?V:
3. +6p|D*TBP'5.;:DEBUG"INFO r ERROR#
g,*+{"6p|D* DEBUG,k4gBy>`-CP:
132 IBM Cognos TM1 V10.1.0: Yw8O
-
4. (; levelMin M levelMax N}DhC#
w{ levelMin M levelMax N}D5T9d6'Z|,*GD~IBM Cognos TM1 Web 20f>dC IBM Cognos TM1 Web U>T+{"4A
TM1_Web_install ?D~PD?;Pyzm;u4TBq=EPD(;{":
2007-01-17 11:13:36,916 [2600] ERROR Cognos.TM1.Web.PageTM1WebpageUtils- not localized
dP:
v 2007-01-17 11:13:36,916 *UZM1dv [2600] *_Lj6v ERROR *{"6pv Cognos.TM1.Web.PageTM1WebpageUtils GSi~{Fv not localized *{"D>#
Z 10 B \m IBMCognos TM1 Web 133
-
TM1 Excel Services U>TM1 Excel Services U>G< TM1 Excel Services D{",s_G;v&CLr,C
&CLrZs(KPT&m*s+ Excel D~*;* XML q=D IBM Cognos TM1
Web ks#
TM1 Excel Services U>D~G ASCII D>D~,IT9CNND>`-w(}g
Microsoft Windows GB>)r*CD~#
dC TM1 Excel Services U>ITw{U>{"6p#
TM1 Excel Services U>DdCf"Z TM1ExcelService.exe.config D~P#
TM1ExcelService.exe.config D~;Z TM1 install_dir\bin ?v U>D~{I 8>
134 IBM Cognos TM1 V10.1.0: Yw8O
-
v n!Mns{"6p6'm>*:
}L
1 . ZD>`-w(}g M i c r o s o f t W i n d o w s GB>)Pr*
TM1ExcelService.exe.config D~#
2. iRTBzk?V
3. +6p|D*TBP'5.;:DEBUG"INFO r ERROR#
}g,*+{"6p|D* DEBUG,k4gBy>`-CP:
4. (; levelMin M levelMax N}DhC#
w{ levelMin M levelMax N}D5T9d6'Z|,*G,OivB,20 IBM Cognos TM1 Web 1adC TM1 Excel Services DU>#
20f>+ TM1ExcelService.exe.config D~T0 TM1 Excel Services D~
TM1ExcelService.exe EA TM1 install_dir\bin ?
-
2007-01-16 10:59:40,846 [3156] ERROR Cognos.TM1.ExcelServices.