IBM Cognos Analysis For Microsoft Excel 1020n

Transcription

IBM Cognos Analysis for Microsoft Excelv 10.2.03! H;-

mL 8M L 8! vxOB Xg &0; gkOb !, 51 dLvG :VGgW;G 8& 6OJC@.&0 8L .-B IBM Cognos Analysis for Microsoft Excel v 10.2.0! {kGg DS 1.:!5 {kI v V@OY.Licensed Materials - Property of IBM Copyright IBM Corporation 2005, 2013.

qwR3 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . v& 1 e uNn ;k . .v 10.2.0G uNn bI.v 10.1.1G u bI . .vxGB /f W C'{! pn vx . . . . . .e. .11113& 2 e IBM Cognos Analysis for Microsoft Excel. . . . . . . . . . . . . . . . . . . . . 5& 3 e 3! Xq . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73! ! 1.: 8 Kd . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7vxGB /f . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7& 4 e IBM Cognos Analysis for Microsoft Excel 3! . . . . . . . . . . . .Microsoft .NET Framework 3! . . . . . . . . . . . . . . . . . . . . .Microsoft Excel! kX PIA(Primary Interop Assemblies) 3! . . . . . . . . . .Microsoft Office 3!& v O) Excel! kX PIA(Primary Interop Assemblies) 3! .Microsoft Excel! kX ghw !IQ P0v!- PIA(Primary Interop Assemblies) 3!L v G IBM Cognos Analysis for Microsoft Excel &E . . . . . . . . . . .IBM Cognos Analysis for Microsoft Excel 3! . . . . . . . . . . . . . . .CY% 9n .Z %C 3 . . . . . . . . . . . . . . . . . . . . . .Microsoft Windows XP ,sLp.! GB18030 vx 3! . . . . . . . . . . .GB18030 [C 5) gk . . . . . . . . . . . . . . . . . . . . . .IBM Cognos Analysis for Microsoft Excel W:. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9. 9. 10. 11. 12. 12. 13. 14. 14. 15. 16NO A. ;T JdQ IG bI3! 6}gG ;T JdQ IG3! 6}g!- 08e v .x w RA. n . . . .IBM W ;T JdQ IG . . .bI. . . .NO B. .&! Xa . . . .&! Xa . . . . . . .vD b] %LM#L: Kv .v gW !.@b . . . . .IBM vx M! .G . . .IBMz 8 3/ . . . . .IBM vx M! 8 [.IBM vx M!- 8 vEvx w%L. 86 . . . . .O] @y . . . . . . . .8: .& . . . . . . .3. .& . . . . . . . Copyright IBM Corp. 2005, 2013.1717171818.191921222224242525272732iii

8H .& . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35IBM Cognos Office x#! v H @y Cv! *8*B .& . . . . . . . . . . . . . . . . 36IBM Cognos Analysis for Microsoft Excel x#! v H @y Cv! *8*B .& . . . . . . . . 38NO C. IBM Cognos Office 8:dR gj#y .Zx DO . . . . . . . . . . . . . . .IBM Cognos Office 8:dR gj#y GB v*Zx DO(.resx) m} . . . . . . . . . .w%L.H Zx DO DDO . . . . . . .[w W:. . . . . . . . . . . . . .414143434445NO D. Z? 3! 3 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 473! 6}g!- }:H DO; gkO) 3! 3 . . . . . . . . . . . . . . . . . . . . . . 47response.ats DO; gkg) 3! 3 . . . . . . . . . . . . . . . . . . . . . . . . . . 49VGgW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51vN . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55ivIBM Cognos Analysis for Microsoft Excel v 10.2.0:3! H;-

R3L .-B IBM Cognos Analysis for Microsoft Excel!- gkO5O [:Gz@OY. IBM Cognos Analysis for Microsoft Excel: . 8m- [:Z! )/ %LM#L:! kQ PQ Y C.G Y u. 8m-& teOB % gkOBMicrosoft Excel b] 58TOY.ksL H;-B gkZ! IBM Cognos Business Intelligence, IBM Cognos for MicrosoftOffice, W IBM Cognos PowerPlay M 0: IBM Cognos &0! #wOYB M;! UOY. gkZB GQ Microsoft ExcelM 0: Microsoft Office C:[5 KF UOY. 8 #b%!- x*H pg .-& wTQ IBM Cognos &0 8& #8Ai IBM CognosInformation 0m0/index.jsp) O*! W :OJC@. 1.: 8B Information Center! YN x3Gg VE bzk. W APAR! kQ 5)& wTUOY.GQ IBM Cognos &0 p:)!- PDF v G &0 1.: k. W 3! H;-&w" P; v5 V@OY.L! vb{ xzL .-!-B vg &0G bI! kX 3mUOY. vg gkR v xB Wq! kQ 6! wTI v V@OY. W/* bD gk!I:! kX n0Q OC5 Ov J@OY. L/Q 6B SGG Za, Ze GB bI; &xOb 'Q . L* }{ %SgW; GLOv J@OY. &0G G3* bI! kQ 3 , bC W Cb! kQ gW: {8N IBML a UOY.;T JdQ IG bI;T JdQ IG bI: E?L RmOE* C" eV nG E { eV! VB gkZ! IT &0; gkOB % 5r; ]OY. IBM Cognos Analysis for MicrosoftExcel! ;T JdQ IG bIL V@OY. Z Q 8B 17 dLvG NO A :;T JdQ IG bI;& 6OJC@. IBM Cognos HTML .-!B ;T JdQ IG bIL &xKOY. PDF .-B 86 .-LGN, L/Q N!{N ;T JdQ IG bI: wTGn Vv J@OY. Copyright IBM Corp. 2005, 2013v

yC i%gWSample Outdoors Company, Great Outdoors Company, GO Sales, Sample OutdoorsGB Great OutdoorssB L'G / W Planning Sample: IBMz IBM m4;'X yC VC.ILG; 3 OB % gkGB yC %LM& gkOB !sG qnO: 6w; *8@OY. L/Q !sG 9Ze!B GE E!, &0 hw, g W N{ Zx! kQ yC %LM! wTKOY. G& L', VR, ,t3 GB E! !]z/gOus5 LM: l,G O!O STOY. b8 yC DO!B v?8N }:GE* bh!- }:H !sG %LM, 30 Za* x3 ZaNNM DDOH G& %LM GB yC VC.ILG 3 ! JdQ yC %LMN gkOb 'X z[GZG c!& m gkOB %LM! wTI v V@OY. p H &0 L': Xg R/GZG s%O v V@OY. c! xL 9&R v x@OY.viIBM Cognos Analysis for Microsoft Excel v 10.2.0:3! H;-

& 1 e uNn ;kL }!B L 1.:G u bI W /fH bI qOL wTGn V@OY. L 8&kX gkZG 30 d8gW; f7Om wW9Le W VC.ILG h! ; h9R v V@OY.n5 &, P!, jslz, % -v, p:d. -v, %LM#L: -v W VC.ILG -v! Q 8& wTO), IBM Cognos &0!- vxOB /fG VE qO; KdOAi IBM Cognos Customer Center(http://www.ibm.com/support/docview.wss?uid swg27038266)& f.OJC@.v 10.2.0G uNn bIL G!- * ! *@B 8!-B 6v7 1.: LDG u bI; *-UOY.w" CH Wq! kQ 5)! wTGn V@OY.v IBM Cognos Analysis for Microsoft Excel W IBM Cognos BI for MicrosoftOfficeM 0: IBM Cognos Office &0: Microsoft .NET Framework 4& gkX UOY.L w%L.H Xv gW: C:[ wW9Le& GLUOY. vg IBM CognosOffice &0G gkZN fl Microsoft .NET Framework 28 3!Gn Vb '.! .NET Framework 4& 3!X UOY. IBM Cognos Office &0; 3!Ob ! w%L.H .NET Framework& 3!X UOY. Microsoft .NETFramework )/ v : -N T2 gkI v V@OY. L v ; &ER Jd!x@OY.v ! pn vxIBM Cognos Office &0!- vxR v VB ! pnB )NF Fn, '6)n, Ze::n, N#OFn, B9nTOY.v 10.1.1G u bIL G!- * ! *@B 8!-B 6v7 1.: LDG u bI; *-UOY.w" CH Wq! kQ 5)! wTGn V@OY.vxGB /f W C'{ .e)/ C'{ W /f! kQ vxL .eGz@OY. Copyright IBM Corp. 2005, 20131

64q. 3! vxIBM Cognos Analysis for Microsoft Excel: 64q. /f; vxUOY. 64q. /f: u *: p. .M bsH .e: W :I; &xR v V@OY. L& IBMCognos Analysis for Microsoft ExcelG 32q. W 64q. v ; 3!Om G O5O 1CR v V@OY. IBM Cognos VC.ILG: 64q. n5 &!- 32q.W 64q. v G Microsoft OfficeN Excel; G R v V@OY.64q. 3!& v OB fl 3!! gkGB b; fNB 32q. 3!! gkGB b; fNM Y(OY. Y : b; 3! p:d.TOY.v 32q.& 3!OB fl - C:\Program Files\IBM\cognos\Cognos for MicrosoftOfficev 64q. OS!- 64q.& 3!OB fl - C:\Program Files\IBM\cognos\Cognosfor Microsoft Officev 64q. OS!- 32q.& 3!OB fl - C:\Program Files(X86)\IBM\cognos\Cognos for Microsoft OfficevxGB /f W C'{! kQ Z Q 8B IBM Cognos Customer tomercenter/)(u "!- -2)& f.OJC@.Microsoft Office 2010 vxL& IBM Cognos Analysis for Microsoft Excel! kX 2010 v G Microsoft ExcelRA. n! vxKOY.u Office Open XML DL ECMA InternationalL vxOB wh %X8N N Gzb '.! Microsoft Office 2010!- vxGB L u D: )/ C'{G 8v; gkO) .e:z s# nk:; kLOT UOY.n5 &, P!, jslz, % -v, p:d. -v, %LM#L: -v W VC.ILG -v! Q 8& wTO), IBM Cognos Business Intelligence &0!- vxOB /fG VE qO; KdOAi Y ; f.OJC@. (u "!- -2)Mozilla Firefox vxL& Mozilla Firefox v 4 % jslz& IBM Cognos Analysis for MicrosoftExcel!- vxUOY.n5 &, P!, jslz, % -v, p:d. -v, %LM#L: -v W VC.ILG -v! Q 8& wTO), IBM Cognos Business Intelligence &0!- vxOB /fG VE qO; KdOAi IBM Cognos Information Center(http://www.ibm.com/support/docview.wss?uid swg27038296)(u "!- -2)& f.OJC@.2IBM Cognos Analysis for Microsoft Excel v 10.2.0:3! H;-

Internet Explorer vxL& Microsoft Internet Explorer v 9 % jslz& IBM Cognos Analysis forMicrosoft Excel!- vxUOY.n5 &, P!, jslz, % -v, p:d. -v, %LM#L: -v W VC.ILG -v! Q 8& wTO), IBM Cognos Business Intelligence &0!- vxOB /fG VE qO; KdOAi IBM Cognos Information Center(http://www.ibm.com/support/docview.wss?uid swg27038296)(u "!- -2)& f.OJC@.! pn vxIBM Cognos Analysis for Microsoft Excel: L& k# Ln& vxUOY.& 1 e uNn ;k3

4IBM Cognos Analysis for Microsoft Excel v 10.2.0:3! H;-

& 2 e IBM Cognos Analysis for Microsoft ExcelIBM Cognos Analysis for Microsoft Excel: 8H 3 H IBM Cognos BusinessIntelligence W Microsoft ExcelG IBM Cognos TM1 AYwM T2 [?UOY.gkZB YgQ %LM R:N Excel!- 9bQ Y C., Y 8m-& teR vV8g IBM Cognos!- p(5H %LM& wx P.Om vR v V@OY. L VC.ILG: gkZ! qnO: C .&& XaOm !e m.Q D8N Vd az& %CR v V5O vD b] %LM! W :R v VT UOY.IBM Cognos BI!- L VC.ILG; #MAsLn %LM& P.O) , b8,.&! GB AN'. /:; D0OB % gkR v V@OY. IBM Cognos TM1Gfl L VC.ILG: qnO: W n5 %LM& h9Om x OB g P.!Mh9 cgZ! gkUOY. Copyright IBM Corp. 2005, 20135

6IBM Cognos Analysis for Microsoft Excel v 10.2.0:3! H;-

& 3 e 3! XqIBM Cognos Office 8:dR& 3!Ob ! 8:dR! [?R v V5O /fGZx; 3 X UOY.Y ).:.& gkO) 3! AN :& \h0N v R v V@OY.v 1.: 8 Kd.v vxGB /fY [w; OaQ D 9 dLvG & 4 e :IBM Cognos Analysis for MicrosoftExcel 3!;& hS x OJC@.3! ! 1.: 8 KdIBM Cognos &0; 3!Ob ! 3! ! 5b; Y v VB pg .&& DGX UOY.L 3! H;-! [:H C!!-B KAvv J: VE .&!L V; v V@OY.&0; 3!Ob ! 1.: 8& KdOJC@. 1.: 8!B KAx .&!!kQ VE 8M .- w%L. W vx \ K2 8! wTGn V@OY. 1.: 8B 3! 6}gG 9 x0 dLv GB &0 p:)!- &xKOY. GQ 1.: 8 w%L.B IBM Cognos Customer tomercenter/)!- &xKOY.vxGB /f&0L CY#T [?O5O OAi VRQG Jv n5 & P!& pN {kOm vxGB v G aeD RA. n8 gkX UOY.vxGB /fG VE qO; KdOAi IBM Cognos Customer Center(http://www.ibm.com/support/docview.wss?uid swg2703826)& f.OJC@. % gL.B/fG Y D.M CH d8gW! kQ 8& &xUOY.v n5 &v P! GB -q: Q GB ? v % jslzv % -vv p:d. -vv %LM#L: -v Copyright IBM Corp. 2005, 20137

v VC.ILG -v05N %CGv JB Q IBM Cognos &0: mCH v G P!/-q: QG VEv z #/KOY.Linux n5 &B YgQ hw /f!- gk !IOg )/ Oe n C'{; vxUOY. gkOm VB n5 &M Oe nG 6UL vxGB MNv .NOJC@.Cognos &0z !s- /fIBM !s- on policy.html):IBML vxOB !s- /f! kX 3mUOY.8IBM Cognos Analysis for Microsoft Excel v 10.2.0:3! H;-

& 4 e IBM Cognos Analysis for Microsoft Excel 3!IBM Cognos for Microsoft Office& gkOAi Microsoft .NET Framework 4.0Lsz IBM Cognos for Microsoft Excel 8:dR& 3!X UOY.IBM Cognos Business Intelligence yC!B IBM Cognos Analysis for MicrosoftExcelG yCL wTKOY. yC: Great OutdoorssB !s 8gG %LM& gkO) &0 bIz bz W qnO: lv gJ& 3mUOY. L yC: 8m- pZNbz; W:. W x/Om .&!; XaOB %5 gkR v V@OY. yC; gkOAi .Z!T yC; 3 W 8:O5O OE* yCL 3!H '!& .GO)#F UOY. yC; 3 Om 8:OB f}! kQ vCgW: IBM Cognos 3!W 8: H;- GB IBM Cognos . W 8H H;-& 6OJC@.u v G IBM Cognos Analysis for Microsoft Excel; 3!Ob ! Uz b8 v ; &EX UOY.ANCz1. Microsoft .NET Framework& 3!OJC@.Z Q 8B Microsoft .NET Framework 3!& 6OJC@.2. PIA(Primary Interop Assemblies)& 3!OJC@.Z Q 8B PIA(Primary Interop Assemblies) 3!& 6OJC@.3. L v G IBM Cognos Analysis for Microsoft Excel; &EOJC@.Z Q 8B 12 dLvG :L v G IBM Cognos Analysis for MicrosoftExcel &E;& 6OJC@.4. IBM Cognos Analysis for Microsoft Excel 8:dR& 3!OJC@.Z Q 8B IBM Cognos Analysis for Microsoft Excel 8:dR 3!& 6OJC@.5. IBM Cognos Analysis for Microsoft Excel; W:.OJC@.Z Q 8B IBM Cognos Analysis for Microsoft Excel W:.& 6OJC@.Microsoft .NET Framework 3!IBM Cognos for Microsoft Excel: pg gkZ D;M! Microsoft .NET Frameworkv 4.0 Ls; 3!X UOY. Copyright IBM Corp. 2005, 20139

vxGB Microsoft .NET Framework v G qO: IBM Cognos wss?uid swg27038266)& 6OJC@.q5n n5 &!- Microsoft .NET Framework& 3!OB fl!5 Microsoft.NET @y Cv, YN !b W /?. B 5nN %CKOY.5n L\G pn!-B Microsoft .NET Framework pn Q; {kOi @y Cv, YN !b W /?. ! n5 &G pnN %CKOY. 9& in, A{:n n5 &! Microsoft .NET Framework& 3!Q fl Microsoft .NET French pnQ5 3!X UOY.ANCz1. Microsoft YnNe % gL.N L?OJC@.2. .NET Framework 4.0 Ls; KvO) ghw !IQ P0v& 1COm Y vCgW! {s YnNeOJC@.3. .NET Framework v z CH b8 8H w%L.& .NO) YnNeOJC@.Microsoft Excel! kX PIA(Primary Interop Assemblies) 3!IBM Cognos Analysis for Microsoft ExcelG bI; gkOAi Excel! kXPIA(Primary Interop Assemblies)& 3!X UOY. O]{8N PIAB D;M!Microsoft Office& 3!R ' Z?8N 3!KOY. W/*, fl! {s PIA& 05N 3!X R v5 V@OY.NET Framework 4.0 Ls; ks8N OB Office VgG; G OAi D;M v):WLG! PIA& 3!Om [Nz n@m. 3C! nOX UOY.N !v f}8N PIA .& [Nz n@m. 3C! 3!R v V@OY.v Microsoft Office 3!& v UOY.Office C:[; 3!Ob ! .NET Framework& 3!Ov J: fl Office 3! C PIA! T2 3!Gv J@OY. Office C:[; 3!Q D .NET Framework& 3!Q fl!B Office 3!& v O) PIA& 3!R v V@OY.v ghw !IQ PIA P0vN 3!UOY.Microsoft Office PIAB drive:/WINDOWS/assembly GB drive:/WINNT/assembly! VB [Nz n@m. 3C! 3!KOY.10IBM Cognos Analysis for Microsoft Excel v 10.2.0:3! H;-

Microsoft Office 3!& v O) Excel! kX PIA(Primary InteropAssemblies) 3!IBM Cognos Analysis for Microsoft ExcelG bI; gkOAi Excel! kXPIA(Primary Interop Assemblies)& 3!X UOY. O]{8N PIAB D;M!Microsoft Office& 3!R ' Z?8N 3!KOY. W/*, fl! {s PIA& 05N 3!X R v5 V@OY.NET Framework 4.0 Ls; ks8N OB Office VgG; G OAi D;M v):WLG! PIA& 3!Om [Nz n@m. 3C! nOX UOY. Ov8, D;M!- .NET Framework 4& ks8N OB Office VgG; G OB %B OfficePIA! JdOv J@OY.Office C:[; 3!Ob ! .NET Framework& 3!Ov J: fl Office 3!C PIA! T2 3!Gv J@OY. Office C:[; 3!Q D .NET Framework& 3!Q fl!B Office 3!& v O) PIA& 3!R v V@OY.Microsoft Office PIAB drive:/WINDOWS/assembly GB drive:/WINNT/assembly! VB [Nz n@m. 3C! 3!KOY.C[Ob !.NET FrameworkM Microsoft Office PIA& 3!OAi D;MG .ZLn UOY.ANCz1. C[ :!- &nG; ,/Q Y ANW% !/&E& um,/OJC@.2. ANW% qO!- Microsoft Office v ; ,/Q Y /f; ,/OJC@.3. Microsoft Office 3! 6}gG /v . pe IG dLv!- bI !/&E& 1COJC@.4. gkZ v 3! dLv!- Excel IG; 1COm VC.ILGG m gkZv ; 1COJC@ 1Cu; 1CQ D Y ; ,/OJC@.5. m gkZ v dLv!- Microsoft OfficeM Microsoft Office Excel ke& n!JC@.6. .Net ANW% vx bI 7G b#& ,/Q Y ; D;M!- G ; ,/OJC@.bIL Oe p:)! 3!Gm zeKOY.7. w%L.& ,/OJC@.& 4 e IBM Cognos Analysis for Microsoft Excel 3!11

Microsoft Excel! kX ghw !IQ P0v!- PIA(Primary InteropAssemblies) 3!IBM Cognos Analysis for Microsoft ExcelG bI; gkOAi Excel! kXPIA(Primary Interop Assemblies)& 3!X UOY. O]{8N PIAB D;M!Microsoft Office& 3!R ' Z?8N 3!KOY. W/*, fl! {s PIA& 05N 3!X R v5 V@OY. Office C:[; 3!Ob ! .NET Framework&3!Ov J: fl Office 3! C PIA! T2 3!Gv J@OY. ghw !IQ PIAP0vN 3!R v V@OY.NET Framework 4.0 Ls; ks8N OB Office VgG; G OAi D;M v):WLG! PIA& 3!Om [Nz n@m. 3C! nOX UOY. Ov8, D;M!- .NET Framework 4& ks8N OB Office VgG; G OB %B OfficePIA! JdOv J@OY.Microsoft Office PIAB drive:/WINDOWS/assembly GB drive:/WINNT/assembly! VB [Nz n@m. 3C! 3!KOY.C[Ob !.NET FrameworkM Microsoft Office PIA& 3!OAi D;MG .ZLn UOY.ANCz1. .NET Framework 4.0L 3!Gn VBv .NOJC@.2. Microsoft YnNe % gL.N L?OJC@.3. YnNe dLvG vCgW! {s PIA(Primary Interop Assemblies)& 3!OJC@.L v G IBM Cognos Analysis for Microsoft Excel &EL v G IBM Cognos Analysis for Microsoft ExcelL 3!Gn VB fl!BL v ; &EX u v G IBM Cognos Analysis for Microsoft Excel; 3!R v V@OY.&EB &E AN :& x OB ?H pg VC.ILG DO GB p:d.& O w &EOv Jb '.! Y ?[; v?8N v X R v V@OY.?OQ '!! Q LsG 8:dR& 3!Q fl!B &E 6}g& gkO) &ERP0v& 1CR v V@OY. P0vG pg 8:dR! &EKOY.C[Ob !&EOb ! Microsoft Office VC.ILG; pN ]@OY.12IBM Cognos Analysis for Microsoft Excel v 10.2.0:3! H;-

ANCz1. C[ :!- ANW%, IBM Cognos for Microsoft Office, IBM Cognos &E, IBM Cognos &E& ,/OJC@.&E 6}g! *83OY.A: IBM Cognos for Microsoft OfficeB 3! ! [:GB ANW% zuG L'TOY. Y% L'; 1CQ fl Xg zuN L?O) ANW%; #@OY.2. vCgW! {s 8:dR& &EOJC@.cognos uninst log.txt DO!B DO; &EOB ?H &E 6}g! v OB 0?L bOKOY.A: NW DO; #8Ai Temp p:d.& .NOJC@.IBM Cognos Analysis for Microsoft Excel 3!IBM Cognos for Microsoft Excel; 3!OAi &0 CD GB S LAN '!GKB: p:d.!- issetup.exe DO; G OJC@. L DO: Microsoft .NETFrameworkG 8H w%L.& 3!Q Y IBM Cognos Analysis for Microsoft Excel8:dR& 3!UOY.IBM Cognos Analysis for Microsoft ExcelG VC.ILG yC: 05G p:)!V@OY. yC; gkOAi IBM Cognos Business Intelligence .Z! IBM CognosBusiness Intelligence yC p:)G yC; 3!X UOY.C[Ob !IBM Cognos Analysis for Microsoft Excel: 32q. GB 64q.N 3! !IUOY. 32q. GB 64q. Windows D;M! XgGB 3! DON 3!X UOY.8:dR& w%L. W 3!Ob ! Y gW; f7OBv .NOJC@.v D;M! kQ . GQL V@OY.v Microsoft .NET Framework 4.0 Ls; 3! @OY.v IBM Cognos Analysis for Microsoft ExcelG L v ; &E @OY.v IBM Cognos Analysis for Microsoft Excel &0; gkOB % JdQ {UQ sL :! V@OY.ANCz1. IBM Cognos Analysis for Microsoft Excel CD& pTOE* 3! DO; YnNeQ '!N L?OJC@. C[ dLv! u "! *83OY.& 4 e IBM Cognos Analysis for Microsoft Excel 3!13

2. C[ dLv! *8*v JE* CD!- 3!Ov JB fl n5 &M MicrosoftExcelG v ! {s 3!R v ; 32q. GB 64q. 1COJC@.v 32q. v ; 3!OAi win32 p:d.N L?O) issetup.exe& um,/OJC@.v 64q. v ; 3!OAi winx64h p:d.N L?O) issetup.exe& um,/OJC@.3. 3!! gkR pn& 1COJC@.1CQ pn! {s gkZ NMdL:G pn! a KOY. 3! D 3!H pnxOB pnN /fR v V@OY.4. 8:dR 1C dLv!- IBM Cognos Analysis for Microsoft Excel; 1COJC@.5. 3! 6}gG vCgW! {s JdQ DO; D;M! 9gOJC@.azIBM Cognos Analysis for Microsoft Excel GB IBM Cognos BI!- gk !IQyC; gkOAi .Z! IBM Cognos BI yC; 3!X UOY. Z Q 8BIBM Cognos BI 3! W 8: H;-& 6OJC@.CY% 9n .Z %C 3 IBM Cognos Office VC.ILG!- 9n # Z! &kN %CGv J; v V@OY. 9n # Z .Z& &kN %COAi Y [w; v X UOY.v :Microsoft Windows XP ,sLp.! GB18030 vx 3!;v 15 dLvG :GB18030 [C 5) gk;Microsoft Windows XP ,sLp.! GB18030 vx 3!NIOL 9n # ZN fl IBM Cognos for Microsoft Office VC.ILGL :M k- sZ& CY#T %CR v V5O KB: pn vxL 3!Gn VBv .NUOY.GB18030: 9n %X NZy .ZTOY. Windows XP L v !- 9n # .Z& CY#T %COAi Windows YI [C(9: Tahoma, Arial, Microsoft SansSerif)! GB18030 vx; !X UOY. GB18030 vx P0v!B N 9n [CN SimSun-18030z NSimSun-18030; aUOB SimSun18030.ttc, .g8T [C]:G DOL wTKOY.9n # Z v L FQ Windows! 9n # Z& 'Q pn vx; 3!R vV@OY. Windows XP! 3!H D;M!- Y ANCz& v OJC@.14IBM Cognos Analysis for Microsoft Excel v 10.2.0:3! H;-

ANCz1. C[ :!- &nG; ,/Q Y 9! W pn IG; um,/OJC@.2. pn G!- ?FCF pn& gkOB % JdQ DO 3! 1Cu; 1COJC@.3. Microsoft!- YnNeQ GB18030 vx P0v& 3!OJC@.GB18030 [C 5) gkIBM Cognos for Microsoft Office VC.ILG!- GB18030 .Z& &kN %COAi / 3 L CY%v .NX UOY.Y ; .NX UOY.v 9! W pn IG k-sZ(&nG, 9! W pn IG, m G)!- /OZe&vxOv JB ANW%k pn& 9n ( 9)8N 3 v FontLink 9v:. WqL " 0: C:[ [C L'! SimSun-18030; wT[C 5)& gkOi VC.ILGG [C .! s n! FQ .Z& vxOv J; ' Xg .Z& ;u5R v V@OY. [C 5)B VC.ILGL \O [C; gkO) pg JdQ .Z& ;u5R v x; ' gkKOY. O* LsG [C(5)H[C); Y% [C(b; [C)! 5)R v V@OY.[C; 5)Q D b; [C; gkOi b; [C!B 8gOv Jv8 5)H [CO*! 8gOB .Z& %CR v V@OY. 9& in, Han [C; Tahoma [C! 5)Oi Tahoma [C!- 9n .Z& %CR v V@OY.d: 9v:.& x m}Oi n5 && YC 3!X OB I"Q .&!}R v V@OY. 9v:.& m}O) }Q .&& XaOv xR v5 V@OY.9v:.& m}Ob ! D;MG dQ %LM& iwOJC@.ANCz1. Windows Start :!- G ; ,/OJC@.2. -b sZ! Regedit& TBQ Y .N; ,/OJC@.3. 9v:. m}b!- Y 9v:. PbN L?OJC@: HKEY LOCAL MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\FontLink\SystemLink4. L' qO!- 5)OAB Tahoma [C; 6l: @%J \ N ,/Q Y v ; ,/OJC@.5. Y .Z- m} k- sZG u !- Y ; !OJC@.SimSun18030.ttc,SimSun-180306. .N; ,/OJC@.& 4 e IBM Cognos Analysis for Microsoft Excel 3!15

7. SimSun; 6OB Microsoft Sans Serif, Arial, SimSun [C! kX-5 4 6\h& ]9OJC@.8. .N; ,/O) D;M& YC C[OJC@.IBM Cognos Analysis for Microsoft Excel W:.VC.ILG; C[O) ,sLp. 8:dRG 3!& W:.R v V@OY. gkZ! Microsoft Excel; C[OE* Microsoft Excel :A9eC.& - ' IBM CognosOffice! Z?8N C[KOY. W Y gkZB IBM Cognos Analysis for MicrosoftExcel; 5)R v V@OY.C[Ob !IBM Cognos Analysis for Microsoft Excel! kQ W : GQ; gkOAiIBM Cognos Business Intelligence!- Express Authors GB Report Administrators*RG 8:xLn UOY. .ZB IBM Cognos Administration; gkO) L/Q GQ; 8:X UOY.ANCz1. Microsoft Excel; C[OE* Microsoft Excel :A9eC.& )JC@.2. IBM Cognos! 58 p ! *8*Bv .NOJC@.IBM Cognos! 58 p ! xB fl 8b :!- 58 p , IBM Cognosfor Microsoft Office& ,/OJC@.3. ?[ "; %COAi 58 p !- IBM Cognos& ,/OJC@.C[ "L *83OY. "!B IBM Cognos Analysis for Microsoft Excel! kQ 5)! wTKOY.4. ?[ "!- IBM Cognos Analysis for Microsoft Excel; ,/OJC@.?[ "G %&! IBM Cognos AnalysisN /fKOY. ?[ "! VB FL\; ,/O) ?[ " gL& /R v V@OY.16IBM Cognos Analysis for Microsoft Excel v 10.2.0:3! H;-

NO A. ;T JdQ IG bI;T JdQ IG bI: E?L RmOE* C" eV nG E { eV! VB gkZ! IT &0; gkOB % 5r; ]OY.3! 6}gG ;T JdQ IG bI3! 6}gG ;T JdQ IG bI: E?L RmOE* C" eV nG E { eV! VB gkZ! IT &0; gkOB % 5r; ]OY.Y qO!B 3! 6}g!- &xGB VdQ ;T JdQ IG bIL V@OY.v \ 0 W mI 0& gkO) 3! 6}g& vR v V@OY.Microsoft Windows!- Alt0& )% Y ?[; .EOB \ 0& )(OY.9& in, ALT SB ALT0& )% sB!- S0& )% M; GLUOY.v 3! 6}gB Microsoft Active Accessibility(MSAA)& gkUOY. L bI; kX C" eV! VB gkZ! :)0 .u RA. nM pvP : U:b& T2 gkOi -i! %CGB ;k; i; v V@OY.3! 6}g!- 08e vY %!B Windows n5 &!- 3! 6}gG ON Vd [w; v Ob 'XgkR v VB 08e \ 0! *-Gn V@OY. :)0 .u& gkOB fl "; Vk-O) Y WqG 08e YN !b %& O w n!m W :R v V@OY. m: Y 08e \ 0B L9 %X 08e& bX8N UOY. L WqG ON AYwB ON pn! {kGv J; v V@OY.% 1. 3! 6}g 08e \ 0q%?[dLv!- Y JeN L?UOY.TABdLv!- L JeN G9F)OY.SHIFT TAB3! 6}g& ]@OY.ALT F4Y 8: \hN L?UOY.ALT NL 8: \hN G9F)OY.ALT, B GB Windows 7 C:[ LsG flALT, B, B Copyright IBM Corp. 2005, 201317

% 1. 3! 6}g 08e \ 0 (hS)q%?[qO!- Y 1C8N L?UOY.F!N -l%qO!- L 1C8N L?UOY.'N -l%1CQ \ ! kQ ?[; v OE*, 1CQ 1C :dL:Yu; 1C GB 1C kRUOY.Y %!B 3! 6}g sL : h dLvG ON Vd [w; v OB % gkR v VB 08e \ 0! *-Gn V@OY.% 2. sL : h 08e \ 0q%?[sL : h ! ?GUOY.ALT AsL : h ; ENUOY.ALT DsL : h ; EN ; ' 3! 6}g& ]@O ALT XY.x w RA. nIBM Cognos for Microsoft Office 8:dR!B IBM sL : h ! p Ov JB / x w RA. n! wTKOY. IBM: L/Q &0G ;T JdQ IGbI! kX n0Q 8u5 Ov J@OY. &0G ;T JdQ IG 8B Xg x w ! .GOJC@.IBM W ;T JdQ IGIBML &xOB ;T JdQ IG! kQ Z Q 8B IBM Human Ability andAccessibility Center& 6OJC@.http://www.ibm.com/able(u "!- -2)18IBM Cognos Analysis for Microsoft Excel v 10.2.0:3! H;-

NO B. .&! XaL .&! Xa 6 8B IBM Cognos Analysis for Microsoft Excel 8:dR3! L* 3! D! }R v VB / .&& XaOB Zx8N gkR v V@OY.&! Xa.&! Xa: .&!; XaOB h{N "Y}TOY. .&! XaG q%B 9sQ kN [?Ov JB L/M .&!; XaOB f}; G0OB MTOY.&! Xa AN :G 9 x0 \h!-B .&!; O w 3mUOY. .&! 3m; kX gkZM IBM bz vx cgZB .&!G xN; #B % C[R '!&K v V@OY. L \h!-B b;{N z.L wTKOY.v .&!G usL yTOn?v np!- .&!L }UOn?v p& .&!L }UOn?v n2 sB!- .&!L }UOn?v .&!; gvR v V@On?Xg z.! kQ @d; kX O]{8N .&!! kX 3mGB%, LN NX .&!G Xa%; 5bR v V@OY.&!G usL yTOn?.&! 3m; C[R ' !e m.Q z.: :.&!L yTOn?;TOY. L z.: #\X 8Lv8, .&!G u 8 {N W2; [:OB nn } {N z.8N *- v V@OY. Xg z.!B Y L wTKOY.v )! GB yL .&!; 8mUOn?v @y Ze W CvB yTOn?v n;T C:[! eV! }UOn? 9& in, .&!L gA, v,, f9, :I zO GB CY#v J: azTOn?np!- .&!L }UOn?.&!L }OB '!& G0OB ML Ws ,n M: FOv8 .&!; XaOB% !e dQ \h O*TOY. YvG bz h L 8m W eV } 8:dR#! 8gR v V@OY. W.v), p:) W esLvB .&!; 6gR ' mARn !v 8:dRO STOY. Copyright IBM Corp. 2005, 201319

Y z.; kX .&! h ; 80R v V@OY.v .&!L O*G C'{ GB n5 &! {% MLE* )/ C'{ GB n5 &!- O]{N MTOn?v vg /f W 8:L vxKOn?O*G h !- .&!L 8mGi .&!L ]eC Xg h !- }OB M: FUOY. .&!L }OB '!& D0OB Q f}: Xg /f; LXOB MTOY. n5 & W v , pg XgGB RA. n W v , Oe n& qTO) C#; .m .&! /f; O w 3mOJC@. vxGB /f ;!- G Om VBv .NOJC@. YvG .&!L T2 G O5O h9Gv JE* T2 O w W:.Gv J: RA. nG q#/ 9'!- qTI v V@OY.p& .&!L }UOn?/w O8: }N fl! eV& / OB L%.G Z Q 8SsN; 3 OJC@. *fb8N [wO) 8SsN; !e 1T 3 R v V@OY. @y! 8mH C#! C[Om(P.Jnv !IQ .w) gk !IQ NW W 8& kX *fb8N [wOJC@. O]{8N x\ NW!- GB 9 x0 GI:/n L%.! QX-8 6gX UOY.L%.G Z Q 8SsN; 3 OAi Y z.! @dOJC@.v .&!L 7 GB cG / C#!8 }UOn?v s6* ZV .&!L }UOn?v L%.G Cv:! .&!L 8mGB C#nv Ln}On?v RA. n* Oe nG 3! GB wW9Le n /fL /fH LD .&!L}UOn?n2 sB!- .&!L }UOn?.&!L }OB C#! G GB C:[ W VC.ILG; FB M: .&! XaG dQ NPTOY. L/Q /f! kQ z.; kX .&!G xN; D0R v V@OY.v ?OQ [wL v I ' Ws .&!L }UOn?v .&!L }OB % L%.G / Cv:! }X UOn?v b8 VC.ILG! ?C! eV! }UOn?L/Q / G z.! @dOi .&!L }OB /f; 3mOm S:; s C0B % 5rL KOY. )/ .&!L ?C! }R v V8GN .&!L ]eC CGvB J@OY.20IBM Cognos Analysis for Microsoft Excel v 10.2.0:3! H;-

.&!; gvR v V@On?gvR v VB .&!: 1T XaKOY. W/* gvR v VB .&!!B \!L V; v V@OY. .&!L dQ qnO: 5b; "!B fl YC }OvJF UOY. !IQ fl W:. GB 3 /f!- .&!; YC [:OB%, O]{8N LN NX 6g /,:z &n! u &xKOY. Y z.! @dOJC@.v .&!; W:. C:[!- YC [:R v V@O!?v )/ gkZ GB VC.ILG!- ?OQ / G .&!L }UOn?v \O mI, mI . GB / VC.ILG; G O) .&!; YC [:R vV@On?:vD b] %LM#L: Kv;IBM vD b] %LM#L:& KvO) .&!! kQ Xa%; #; vV@OY. gk !IQ Zx, vx 58 W Kv f}; gkO) Xg az&V{-R v V@OY.vD b] %LM#L: KvIBM vD b] %LM#L:& KvO) .&!! kQ Xa%; #; v V@OY. gk !IQ Zx, vx 58 W Kv f}; gkO) Xg az& V{-R vV@OY.L B:) 8 8 M!- IBM Cognos& KvO) /kQ 8& #; v Vv8, .&!; XaOAi 8 M ' \N!- 6gX R v5 V@OY.ANCzvD b] %LM#L:!- JdQ 8& KvOAi Y "Y} O* Ls; gkOJC@.v IBM Support Portal(IBM Cognos Business Intelligence Support Portal)(u "!- -2); gkO) JdQ AYw& #8JC@.IBM Support Portal: pg IBM C:[, RA. n W -q:!- pg bz vx 58 W 8G kUH S } D 8bTOY. IBM Support Portal; kX Q'!!- IBM Z vx w.z.@! W :UOY. .&! 9fz ESQ .&!Xa; 'X JdQ 8 W Zx 'VN dLv& Bb v V@OY. L 58! kQ %p qp@(https://www.ibm.com/blogs/SPNA/entry/the ibm support portal videos)(u "!- -2)& 8m IBM Support Portal; wNO B. .&! Xa21

vOJC@. L/Q qp@!-B IBM Support Portal! kX R3Om .&! Xa W b8 Zx; vOg w24 L?, ! W h&& kX dLv& B B f}; 8)]OY.v Y G ! bz Zx O*& gkO) IBM Cognos! kQ AYw& KvOJC@.– IBM Cognos BI APAR(.&! 8m-)(u "!- -2)– IBM Cognos BI Support % gL.(u "!- -2)– IBM Cognos w3 W ?BO (u "!- -2)v IBM 6:.le Kv; gkO) AYw& KvOJC@. ibm.com dLv!- Kv Je! Kv .Z-; TBO) IBM 6:.le Kv; gkR v V@OY.v Google, Yahoo GB Bing nG \N Kv #x; gkO) AYw& KvOJC@. \N Kv #x; gkOi az! ibm.com 5 N \NG 8! wTI !I:L u 9@OY. W/* ibm.comG mNW, w3 W ::Wl!- IBM &0! kQ /kQ .&! Xa 8& #; v V@OY.A: IBM &0! kQ 8& #B fl Kv!- :IBM; W &0G L'; wTOJC@.v gW !.@b.&!; XaOB % &0 v gW; gkR v V@OY.ANCzv gW; #F- 3!OAi Y ; v OJC@.1. JdQ v gW; G0OJC@(Fix Central)(u "!- -2)(http://www.ibm.com/support/fixcentral/).2. v gW; YnNeOJC@. YnNe .-& -m :YnNe P0v; G!- 5)& ,/OJC@.3. YnNe .-G :3! vCgW; }! VB vCgW! {s v gW; {kOJC@.4. v gW W b8 IBM vx 8! kQ L O K2; EV vEO5O 86OJC@.IBM vx M! .GIBM vx M!-B RA. n z.z CX- 5r; rb 'X YgQ IBM Zx! kQ W :& &xUOY.22IBM Cognos Analysis for Microsoft Excel v 10.2.0:3! H;-

C[Ob !bz k. nG b8 Z 5r; IG; gkO) @d GB VgG; #F; D IBMvx M! .GR v V@OY. IBM vx M! .GOb ! 8g! 0: IBM/v8v h L Vn Om IBM! .&!; &bOB % JdQ GQL Vn UOY. GQ Y 8& XqX UOY.v m4 D0 x#v vS{N -q: d;N fl -q: d; x#v ,t !IQ - x#v gk N RA. n v v gk N n5 /fG v v .&! } ; ' v Lx [w! kQ 3mv %CGB pg @y CvG .Q %vv .&& XaOb 'X v Q \hgk !IQ vx / ! kQ 8B RA. n vx ZeOG vx w.z.@ V&& 6OJC@(u "8N -2).ANCzY \h& OaO) .&!z CX- IBM vx M! .GOJC@.1. .&!; GOm hf 8& v}Og .&!G I"5& G0OJC@. Z Q 8B RA. n vx ZeOG IBM vx rb V&& 6OJC@(u "8N-2).2. x\ 8& v}OJC@.3. Y f} O*N IBM vx M! .&!; &bOJC@.v ISA(IBM Support Assistant) gk: L bI; gkO) IBM; kQ Z q: d;; -m w%L.Og 8JC@. v}H 8B -q: d;! 7NRv V@OY. W/i P.; u ESw 3.Om Xa C#; YTOY.v IBM Support Portal; kQ BsN(u "!- -2): -q: d; dLvG q: d; w24!- pg -q: d;; -m, w%L.Om .NR v V@OY.v -: ,tR v VB -x#B Directory of worldwide contacts(u "!-2) % dLv& 6OJC@.az&bOB .&!L RA. n aT GB )tGE* N .Q .-N NQ MN flIBM vx M!-B APAR(Authorized Program Analysis Report); [:UOY.APAR!-B .&!; Z w 3mUOY. IBM vx M!-B !IOi APARLNO B. .&! Xa23

P.Gn v gWL I 'nv 8vR v VB SC Xa%; &xUOY. IBM:EO IBM vx M % gL.! P.H APAR; TCO) ?OQ .&& fhOBgkZ! ?OQ Xa%!- 5r; ; v V5O UOY.IBMz 8 3/.&!; x\OE* D0OAi IBM vx M! Xg C:[G %LMM 8& &xX UOY.Y% fl! IBM vx M!-B .&! G0! gkR 58* /?. & gkZ!T &xR v V@OY.IBM vx M! 8 [.&!; XaOB % I.B C#; YLAi IBM vx M! { W x\ 8& [R v V@OY.ANCzIBM vx M! x\ 8& &bOAi Y ; v OJC@.1. .&! . 9Ze(PMR)& )JC@. IBM Support Assistant(u "!- -2) GB IBM -q: d; 58(u "!- -2)& gkR v V@OY.2. JdQ x\ %LM& v}OJC@. x\ %LM& kX PMR; XaOB % I.B C#; YO v V@OY. x\ %LM& v?8N GB Z?8N v}R v V@OY.3. TRSMAIN GB AMATERSE ANW%; gkO) DO; P OJC@. IBM!- IBM Cognos BI C:[8N a /?. & YnNeQ D TSO RECEIVEmI; gkO) /?. & 3!OJC@.4. IBM! DO; [OJC@. Y f} O*& gkO) IBM! DO; [R v V@OY.v -q: d; 58(u "!- -2)v %X %LM wNe f}: FTP, HTTPv 8H %LM wNe f}: FTPS, SFTP, HTTPSv L OIBM Cognos &0; gkOm ServiceLink / IBMLink& gkO) PMR; &bOB fl L O GB FTP& gkO) IBM vx M! x\ %LM& [Rv V@OY.pg Xg %LM 3/ f}: IBM vx gL.(u "!- -2)! 3mGn V@OY.24IBM Cognos Analysis for Microsoft Excel v 10.2.0:3! H;-

IBM vx M!- 8 vEIBM bz vx cgZ! gkZ!T x\ 58 GB b8 DO; YnNeO5O d;OB fl5 V@OY. L/Q DO: FTP& gkO) YnNeR v V@OY.C[Ob !IBM bz vx cgZ! DO; YnNeOB % gkR b; -vM W :R .Q p:d. W DO L'; &x Bv .NOJC@.ANCzIBM vx M!- DO; YnNeOAi Y ; v OJC@.1. FTP& gkO) IBM bz vx cgZ! &xQ gL.! ,aOm Mm8N NWNOJC@. L O VR& qPx#N gkOJC@.2. {UQ p:d.N L?OJC@.a. /fromibm p:d.N L?OJC@.cd fromibmb. IBM bz vx cgZ! &xQ p:d.N /fOJC@.cd nameofdirectory3. Xg G! YLJ. pe& gkOJC@.binary4. get mI; gkO) IBM bz vx cgZ! v Q DO; YnNeOJC@.get filename.extension5. Xg FTP G; aOJC@.quitvx w%L. 86gkOB IBM &0! kQ dQ 8& hS vEOAi w%L.& 86R v V@OY.L B:) 8w%L.& vEO5O 86O) / Q vx 58 W ZxG dQ bz 8 W w%L.& vER v V@OY. 2!v "Y} O*& gkO) w%L.& 86R vV@OY.RSS Ge W g8 E 86Y RSS Ge W g8 E 86; IBM Cognos BI!- gkR v V@OY.v developerWorks w3! kQ RSS Ge(u "!- -2)NO B. .&! Xa25

v Cognos Support k.O mNW! !T(u "!- -2)v IBM Cognos Business Intelligence vx gL.! kQ RSS Ge(u "!- -2)RSS vx IBM % dLv qO W C[Ob \h& qTO) RSS! kQ O]{N 8& 8Ai IBM Software Support RSS Ge(u "!- -2) gL.& f.OJC@.; K2; K2; kX IBM &0G vx w%L.& 86R v V@OY. L O xm& EO GB EV vEO5O v R v V@OY. %, y.M A, &0 C!C(GB f8), YnNe W esLv n vEOAB 8G / ; v R vV@OY. ; K2; kX gkZG d8gW! !e BB f}z 8& vEOAB &0; gkZ GOm PyR v V@OY.ANCzvx w%L.& 86OAi Y ; v OJC@.1. &0 RSS Ge& 86OJC@.2. ; K2; 86OAi, IBM Support Portal(u "!- -2)N L?O) K2 w24G ; K2; ,/O) C[OJC@.3. ; vx! LL nOH fl NWNOm W Y \hN GJYJC@. nOGvJ: fl v] nO; ,/OJC@. L O VR& IBM IDN gkO) nO gD; OaOm &b; ,/OJC@.4. ANDO m}; ,/OJC@.5. &0 !& ,/Om &0 Wm.(9: RA. n)& 1COJC@.6. N x0 qO!-, &0 WU.(9: %LM W 8 .)& 1COJC@.7. x0 qO!- &0 -j WU.(9: %LM#L:)& 1COJC@.8. w%L.& vEOAB &0; 1COJC@.9. &0 !& ,/OJC@.10. CH pg &0; 1CQ D ANDO m} G!- L O 86; ,/OJC@.11.

IBM Cognos Analysis for Microsoft Excel . IBM Cognos Analysis for Microsoft Excel Microsoft Excel . IBM Cognos Business Intelligence, IBM Cognos for Microsoft Office, IBM Cognos PowerPlay IBM Cognos .