DB2 商业智能教程


IBM DB2 (C}]b L5G\LL f> 7  IBM DB2 (C}]b L5G\LL f> 7  Z9C>JOT0|'VDz7.0,qXDAZ1493D:"bBn;PD;cE"# KD5|, IBM D({E"#KD5(}mI$-ia)"\f((#$#KvfoP|,DE";|(NNz7#$, R>Vaa)DNNyw<;&gKbM# (} IBM zmrZz>X~qD IBM V'z9,r_(}Bg 1-800-879-2755(Z@z)r 1-800-IBM-4YOU(ZSC s)4):vfo# 1z"ME"x IBM s,4Zh IBM G(P(,IBM TZzya)DNNE",P({TNN}O*J1D==9Cr "",x;XTzP#NNpN# © Copyright International Business Machines Corporation 2000. All rights reserved. ?< XZ>LL.............v LLPDL5Jb ..........v *<.0 .............vi >LLP9CD<( .........viii `XE" .............viii k IBM *5 ............ix z7E" ............ix Z1?V }]kb .........1 Z1B PX}]kb .........3 24G}]kb? ..........3 NLEv .............3 Z2B 4(Vb}]b .........5 4(}]b .............5 r ODBC "a}]b .........6 ,S?j}]b ...........8 zUEvK24 ...........9 Z3B /@4}] ..........11 i4m}] ............11 i4D~}]............12 zUEy4PDYw .........13 Z4B (eVb2+T ........15 XBuLL >LLa)KdMDL5G\NqDKTKD8<#|V*=vw*BZ: }]kb '0>ZPDNLTKbgN9C0DB2®XFPD1M0}]VbP D14(Vb}]b"F/Md;4}]T0+}]4kVb?j}] b#jI>ZI\h*s<=!1D1d# `,}]Vv '0>ZPDNLTKbgN(}*zVv&m (OLAP) ZI\h*s<;! 1D1d# >LLP HTML M PDF =Vq=#zITS0}]VbPD1"OLAP Starter Kit r0E"PD1i4>LLD HTML f>#PDF D~Z0DB2 vfo1 CD-ROM O# LLPDL5Jb zG3+>D}]b\m1,C+>F* TBC:The Beverage Company#C+> Fl*z[xd{P5D{O#Fq?Ek*T1d*y!4zY"VvM$b wXxyP[vz7Dz[Uk#zQ-("Kz[}]Djv(*z[}]4(;v}]Vb#}]VbG;v|,}]D}] b,b)}]Q-}a6Rd;*JOTq=#zDNqG4(K}]Vb# zF.TVb9CGM#=hF#GM#=GI`v,HmM;vB5miID (EhF#,HmhvK5qDwv=f#B5m|,PXC5qDB5rH ?#Z>LLP,GM#=|(BP,: v z7 v P! v =8 v 1d B5mPDB5|(;N1dZDz7):iv# © Copyright IBM Corp. 2000 v >LLPD0}]kb1?Vf_zgN(eKGM#=# zDB;vNqG4(C4Vv}]D OLAP &CLr#WH4(;v OLAP # MM*V*,;sC|G4(&CLr#>LLPD0`,Vv1?Vf_zg N4( OLAP &CLr# *<.0 *<.0,Xk20k*9CDLLPDBZyf0Dz7: v TZ0}]kb1;Z,Xk200DB2 XFPD1,||(0}]VbPD1 \mSZ#zIZBPYw53O200}]VbPD1\mSZ:Windows NT®"95"98"AIX®M0Solaris Yw731#9Xk20 DB2 ~qwMVb~ qw,|G|(Z0DB2 (C}]b ®1DdM20P#+G,Xk+Vb~ qw20Z Windows NT O# g{+ DB2 ~qw20Z;,ZVb~qwr0}]VbPD1\mSZD$ w>O,rXk+ DB2 CAE 20Z,;$w>Or20Z0}]VbPD1 \mSZO# PX200DB2 (C}]b1Dji,N{zy9CDYw53D DB2 (C} ]blYkE# g{zP0DB2 Vb\mLr1,rzIT!q200E"?<\mLr1#g {z;P0DB2 Vb\mLr1,rx}Z833D:Z14B `?VbPD}] T)nUC'9C;MZ873D:Z15B 9CL5*}];# PX200DB2 Vb\mLr1Dji,kND DB2 Vb\mLr208O# v TZ0`,}]Vv1;Z,Xk20 DB2 M OLAP Starter Kit#OLAP M' zv'V Windows# Xk20>LL#Z DB2 Windows fP,zI+LLw*dM20D;?V4x P20#Z DB2 AIX fr0Solaris Yw731fP,zIT+>LLkD52 0Z;p# zh*y>}]4dOLL9C#>LL9C0DB2 }]kb1y>}]M OLAP y>}]# 1z20LL1,0}]kb1y>}]v20Z Windows NT O#|Xk20 ZkVb\mLr`,D$w>O,ry>}]bD6LZcXkZ\mLr$ w>OxP`?# zITZ Windows NT"AIX M0Solaris Yw731O20 OLAP y>}]# |Xk20Zk0OLAP /I~qw1~qw`,D$w>O,ry>}]bD6 LZcXkZ~qw$w>OxP`?# vi L5G\LL KLL}CK X:\sqllib ?}],dP X G20P DB2 D}/w# g{9C1!?DD~s,Xk4(y>}]b#*4(C}]b: 1. r*0Z;=h10Z# 2. %w4(y>}]b# 04(y>}]b10Zr*# 3. !q0}]kb1y>#ir"OLAP y>#ir,r=_,b!vZzk* 9CLLDD)?V# 4. %w7O# 5. g{z}Z200}]kb1y>,aP;v0Zr*,C4dkCZf!C y>D DB2 C' ID MZn# a. dkk*9CDC' ID MZn#GBC' ID MZn,r*ZsfDNL P(e2+T1+h*|G# b. %w7O# DB2 *<4(y>}]b#xH0Zr*#14(K}]b1,%w7O# g{GZ Windows NT O20y>,r+T/T ODBC "a}]b#g{GZ AIX r0Solaris Yw531O20y>,rXkK$XT ODBC "a}]b#P XZ AIX r0Solaris Yw531O"a}]bDji,N{zy9CDYw53 D DB2 (C}]blYkE# g{!qK0}]kb1y>,r4(BP}]b: DWCTBC |,LLD0}]kb1;ZyXhDYw4m# TBC_MD |,y>P0}]VbPD1TsD*}]# g{!qK OLAP y>,r4(BP}]b: TBC |,LLD0`,}]Vv1;ZyXhDa6}DMQd;Dm# TBC_MD |,y>P OLAP TsD*}]# g{,1!q0}]kb1M OLAP y>,r TBC_MD }]b+,1|,y> PD0}]VbPD1M OLAP TsD*}]# Z*}]b: XZ>LL vii 1. t/0DB2 XFPD1: v Z Windows NT O,%w*<—>Lr—> DB2 Windows f—>XFPD# v Z AIX r Sun Solaris O,dkTB|n: db2jstrt 6790 db2cc 6790b 2. 9*?}]b.;*9:DWCTBC"TBC r TBC_MD# 3. CsjR|%wC}]bD{F"%w,S# 0,S10Zr*# 4. ZC' ID VNP,dkzCZ4(y>DC' ID# 5. ZZnVNP,dkC44(y>DZn# 6. %w7O# 0DB2 XFPD1,SAC}]b# >LLP9CD<( >LLZD>P9C!"e<(4ozz+X~{kzdkDD>xp*4#} g: v K%n*Ve: %wK%—>K%!n# v VN"#irM4%D{F2*Ve: ZVNVNPdkD># v dkDD>GBPOD>}Ve: bGzdkDD># `XE" >LL|(I9C0DB2 XFPD1"0}]VbPD1M OLAP Starter Kit j IDn#{DNq#PX`XNqDji,N{BPD5: XFPD v 0DB2 XFPD1*zoz v 0M'zdC(z1*zoz v 0B~`XLr1*zoz v zDYw53D DB2 (C}]blYkE v DB2 Warehouse Manager Installation Guide viii L5G\LL v DB2 (C}]b SQL kE v DB2 Universal Database SQL Reference v DB2 (C}]b\m8O—5V }]VbPD v 0}]VbPD1*zoz v DB2 (C}]b}]VbPD\m8O OLAP Starter Kit v OLAP Setup and User’s Guide v OLAP Model User’s Guide v OLAP Metaoutline User’s Guide v OLAP Administrator’s Guide v OLAP gSmq=~C'8O 1-2-3 f v OLAP gSmq=~C'8O Excel f k IBM *5 g { P < u J b , k Z k 0 DB2 M ' ' V P D 1 * 5 . 0 4 i"4 P Troubleshooting Guide y(iDYw#>8OTzITU/D)E"T90DB2 M ''VPD1|CX*z~qavK(i# *q!E"r):NN0DB2 (C}]b1z7,k1XV'z9D IBM zm* 5,rkNNXm IBM m~-zL*5# zg{!Z@z,kBgBPdP;vEk: v 1-800-237-5511,IqCM''V v 1-888-426-4343,IKbya)D~qn? z7E" zg{!Z@z,kBgBPdP;vEk: v 1-800-IBM-CALL (1-800-426-2255) r 1-800-3IBM-OS2 (1-800-342-6672),I) :z7rq!;cE"# v 1-800-879-2755,I):vfo# http://www.ibm.com/software/data/ DB2 r,xx3a)XZBE"z75w"`5F.HHD10 DB2 E "# XZ>LL ix http://www.ibm.com/software/data/db2/library/ 0DB2 z7M~qca)XZgN):i.DE"# http://www.ibm.com/education/certify/ IBM Web >cPD0(5O$Lr1a)wV IBM z7(|( DB2) DO$bTE"# ftp.software.ibm.com Td{N="a#IZ?< /ps/products/db2 PR=PX DB2 Mm` d{z7D]>Lr"^)"E"M$_# comp.databases.ibm-db2, bit.listserv.db2-l b) Internet BEiI)C'4V[9C DB2 z7D-i# On Compuserve: GO IBMDB2 dkK|n4CJ IBM DB2 5P[3#b)[3'VyPD DB2 z7# PXgNZ@zTbDXxk IBM *5DE",N{ IBM Software Support Handbook D = < A # * f ! K D 5 , C J T B Web 3 f : http://www.ibm.com/support/,;s!qC3fW?=|D IBM Software Support Handbook 4S# ": Z3)zR,IBM Xm-zL&k{GD-zL'Vz9*5,x;Gk 0IBM 'VPD1*5# x L5G\LL Z1?V }]kb © Copyright IBM Corp. 2000 1 2 L5G\LL Z1B PX}]kb Z>ZP,z+qCKLLPD}]kb0}]kbNqDEv# 24G}]kb? |,Yw}](C}]KPU#DL5Bq)D53P|,T5qVv1PCD E"#}g,Vv1I9CPXZ;jPDDv1d"Dvxrz[KDVz7 DE"4iRl#ivrf.44Dz[#+G,g{Vv11Sf!Yw} ],aPm`Jb: v {GI\;Pi/Yw}]bD(E*6#}g,i/ IMS }]bh*9C; V(E`MD}]YwoTD&CLr#;c54,G)_Pi/Yw}]b (E*6DLr1#NE,$C}]b0d&CLrD(0$w# v Tm`Yw}]b(gxPD}]b)45,T\G#X*#53;\T4P Xpi/DC'xP&m# v ;c45,Yw}]Dq="G)5qVv19CDnQq=#}g,TVv 145,4z7"XxM>Zc\Dz[}]H-<}]PCC`# }]kbbvKBPJb#Z}]kbP,+4(JOT}]Df"b,C}] GSYw}]i!D,;sd;*CZnUC'v_DN=#}g,}]kb$ _I\SYw}]b4FyPDz[}],4PFcTc\}],"+c\}] 4kkYw}];,D}]bP#nUC'Ii/C@"D}]b(Vb),x ;a0lYw}]b# NLEv 0DB2 (C}]b1a)K0}]VbPD1,|G;vT/4PVb&mD DB2 ?~#zI9C0}]VbPD14(e*|(ZVbZD}]#;s,I9C 0}]VbPD14T/wHCVbPD}]"B# >LL|(KhC;vVbyhDn#CDNq# Z>LLP,z+: v (e;vwbx,|j6z+*LL4(DxL"TdxPVi# v *"4}](|GYw}])"(eVb4#Vb4j6zk*ZVbP9C D4}]# © Copyright IBM Corp. 2000 3 v 4(*CwVbD}]b"(eVb?j,b)Vb?jj6K*|(ZVb PD?j}]# v 8(F/4}]"+dd;*CZVb}]bDq=D==#+(e;vx L,||,S;vr`v4m"SZ.VD?vxr):Dz7D;WE"# v zI,aB5mM,HmT+,HmPD8Zk):E"iOZ;p#}g, zI\+z7,kB5m,aZ;pTmSPXgN+?vz7|0T{O) %*sDE"# 4 L5G\LL Z2B 4(Vb}]b Z>NLP,+*Vb4(}]b,"r ODBC "aC}]b# w*0 DB2 Z;=h1D;?V,zC DB2 4(K DWCTBC }]b,C}] b|,CZKLLD4}]# Z>NLP,+4(;v}]b,C}]b+|,TVbd;D4}]f>#Z Z113D:Z3B /@4}];P,zIKbgNi44}]#CLLDd{BZ +LzgNd;}]M9CVb}]b# Z>NLP,z9+KbgNr0*E=}]b4S1(ODBC) "a}]b,*E =}]b4S (ODBC) Jmng Lotus® Approach M Microsoft Access .`D$ _9CzDVb# 4(}]b ZK70P,+9C04(}]b1r<4*Vb4( TUTWHS }]b# *4(C}]b: 1. t/0DB2 XFPD1: v Z Windows NT O,%w*< —> Lr —>IBM DB2 —> XFPD# v Z AIX r Sun Solaris O,dkTB|n: db2jstrt 6790 db2cc 6790b 2. CsjR|%w}]bD~P,"!q4( —> }]b(9Cr<)#04( }]b1rZ0DB2 XFPD1P# r ODBC "a}]b ITP8V=(r ODBC "a}]b#IT9C Windows NT OD0M'zd C(zLr1"9C0|nP&mw1,r_9C Windows NT OD0ODBC32 } ]4\m11#ZK70P,+9C0M'zdC(zLr1# PX0|nP&mw1Dji,N{ DB2 Universal Database Command Reference# PX0ODBC32 }]4\m11Dji,N{0\m11PD*zoz# *r ODBC "a TUTWHS }]b: 1. (}%w*< —> Lr —> DB2 Windows NT f —> M'zdC(zL r4t/0M'zdC(zLr1#0M'zdC(zLr10Zr*# 6 L5G\LL 2. S}]bPmP!q TUTWHS# 3. %wXT#0}]bXT10Zr*# Z2B 4(Vb}]b 7 4. !qT ODBC "aK}]b#9C1!!qw*53}]4,bb6E}]T 53ODyPC'zr 0DB2 XFPD1"ay9CDC' ID M Zn# 8 L5G\LL 3. %w7O# 0DB2 XFPD1+,SC}]b# zUEvK24 Z>NLP,z4(K|,Vb}]D TUTWHS }]b#;s,r ODBC "a C}]b#ns,i$KzIT,SC}]b#ZB;NLP,z+i4Ts+ d;D4}],"+|f"ZU4(D}]bP# Z2B 4(Vb}]b 9 10 L5G\LL Z3B /@4}] Z>NLP,+/@Zy>PICD4}]#+TiI+K}]d;*CZVb DGN#=D=(# 4}]";\GTcZVvDN=9(D,|I\h*d;*|JCDN=#z +*9CD4}]I0DB2 (C}]b1mMD>D~iI#3)d{dMD4} ]PG DB2 X5m"MVS™ }]/M Microsoft Excel gSmq#1z/@C} ]1,0R}]dDX5"70P,+9C0DB2 XFPD14i4;vmD0 200 P# *i4Cm: 1. 9* DWCTBC }]bPDTs,1=4=mD~P*9# 2. %wCD~P#ZR_DAfP,a4=C}]bPyPDm# 3. iR GEOGRAPHIES m#CsjR|%wCm,;s%wy>Z]# © Copyright IBM Corp. 2000 11 n`T>CmD 200 P#P{T>ZC0ZD%?#zI\h*rRm/E\ 4=yPP,xrBm/I4=yPDP# 4. %wXU# i4D~}] Z>70P,+9C0Microsoft GB>14i4 demographies.txt D~DZ]# *i4CD~: 1. %w*<—>Lr—>=~—>GB>Tr*0Microsoft®GB>1# 2. %wD~—>r*# 12 L5G\LL 3. 9 C 0 r * 1 0 Z 4 R v C D ~ # } g , | I \ Z X:\sqllib\samples\db2sampl\dwc\demographics.txt P,dP X GzZdO20K y>D}/w# 4. !q demographies.txt D~"%wr*4i4dZ]# "b,CD~GC:E(gD#z+h*ZsfDNLPa)KE"# 5. XUC0Z# zUEy4PDYw Z>NLP,zi4K GEOGRAPHIES 4mM demographics.txt D~,|GGZ 0}]kb1y>Pa)D#ZB;NLP,z+r*A0}]VbPD1"* <(ezDVb# Z3B /@4}] 13 14 L5G\LL Z4B (eVb2+T Z>NLP,+(eVbD2+T# Z;62+TG1zr*0}]VbPD119CD"aC' ID#!\zr0DB2 XFPD1xPK"a,+0}]VbPD19G*(}+zDC' ID kVbX F}]bPDnxPHO4i$zGqP(r*0}]VbPD1\mSZ#V bXF}]bP|,f"0}]VbPD1*}]yXhDXFm#1z+Vb ~qww*0DB2 (C}]b1D;?V420,r_9C0}]VbPDXF} ]b\m10Z1,u: TZVbXF}]b'VD?vYw53,1!VbC'h*;,`MD }]bMYw53(^#PXji,N{ DB2 Warehouse Manager Installation Guide# 1!VbC'P(f!yP0}]VbPD1Ts,"4PyP0}]VbP D1&\# +G,zI\k^FT0}]VbPD1ZD3)TsDf!,"^F C'ITTTs4PDNq# }g,Vb4MVb?jP|,|G`&D}]bD C' ID MZn# zI\k^FTG)|,tP}](}g,vK}])DVb 4MVb?jDf!# *Ka)bV6pD2+T,0}]VbPD1a)K@"Z}]bMYw53 2+TD2+T53#*5V0}]VbPD12+T,I(eVbC'MVb i#VbiGVbC'0d4P&\D(^D|{Vi#VbC'MVbi;; (*k*VbXF}]by(eD DB C'M DB i`%d# }g,zIT(e;vVbC',CC'k9C0}]VbPD1D3K`T &#z9IT(eP(f!3)Vb4DVbi,"rCBVbimSBC'# BC'P(f!CiPy|(DVb4# ITZhC'wV`MD(^#Z;vVbiPIT|(NN;,`MD(^# 9ITZ`vVbiP|(,;vVbC'#;vC'ytZDyPiDiOM GCC'D{v(^# Z>NLP,z+w*1!VbC'"aA0}]VbPD1"(eBDVbC '"(eBDVbi# © Copyright IBM Corp. 2000 15 XBuPXk+ TBC_MD } ]bCwVbXF}]b,T9zI9Cy>*}]#*9 TBC_MD I*n/} ]b,XkXBTdu Lr —> IBM DB2 —> VbXF}]b\m# 0}]VbPD - XF}]b\m10Zr*# 2. ZBXF}]bVNP,dkk*9CDBXF}]bD{F# TBC_MD 3. Z#=VNP,9C IWH D1!#=# 4. ZC' ID VNP,dkf!C}]byXhDC' ID D{F# 5. ZZnVNP,dkCC' ID DZn# 6. Zi$ZnVNP,YNdkCZn# 7. %w7O# C0ZT&Zr*4,#0E"1VNaT>;)E",8>4(M(F}L D4,# 8. ZC}LjI.s,XUC0Z#TBC_MD VZGn/DVbXF}]b# t/}]VbPD Z>70P,z+S0DB2 XFPD14t/0}]VbPD1,"w*1!Vb C'"a#Z"a1,+9C TBC_MD VbXF}]b#TBC_MD D1!Vb C'MGZ4(0}]kb1y>}]b1y8(DC' ID# TBC_MD XkG|,Vb~qwD$w>OD>X}]br_Q`?D6L}] b#|9XkG|,0}]VbPD1\mM'zD$w>OD>X}]br_ Q`?D6L}]b# *t/0}]VbPD1: 1. %w0DB2 XFPD10ZPD$_ —> }]VbPD#0}]VbPD" a10Zr*# 2. %w_6# 0_610Zr*# 3. ZXF}]bVNP,dk TBC_MD,4y>Py|(DVbXF}]bD{ F# 16 L5G\LL 4. Z~qwwz{VNP,dk20KVb\mLrD$w>D TCP/IP wz{# 5. %w7O# 0_6"a10ZXU# 1zBN"a1,0}]VbPD1+9CzZ0_6"a10ZPy8(D hC# 6. Z0"a10ZDC' ID VNP,dk1!VbC' ID# 7. ZZnVNP,dkCC' ID DZn# 8. %w7O# 0}]VbPD"a10ZXU# (eVbC' Z>70P,+T0}]VbPD1(eBC'# Z4B (eVb2+T 17 0}]VbPD1{CC' ID 4XFf!#1C'"a1,+CC'DC' ID k0}]VbPD1PQ-(eDVbC'xPHO,Sxv(CC'GqP( f!0}]VbPD1#IT(}(eBDVbC'4Z(=SC'f!0}]V bPD1# BC'DC' ID ;h*TYw53rVbXF}]bD(^#CC' ID vfZ Z0}]VbPD1Z# *(eVbC': 1. Z0}]VbPD1w0ZDs`,%w\mD~P# 2. 9*VbC'Miw# 3. CsjR|%wVbC'D~P,"%w(e# 0(eVbC'1JG>r*# 4. Z{FVNP,dkC'DL5{: LLC' C{Fj60}]VbPD1PDC' ID#K{Fn$Io 80 vV{(| (UqZZ)# 5. Z\m1VNP,dkzDU{w*KC'D*5K# 6. Z5wVNP,dkTC'Dr*5w: bG*LL4(DC'# a>: IT9C5wM"MVN4a)XZVbD(eD*}]#;s,I TZVbDE"?"+"= M #)#|IT|,B._V{# 8. ZZnVNP,dkZn: password ZnXkAYPyvV{,"R;\|,Uq"La_rXbV{# a>: ITZC'JG>DK3O|DZn# 9. Zi$ZnVNP,YNdkCZn# 10. i$Gq!qKn/C'#ir# 18 L5G\LL a>: IT!{!qK#irTc]1!{C'T0}]VbPD1Df! (,x;C>}C'(e# 11. %w7OTc#fVbC'"XUJG># (eVbi Z>70P,+(e;vVbi,|+Z(xzUE4(D0LLC'1T4P Nq# *(eVbi: 1. S0}]VbPD1w0ZP,CsjR|%wVbiD~P,"%w(e# Z4B (eVb2+T 19 0Vbi1JG>r*# 2. Z{FVNP,dkBiD{F: LLVbi 3. Z\m1VNP,dkzDU{w*KBiD*5K# 4. Z5wVNP,dkTBiDr*5w: bGCZLLDVbi# 5. SICDX(PmP,%w >> TTCi!qyPX(# 0\m1X(M0Yw1X(FA!qDX(PmP#CiVZ_PBPX (# \m VbiPDC'IT(eM|DVbC'MVbi"|D0}]Vb PD1XT"wk*}]""R(eD)VbiZ4(1Tb)Ts _Pf!(# Yw VbiPDC'IT`XywHD&mD4,# 20 L5G\LL 6. %wVbC'j)# 7. SICDVbC'PmP,!qLLC'# 8. %w ># 0LLC'1FA!qDVbC'PmP# CC'VZMGVbiD;?VK# x}0Vb41M?j3T00xL13#+ZsxNLP4(b)Ts#1 4(Ts1,+Z(VbiTf!b)Ts# 9. %w7OTc#fVbC'i"XUJG># zUEvK24 Z>NLP,zr0}]VbPD1xPK"a"4(KBC'"(eKVb i#ZsxNLP,+Z(VbiTf!z+(eDTs# Z4B (eVb2+T 21 22 L5G\LL Z5B (ewbx Z>NLP,+9C0}]VbPD14(ewbx#wbxj6k_-L5x `XDxL,"+b)xLVi# }g,tz}Z9(z[MP!*z}]DVb,r(e;v0z[1wbxM ;v0P!*z1wbx#;s,+kz[`XDxLmS=0z[1wbxB f#`FX,+kP!*z}]`XD(emS=0P!*z1wbxBf# TZKLL,+(e;v0TBC LL1wbxT|,CLLD(e# NNC'r*# 2. Z{FVNP,dkKLLDwbxDL5{: TBC LL C{Fn`I* 80 vV{(|(UqZZ)# 3. Z\m1VNP,dkzDU{w*KBwbD*5K# © Copyright IBM Corp. 2000 23 4. Z5wVNP,dkCwbxDrL5w: LLwbx 9IT9C"MVN4a)XZCwbxD=SE"# 5. %w7OTZ0}]VbPD1wP4(Cwbx# zUEvK24 Z>NLP,z(eK0TBC LL1wbx#ZZ413D:Z8B (e}]d;M F/;P,+ZKwbxB(exL# 24 L5G\LL Z6B (eVb4 ZBf8vNLP,XcGZZv3D:LLPDL5Jb;P(e0P!1,H m# Z>NLP,+(eVb4,|G+*0P!1,Hma)}]DmMD~D _-(e#0}]VbPD19CVb4PD5w4f!M!q}]# +(e= vkzZ Z113D:Z3B /@4}]; Py4=D4}]`T&DVb4: LLX54 T&Z DWCTBC }]bPD GEOGRAPHIES 4m# LLD~4 T&ZKZ3FD~,ZTsDNLP,|+0kVb}]bP# tz}Z9C;v4}]b,C4}]b`TZVb~qw45G6LD,rX kZ|,Vb~qwD$w>O"aC}]b# (eX5Vb4 ZK70P,+(eF*0LLX541DX5Vb4#|T&Z DWCTBC }] bPya)D GEOGRAPHIES X5m# *(e0LLX541: 1. CsjR|%wVb4D~P# 2. %w(e# 0(eVb41JG>r*# 3. ZVb4{VNP,dkVb4DL5{: LLX54 Z{v0}]VbPD1P,<+9CK{F4m>Vb4# 4. Z\m1VNP,dkzDU{w*CVb4D*5K# 5. Z5wVNP,dkT}]Dr*5w: TBC +>DX5m © Copyright IBM Corp. 2000 25 6. ZVb4`MPmP,*zDYw53!q0DB2 (C}]b1Df>(} g,0DB2 (C}]b Windows NT f1)# 7. %w}]bj)# 8. Z}]b{VNP,dk DWCTBC 4w*om}]bD{F# 9. ZC' ID VNP,dk;vTC}]b_Pf!(DC' ID# 9CzZZ53D:Z2B 4(Vb}]b;P4(y>}]b1y8(DC' ID# 10. ZZnVNP,dkZn,+|w*+f!}]bDC' ID DZn# 26 L5G\LL 11. Zi$ZnVNP,YNdkCZn# 12. %wmMS;vxH0Z#wk}LI\*(;c1d# jIwk.s,0}]VbPD1+ZICDmMSywkD Ts# 15. SICDmMS# Z6B (eVb4 27 GEOGRAPHIES mFAy!qDmMS# 28 L5G\LL 0LLVbi1FAy!qD2+TiPmP# S\JG>PDd{5#PXb)5Dji,N{*zozPD:Vb 4;# 20. %w7OT#f|D"XU0(eVb41JG># (eD~4 ZK70P,+(eF*0LLD~41DD~Vb4#|T&Zf0}]k b1y>;pa)D0KZ3F1D~#Z>LLP,ZVb4P+;(e;v D~,+GzITZVb4P(e`vD~# *(e0LLD~41: 1. CsjR|%wVb4D~P# 2. %w(e# 0Vb41JG>r*# 3. ZVb4{VNP,dkVb4DL5{: Z6B (eVb4 29 LLD~4 4. Z\m1VNP,dkzDU{w*CVb4D*5K# 5. Z5wVNP,dkT}]Dr*5w: TBC +>DD~}] 6. ZVb4`MPmP,%w>XD~# D~kLL,120ZzD$w>O#0>X1zm>XD~# 7. %wD~j)# 8. CsjR|%wD~PmPDUWx,"%w(e# 30 L5G\LL 0(eVb4D~1JG>r*# 9. ZD~{VNP,dkTB{F: X:\Program Files\sqllib\samples\db2sampl\dwc\demographics.txt dP: v X G20Ky>D}/w#KnGKZ3FD~D76MD~{# v sqllib G20K0DB2 (C}]b1D?<# D~{;(;\|,Uq#Z UNIX®O,D~{GxVs!4D# 10. Z5wVNP,dkTD~Dr*5w: XZz[xrDKZ3F}] Z6B (eVb4 31 11. %wN}j)# 12. SD~`MPmP,!qV{# 13. ZVN(g{VNP,%w:E# }gzZNLZ113D:Z3B /@4}];Py{=D;y,D~GT:E w*(g{D# 14. e}Z;P|,P{#ir# D~P;|,P{# 15. %wVNj)# 0}]VbPD1A!zZ0Vb4D~13Oy8(DD~#|(eyZ D~PDVNDP,"ZVNPmPT>P(e#|ZD~$@xT>y> }]#n`T> 10 Py>}]#zITv/i4yPy>}]# 16. +w COL001 P{T|DCP{# 17. *CPdkB{F: STATE 18. 4 Enter |# 19. X4=h 16 ==h 18,TcX|{d{P#+ COL002 X|{* CITY, x+ COL003 X|{* POPULATION# 32 L5G\LL 20. %w7O# 0D~1JG>XU# 21. S0Vb41JG>P,%w2+Tj)# 22. !qLLVbi,TZ(xzDC' ID T4(9CKVb4D=h# 23. %w >#0LLVbi1FAy!qD2+TiPmP# 24. %w7OT#f|D"XU0Vb41JG># zUEvK24 Z>NLP,z(eKX5Vb4MD~Vb4#z+ZZ413D:Z8B (e} ]d;MF/;P9Cb)4,Tc8>b)4rz*0TBC +>1(eDGM# =D LOOKUP_MARKET ,Hma)}]# Z6B (eVb4 33 34 L5G\LL Z7B (eVb?j Z>NLP,+(eVb?j#Vb?jj60}]VbPD1*T}]Vb9 CD}]bMm#(#,Vb?jPy(eD?jmMGGM#=PD,HmM B5m#;x,Vb?j9I\|(CZ}]d;DPd?jm# Z>NLP,+(e0LL?j1Vb?j,|GzZZ53D:Z2B 4(Vb} ] b ; P 4 ( D V b } ] b D _ - ( e # Z V b ? j Z , + ( e DEMOGRAPHICS_TARGET ?jm#K?jmG+0KZ3F1D~0kVb} ]bPDa{# Z3)ivB,IT9C0}]VbPD14zIyZ SQL D?jm,x;T: (e?jm#0P!1,h* GEOGRAPHIES mD?jm,+Q|k DEMOGRAPHICS_TARGET ?jm,STzIF* LOOKUP_MARKET D0P !1,Hm#ZB;NLP,0}]VbPD1+zI GEOGRAPHIES ?jmM LOOKUP_MARKET m# (eVb?j Z>NLP,+(e0LL?j1Vb?j,|GzZZ53D:Z2B 4(Vb} ]b;P4(D TUTWHS }]bD_-(e# *(eVb?j: 1. CsjR|%wVb?jD~P# 2. %w(e# 0Vb?j1JG>r*# 3. ZVb?j{VNP,dkVb?jDL5{: LL?j 4. Z\m1P,dkzDU{w*CVb?jD*5K# 5. Z5wVNP,dk}]DrL5w: TBC +>DVb 6. ZVb?j`MPmP,*zDYw53!q0DB2 (C}]b1# 7. %w}]bj)# 8. Z}]b{VNP,dk}]b{: TUTWHS © Copyright IBM Corp. 2000 35 9. ZC' ID VNP,dkzDC' ID,+|w*+Szmcf!}]bDC ' ID# 10. ZZnVNP,dk;vZn,+|w*+f!}]bDC' ID DZn# 11. Zi$ZnVNP,YNdkCZn# S\C3Od`X~D1!5#PXX~Dji,N{*zozPD:Vb ?j - VNMX~,}]b3;# 12. %w2+Tj)# 13. !qLLVbiTcZ(zDC' ID \;4(9CKVb?jD=h# 14. %w ># 0LLVbi1FAQ!qD2+TiPm# x}0XT13#PXC3OD!nDji,N{*zozPD:Vb?j - VNMX~,0XT13;# 15. %w7O#f|D"XU0Vb?j1JG># 16. 9*Tsw,1=4=LL?jVb?jBDmD~P*9# 17. CsjR|%wmD~P,"%w(e# 36 L5G\LL 0(eVb?jm1JG>r*,zMIT(e DEMOGRAPHICS_TARGET ?jmK# 18. Zm#=VNP,dkC' ID, Z53D:Z2B 4(Vb}]b;PDV b}]bMGTCC' ID 4(D# 19. Z0m{1VNP,dk?jmD{F: DEMOGRAPHICS_TARGET r*z}Z1!mUdP4(m,yT,ITx}mUdMw}mUdV N# 20. Z5wVNP,dkmD5w: wz[xrDKZ3FE" 21. ZL5{VNP,dkmDL5{(C'ImbD5wT{F): KZ3Fm 22. i$Gq!qK0}]VbPD14(Dm#ir# 1KP0k0KZ3F1}]D=h1,0}]VbPD1+4(Km# Z7B (eVb?j 37 1zk*0}]VbPD14(?jm1(}g,1?jmG SQL =hDa {1),9CK!n#tz}Z9CQ-(eD?jm,re}K#ir# 23. i$Gq!qKZh+C#ir# K#ir8(P(f!}]bDNNK:CmG*wvA0OLAP /I~qw1D, HmrB5m#PXwvA0OLAP /I~qw1Dji,N{Z993D:Z 16B S0}]VbPD1Z4(GM#=;# x}C3ODd`X~# PX|GDji,N{*zozPD:(eVb?j m;# 25. %wPj)# 26. CsjR|%wPmPDUW&# 27. %wmS# 4rPmPmSK;P,"RzI(e CITY P,CPGmDX|V5# 28. %w{FP,"dk CITY# 29. Z}]`MPP,i$Gq!qK CHAR# 30. %w$HP,"dk 50# x}+HM!};P,r*|G;JCZ!}}]# 31. e}I*UP,r*?;P#ir# x}4F0M4FsP#PXb)PDji,N{*zozPD:(eVb ?jm;# 33. ZL5{VNP,dk City# 34. X4=h 26 A=h 33,T(emPDd`P: U{ }]`M $H JmU5 L5{ STATE CHAR 50 G 4, POPULATION INTEGER N/A q KZ 38 L5G\LL x}JG>Dd`?V#+9C0DB2 XFPD14Zom?jmO(ewX |VMb?X|V,TcVbDnUC'IT+b)X|VCZ,S# 35. %w7O# 0m1JG>XU#0KZ3F1m;mSZQ!qDmPmPDmD~P Bf# zUEvK24 Z>NLP,z(eK_P;v?jmDVb?j DEMOGRAPHICS_TARGET# ZZ413D:Z8B (e}]d;MF/;P,+*KVb?jzI?jm,|( GM#=D LOOKUP_MARKET ,Hm# Z7B (eVb?j 39 40 L5G\LL Z8B (e}]d;MF/ Z>NLP,+(e0}]VbPD1gN*}]VbF/}]0+}]d;* dq=#WH,z+(e;vxL,CxL|,d;MF/xLPD;5P= h#;s,+8(**VbxPd;D4m#ns,+(e9CTB=V;,d ;=(D}]d;=h: v +CLr4Q}]0k=Vb}]bP# v +!q4}]"+mk SQL od`,# XpX,z+(e0LLP!1xL,CxL4PBP&m: 1. +0KZ3F1D~0k=Vb}]bP# 2. S GEOGRAPHIES mP!q}],"4(?jm# 3. ,S0KZ3F1mM GEOGRAPHIES ?jmPD}]# nUa{G LOOKUP_MARKET ?jm# (exL ZK70P,+*0LLP!1xL(exLTs# *(exLTs: 1. S0}]VbPD10Z,9*wbxw# 2. 9* TBC LLwbx,CwbxGZZ233D:Z5B (ewbx;P(e D# 3. CsjR|%wxLD~P,"%w(e# 0(exL1JG>r*# 4. Z{FVNP,dkxLD{F: LLP! C{Fn$I* 80 vV{,RGxVs!4D#C{FDZ;vV{XkG V8}V#Z"DP,;\+ & CwWvV{#KVNGXhD# 5. Z\m1VNP,dkzDU{w*xL(eD*5K# 6. Z5wVNP,dkxLD5w: 4( LOOKUP_MARKET mDxL 7. %w2+Tj)# © Copyright IBM Corp. 2000 41 8. ZIC2+TiPmP,%wLLVbi,|GZZ193D:(eVbi; P(eD# QxLmSA2+Ti+Z(iPDC'(KivP*z)r*Ts,"+ TsmSACxL# 9. %w ># 0LLVbi1MFAQ!qD2+TiPmP# 10. %w7O# 0(exL1JG>XU# r*xL ZK70P,+r*xL,TczITZVbP(eDVb4DPm# 3. 9*0LLD~41Vb4w# 4. 9*D~w# 42 L5G\LL Z C w N a 9 P , z & I4= X:\sqllib\samples\db2sampl\dwc\demographics.txt,dP,X G20Ky> D}/w# 5. !q0KZ3F1D~# 6. %w > T+0KZ3F1D~mSAQ!qD4mM?jmPm# *mS DEMOGRAPHICS_TARGET ?jm: 1. ZICD4mM?jmPmP,9*Vb?jw# +T>ZVbP(eDVb?jDPm# 2. 9*0LL?j1Vb?jw# 3. 9*mw# ZCPmP&I4= DEMOGRAPHICS_TARGET ?jm# 4. !q DEMOGRAPHICS_TARGET ?jm# 5. %w > T+ DEMOGRAPHICS_TARGET ?jmmSAQ!qD4mM?j mPm# Z K 7 0 D B ; ? V , h * m S GEOGRAPHIES 4 m # 1 z ( e S GEOGRAPHIES m!q}]D=h1,I8(0}]VbPD1T/zI?jm, rK;h*mS?jm# *mS GEOGRAPHIES 4m: 1. S0mS}]10Z,!q GEOGRAPHIES m# 2. %w > T+ GEOGRAPHIES mmSAQ!qD4mM?jmPm# 3. %w7OT+y!qDD~MmmSAxL# y!qDD~MmT>Z0xL#M10ZP# ns;v=h+Q0KZ3F1mM0Xm1mCw4,rKz;h**C=h 8(4#IT8(0}]VbPD1T/zIa{?jm LOOKUP_MARKET,r K;h**C=h8(?jm# +=hmSAxL VZ,h*mSC4(egN+4}]d;*?j}]D=h#Xk(e}v= h: 0kKZ3F}] bG;v DB2 Lr=h,|+}]S0KZ3F1D~0k= 0TBC V b1}]bDmP,C}]bGZZ53D:Z2B 4(Vb}]b;P4 (D# Z8B (e}]d;MF/ 43 !qXm}] bG;v SQL =h,|S0Xm14mP!qP# ,SP!}] bG;v SQL =h,|,S0Xm1mM0KZ3F1m,"+y,SD m4k0LLVb1}]bP# (e00kKZ3F1=h ZK70P,+(e00kKZ3F1=h: 1. Sw+e(0Zs_D$_8)P,%w DB2 Lr<{,C<{GTW?} O4DZ~v<{: ?vLr<{;vLri,|G``FLrDVi# 2. %w DB2 UDB —> 0k# LriPDLrGSLr<{6*D# 3. %wzk+=hEZ-<(0ZR_DUWxr)ODGv;C# m>C=hD<{4;mSA0Z# 4. CsjR|%wC=h# 5. %wXT# 0=h1JG>r*# 6. Z{FVNP,dk=hD{F: 0kKZ3F}] 7. Z\m1VNP,dkzDU{w*K=hD*5K# 8. Z5wVNP,dk=hD5w: +KZ3F}]0kVbP# 9. %w7O# 0=hXT1JG>XU# 10. %wNqw<{: 11. %w}]4S<{: 44 L5G\LL +9C0}]4S1<{4(eS4D~A?jm((}Z3;=hPxP d;)D}]w# 12. %w0KZ3F14D~DP?,"+sjOA00kKZ3F}]1= h# 0}]VbPD1MaZ4D~M=h.d.;u_# b8>0KZ3F14D~|,C=hD4}]# 13. %w00kKZ3F}]1=hDP?,"+sjOA0KZ3Fm1?j m# b8>0KZ3Fm1?jm|,C=hD?j}]# 14. CsjR|%wC=h# Z8B (e}]d;MF/ 45 15. %wXT# 0=h1JG>r*# 16. %wN}j)# 17. S0k==PmP,%wf;# S\C3ODd`1!5# r* Load Lr;9CP3d4zI?jm,yTzITx}0P3d13# Load Lry]4D~zI?jm# 46 L5G\LL 18. S\0&m!n13OD1!5# PXK3OD5Dji,N{*zozPD:+}]0kmP;# 19. %w7O# 0=h1JG>XU# (e0!qXm1=h ZK70P,+(e0!qXm1=h: 1. Sw+e,%w SQL <{: 2. %wzk+=hEZ-C=hD<{4;mSA0Z# 3. CsjR|%wC=h# 4. %wXT# 0=h1JG>r*# 5. Z{FVNP,dk=hD{F: !qXm}] 6. Z\m1VNP,dkzDU{w*C=hD*5KU{# 7. Z5wVNP,dk=hD5w: Z8B (e}]d;MF/ 47 SVb4P!q0Xm1}] 8. %w7O# 0=h1JG>XU# 9. %wNqw<{: 10. %w}]4S<{: 11. %w0Xm14mDP?,"+sjOA0!qXm}]1=hDP?# 0}]VbPD14.;u_,|8>0Xm14m|,C=hD4}]# r*z+8(0}]VbPD1*4(?jm,yT;h*+?jmkC= h4S# 12. CsjR|%w0!qXm}]1=h# 13. %wXT# 0=h1JG>r*# 14. %w SQL odj)# 15. %w9( SQL T(}9C0SQL (zLr1r<49( SQL,+ay]z ZCrK GEOGRAPHIES# 18. %wPj)# Z8B (e}]d;MF/ 49 19. %w >>,T+0Xm1mPDyPPmSAdvPm# 20. %w4ij)Ti4zUE9(D SQL od# 21. %w7O# 50 L5G\LL 0SQL (zLr1XU#zUE9(D SQL odT>Z0SQL od13O# 22. %wbTTbTUEzID SQL# 0}]VbPD15X SELECT odDy>a{#b)a{&Ckz/@0X m14mDy>}]1ZZ113D:Z3B /@4}];PqCDa{`,# 23. %wXU4XUC0Z# 24. !qy]N}4(Vb?jm#ir# !qK#ir+8(0}]VbPD1ay]Z0P3d13O8(D54 4(?jm# 25. SVb?jPm,%wLL?j# Vb?jMG+ZdP4(?jmD}]brD~53# 26. %wP3dj)# Z8B (e}]d;MF/ 51 27. i$4PGq3dA}7D?jP# 28. %w&m!nj)# 29. Znd`MPmP,%wf;# 30. i$Gq!qK4hKP#ir# S\K3ODd`1!5#PXK3OD5Dji,N{*zoz# 31. %w7O# 0=h1JG>XU#0}]VbPD1zI;v?jm ″Select_Geog_T″#r *C?jm{GlOs!4D,yT(Z}EP# 32. |D?jmD{F: a. CsjR|%w ″Select_Geog_T″ ?jm# b. %wXT# 0m1JG>r*# c. Zm#=VNP,dk IWH# d. Zm{VNP,*CmdkB{F: GEOGRAPHIES_TARGET e. Z5wVNP,dkmD5w: *0!qXm}]1=hT/zID?jm# 52 L5G\LL f. Z0L5{1VNP,dkmDhv{: Xm?j g. e} OLAP #=D;?V#ir# h. %wPj)Ti4P(e# i. %w7O#0m1JG>XU# (e0,SP!}]1=h *(e0,SP!}]1=h: 1. Sw+e,%w SQL <{# 2. %wzk+=hEZ-C=hD<{4;mSA0Z# 3. CsjR|%wC=h# 4. %wXT# 0=h1JG>r*# 5. Z{FVNP,dk=hD{F: ,SP!}] 6. Z\m1VNP,dkzDU{w*C=hD*5K# 7. Z5wVNP,dk=hD5w: +0Xm1mk0KZ3F1m`, 8. %w7O# 0=h1JG>XU# 9. %wNqw<{: 10. %w}]4S<{: 11. %w0Xm?j1mDP?,"+sjOA0,SP!}]1=h#T0K Z3F?j1mM0,SP!}]1=hX4K=h# 0}]VbPD1+.;)_,|G8>0Xm?j1mM0KZ3F? j1m|,C=hD4}]# r*z+8(0}]VbPD1*4(?jm,yT;h*+?jmkC= h4S# Z8B (e}]d;MF/ 53 12. CsjR|%w0,SP!}]1=h# 13. %wXT# 0=h1JG>r*# 14. %w SQL odj)# 15. %w9( SQL TC0}]VbPD1zI SQL#(qr,zITdkzT: D SQL#) 0SQL (zLr1r*# 16. %wmj)# 17. i$Gq!qK DEMOGRAPHICS_TARGET M GEOGRAPHIES_TARGET m# 18. %wPj)# 19. %w >>,T+yPPS0Xm1mM0KZ3F1mmSAdvPPm# 20. SdvPPm,%w DEMOGRAPHICS_TARGET.STATE# 21. %w <# DEMOGRAPHICS_TARGET.STATE P4FAICPPm# 54 L5G\LL 22. %w DEMOGRAPHICS_TARGET.CITY# 23. %w <# DEMOGRAPHICS_TARGET.CITY P4FAICPPm# 24. ; h * DEMOGRAPHICS_TARGET.STATE M DEMOGRAPHICS_TARGET.CITY P , - r G Q - Z GEOGRAPHIES_TARGET mP(eK|#+(}9C=vmPD CITY P (|G(;D)4,Sb=vm# 25. %wmS# 0mo=9(Lr10Zr*# 26. Zmo=VNP,dkTB CASE od: case when POPULATION < 9000000 then 1 when POPULATION < 15000000 then 2 Else 3 end Z8B (e}]d;MF/ 55 27. %w7O# BP4;mSAQ!qDPPm# 28. %wBPD{FVN,"dkCPD{F: SIZE_ID 29. 4 Enter |# 30. %wOFT+ SIZE_ID PF= POPULATION PDOf# 31. %w,Sj)# 32. Z GEOGRAPHIES mP,!q CITY P# 33. Z GEOGRAPHIES mP,!q CITY P# 34. %w,S# 0SQL (zLr1+Z=v CITY P.d.;u_,8>b=vmGZCP OxP,SD# 35. %w4ij)Ti4zUE9(D SQL od# 36. %w7O# 0SQL (zLr1XU# 56 L5G\LL 37. !qy]N}4(Vb?jm#ir# !qK#ir48(0}]VbPD1+y]Z0SQL od13M0P3d1 3O8(D544(?jm# 38. SVb?jPm,%wLL?j# 39. %wP3dj)# 40. i$4PGq3dA}7D?jP# 41. %w&m!nj)# 42. Znd`MPmP,%wf;# 43. !q4hKP#ir44h*KP=h# S\K3ODd`1!5#PXK3OD5Dji,N{*zoz# 44. %w7O# 0=h1JG>XU# 45. |D?jmD{F: a. CsjR|%w ″Join_Market_T″ ?jm# b. %wXT# 0m1JG>r*# c. Zm#=VNP,dk IWH# d. Zm{VNP,*CmdkB{F: LOOKUP_MARKET e. Z5wVNP,dkmD5w: P!,}] f. i$Gq!qKOLAP #=D;?V#irM,Hm%!4%# KmGdP;v+ZZ993D:Z16B S0}]VbPD1Z4(GM# =;P|(=GM#=PD,Hm# g. %wPj)Ti4P(e# h. e} CITY ID PDI*U#ir,r*ZZ713D:Z11B (e?jm DX|V;P,+QKP(eImDwX|V i. %w7O#0m1JG>XU# Z8B (e}]d;MF/ 57 zUEvK24 Z0LLP!1xLP(eK LOOKUP_MARKET ,Hm,||,}v=h: v 0kKZ3F}] v !qXm}] v ,SP!}] 58 L5G\LL ?v=hD4M?jVpG: =h 4 ?j 0kKZ3F}] 0KZ3F1D~ 0KZ3F?j1m !qXm}] 0Xm1m 0Xm?j1m ,SP!}] 0KZ3F?j1mM0X m?j1m 0iRP!1m TZKLL,1z(e?v=hDXT1,MmSK?v=hD}]4S#IT jIKNqDm;V=(G:,1mSxLPDyP=h,+b)=hk|GD 4M?j4S,;s(e?v=hDXT#0}]VbPD1TzZ0=h1J G>PI|DD=h8(1!{# (eGM#=Dd`=h(I!) zZ0;ZP4(Dm LOOKUP_MARKET GZv3D:LLPDL5Jb;D> }PDdP;v,Hm#>Zpv*GM#=9(d`,HmMB5mD=h# >ZGI!D,+G,t;jI>ZPD=h,r+;\xPBPNL: v Z713D:Z11B (e?jmDX|V; v Z833D:Z14B `?VbPD}]T)nUC'9C; v Z873D:Z15B 9CL5*}]; v Z993D:Z16B S0}]VbPD1Z4(GM#=; tkx}>Z,r*AZ633D:Z9B bTVb=h;# 1(e?vm1,Xk*Cm(eBxL#;x,z+4Fy>P(eD=h, x;G*xL(eT:D=h#=hD(eZz}Z9CD0}]VbPD1 P#14F=h1,0}]VbPD1+4FC=hy9CD4,"zI?j m# *(e0z71,Hm: 1. q-Z413D:(exL;PD=h4(eBxL#+xL|{*LLz 7# 2. S0}]VbPD1w0Z9*w,1=4=0y>z71xL*9# 3. CsjR|%w0y>z71xL# 4. %wr*# 0xL#M10Zr*# 5. CsjR|%w0!qz71=h# Z8B (e}]d;MF/ 59 6. %w4F# 04F=h10Zr*# 7. Z{FVNP,dk=h1>D{F: LL!qz7 8. ZBxLVNP,!qrdkk*+C=h4FADxLD{F: LLz7 9. i$Gq!qK4F?jm#ir# 10. ZVb?jVNP,SPm!qLL?jVb?j# 11. %w7O# =h0d4;4F=0LLz71xLP#0}]VbPD1zI`&D? jm# 12. q-Z423D:r*xL;PD=h4r*0LLz71xL# 13. i$xLGq|(BPTs: v PRODUCT 4m v 0LL!qz71=h v TARGET_PRODUCT ?jm 14. + TARGET_PRODUCT ?jmX|{* LOOKUP_PRODUCT# Td`,HmMB5mX4K}L# 60 L5G\LL , L L } L y > x L y > = h L L = h Vb?j 4m ?jm B ? jm { 1d L L 1 d I y 1 d ! q 1 d L L ! q1d LL?j TIME TARGET_ TIME LOOKUP_ TIME =8 L L = 8 y > = 8 ! q = 8 L L ! q=8 LL?j SCENARIO TARGET _SCENARIO LOOKUP_ SCENARIO B5m L L B 5m y > B 5m B5m ,S L L B 5 m , S LL?j SALES, INVENTORY, M PRODUCT _COSTS TARGET_FACT_ TABLE FACT_ TABLE zUEvK24 VZ,zQ-Z0}]VbPD1P(eKevxLT0k|G`X*D4"? jM=h: v LLP! v LLz7 v LL=8 v LL1d v LLB5m Z8B (e}]d;MF/ 61 62 L5G\LL Z9B bTVb=h Z>NLP,+(}KPzZZ413D:Z8B (e}]d;MF/;P4(D= h4nd LOOKUP_MARKET m: v 0kKZ3F}] v !qXm}] v ,SP!}] ;s+i$KP|GDa{# ZKPb)=h.0,Xk+|Ga}AbT==#ZK.0,zy4(D=h ;1&Z*"==#Z*"==P,IT|DNN=hD5w#1+=ha}A bT==1,0}]VbPD1+*C=h4(?jm#rK,Z+=ha}A bT==.s,;\xPG);aF5?jmD|D#}g,1?jmD`X= h&ZbT==1,ITr?jmmSP,+Gz;\}%?jmPDP# Z+=ha}AbT==.s,+pvXKP?v=h#ZsfDNLP,+8 (wv=h43rKP# bT00kKZ3F}]1=h ZK70P,+a}"KP00kKZ3F}]1=h#;s,+a}C}LP Dd{=h# *a}00kKZ3F}]1=h: 1. S0LLP!1}LD0}L#M10Z,CsjR|%w00kKZ3F} ]1=h# 2. %w== —> bT# ;v7O0Z+/JzGq*#fC}L#%wG# 0}]VbPD1*<4(?jm,"T>;vxH0Z#;1*H=0}] VbPD1ax&mTs,E\* XFPD4Sw0}]VbPD1 0Zr*0DB2 XFPD1# © Copyright IBM Corp. 2000 63 2. 9*Tsw,1=4=zZZ53D:Z2B 4(Vb}]b;P4(DVb} ]b TUTWHS *9# 3. 9* TUTWHS }]b# 4. 9*mD~P# Z0ZD0Z]10qP&C4=mDPm# 5. i$ DEMOGRAPHICS_TARGET mGqZCPmP# *bT00kKZ3F}]1=h: 1. S0xL#M10Z,CsjR|%w00kKZ3F}]1=h# 2. %wbT# 3. S0}]VbPD1w0Z,%w}]VbPD —> xPPDYw# 0xPPDYw10Zr*#9C0xPPDYw10Z4`X0}]VbP D1P}ZKPr$(DyP=hDxH#z&CI4=m>}ZKPD=h Dn#1=h}ZKP1,d4,*0}Znd1#1C=haxKP1,d 4,&*0I&1# PX0xPPDYw10ZDji,N{*zozPD:xPPDYw — E v;# Z=h#9KP.s,T>;v7O0Z# *i$C=hD&ma{: 1. S0DB2 XFPD1,CsjR|%w DEMOGRAPHICS m# 2. %wy>Z]# 64 L5G\LL 0DB2 XFPD1+T>mP}]DS/# T0!qXm}]1=hM0,SP!}]1=hX4>NLPD=h#0!q Xm}]1=hD?jm* GEOGRAPHIES_TABLE#0,SP!}]1=hD? jm* LOOKUP_MARKET# a}GM#=PDd`=h(I!) *4(GM#=Pd`Dm,Xka}zZ Z593D:(eGM#=Dd`=h (I!); P4(D=h#>ZGI!D,+G,t;jI>ZPD=h,r+; \xPBPNL: v Z713D:Z11B (e?jmDX|V; v Z833D:Z14B `?VbPD}]T)nUC'9C; v Z873D:Z15B 9CL5*}]; v Z993D:Z16B S0}]VbPD1Z4(GM#=; tkx}>Z,r*A Z673D:Z10B wHVbxL;# *a}b)=h,r*|,b)=hDxL,"q-=h Z633D1 ==h Z6 43D5 PD}L#z2;XbTb)=h#;x,tzkbTb)=h,2ITb T|G# a}BP=h: LL}L LL=h Vb}]b ?jm LLz7 LL!qz7 TUTWHS LOOKUP_PRODUCT LL1d LL!q1d TUTWHS LOOKUP_TIME LL=8 LL!q=8 TUTWHS LOOKUP_SCENARIO LLB5m LLB5m,S TUTWHS FACT_TABLE zUEvK24 Z>NLP,z+00kKZ3F}]1"0!qXm}]1M0,SP!} ]1=ha}AKbT==#;szKPKb)=hTcbT|G#ZZ673D :Z10B wHVbxL;P,z+wHb)=hT/KP# Z9B bTVb=h 65 66 L5G\LL Z10B wHVbxL Z>NLP,+8(0LLP!1xLPD=h+4BP3rKP: 1. 0kKZ3F}] 2. !qXm}] 3. ,SP!}] ;s,+8(00kKZ3F}]1=h+Z$(D1dKP#+(}QxLP D=ha}=zz==4$nwH# 8(=h43rKP *8(=h43rKP: 1. S0xL#M10ZP,%wNqw<{: 2. %wI&1<{(L+}7)# I&18>:;v=h+vZ|0fD=hI&KP.sE*;v=h+Z|0fD=hKPI&r'\1E*;v=h+vZ|0fD=hKP'\1E*NqwDL+}7T>Z=v=h.dD-NLDi\PyP>DNr4KP# wHZ;v=h VZ,+wH00kKZ3F}]1=hZ8(DUZM1d*r*# 2. %wwHj)# 3. S1ddtPmP,%w?j# 4. Zt/UZM1dVNP,S\1!5,410UZ,"+1d8(*101 d.s8VS# C=h+Zz!qD1d* =h&ZnUq=#Zzz==P,z+;\|D;a0l=hD&mDG)h C,}g,|DT=hD5w#PXji,N{}]VbPD\m8O# *+=ha}Azz==: 1. CsjR|%w00kKZ3F}]1=h# 2. %w== > zz# 0}]VbPD1+T>;vxH0Z#;1*H=0}]VbPD1jI& mTs,E\Lx>NL# 3. T0!qKZ3F}]1=hM0,SP!}]1=h4NrX4TO=h# zUEy4PDYw Z>NLP,z4TBNrwHKzy4(D=h,"9b)=hZ?jD10 UZM1dKP: 1. 0kKZ3F}] 2. !qXm}] 3. ,SP!}] z;s+b)=ha}=zz==T5VwH# 70 L5G\LL Z11B (e?jmDX|V Z>NLP,z+(e?jmDwX|VMb?X|VTZTsD,SP9C# *'0>NL,zXkQ-ZZ593D:(eGM#=Dd`=h(I!);P (eK,HmMB5m# Z?v?jmP,!qIC4(;j6CmPDPD;P#b+GmDwX| V#!qw*wX|VDPXk_PBPXT: v |Xk\G_P;v5#wX|VDP;\|,U5# v |Xk_P(;5#CPPDT&ZmPD?;PD?v5Xk;`,# v |D5XkGH(D#;v5v;\|D*m;v5# }g,LOOKUP_MARKET m(CmZZ413D:Z8B (e}]d;MF/;P 4()PD CITY_ID PG8(*wX|VDOCDr!Ts#r*?vGPh* ;vj6{,NN=vGPDj6{<;`,,xj6{;+I\"z|D# (inC(emDwX|V,r*(;Xj6?;Paa_Pf!DYH# Cb?X|V4(em.dDX5#ZGM#=P,b?X|V(eKB5mk d`XD,Hm.dDX5#,HmDwX|VZB5mP_PT&Db?X| V#b?X|V*sB5mPx(PDyP52fZZ,HmP#}g, FACT_TABLE D CITY_ID PI\_P(eZ LOOKUP_MARKET ,HmD CITY_ID PODb?X|V#bb6E}G CITY_ID fZZ LOOKUP_MARKET mP,qr FACT_TABLE P;fZCP# Z>NLP,z+(eZZ413D:Z8B (e}]d;MF/;P4(DBPD v ? jmD w X | V : LOOKUP_MARKET" LOOKUP_TIME" LOOKUP_PRODUCT M LOOKUP_SCENARIO#+Z FACT_TABLE ?jmP(eT&Db?X|V# (ewX|V Z > 7 0 P , + T B P ? jm( e w X | V : LOOKUP_MARKET" LOOKUP_TIME"LOOKUP_PRODUCT M LOOKUP_SCENARIO# *(ewX|V: 1. *A0DB2 XFPD10Z# © Copyright IBM Corp. 2000 71 2. Z TUTWHS }]bDmPmPRv LOOKUP_MARKET m#CsjR|% wCm,"%wDd# 0Ddm1JG>r*# 3. %wwX|Vj)#0wX|V13fr*# 4. ZICPP,!q CITY_ID w*wX|V# 5. %w > 4+ CITY_ID FAwX|VPPm# 6. +70P,+y] LOOKUP_MARKET m(8m)DwX|V4(e FACT_TABLE(Stm)Db?X|V# *(eb?X|V: 1. Z TUTWHS }]bDmPmPRv FACT_TABLE m#CsjR|%wCm, "%wDd# 0Ddm1JG>r*# 2. %wb?X|Vj)#0b?X|V13r*# 3. %wmS#0mSb?X|V10Zr*# 4. Zm#=VNP,dkzZZ53D:Z2B 4(Vb}]b;P4(Vb}] b19CDC' ID# 5. Zm{VNP,8( LOOKUP_MARKET(|G8m)# wX|VVNT> LOOKUP_MARKET DwX|V# 6. ZICPPmP,!q CITY_ID w*k(e*b?X|VDP# 7. %w > 4+ CITY_ID FAb?X|VPm# S\Z>}1MZ|B1VND1!5#PXb)VNDji,kN{*zo z# 8. + N L P , z ( e K B P ? jmD w X | V : LOOKUP_MARKET" LOOKUP_TIME" LOOKUP_PRODUCT M LOOKUP_SCENARIO#z9(eKT&ZwX|VD FACT_TABLE Db?X| V#ZZ993D:Z16B S0}]VbPD1Z4(GM#=;P,z+9Cb) X|VZGM#=P,Sm# Z11B (e?jmDX|V 75 76 L5G\LL Z12B ,$}]Vb Z>NLP,z+'0(ew}"9C RUNSTATS M REORG 5CLr0`X Vb}]b# }]byhD,$?k}]bDn/?r$w:I?1S`X#r*>LL;z IP'n/,>NLw*GTzIZ9C5JDVb}]b19CD DB2 $_M 5CLrD8O# 4(w} zI4(w}4E/VbnUC'Di/#w}G;iX|V,?;v8rmP D;vPD/O#w}G@"Zm}]DTs#}]b\mLr9(Kw}a9 "T/TdxP,$#w}(}9Cw}4(D8k44(A}]D1S76, 9CTmPDPDf!|*P'# 1z(ewX|Vrb?X|V1,M4(Kw}#}g,1zZZ713D:Z 11B (e?jmDX|V;P+ CITY_ID (e* LOOKUP_MARKET mDwX |V1,M4(KCmDw}# *4(=Sw}: 1. S0DB2 XFPD19* TUTWHS }]bPDTs,1=4=0w}1D~ P*9# 2. CsjR|%ww}D~P,"%w4( —> 9Cr<4(w}# 0w}1rf"ZCm10yZD,;mUdP# 3. Z9Cw}VNP,8(*C4XimPDw}#g{;8(w},r;4N rXimP# 4. %wVZXi"LXim#%wwHTZX(DUZM1dwHXi# `X}]b T\`XLra)KPX0DB2 (C}]b10dXFD}]D4,E","aQ z"bl#iv#CE"Z;5PlUPa),?vlUm>;v1dcD53 0d}]bD4,#zIXFlUD5JM?vlUU/DE"?# IT\`XLrU/DE"TT\d?DN=5X#b)T\d?G;i(eD *X,|GIT: v T3)Bo"zDN}xPF}(F}w),}gA!DP}# v 5X105(F?w),}g,10,SD&CLr}# v m>3)Bo"zD1d(1dAG),}g,O;v&CLrjID1d# v G),}g,}]bQDnss!# *`X LOOKUP_MARKET m: 1. S0DB2 XFPD1,CsjR|%w LOOKUP_MARKET m,"%wT\ `X—>t/`XLr# Z12B ,$}]Vb 79 0t/`XLr10Zr*# 2. 0t/`XLr10ZP>KIZm6p4PlUDT\`XLr#!q Default_for_table_level `XLr,"%w7OTt/|# Default_for_table_level G;v IBM a)D`XLr,hF*Zm6pU/kw *T\`XDE"# 3. CsjR|%w LOOKUP_MARKET m"!qT\`X—>T>`XLrn/# 0T>`XLr1JG>r*# 08Z13P>K}I`XLrU/DT\d?MIlU5XD5# Default_for_table_level `XLr? 30 kxP;NlU(0#f1y>r), x;C13O,4PBPYw: 1) "v connect to TUTWHS user userid using password,dP: v userid GZZ53D:Z2B 4(Vb}]b;P4(}]b19CD C' ID# v password GC' ID DZn# 2) "v;) SELECT * FROM userid.LOOKUP_MARKET od,dP userid G ZZ53D:Z2B 4(Vb}]b;P4(}]b19CDC' ID# c. 5XA0T>`XLr1JG>#1xPlU1,0?kA!DP1T\ d?D5+43 SQL odDn/# 5. XU0T>`XLr1JG>#CsjR|%w LOOKUP_MARKET m"%w T\`X—>#9`XLr#Default_for_table_level `XLr#9# zUEy4PDYw Z>NLP,z4(Kw}#U/K LOOKUP_MARKET mD3FE",T|x PKXi0`X#ZB;NLP,+Z(Vb}]bDC'f!Cm# 80 L5G\LL Z13B ZhC'9CVb}]bD(^ Z>NLP,+(eZhC'9CVb}]bDX(#Vb}]bD2+TGZ 0DB2 (C}]b1ZxP\mD#|@"Z0}]VbPD12+T# 0DB2 (C}]b1ZDf!(GI}]b\mLrZD\m(^MC'X(\m D#(^(#GZ}]b6ZhD,xZhDX((#kT}]bZDTs(} g,m)# X(GI_P SYSADM r DBADM (^DC'rCTsD4(_XFD#zI +X(Zh TUTWHS }]bDC',r*zG|D4(_# ZhX( *+X(Zh TUTWHS }]b: 1. S0DB2 XFPD19* TUTWHS }]bPDTs,1=4=mD~P* 9# 2. %wmD~P#ZR_DAfP,+4=C}]bPyPDm# 3. CsjR|%w LOOKUP_MARKET m,"%wX(# 0mX(10Zr*# 4. %wmSC'# 0mSC'10Zr*# 5. !q;vC',rdk;v{F#%w&C#CC';mSA0C'13# 6. %w7O5XA0mX(10Z# 7. !q;vr`vC'#*+yPX(Zh!(DC',%wZhyPX(#* ZhvpX(,r9CX(Pmr# 8. %w&C4&mzDks# zUEy4PDYw Z>NLP,zZhKC'9C LOOKUP_MARKET mD(^#ZB;NLP, z+`?zZ0}]VbPD1P(eD*}],TczZ>NLPZhd(^ DC'I|]WXR={GyhD}]# © Copyright IBM Corp. 2000 81 82 L5G\LL Z14B `?VbPD}]T)nUC'9C TZ>NL,zXk_P0Vb\mLr1Lr|E\200E"?<\mL r1,CLr|GZ Windows NT"Windows 95 M Windows 98 OKPD#z 9XkQ-ZZ593D:(eGM#=Dd`=h(I!);P(eK,HmM B5m# Z>NLP,z+`?zD}]VbPD}]T)nUC'9C#+(}"NLP,z+" E"?<\mLr —> u 3. %w7(# 0Z DB2 UDB O(e?<10Zr*# 4. ZE"?<{VNP,dk TBC_MD# S\;JC{EVNPD1!5 -# © Copyright IBM Corp. 2000 83 5. Zw\m1C' ID VNP,dkzDC' ID# S\!qPDd`nD1!5#PXb)VNDji,N{*zozPD:Z DB2 UDB O(e?<;# 6. %w(e# 0,SAE"?<10Zr*# 7. ZC' ID VNP,dkZ20y>18(DC' ID# 8. ZZnVNP,dkZ20y>18(DZn# 9. %w,S# 0E"?<\mLr1a4(E"?<# !q*"r*# 84 L5G\LL 5. ZICTsPmP,%w0TBC LL1wbx# 6. %w ># 0TBC LL1wbxFA!(DTsPm# 7. %w,=hCj)# 8. Z?<{VNP,dk TBC_MD# TBC_MD }]b|,y>*}],C*}]|(;vy>E"?<#z+Q PX0P!1xLD*}]mSAVfD*}]# 9. Z\m1C' ID VNP,dk9Cd20y>DC' ID# 10. Z\m1ZnVNP,dkT&ZCC' ID DZn# 11. S+4m3dA?jVbPm,!qZm6%!4%4Zm6p3d4mM ?jm#E"?<+9C;v0d;1Ts48>Z=vm.dP;v3 d# zI!qDm;v!nGZP6,4ZP6p3d4mM?jm#E"?< +8>4mPD?;PkdZ?jmPDT&P.dP;v3d#+G,g {Pm`P,rE"?{a;1T>,1=TsD"U>D~DZ],P>I&"D~;>}#0"<*}]10Zr*,"Z"zDE"?<{# |BQ" xPPDYw# 0xPPDYw10Zr*#z&Ca4=}ZKPD=hDn#1C=hK P1,|&Znd4,#1|axKP1&&ZjI4,# PX0xPPDYw10ZDji,N{*zozPD:xPPDYw—E v;# zUEy4PDYw Z>NLP,z+ZLLP4(D0}]VbPD1*}]"NL,zXk_P0Vb\mLr1Lr|E\200E"?<\mL r1,CLr|GZ Windows NT"Windows 95 M Windows 98 OKPD#9 XkQ-ZZ593D:(eGM#=Dd`=h(I!);P(eK,HmMB 5m# Z>NLP,z+i4E"?DGE"D%;r`lVi,+;|,5J DE"#z+Z?D~DTst/;vLr4i45JD~ }]# r*E"?< *r*E"?<: 1. %w*<# 2. %wLr —> IBM DB2 —> E"?<\mLr —>TBC_MD C'# TBC_MD C'm>zZZ833D:Z14B `?VbPD}]T)nUC'9 C;PTdmSK*}]DE"?<# 3. ZC' ID VNP,dkC44(E"?zDE"? ?tZX(ViDTsdDX5#?KS70P,z+QwkZ413D:Z8B (e}]d;MF/;P8(D,Hm `T&DTs# *QwE"?ZzDE"? +!qDTs`MmSAQwTs`MPm# 5. SXT/5PmP,%w{F# 6. Zdky!XTD5VNP,dkTB5: LOOKUP 7. %w dk#C5T>ZXT/5PmD5PP# 8. !qvTs!4#ir4QwyP5,x; Z0Qwa{10ZP# 4(Ts/O zI4(;v+;,TsVZ;pD/O,T=cxPf!#/OGCZ0E" ?<10ZPT>D<{4m>D#Z>70P,z+*kZ413D:Z8B (e }]d;MF/;P8(D,Hm`T&DTs4(;v/O# *4(/O: 1. Z0E"?<10ZP,%w?< —> 4(/O#04(/O10Zr*# 2. Z/O{VNP,dkB/OD{F: LLGM#= Z15B 9CL5*}] 91 S\m>/OD1!<{# 3. %w4(#T>B/OD<{#zVZI+TsmSAC/OrSd>}T s# 4. S0Qwa{10Z,CsjR|%w LOOKUP_MARKET Ts# 5. %w4FA/O# 04FA/O10Zr*# 6. S!q/OPm,!q0LLGM#=1/O# 7. %w4F#CTs4FAzy!TsD/O# 8. T LOOKUP_PRODUCT"LOOKUP_SCENARIO M LOOKUP_TIME TsX4 =h4A7# ZjIb)=h.s,g{z+w0E"?<10ZPD0LLGM#=1/ O,z+4=0Qwa{10ZPT>DmPm# t/Lr 0E"?<\mLr1r/Kt/Lr(CLrITlwTsyhvD5J} ])D$w#}g,g{Phvt/Lr#CLrXk20ZM'z$w>O# %;Ts`MITt/`vLr(}g,Ts`M0gSmq1IT,1k Lotus 1-2-3®M Microsoft Excel `X*)# *9;vTs\;t/Lr,kZ0Lr1TskNN4`?*0Lr1DTs `M.d4(X*#Z>70P,z+*0Microsoft GB>1(e;v0Lr1T s# z+Z0GB>Lr1TsM0D~1Ts`M.d4(X*# 92 L5G\LL 4(0Lr1Ts *4(0Lr1Ts,z+(eCTsDXT"8(*CwLrN}DXT# Z>70P,z+4(;v0Lr1Ts# 1. %w*< —> Lr —> IBM DB2 —> E"?<\mLr —>TBC_MD \ m1# 2. S0E"?<10ZP,CsjR|%wTs`M<{# 3. %wr* —> <{Pm# 4. CsjR|%w0D~1Ts`MD<{# 5. %wX*Lr# 0Lr10ZT>10k!qDTs`M`X*DLrDPm# 6. %wmS# 0D~-mSLr10Zr*#Q!qK{FXT# 7. Zdky!XTD5VNP,dkCLrD5w: 9C0Microsoft GB>1i4D~ 8. %w dk 4%T+5FAXT/5PmrD5P# g{*A}Zdky!XTD5VNPdkDZ],k%we}4%# 9. SXT/5PmrP,%w`XT# 10. Zdky!XTD5VNP,dkCLrDV`: DV&mw 11. %w dk 4%T+5FAXT/5PmrD5P# 12. SXT/5PmrP,%w^({ 1 XT# 13. Zdky!XTD5VNP,dkCLrD^({: GB> 14. %w dk 4%T+5FAXT/5PmrD5P# 15. SXT/5PmrP,%w^({ 2 XT# 16. Zdky!XTD5VNP,dkCLrD^({: Windows 17. %w dk 4%T+5FAXT/5PmrD5P# 18. SXT/5PmrP,%w^({ 3 XT# 19. Zdky!XTD5VNP,dkCLrD^({: - ,V{G1!D0;JC1{E# Z15B 9CL5*}] 93 20. %w dk 4%T+5FAXT/5PmrD5P# 21. SXT/5PmrP,%wj6{XT# 22. Zdky!XTD5VNP,dkCLrDj6{: notepad.exe 23. %w dk 4%T+5FAXT/5PmrD5P# QTKLr&mDTs`MXT(eK0D~1Ts# 24. SXT/5PmrP,%wt/,wC:XT# 25. Zdky!XTD5VNP,dkC4t/CLrD|n: START X:\path\notepad.exe dP,X:\path G200Microsoft GB>1D76,g C:\WINNT\system32# a>: 0`1"0^({ 11"0^({ 21"0^({ 31M0j6{1XTD iOZE"?70P,z+8(;)XT,b)XTD5+;CwLrN}# 1. Z0D~-mSLr10ZP,%wN}4%#0D~-wCN}10Zr *,P>0D~1Ts`MDXT# 2. SXTPmrP,%w{F# 3. %w7S# Z15B 9CL5*}] 95 %NAME% vVZdkLrwCN}PmrP# 4. %w7O# 5. Z0D~-mSLr10ZP,%wmS4%# 6. XU0D~-Lr10Z# S0D~1Tst/Lr Z>70P,z+S demographics D~D0D~1Tst/0Microsoft GB>1# z+QwCTs,;st/CLr# *S0D~1Tst/CLr: 1. Z0TBC_MD C'1P,+w0E"?<10ZPDBDQw<{# 0(eQw10Zr*# 96 L5G\LL 2. m/ICTs`MPm#KPmT>ZzDE"? +!qDTs`MmSAQwTs`MPm# 5. SXT/5PmP,%w{F# 6. Zdky!XTD5VNP,dkTB5: demographics.txt 7. %w dk#C5T>ZXT/5PmD5PP# 8. !qvTs!4#ir4QwyP5,x; Z0Qwa{10ZP# 11. S 0 Qwa { 1 0 Z P , C s j R | % w X:\sqllib\samples\db2sampl\dwc\demographics.txt Ts,dP X G20 Ky>D}/w# 12. !qt/Lr# 0Microsoft GB>1Lrt/#z+4=ZZ113D:Z3B /@4}];P 9C0Microsoft GB>1i4D}]# zUEy4PDYw Z>NLP,zr*KE"?<"/@KzS0}]VbPD1+MD*}]# zQwKk LOOKUP* m`T&DTs,"+|G1(eK;v0Lr1Ts,"S demographics.txt D~DTst/K0Microsoft GB>1# Z15B 9CL5*}] 97 98 L5G\LL Z16B S0}]VbPD1Z4(GM#= Z>NLP,+SZKLLP4(DVbm4(GM#=#ITTVb}]bP Di/9CKGM#=#9IT+GM#=wvA0OLAP /I~qw1T4( OLAP }]b#Z>NLP,+QGM#=wvA0OLAP /I~qw1# *jI>NL,zXkQ-20K OLAP Starter Kit#9XkQ-ZZ593D:( eGM#=Dd`=h(I!);P(eK,HmMB5m# (eGM#= ZK70P,+(eGM#=,CGM#=+|,zQ-ZKLLP(eD,H mMB5m# *(eGM#=: 1. S0}]VbPD1,CsjR|%wVb#=D~P# 2. %w(e# 0(eVb#=1JG>r*# 3. Z{FVNP,dk#={: LL#= 4. Z\m1VNP,dkzDU{w*C#=D*5K# 5. Z5wVNP,dk#=D5w: bG TBC GM#= S\d`5#PXK3ODVNDji,N{*zozPD:(eVb# =;# 6. !qv9C;v}]b#ir# 7. SVb?j}]bPmP,!q TUTWHS# 8. %w7OT(eVb#=# GM#=;mS=Vb#=D~PBfDwP# © Copyright IBM Corp. 2000 99 r*#= ZK70P,+r*GM#=,T9zI+,HmMB5mmSAB;v70P D#=# *r*0LL#=1Vb#=: 1. CsjR|%w0LL#=1Vb#=# 2. %wr*# +mmSA#= ZK70P,+QZKLLPy(eD,HmMB5m LOOKUP_PRODUCT" LOOKUP_SCENARIO"LOOKUP_TIME T0 FACT_TABLE mmSAGM#=# *+,HmMB5mmSAGM#=: 1. %wmS}]<{: 2. Zk*ECmD;C%w-<# 0mS}]10Zr*# 3. 9*0Vb?j1w,1=ZmD~PBf4=mDPm*9# 4. !q LOOKUP_MARKET m# 5. %w > T+ LOOKUP_MARKET mmSAQ!qD4mM?jmPm# 6. X 4 = h 4 M = h 5 , T m S LOOKUP_PRODUCT"LOOKUP_SCENARIO"LOOKUP_TIME M FACT_TABLE m# 7. %w7O#y!qDmT>ZC0ZP# T/,Sm ZK70P,+9CZ713D:Z11B (e?jmDX|V;P(eDwX|VM b?X|V4T/,S,HmMB5m# *T/,Sb)m: 1. ( } 4 ! Ctrl | " % w ? v m 4 ! q LOOKUP_PRODUCT"LOOKUP_SCENARIO"LOOKUP_TIME M FACT_TABLE m# 2. %w$_8ODT/,S<{# 100 L5G\LL 0}]VbPD1+Z,HmPDwX|VkB5mPDb?X|V.d.O L_# Z#fb)L_.0,IT|Db)_# *}%b)_,,1!q| G,CsjR|%w,"%w}%# 3. %w$_8OD#f<{T#fzD$w: L+T/,S_dIZ+# wvGM#= ZK70P,+wvGM#=T)Z0OLAP /I~qw1P9C# *wvGM#=: 1. CsjR|%wVbD~P# 2. %wwv*}] —>OLAP /I~qw# 0wvVb#=1JG>r*# 3. SICDPm,!qLL#=# 4. %w ># 0LL#=1FAQ!qDPm# 5. %w/I~qwj)# 6. Z?<{VNP,*LLD0`,Vv1?Vdk?<{: TBC_MD 7. Z?}]bMGTCC' ID 4(D#bGy>0OLAP /I~qw1?0OLAP /I~qw1?< DZn# 11. Zi$ZnVNP,YNdkCZn# Z16B S0}]VbPD1Z4(GM#= 101 S\K3d`?VOD1!5#PXK3ODX~Dji,N{*zozP D:+Vb#=wvA0OLAP /I~qw1;# 12. %w7OT+y!qDVb#=wvA 0OLAP /I~qw1# JG>XU,ZjIwv.0,+;1T>;vxH8>w#1wvyP8 (DVb#=1,0wvE"10Zr*,T>XZwvDI&r'\E "#%w7OXUK0Z# zUEvK24 Z > N L P , z 4 ( K I LOOKUP_MARKET" LOOKUP_PRODUCT"LOOKUP_SCENARIO"LOOKUP_TIME M FACT_TABLE miIDGM#=#"+CGM#=wv=K0OLAP /I~qw1P# 102 L5G\LL Z17B** #Xz!VZzQ-jIKLLD0}]kb1?V#ZKLLP,z*GM# =(eK|,,HmMB5mDVb,gBy>: v (eKVb}]b4|,GM#=# v i4Kfy>;pa)D4}]# v (}(eVbC'MVbi4(eK0}]VbPD12+T# v (}*4mM4D~(eVb4,;s(e+4}]FAVbPD=h0,S mD=h,z(eKGM#=PDdP;v,Hm LOOKUP_MARKET# v Sy>4FKd`,HmMB5m# v a}K=h"bT"wHK|G# v (eKGM#=PDmODwX|VMb?X|V# v TVb}]bxPK,$TDxT\# v ZhKC'TVb}]bD(^# v +*}]"NLP,+=w9C0*zVv&m1(OLAP)D+&\0DB2 OLAP ~qw1z7#DB2 OLAP Starter Kit M0DB2 OLAP ~qw1HP{s JG`Y?1by;vJbh*`v=fD}],g1d"XxMz7#b)= fPD?;v<;F*,#DB2 OLAP Starter Kit 9zI+zD}]i/I`,, TcxPVv# X5}]I;S*=,D,r*?;u}](2IF*B5)5qF.KD?~D}]DO _6pD=f,gJ'"1d"z7MP!#Z OLAP &CLrP,b),yy ;f1dx|D# ?;,HITG01d1,DI1, xvpz7ITG0z71,DI1#zIC,PDI1_PcN,g01d1 ,D>HPDB]#I1yyaf1d"z|D,}g,1zD5qZI$1, Bz7MM'aPyvS# NLEv Z>LLP,z+: v 4( OLAP #M,|G;vhvzD{v5qF.D_-a9#C#MICK GM#=DN=,|9C`FGNDa94m>d?~dDX5#GM#=D PDG;vB5m,||,Kzk*VvD5J}],gz7z[}V#SB 5mDxdv4G|,(e OLAP ,(gJE"B]"z7{,HH)D}] © Copyright IBM Corp. 2000 107 D,Hm#;vrY}8v OLAP #MMIm>z5qDs?VryP=f# Z>LLDE>P,z+4(;v OLAP #M,C#M+f0zDzb({O +>(TBC))Ds`}Z]# v 4( OLAP *V*,|(#GzC44( OLAP &CLrD#MDS/#F. G4(;vr8v OLAP #M,Iy]|G4(`v*V*,?;vLLP,z+4(;v*V*,|kT TBC +> Z0P?w]1XxDz[}]# v 0k"FczD}]T4(OLAP &CLr#OLAP &CLr|,IyZ*V* D Essbase V*r#e9lD}]# v VT/@0DB2 OLAP /I~qw1Dd{?~# ZzjIK>LL"4(K OLAP &CLr.s,zIT9C Microsoft Excel r Lotus 1-2-3 gSmqLr4Vv TBC Z0P?w]1XxDz[}]#N{ OLAP Spreadsheet Add-in User’s Guide for 1-2-3 r OLAP Spreadsheet Add-in User’s Guide for Excel TKbji# 0DB2 OLAP /I~qw1@f|,BP?~: v 0OLAP #M1gfGC44( OLAP #MD+&\$_#0DB2 OLAP /I ~qw19|( 0OLAP #M(zLr1,|8L LPDNLT>KgN9CK0(zLr1# v 0OLAP *V*1gfGC44( OLAP *V*D+&\$_#0DB2 OLAP /I~qw19|( 0OLAP *V*(zLr1,|8LLPDNLT>KgN9CK0(zLr1# v hz0\m\mw1$_,zIT4Pr%D OLAP }]b\mNq,g+} ]wvA0}]Vb1"\mf"wM4(BC'"Zh{GT&CLrDf !(#kND OLAP Administrator’s Guide TKbji# 108 L5G\LL Z19B t/ OLAP #M Z>NLP,z+t/0DB2 OLAP /I~qw1@f""aA+*I* OLAP ? Lr —> IBM DB2 —> DB2 OLAP —> @f#aT>0"a10Z# ,SA OLAP ?< Z0"a1AfP,"aA+|, OLAP ?LL9C 0DB2 (C}]b1=x;6Dy>?<,|{* TBC_MD# C'{ z+C4f! DB2 UDB DC' ID#Z>LLD>}P,CC' ID * tbc# Zn CZC'{PdkDC' ID DZn# 2. zI%whC"a1!54f"zZK&w*1!5dkD~qw"?LL,;*#f 1!5# 3. %w7O#0DB2 OLAP /I~qw@f1D06-10ZT>: . 110 L5G\LL t/0#M(zLr1 4( OLAP #MDZ;=Gv(9C0OLAP #M1SZ(|a)+?&\), 9G9C0#M(zLr1(|a)Or%D8NLP,z+ 9C0OLAP #M(zLr1# 1. %w#M(zLr<{# 2. +a>z"aA TBC }]b,||,4}]#+T>0}]410Z# dkBP5: }]4 DB2 }]bD{F,+ZdPf"5q}]#>LL9C0DB2 (C }]b1=x;6DdP;vy>}]b,|{* TBC# C'{ z+C4f! DB2 UDB DC' ID#Z>LLD>}P,CC' ID * tbc# Zn CZC'{PdkDC' ID DZn# %w7O,+T>0#M(zLr1D0!qB5m13# zUEvK24 Z>NLP,zt/K0/I~qw1@fgf",SK OLAP ?NLP,z+!q;vB5m"4(0J'1M01d1,#.s,z+4 (0z71"0P!1M0=81,# !qB5m ?v#Mh*;vB5m,|GGM#=DPD#B5mI;vr`v|,B5 (}gz[~}rL7I>)DX5mT0+B5mk?v,Hm`4SDb? X|ViI#Z>NLP,B5m9+;Cw0J'1,#0J'1,|,zI 41dVvMzYD}V}],gz[Mbf;K}]2F*d?H?}],| Z*zVv&mZdtCaFG\# *!qB5m: 1. Z0!qB5m13O,"b={FVNPD1!5GJ'#;*|DK5# Z>NLP,z+9CB5mT/4(0J'1,# 2. ZICX5mVNP,%w TBC.FACT_TABLE# © Copyright IBM Corp. 2000 113 3. %wR}74%,TBC.FACT_TABLE T>Z!qDX5mVNP#C0ZD b[`FZ: 4. %wB;=,+T>0!q1d13# 4(1d, Z>70P,z+4(01d1,,|C4hvzU/M|B}]D5J#} g,zI+1dV*j">HMB]# 1. Z0!q1d13O,zIS\{FVNPD1dD1!5# 2. %w(}!qX5m,|+$nICX5mVN# 114 L5G\LL 3. !q TBC.LOOKUP_TIME m"%wR}74%#CmT>Z!qDX5mV NP#C0ZDb[`FZ: 4. %wB;=,+T>0|{,13f# 4(j<, Z>70P,z+*#M4(j<,,"+?vj<,k|,C,D}]DX5 m`X*#b),G: =8, hvVv}]DI\=8# z7, hvzD5qPDz7#Z>LLP,zDz7Gm{O# P!, hvzZdPxPKwDP!#}g,zI+P!V*XxMGP# 1. Z0|{,13O,Z{FVNPdk=8"%wmSAPm#C,;mSA ,PmVNP# Z20B !qB5m"4(, 115 2. T0z71,M0P!1,xP`,&m#C0ZVZDb[`FZ: 3. %wB;=,+T>0!qX5m13f# Z0!qX5m13O,zI+;vmr`vmkz4(D,`X*#?v,X k_PAY;vm#4P>0J'1,M01d1,,r*zQ-4(K|G# 1. Z,PmVNP,%w=8,# 2. BmICX5mPmA TBC.LOOKUP_SCENARIO m#!qCm,"%ww ,HmVNTDR}7,Cm;mSAVN#Cm9;mS=,PmVNPD wmjbBf# g{zk*X*K,D=Sm,I!qCm"%w=S,HmVNTDR} 7#+TZ>NL,;*mS=Sm# 3. T 0 z 7 1 , M 0 P ! 1 , x P ` , & m # T Z 0 z 7 1 , , 9 C TBC.LOOKUP_PRODUCT m#TZ0P!1,,9C 116 L5G\LL TBC.LOOKUP_MARKET m#C0ZDb[`FZ: 4. %wB;=,+T>0B5m,S13f# zUEvK24 Z>NLP,z!qK;vB5m"*#M4(K0J'1M01d1,#. s,z4(K0z71"0P!1M0=81,# Z20B !qB5m"4(, 117 118 L5G\LL Z21B ,SM`-,Hm GM#=m>B5mM#MPDd{,.dX5#Z>NLP,z+4=,Hm MB5m.dD,SGgN(eGM#=Da9D#z+KbgN~X,HmP DP,Tcb)P;w*#MPD,DI1vV# 0B5m,S13Ds_P>#MPDyP,#R_T>Z,HmMB5md, SKD)P(g{,SfZD0)#Z,PmVNP,,T_D X b6EC,Gk B5m,SD#"b,yP,70P,z+4=DvP+B5mk01d1,`,#Z,PmVNP, !q1d,# "b,TIME_ID P+B5mk01d1,`,# 2. %wB;=,+T>0,Hm,S13#zI9CK344(,Dw*mMz Z0!qX5m13OmSDNN=S,Hm.dD,S#Z>LLP,z; mSNN=SDX5m,yT2;aP>NNX5m# 3. %wB;=,+T>0`-m13# © Copyright IBM Corp. 2000 119 `-,Hm Z>70P,z+~X0z71,PD;P,T9|;vVZ#MP: 1. Z,PmVNP,!qz7,# 2. ZP8ZVNPiR CAFFEINATED#Z~XjGBf,%w CAFFEINATED T_ D#ir#C0ZDb[`FZ: z9ITxhb)P|`hvTD{F,x;X|D4}]PDP{#b){ FF* Essbase z{ (Essbase generation name),|GZnUD OLAP &CL rPj6P#g{;8( Essbase z{,|G1!*P{#;*ZK18(z {# 3. %wB;=,+T>0(eVca91# zUEvK24 Z>NLP,z4=K,HmMB5m.dD,SGgN(eGM#=Da9 D#z9KbKgN~X,HmPDP,Tcb)P;w*#MPD,DI1v V# 120 L5G\LL Z22B (eVca9 Z>NLP,z+ZdP;v,P4(Vca9#Vca99IK,PDP.d D8SX5,"T>*wa9#}g,Z01d1,P,zI\+0j1I1( e*Vca9D%?#0>H1I1+G0j1DSz,x0B]1+G0> H1DSz# 4(Vca9 Z>70P,z+Z0P!1,P4(Vca9# 1. Z0(eVca913Ds_VNP!q0P!1,,"%wmSVca9# +T>0mSVca910Z# 2. Z{FVNP,4-ydkZK&T>DXx-GP(;xUq),"%wj I#"b,0P!1,PDPVZT>Z0(eVca913OD,PVN P# 3. !q,PVNPDXxP,"%wR}74%#0Xx1P;mSA8/SX 5VNP# © Copyright IBM Corp. 2000 121 4. !qGPP"%wR}74%#Z8/SX5VNP,0GP1PT>*0X x1PDSz#C0ZDb[`FZ: 5. %wB;=,+T>0$@Vca913# $@Vca9 Z>70P,Z4(KyPk*DVca9s,zIZ0$@Vca913Pi 4|G+JVNV}]# 1. Z4,ErDVca9PmP,r*0P!1,DwNa9# 122 L5G\LL 2. %wXx-GP,Z Essbase V*Vca9 PvV;vy>0P!1V*# C0ZDb[`FZ: 3. %wB;=,T>0OLAP #M(zLr1DnU0Z# zUEvK24 Z>70P,zZ0P!1,P4(KVca9,"4iKCa9# Z22B (eVca9 123 124 L5G\LL Z23B $@M#f OLAP #M Z>NLP,z+jI OLAP #M#z+4=z4(DGM#=D$@,"+C #M#fZ}]bP# 1. 0#M(zLr1DnU0Z`FZ: © Copyright IBM Corp. 2000 125 2. %wGM#=4%4i4GM#=#b+T>B5mGgNkyP,Hm`, D# 3. ;*!qZ#fst/*V*(zLrr#Z>LLDd`?VP,z+y] 0DB2 (C}]b1=xa)Dy> OLAP #M44(*V*,x;Gy] zUU4(D#M44(*V*,bGr*y>#Ma)K|`8Z#ZB; NLP,z+K$t/0*V*(zLr1# 126 L5G\LL 4. %wax,+a>zdk{FMXZC#MDd{E"#.s,C OLAP # Mc;#fZ TBC }]bP,"T>0/I~qw1@f# zUEvK24 Z>NLP,z$@KGM#=,jIK OLAP #M,"+d#fZK}]bP# Z23B $@M#f OLAP #M 127 128 L5G\LL Z24B t/ OLAP *V* zDnU?jG4(;v|(0P?w]1XxPDH?,"E}d{XxD OLAP *V*#SC*V*,z+4(;v OLAP &CLr,zI9CCLr4 li0P?w]1Dz[}]Z 1996jGgNd/D# 4( OLAP *V*DZ;=Gv(9C OLAP *V*SZ(|a)+?&\), 9G9C0*V*(zLr1(|a)Or%D8NLP,z +t/0OLAP *V*(zLr1,!qw**V*y!D OLAP #M,",S }]b# t/0*V*(zLr1 Zz"aA0DB2 OLAP /I~qw1.s,cT>0@f1# 1. Z0DB2 OLAP ~qw@f1P,%wD~ —> B(#T>06-10Z# 2. %w*V*(zLr<{# © Copyright IBM Corp. 2000 129 3. "b,BVN!qw**V*y!D#MT>Z0ZW?#SPmr,!q TBC #M#b"GzgHZ>LLP4(D#M,K#M|*j8# 4. %wr*,+a>z"aA4}]b# ,SA4}]b 1. Z0}]410ZP,dkBP5: }]4 DB2 }]bD{F,+ZdPf"5q}]. >LL9C0DB2 (C }]b1=x;6DdP;vy>}]b,|{* TBC# C'{ z+C4f! DB2 UDB DC' ID#Z>LLD>}P,CC' ID * tbc# Zn CZC'{PdkDC' ID DZn# 130 L5G\LL %w7O#T>0*V*(zLr1D0`-,MI113# zUEvK24 Z>NLP,zt/K0OLAP *V*(zLr1,!qK*w**V*y!D OLAP #M,",SK}]b# Z24B t/ OLAP *V* 131 132 L5G\LL Z25B !q,MI1 Z>NLP,z+S#M!qk*Z*V*P9CD,MI1# 1. Z0`-,MI113O,r* OLAP #M VNPD0J'1,D?H"BVca9,"%wR}7(mS)4%#CVca9;4F A OLAP *V* VNP# 4. r*0P!1,DwNa9,1=4=Vca9*9#%wPDXx"]Vc a9,"%wR}7(mS)4%#CVca9;4FA OLAP *V* VN P#C0ZDb[`FZ: "b,z4(D*V*G TBC #MD;vS/,x;G+7D1>#z!qK {v0J'1,,+;!qKdP;v01d1Vca9,";!qK;v 0P!1Xx# 5. %wB;=,+T>0hC,XT13# © Copyright IBM Corp. 2000 133 zUEvK24 Z>NLP,zr*V*mSK0J'1"01d1M0P!1,# 134 L5G\LL Z26B hCXT Z>NLP,z+=?,MI1DXT,"|D0J'1,D;vI1DXT. ;#b)XTXF OLAP &CLrP9( Essbase V*D==#z9+wi0J '1,DXbXT# hC,XT 1. Z0hC,XT13O,ktb,DXTGgNT>Z,{R_D# W+DVNGIT|DD,DXT#b)XT+0l;v,DyPI1# f" ,ITG0m\1Dr0!h1D#0m\1,I\|,JCZ,I 1D?viOD}],}g,01d1,#0!h1,;sI\|, ,I1D?viOP;vI1;`v,2 m,HH# © Copyright IBM Corp. 2000 135 Fc=N FcGSByO"SSz5=8z5xPD#3)SzI1D5I\ !vZ8z5,h*Fc=N# p{ ITx;v,8(p{# UDA ITx,4(C'(etT (UDA)# 2. %wB;=,+T>0hCI1XT13# hCI1XT Z>70P,z+|D,I1D;vXT# 1. "bI1DXTGgNT>ZI1{R_D#W+DVNGIT|DD,DX T: }]f" KXT7(gN*I1f"}]5T0N1f"#}g,zITf" 5(bG1!5)"/,XFcMf"5"8>;vI1;`v,2 m,HH# Fc=N FcGSByO"SSz5=8z5xPD#3)SzI1D5I\ !vZ8z5,h*Fc=N# O" KXT7(S5gNOvA8z#1!5G;vSE (+),m>+S5 mSA85# p{ ITx;v,8(p{# UDA ITx,4(C'(etT (UDA)# 2. Z0hCI1XT13O,ITTvpI1|DH0*{v,hCD3)X T,9I|DTI1G(;DXT#Z,jbB,%w0J'1,#"b,I 1T>ZI1PmVNP# 136 L5G\LL 3. Z}]f"jbB,%w MISC I1DO"PPD5#ZC%*P+r*;v 0Pmr14%#+CXT|D*uE (−)# VZ,1 Misc I1PD5Ov=0J'1,P1,+u%(xGmS) Misc 5# 4. %wB;=,+T>0hCJ'XT13# liJ'XT Z>70P,z+wiJ',DI1DXbXT: 1. Z0hCJ'XT13O,zIT|D0J'1,DI1DBPXT: 1d=b KXT(eZ01d1,PgNFcI1D8z#8zITm>Z; vI1D5#1!50^1m>JmCkI1`X*DVfFc47 (8z#d{5|(0Z;v1(1dNPDZ;v5)"0ns; v1(1dNPDns;v5)"r0=y51(1dNPDyP5 D=y5)# x} KXT7(1Fc8z1Gq*x}3vI1# Z26B hCXT 137 +n(f Z0+n(f1P,FcK$c}]k5J}].dD+n# 2. TZ0J'1,,ITT?vI1hCBPXT: 3. %wB;=,+T>0{F}Kw13# zUEvK24 Z>NLP,z=?K,MI1DXT,"|DK0J'1,D;vI1DXT .;#z9wiK0J'1,DXbXT# 138 L5G\LL Z27B hC}Kw Z>NLP,+hC}Kw4^F0k= OLAP &CLrPDI1r}]#}g, t OLAP #MP|,+jD}],rIThC}Kw4v0kZ~>HD}]# Z>70P,z+4(;v}Kw,C}Kw+0k OLAP &CLrD}]^F * 1996 jD}]# 1. Z0|{}Kw13P,Z{FVNPdk Sales96,"%wmSAPm#C {F;mSA*V*}KwPmVN# 2. %wB;=,+T>08(I1}Kw13# 3. !q *V*}KwPmVNPD Sales96# 4. ZI1VNP,r*0j]1,DwNS<,"!q1d,j]Vca9# 5. %w(e}Kw,+T>0}Kw10Z#9CK0Z48(*S OLAP & CLr}KD}]#+T1d,4(}Kw,C}KwP;vu~# 6. TZZ;vu~,#VPVNPj]D5#ZKc{PmrP,!qHE (=)# 7. %wu~VNR_D4%,+T>!q1d"j]D50Z# 8. SPmP!q 1996,"%w7OT5X=0}Kw10Z# © Copyright IBM Corp. 2000 139 9. Z0}Kw10ZP,%wmS,C}Kw+T>Z}KwVNP#tk` -}Kw,IT1SZ}KwVNP`-,+VZ;*byv# 10. %wi$T7#}KwDo(}7,"%w7OTXU0}Kw10Z# 08(I1}Kw13`FZ: 4i}Kw Z>70P,z+wigNT,I1hC}Kw,"4izQ4(D}Kw# v %wB;=,+T>08(H?}Kw13#ZK3IT*|,H?5D, (}g,0J'1,)(e}Kw#}g,ITr*0J'1,DwNS<, !q0z[1m,"(e;v^F*v9CsZ 100 Dz[?D}Kw# v %wB;=,+T>04i}Kw13#ZK3OITi4yP}Kw#9I T5X=0fD34`-VfD}Kwr_mS|`}Kw# v %wB;=,T>0jI10Z# zUEvK24 Z>NLP,zhCK;v}Kw,C}Kw+0k OLAP &CLrD}]^F * 1996 jD}]# 140 L5G\LL Z28B 4( OLAP &CLr Z>NLP,z+$@zy4(D*V*,#fC*V*,"0kMFc4( OLAP &CLrD}]# 1. %w0$@14%Ti4*V*#0y>V*10ZT>#%wXU# 2. #V+}]MI10k Essbase #irD1!5# 3. 7#!qKI1M}]0k4%# 4. Z&C}KwVNP,!q Sales96# 5. %wax,+a>zdk{FMXZC#MDd{E"#dk MyMetaoutline# C*V*+;#fZ TBC }]bP# 6. +a>zdkBPE": v OLAP &CLrD{F,C&CLr|,;v}]b,+Q}]0k=C} ]bP#dk MyAppl# v *+}]0kdPD OLAP }]bD{F#dk MyOLAPdb# v |nE>#z;PNN|nE># v N10k}]#!qVZ"%wax# © Copyright IBM Corp. 2000 141 00kMFc1xL*<#1jIC=h1,M4(K OLAP &CLr,"R IT9C Microsoft Excel r Lotus 1–2–3 gSmqLr4Vv|# 7. %w!{4XU0*V*(zLr1# zUEvK24 Z>NLP,z$@Kzy4(D*V*,#fKC*V*,"0kMFcK4 ( OLAP &CLrD}]# 142 L5G\LL Z29B =? Starter Kit Dd`?V Z>NLP,z+=?0DB2 OLAP /I~qw1D0OLAP #M1"0OLAP * V*1M0\m\mw1gf# =?0OLAP #M1gf Z>NLP,z+Z0DB2 OLAP /I~qw1D0OLAP #M1gfPr* TBC #M# 1. %wD~ —> r*4T>06-10ZD0Vf13# 2. Z0Zs_DVNP!q TBC #M,"%wr*# 3. XpXZ0}]41"0C'{1M0Zn1Da>#0}]41G TBC# 4. 0OLAP #M1gfT>,"+GM#=T>ZR0qO#%wi4—> i4 yPP49*B5mM,#zITCsjXBEPR0qPD,#C0ZDb [`FZ: © Copyright IBM Corp. 2000 143 5. zjIs,%wD~ —> XU#;*#f|D# =?0OLAP *V*1gf Z>NLP,z+Z0DB2 OLAP /I~qw1D0OLAP *V*1gfPr* TBC #M# 1. %wD~ —> r*4T>06-10ZD0Vf13# 2. 9*0TBC #M1D?#0}]41G TBC# 4. 0OLAP *V*1gfT>,"+*V*T>Z0ZR_#C0ZDb[`F Z: 5. zjIs,%wD~ —> XU#;*#f|D# =?0\m\mw1 Z>70P,z+wi0DB2 OLAP /I~qw1D0\m\mw1$_# 1. %w$_ —> \m\mw4T>0\m\mw1# 144 L5G\LL 2. Zs0qPr*? XU# 4. %wD~ —> Kv4Kv0DB2 OLAP /I~qw1# zUEvK24 Z>NLP,z=?K0DB2 OLAP /I~qw1D0OLAP #M1"0OLAP * V*1M0\m\mw1gf# Z29B =? Starter Kit Dd`?V 145 146 L5G\LL Z3?V =<0=tJO © Copyright IBM Corp. 2000 147 148 L5G\LL "bBn KE"G*Z@za)Dz7M~q*"D# IBM I\;aZd{zRa)>D 5PV[Dz7"~qM&\?~#I/zD>X IBM zmTq!PXzyZx r10a)Dz7M~qDE"#NNT IBM z7"Lrr~qD}C";5w r5>;\9C IBM Dz7"Lrr~q#;*;V& IBM D*6z(,NN &\`,Dz7"Lrr~q,D5PXDwn({(#a)>D5,";m> Jmz9Cb)({#zITCif==+mI$i/Dy: IBM Director of Licensing IBM Corporation North Castle Drive Armonk, NY 10504-1785 U.S.A. PX+VZ (DBCS) E"DmI$i/,*5zyZzRD 0IBM *6z( ?1,rTif==+i/Dy: IBM World Trade Asia Corporation Licensing 2-31 Roppongi 3-chome, Minato-ku Tokyo 106, Japan BPLD;JCZ"zrbVf(k1X(I;;BDNNzR:zJL5zw +>:4-y;a)Kvfo,+;wNNw7r~,D#$,|((+;^ Z);%("L5Tr{OXb?DD~,#$#Z3);WP,;)zR;J mqOw7r~,D#$,rK,>ywI\;JCZz# KE"I\a|(DvfoP#IBM I\f1DxM/r|D>vfoPDh vDz7M/rLr,x;mP(*# IBM ITT}O*J1DNN==9CrV"za)DE",x;XTzP#NN pN# © Copyright IBM Corp. 2000 149 *KTB?D:(i) JmZ@"4(DLrMd{Lr(|(>Lr).dxPE" ;; (ii) JmTQ-;;DE"xP`%9C,x#{q!>LrPXE"DO( C'kkBPX7*5: IBM Canada Limited Office of the Lab Directory 1150 Eglinton Ave. East North York, Ontario M3C 1H7 CANADA ;*qXJ1Du~Mun,|(3)ivB;(}?D6n,E"PhvDXmLrM|ICDyPXmJOG IBM y]BP-ia)D: 0IBM M'-i1"0IBM zJLrmI$-i1rRG.doIDNNH'- i# PXG IBM z7DE"GSG)z7D)&L"|GD"}#*K!I\j{X5wJ b,b)>}P|,KvK"+>"7FMz7D{F#yPb){FZ@zM/rd{zRDLj: AIX AS/400 Dataguide Datajoiner DB2 DB2 Connect DB2 OLAP Server DB2 Universal Database DRDA IBM IMS Intelligent Miner MVS Net.Data OS/2 OS/390 QMF Visualage Visual Warehouse Websphere Lotus M 1-2-3 G Lotus Development +>Z@zM/rd{zRDLj# Java 0yPyZ Java DLjMj>G Sun Microsystems +>Z@zM/rd{ zRDLjr"aLj# Microsoft"Windows"Windows NT M Windows j>G Microsoft +>Z@zM /rd{zRDLj# UNIX GZ@zM/rd{zRD"aLj,"R-} X/Open P^+>(;m I# d{+>"z7M~qn?D{F,I\Gd{+>DLjr~qjG# "bBn 151 152 L5G\LL  Printed in China Spine information:  IBM DB2 (C}]b L5G\LL f> 7
还剩166页未读

继续阅读

下载pdf到电脑,查找使用更方便

pdf的实际排版效果,会与网站的显示效果略有不同!!

需要 6 金币 [ 分享pdf获得金币 ] 0 人已下载

下载pdf

pdf贡献者

mish

贡献于2015-06-07

下载需要 6 金币 [金币充值 ]
亲,您也可以通过 分享原创pdf 来获得金币奖励!