Home

OLAP Intelligence user manual

1. 1 Worksheet 2 ee 1 Worksheet 2 8 9 2
2. 68 OLAP Intelligence 3 133 4 5 4 Worksheet Sn 142 1
3. 1 2 OLAP 209 3 2
4. Worksheet 146 OLAP Intelligence 133 8 6
5. 152 OLAP Intelligence 1 Worksheet 2 e 1 Worksheet 2 8 9 3 8 9 3 1
6. 163 10 2 2 j 10 2 3 162 Worksheet
7. 146 2 91 0LAP 4 5 3
8. el1ieonoe 123 124 175 6 5 1
9. lt gt OLAP 16 2 1
10. Worksheet Worksheet 153 329 0LAP Intelligence L 8 E ore J
11. Worksheet 77 134 Worksheet Web OLAP Worksheet 4 7 3 2
12. 107 5 3 2 3 2
13. 3 123 3 1 3 1 3 123 159 1000 1 xie ets EE F
14. 8 9 3 2 1 1 This Year Next Year Meat 4 9 1 Worksheet 165
15. Worksheet Worksheet 177 Worksheet Worksheet Worksheet Worksheet
16. 161 157 8 2 Worksheet
17. DHTML 1 3 CTRL 9 3 gt CTRL 1
18. Measures 2 406 61 12 477 15 20 897 12 20 524 32 Worksheet a CTRL Ti 5 4 4
19. 2 3 OLAP I OLAP 0LAP 0LAP
20. 8 4 1 2 Worksheet Worksheet
21. 2 338 115 49 1 928 725 21 1 899 793 46 440 917 99 438 322 02 03 2 255 014 78 1 835 022 00 419 992 78 ep de ee 40 4 37 0LAP 28 3 5 4 report2 1 2 OLAP
22. 188 OLAP Intelligence 5 6 12 4 2 MDX _ up OLAP Intelligence OLAP Intelligence 189 MDX MDX
23. 1 y 3 4 y OLAP 3 4 5
24. Fulk Mail 1 Cash Register Ha 2 127 i 161 Worksheet Worksheet 5 5 10 10 5 5 10 10 7
25. Measures 1 Actual Time 1999 1 1 2 3 4 Actual 1 2 3 4 Je e 3 4 638 KPI 246 OLAP Intelligence Worksheet 1 2 Jeasures z 247 Time Worksheet
26. 251 17 2 6 X Y X X Y 1 2
27. MDX 102 MDX Microsoft SQL Server Analysis Services 0LAP Intelligence 5 2 2 4 96 OLAP Intelligence URL HTML MDX Name
28. es 8 7 2 149 SHIFT 5 Microsoft SQL Server 2000 Analysis Services gt 39 Hy
29. 61 4 5 OLAP Worksheet Worksheet 4 5 1 Worksheet Worksheet 8 0LAP Worksheet Worksheet 1
30. 10 2 4 164 OLAP Intelligence 10 2 5 Worksheet Worksheet
31. G OO 0 H 186 OLAP Intelligence X Y Fa Y x X Y XY Y oO X 3 Store Sales 4 Y 5 X Store Size 6 X 12 4 0LAP Intelligence Microsoft Analysis Servic
32. 0LAP Intelligence 0OLAP Intelligence 0LAP Web BusinessObjects Enterprise Web 0LAP 0LAP Web OLAP 0LAP Intelligence BusinessOb jects Enterprise InfoView OLAP Intelligence
33. 7 Ees FE Fe ti s0 6 w Worksheet 3 0LAP 33
34. 7 1 0LAP Intelligence Excel Worksheet 1 zm htm a
35. 105 E EE amp OLAP Intellige
36. X Y 12 3 1 i tk 245 1
37. Worksheet Worksheet Measures Worksheetd 142 132 OLAP Intelligence 8 1 1
38. Worksheet Worksheet 63 DHTML OLAP Worksheet 4 4 5 2 Worksheet Worksheet Worksheet
39. Member 0LAP 1 22 OLAP Intelligence 6 4 0LAP Web Web CGI
40. books 6 fiction 7 reference 5 history 6 books paperback books 2 fiction 1 reference null history 1
41. 2 3 URL PageNumber 115 EE Web OLAP 5 2 OLAP 0LAP Intelligence OLAP
42. 16 4 3 gt 2 3 4 238 OLAP Intelligence 16 4 4 0LAP Intelligence 0LAP Intelligence GetCaption GetCaption 1
43. SHIFT CTRL 8 3 3 137 1 2 3 A 2 1 2
44. 130 ss 224 Wk 126 239 Excel ee 125 a 239 re 29 oven 151 be 0S 123 127 142 i 128 2 aaai 126 J i 128 IBM DB2 OLAPLI1BM DB2 OLAP 128 Hyperion Essbase IBM DB2 OLAP SAP a 126 iCube i 243 129 130 ee te 183 54 61 46 155 A oR Me OB WO 184 ee 155 ep Nk Pt Te Re 186 127 We a et 18 MDX 188 Oe 189 J nn Es 187 a 74 er 183 80 Nii 4 ie 7 Ea ee ee 128 177 178 CE 160 i Ph lr hhh hr 182 159 00 1 Te 179 160 185 161 ee Os
45. 161 10 1 8 Worksheet gt Worksheet 10 2 Worksheet 162 OLAP Intelligence 10 2 1
46. 229 16 3 Essbase Q1 a te Ss 231 1 0 232 OLAP Intelligence 234 0LAP Intelligence
47. 1 WEEE x kx v J C 69 2 4 5 5 0LAP
48. Def t Analytic Services Default x ault OLAP Default 1 16 4 1 0OLAP i Worksheet Worksheet
49. 20 OLAP Intelligence 3 1 1 OLAP Worksheet OLAP 2 OLAP 0LAP Web 3 0LAP OLAP Worksheet 4 3 5 Microsoft Excel Excel OLAP Intelligence Microsoft Excel 6 OLAP 0LAP 7 LU 9 OLAP Intelligence
50. 3 3 4 4 1 2 3 4 5
51. 212 231 a0 x 19 en JE NI i 0 re 0LAP
52. 16 3 5 gt 1 229 QO TD May QO TD Feb QT D Feb 100 Worksheet
53. QT D ParallelPeriod Aug 3 Worksheet ParallelPeriod QT D Market East New York Massachusetts Florida Connecticut New Hampshire Intro Date Intro Date inactive Measures Measures Attribute Calculations Attribute Calculations in Product Product Scenario Scenario Caffeinated Caffeinated nactive Dunces Dunces nactivel PkgType Pkg Type linactive Population Population inactive 235 Worksheet
54. EE Worksheet Worksheet 128 OLAP Intelligence Te 157 7 1 6 i Ysls Worksheet
55. 6 139 298 880 85 63 676 754 16 26 554 E78 06 26 261 723 40 9 575 611 58 8 505 040 399 Worksheet gt 1 2
56. 9 Microsoft Excel DHTML Intelligence Worksheet i csV txt Web ActiveX Worksheet 6 TGS Excel 0LAP 0LAP Intelligence OLAP NE Microsoft OLAP ActiveX 126 OLAP Intelligence
57. 0LAP 1 Worksheet C Worksheet ME 0g OLAP i Y
58. Microsoft SQL Server OLAP Services 12 4 3 1 14 3 2 12 4 4 66 9 12 4 5 190
59. 2 13 2 1 2000000 1600000 1200000 OLAP 193 1 2
60. 114 OLAP Intelligence 5 4 7 0LAP OLAP 0LAP Crystal Web Web CGI HTML 91 0LAP 1 2 4 5
61. Worksheet NN gt 237 1 Worksheet 2 5 3 Prodquct 0LAP Intelligence 100 20 Diet Cola 16 4 2
62. Worksheet 171 Worksheet 166 OLAP Intelligence 11 2 Worksheet 1 Work 2 sheet
63. OLAP 0LAP Intelligence OLAP 8 3 9 1 2
64. a El ed rl EL 30rBaBa 214 OLAP Intelligence 13 4 gt 1 2 3 Y1 x
65. de OLAP Intelligence 3 8 3 1 135 74 Se 136
66. 129 Td Worksheet Worksheet wan
67. 70 69 221 66 155 793 71 152 195 83 139 857 17 131 276 54 368 271 79 359 545 13 795 548 46 791 269 11 305 913 51 338 075 30 Measures 40 Worksheet 175 1 8 2 32 OLAP Intelligence 8 EE
68. Worksheet 3 OLAP 31 1 0LAP Intelligence 22 1 OLAP OLAP 1 0LAP Worksheet 22 1 0LAP Worksheet 22 1 0LAP OLAP 1 6 Worksheet 0LAP 2 Worksheet 3 4 40 5 Worksheet
69. 0LAP OLAP 0LAP DHTML 0LAP
70. 0 360 0 180 0 360 13 2 7 1 1
71. 0LAP Intelligence 1 0 TE _T_D May gt Q T _D Feb 1 0 3 Worksheet IIf 1 IIf 0 12 Market QTD Feb QTD May 3 i Fi New York 1 113 00 1 451 00 1 00 Massachusetts 101700 108200 1 00 Florida 697 00 848 00 1 00 Conneoten 630 00 52500 New Hampshire 118 00 185 00 1 00 TD Attribute Calculations Attribute Calculations in Product Product Scenario Scenario Caffeinated Caffeinated nactive Dunces Dunces inactive Pkg Type Pkg Type inactivel Population Population inactive
72. 235 16 3 1 Worksheet 0
73. 0LAP Worksheet OLAP WMeasures i 4 7 3 1 Worksheet x 6E v YE Y Worksheet
74. Worksheet 191 64 OLAP Intelligence 1 2 gcapl7T8_pe68 car OLAP Intelligence
75. 3 Excel 4 0LAP Intelligence Worksheet Excel Excel TH HH 222 OLAP Intelligence 15 4 DHTML DHTML Web HTML Excel Excel 1 2 Excel Ex
76. gi RC 0 1 QD BR Q S Web Internet URL mailto sales my_company com subject amp body Name Name HH Yt I 8 51 0 amp mailto sales my_company com subject abody ane
77. 16 3 2 1 229 2 Worksheet 22 OLAP Intelligence Year Market Year es 3 TT mes NewYork 8202 1 451 00 Massachusetts 6712 1 082 00 Florida 5029 848 00 Connecticut 3093 525 00 New Hampshire 1125 185 00 el De ee Attribute Calculations Attribute Calculations in Product Product Scenario Scenario Caffeinated Caffeinated nactive 0unces Dunces nactivel Pkg Type Pkg Type nactivel Population Population inactive
78. 58 2 3 x Ce 0 00 WW o 3 4 3 1 1 0LAP 0LAP 243
79. C 0LAP Web 0LAP Business0bjects Enterprise 17 3 4 CMC 0LAP 2 3 CMC OLAP 0LAP 0LAP 255 17 3 5
80. 4 E 100 150 250 200 250 450 300 400 700 1 2 3 0LAP
81. 211 13 2 10 x 204 OLAP Intelligence 1 2 3
82. Ey Neasures gt 1 2 1 ESEE x Y E lv amp Y 2
83. 163 11 1 Worksheet Jeasures i 170 888 357 64 139 298 880 85 i 176 376 769 52 63 676 754 16 12 853 800 35 9 575 611 58 4 908 030 29 4 317 634 95 176 772 35 155 875 23 173 823 78 153 299 46 92 641 62 80 164 46 20 505 16 18 098 55 Worksheet
84. 2 3 1 2 3 1 2 3 4 211 208 OLAP Intelligence 1 x 10000 8000 6000 4000 2000 1998 1999 ET
85. 1000 2 3 4 5 6 10 1 2 n 1 2 n 3 160 OLAP Intelligence 4
86. 141 3 gt 4 5 6 7
87. 3 161 10 1 5 1 2 I 10 1 6 10 1 7
88. gt 1 gt GO 218 2 3 4 5 13 3 6
89. 161 4 7 5 2 n n 157 80 OLAP Intelligence 4 7 5 3 165 4 7 5 4
90. 2n 1 n 1 2 3 Xi A A Xi sum j i n i n Xj 2n 1 2 4 6 2n n 1 2 3 Xi A A Xi sum j i n i n 1 Xj 2n sum j i n 1 i n Xj 2n 2 NS 250 OLAP Intelligence OLAP Intelligence 3
91. 338 075 30 191 075 97 146 999 33 69 221 66 791 269 11 152 195 83 359 545 13 131 276 54 40 1 OLAP Ll report2 3 0LAP 35 gt 1 2 Worksheet CC EE i EF 3 4 5 6 7 40 8 Work
92. 0LAP 0LAP 8 4 2 OLAP Worksheet 144 OLAP Intelligence gt 1 2
93. OLAP Intelligence 0LAP Intelligence DHTML 139 8 3 6 1 2 3 1
94. 0OLAP Intelligence Worksheet 6 OLAP OLAP Intelligence Excel 1 2 OLAP Intelligence 3 3 4 133 5 6 0LAP Intelligence 99 7 70000 85000 2004 12 8 23 42 83929 48401 75067 67484 72946 74243 74086 27947 73277 79135 87638 43707 78747 58293 76207 33871 77477 45985 76842 40196
95. Worksheet MDX OLAP Intelligence MDX 175 4 8 OLAP 0LAP CAR OLAP Intelligence BusinessOb jects Enterprise Web CAR OLAP 82 0LAP OLAP 81 Business0bjects Enterprise Web 0OLAP BusinessObjects Enterprise
96. 0LAP 0LAP OLAP 0LAP Web HTML OLAP OLAP Web CGI s 4 3 OLAP Intelligenc OLAP Intelligence 0LAP 0LAP OLAP 0LAP 82 OLAP Intelligence e Crystal OLAP 0LAP 1 0OLAP Intelligence
97. OLAP Intelligence OLAP Intelligence Microsoft Excel 1 1 3 Business 0bjects A Business 0bjects Business Ob ects 2 0LAP 2 1 0LTP 0LTP
98. 17 2 5 nshest X Y X Y gt i Y X X 1 Worksheet X Worksheet
99. 3 1 2 3 4 5 211 202 OLAP I ntelligence 13 2 9 x 1200000 1000000 800000 500000 400000 200000 ok mm ee 01 02 03 04 05 06 07 08 09 1 1 2 2
100. OLAP Intelligence 12 12 1 Worksheet 1 2 pe pr 4 994 659 36 5 516 062 47 10 510 721 83 6 838 943 17 6 014 857 17 12 853 800 35 17 863 E456 65 14 475 246 71 32 338 893 35 43 843 819 51 32 532 950 01 T6 376 769 52 18 769 419 00 14 E66 980 40 33 436 399 40 95 219 728 68 75 668 628 97 170 888 357 64 Worksheet 12 1 1 OLAP Intelligence OLAP OLAP Intelligence
101. ea Ee 0 New York 111300 1 451 00 Massachusetts 1 017 00 1 082 00 Florda 697 00 848 00 Connecticut 630 00 525 00 New Hanpshie 118 00 185 00 Intro Date Intro Da inactive Attribute Calculations Attribute Calculations in Scenario Scenario Dunces Dunces inactive Population Population inactive Caffeinated Caffeinated nactive Pkg Type Pkg Type nactive 236 OLAP Intelligence Worksheet 16 4 SKU
102. 4 11 OLAP Intelligence OLAP KPI Web OLAP 83 0LAP 0LAP 0LAP Intelligence KPI
103. 206 OLAP Intelligence gt 1 2 gt 1 2
104. Worksheet Worksheet Worksheet Worksheet 165 130 OLAP Intelligence 7 Val 13 Worksheet A
105. 5 2 11 2 3 4 SHIFT CTRL DELETE 5 2 12 2 SHIFT CTRL OLAP 101 4 100 5 2 13 0LAP gt 1
106. MDX MDX 103 2 MDX Worksheet MDX MDX MDX MDX 0LAP MDX Ar 6 OLAP Intelligence SELECT Microsoft SQL Server Books Online WITH Set crystal set name AS Members ee 4 WITH Member parent crystal_member_name AS 1 2 OLAP Intelligence
107. Worksheet 1 lt lt lt lt lt NG MDX MDX OLAP 0 4 7 4 1 0LAP Intelligence Excel Worksheet Excel 1 2 4 7 4 2
108. 0 156 OLAP Intelligence 9 4 Db ee 100 00 100 005 100 157 3 x 332 111 45 160332111 447697
109. 156 100 00 100 005 100 1000 158 159 10 160 Pareto 158 OLAP Intelligence 10 1 1
110. FI 0OLAP Intelligence Xx ec ou 1 0LAP DE CAOLAP Intelli igence Tutor C AOLAP Intelligence T C AOLAP Intelligence Tutori C NOLAP Intelligence Tutor Y 0LAP Web 0LAP OLAP OLAP DHTML ActiveX Web OLAP ActiveX DHTML ActiveX ActiveX 0LAP ActiveX 0LAP Web DHTML
111. 142 OLAP Intelligence Excel Worksheet Worksheet 79 4 7 5 OLAP Intelligence Worksheet Worksheet ee Worksheet 4 0 62 Worksheet 4 7 5 1 Worksheet
112. 3 i o 4 171 153 Worksheet o 11 3 Worksheet Worksheet Worksheet 171
113. CD release pdf OLAP Intelligence 59 4 3 1 2 0LAP Business0bjects Enterprise CMC 0LAP CMC 1 EE gt u 2 1 2 3
114. 8 115 9 Web 0LAP 5 1 4 0LAP o 32 1 2 MeasuresSlice
115. Worksheet 75 Worksheet Measures 139 298 880 85 31 589 476 80 33 436 399 40 26 261 723 40 7 174 676 02 5 371 773 20 4 725 072 566 5646 700 54 10 510 721 83 8 505 040 39 2 005 680 83 12 853 800 35 9 575 611 58 3 278 188 77 32 338 893 35 26 554 E78 06 5 784 215 34 76 376 769 52 563 676 754 16 12 700 015 30 4 7 2 147 Worksheet Worksheet Worksheet
116. 0LTP 0LTP i er 200 20 0LAP 20 000 30 000 0LAP x 0LAP JU OLAP Intelligence 2 2
117. 4 5 7 0LAP OLAP 72 0LAP 1 2 3 4 5 ie OLAP Intelligence 4 6 0LAP OLAP pe 4 6 1
118. 1 2 154 OLAP Intelligence gt o 3 x 0 8 8
119. gt 5 211 13 2 7 hs 1 200 OLAP Intelligence 2
120. 0LAP Intelligence 249 gt 1 2 MDX currentmember level members Except currentmember level members 0LAP Intelligence 249 AllMembers Level CurrentMember Except AllMembers Level CurrentMember Set 17 2 3 OLAP
121. Business 0bjects Business 0bjects A 2 Business 0bjects A 2 1 Business 0bjects http www businessobjects com support Business 0bjects A 2 2 Web CD A 2 2 1 Adobe PDF PDF A 2 2 2 Web Web Web http www businessob jects com support 258 OLAP Intelligence A 2 2 3 CD CD docs
122. DD 216 OLAP Intelligence 14 2 OLAP Intelligence 0LAP car 0LAP Microsoft Excel 219 Microsoft Excel 0LAP OLAP Intelligence OLAP 0LAP BusinessOb jects Enterprise 80 OLAP 14 2 1 0LAP OLAP 1 2 3 CAR
123. Crystal 0LAP 0LAP Business0bjects Enterprise CMC ge CMC BusinessOb jects Enterprise CMC OLAP OLAP 0LAP 17 3 1 0LAP CMC Business0bjects Enterprise OLAP OLAP 1 CMC 2 0LAP 3 0LAP 253 4 InfoView OLAP InfoView OLAP 1 InfoView
124. 115 5 5 0LAP Intelligence Crystal Reports Web Intelligence HTML OLAP Intelligence car Crystal Reports rpt Web Intelligence wid openDocument 0LAP Intelligence openDocument BusinessObjects Enterprise COM SDK Java SDK URL 116 OLAP Intelligence 6 0LAP 6 1 OLAP 0LAP Intelligence OLAP BusinessOb je
125. GD Y toi C CD 6 0 JY 9 Actual 183 6 Budget 7 8 Budget 9 10 12 3
126. OLAP 1 2 cupepetails 3 4 5 0LAP 0LAP 57 my 88 OLAP Intelligence 6 URL 7
127. n EEEEE ll RB n amp 00 OLAP Intelligence 4 gt 5 ns jr 6
128. 3 2 4 5 6 105
129. 4 1 2 CD 4 gt 2 3
130. 124 OL AP Intelligence gt Worksheet 1 2 5 1 1 o 6 5 2 Worksheet 1 2 OLAP Intelligen ce
131. OLAP Intelligence 0LAP Intelligence OLAP Intelligence 8 6 1 1 2 0LAP Intelligence OLAP Worksheet
132. Worksheet Worksheet Next Year Actual Last Year Budget Worksheet 151 8 9 1
133. Q1 224 OLAP Intelligence UPC UDA UDA
134. Worksheet SEE es i Worksheet Worksheet 0LAP Worksheet Worksheet OLAP Crystal Web 56 OLAP Intelligence OLAP 0LAP
135. Business Objects 259 RN http www businessobjects com services consulting A 3 3 Business Objects Web http www businessobjects com services training A 4 Business 0bjects http www businessobjects com Business 0bjects support http www businessobjects com Business 0bjects Business Objects Business 0bjects documentation businessobjects com
136. 1 Worksheet 2 Worksheet i Worksheet 142 8 2 1 Worksheet
137. 5 5 DA 171 34 OLAP Intelligence 4 5 66 Ie ASUreES 338 075 30 556 150 70 69 221 66 795 548 46 791 269 11 155 793 71 152 195 83 368 271 79 359 545 13 139 857 17 131 276 54 40 155 271 49 150 642 02 66 150 70 795 548 46 155 793 71 368 271 79 139 857 17 Measures 0LAP
138. 136 OLAP Intelligence 8 3 2 CTRL SHIFT CTRL SHIFT
139. 6 7 8 13 3 3 1 2 3 4 13 3 4 13 3 5
140. 888 357 6 Jleasures 8 gt oo cn 8 9 OLAP Internet URL http ww google com search q Name 0 Internet amp 8 t 50 OLAP Intelligence gt 1 2 3 Internet a Te
141. 139 oo 138 OLAP Intelligence EE 6 3
142. OY 13 3 2 2 3 4 EE pA OLAP Intelligence 5
143. 6 5 4 3 gt 105 TH o 110 OLAP Intelligence F EEE x Measures
144. 2 8 3 7 0LAP 0LAP Intelligence o oo 140 OLAP Intelligence 8 3 8 Worksheet Products 14 0LAP
145. 3 1 2 y 3 y 4 1 2 3 4 211 0LAP 195 13 2 3
146. I IT gt z 17 4 39 JNMeasures 152 817 69 2 453 80 150 642 02 116 438 84 34 203 18 2 be
147. Worksheet 181 3 I 1 2 Measures I CL 5 4 5 6 7 8 12 2 3
148. 6 11 4 10 000 10 000 10 000 10 000 168 OLAP Intelligence 1 2 3 I
149. OLAP Intelligence GetName Member MDX Name GetName 0LAP Intelligence MDX Name 0LAP Intelligence GetName HTML lt HTML gt lt P gt 1 Name lt P gt lt P gt 2 Name lt P gt lt HTML gt OLAP 97 5 2 3 OLAP B
150. Please choose a me amp 2 oo rr ali 48 OLAP Intelligence 8 14 99 ProductsMembers 3 9 8 0LAP OLAP 0LAP OLAP 22 OLAP 2 OLAP Intelligence 0LAP Intelligence 0LAP 0LAP Worksheet Worksheet
151. a 135 x SHIFT CTRL 0
152. SET _CRYSTAL_SET_ON _AXIS 0 AS MEMBERS SET CRYSTAL_SET_ON_AXIS 0 AS MEMBERS CHILDREN SET CRYSTAL_SET_ON_AXIS 1 AS CHILDREN SELECT SELECT __CRYSTAL_SET_ ON_AXIS_0 ON COLUMNS __CRYSTAL_SET_ON_AXIS_1 ON ROWS 104 OLAP Intelligence wHERE WHERE 40 crRossJoIN CROSSJOIN
153. 166 D00l amp D001 1 5 Cr rys Samples 10 10 1 Worksheet n n
154. 5 85 Doh LS ee ee ee 85 5 1 0 NSW ee 87 5 1 3 9 87 5 1 4 i 88 5 1 5 9 89 5 1 6 i 91 91 5 2 1 oo 0 ee ee i el ode 92 5 2 2 URL HTML i 93 5 2 3 OLAP 97 5 2 4 Web 4 97 5 2 5 i 97 5 2 6 Web CGI 9 98 5 2 7 FTP i 99 5 2 8 i 99 5 2 9 HTML i 99 5 2 10 7 100 5 2 11 4 100 5 2 12 9 100 2 101 5 2 14 Microsoft iii 101 5 3 MDX sl ese 102 4 105 5 4 1 i 105 5 4 2 4 108 5 4 3 i 109 5 4 4 i 111 5 4 5 i L12 5 4 6
155. 0 178 1 179 180 9 Variance 182 9 12 2 1 Bakery 1 2
156. 0LAP 7 4 6 2 1 2 FEED B C 3 OLAP 4 5 4 6 3 1 2 3 0LAP 4 4 6 4 1 2 74 OLAP Intelligence 3 rN
157. Worksheet 0OLAP Intelligence I I 0 DD 9 IN A C Worksheet Worksheet 0LhP Intelligence C I DD 98IN A Wl 170 888 357 64 139 298 880 85 31 589 476 80 Worksheet 1 OLAP 25 Worksheet Worksheet me CE 130000000 50000000 140000000 120000000 100000000 S0000000 50000000 40000000 20000000 Lt Worksheet 1 2 3 Worksheet Worksheet
158. 167 1 39 x gt gt 5000 0 peo 4800000 3600000 2400000 QW a A 6 measures 2400000 3600000 el Li 4800000 6000000 500 0 0 2 3 4 5 171
159. 76 77 79 Worksheet 105 OLAP Intelligence 4 7 3
160. OLAP Intelligence Excel Worksheet 145 8 5 Microsoft OLAP 1 ET x 2
161. 3 8 10 3 Worksheet Worksheet 108 OLAP Intelligence 5 4 2 ET Measures Dr CC 1
162. Worksheet 0 lee Tm Worksheet OLAP Worksheet Worksheet 0LAP Intelligence Microsoft Excel Worksheet 131 132 6 3 OLAP OLAP 0LAP 0
163. 115 8 9 1 2 3 ColumnMembers x amp Ei Dm oO v Yi 4 Web OLAP OLAP 91 5 1 6 0LAP OLAP 0LAP
164. 4 5 7 10 000 10 000 10000 10000 8 171 oo 9 11 5 5 5 5 5 169
165. Worksheet 0LAP Crystal Web 0LAP Worksheet 0LAP 105 1 2 3 4 EA OLAP Intelligence ara
166. filename file C OLAPExamples tutoriall car tutoriall car URL file Web 5 2 9 HTML URL Web HTML 92 HTML HTML MDX OLAP Intelligence 0LAP Intelligence HTML lt HTML gt lt P gt Store Name GetName lt P gt lt HTML gt 100 OLAP Intelligence 5 2 10 gt 2 3 4 en 92
167. 105 4 5 6 0LAP 6 AAAUUCUAAUUUAGCUAAGAAAANNCGUUGNNAUANNAAAANNAANACGCGO Text A I I I I III I I I I I I ey bk 6 99 EE 71 9 Xx o 12 lt E a 0 C ED C7 gt
168. 2 3 0LAP Enterprise 4 0LAP 5 S BusinessOb jects OLAP 5 2 14 Microsoft OLAP Intelligence Microsoft Analysis Services Microsoft Microsoft Analysis Services OLAP Intelligence _ Microsoft Microsoft Microsoft Intelligence OLAP Intelligence Microsoft HTTP OLAP Web 0LAP
169. mailto URL OLAP 1 92 URL 2 3 URL mailto URL URL mailto 98 OLAP Intelligence URL mailto stock mycompany com
170. OO 0 URL 8 E 115 89 9 1 o 2 3 MeasuresSlice ns 6 sj 4 Web
171. gt 1 2 14 14 1 OLAP 0LAP 0LAP Worksheet OLAP 1 2 TELT C f JY F VY Worksheet Worksheet Worksheet
172. 2 HTML lt HTML gt GetCaption lt HTML gt amp T Ja 0 lt HTML gt GetCaption lt IHTML gt C 8 3 4 Worksheet HTML 239 16 5 Essbase UDA OLAP Intelligence UDA UDA UDA UDA es
173. 8 2 2 8 3 0LAP 140 gt 1 Worksheet EEEEDEE x G iy 2
174. Business 0bjects 14 OLAP Intelligence 1 1 1 1 0LAP Intelligence OLAP Intelligence OLAP OLAP OLAP Worksheet 0LAP Intelligence ID x I I DD 9 BIN A JjMeasures a 5 371 773 20 546 700 33 436 399 40 26 261 723 40 T 174 676 02 4 10 510 721 83 8 505 040 93 2 005 5680 83 12 853 800 35 9 575 611 58 3 278 188 77 32 338 893 35 26 554 E78
175. 16 2 Hyperion Essbase Analytic Services OLAP Intelligence Worksheet
176. gt 241 UDA UDA OR AND 4 Worksheet 0 EE xJ Member Property User Define New Market DR Member Property User Define Small Market
177. 2 3 1 5 211 5 oY 0LAP 201 13 2 8 OD DN WwW Ud mm x K 300K 600K 1 2
178. Worksheet 16 3 3 OLAP Intelligence 0LAP Intelligence 0LAP Intelligence 1 0 233 0LAP Intelligence 1 229
179. 82 OLAP Intelligence 4 9 OLAP CAR OLAP 0LAP 1 2 i 4 10 OLAP Intelligence 0LAP AAA 82 OLAP BusinessObjects Enterprise 255 OLAP 2 0LAP 57 0LAP
180. 11 7 171 11 8 a 2 3
181. Worksheet Drs 12 2 Worksheet Worksheet e Variance Worksheet Worksheet 1 2 ee amp Y ee 4 TT 178 OLAP Intelligence 3
182. 1 74 Worksheet 2 3 Web Worksheet Worksheet 76 2 OLAP 143 9 4 7 4 0LAP Worksheet Jeasures 78 OLAP Intelligence gt 1 2
183. 1 2 3 60 OLAP Intelligence 1 2 3 4 4 4 Worksheet I K cs Worksheet 1 2 0LAP
184. 6 1 2 3 211 1 EEC 210 OLAP Intelligence 13 2 14 1 2 5 1
185. o 8 3 9 1 1 2 3 gt 142 OLAP Intelligence OR AND
186. 155 793 71 59 221 66 152 195 83 139 857 17 131 276 54 368 271 79 359 545 13 795 548 46 791 269 11 305 913 51 338 075 30 MDX MDX 5 4 0OLAP 5 4 1 Worksheet Worksheet 1 188 x C 1 E 1 lt gt 106 OLAP Intelligenc
187. 0LAP 2 OLAP 3 EE 17 3 2 0LAP 0LAP CMC 0LAP 1 CMC 2 0LAP 3 4 17 3 3 CMC OLAP OLAP 1 CMC 2 0LAP 3 254 OLAP Intelligence 4 5 OLAP BusinessObjects Enterprise
188. EES x 144 hn Store_sales florist frozen sqft 17100 1ast_remdel_date 1 50 1 62 2 40 2 79 5 18 3 550 91 1973 6 4 3 550 31 19736 4 3 550 91 19736 4 3 550 91 1973 6 4 3 550 91 1973 6 4 3 550 91 19736 4 3 550 91 1973 6 4 3 550 91 1973 6 4 3 560 91 1973 6 4 3 5650 91 1973 6 4 3 550 91 1973 6 4 3 550 91 1973 6 4 3 550 91 19736 4 3 550 91 1973 6 4 3 550 91 19736 4 3 550 91 19736 4 3 550 91 1973 6 4 3 550 91 1973 6 4 2 Excel OLAP OLAP Excel Excel BusinessObjects Enterprise 150 OLAP Intelligence 8 9
189. OLAP Intelligence 57 TH oP 0LAP EMO Intelligence TutorialsATutorial2 car C AOLAP Intelligence Tutorials Tutorial3 car 00 2 OLAP 0LAP 4 3 1 0LAP OLAP 0LAP OLAP Intelligence OLAP Microsoft Excel Wr 0LAP 0LAP be 0LAP Intelligence 0LAP 0LAP OLAP Intelligence 58 OLAP Intelligence
190. ee 0LAP Intelligence amp Intelligence 0OLAP Worksheet 119 Web OLAP 1 BusinessOb jects Enterprise Business0bjects Enterprise 2 Business0bjects Enterprise 3 OLAP Intelligence 4 0LAP ActiveX DHTML 5 CMC Crystal Reports OLAP Intelligence Web 0LAP 1 BusinessOb jects Enterprise BusinessObjects Enterprise 2 OLAP 3 OLAP 6 2 Worksheet Worksheet o Jeasures
191. ml 185 2 EEEIEEEERII IT gt 0 G 2 50 7 12 3 3 245 1
192. ts Market Colorado Connecticut Y lowa Louisiana lt lt Missouri Nevada New Hampshire New Mexico Oklahoma Dregon South lt lt 5 Worksheet 242 OLAP Intelligence 17 17 1 17 1 1 Microsoft 0LAP CUB Microsoft SQL Server OLAP Services Microsoft SQL Server Analysis Services 1 0OLAP 2 e Microsoft OLE DB Provider for OLAP Services Microsoft OLE DB Provider for OLAP Services 8 0 3 0LAP OLAP 0LAP Intelligence Windows
193. 4 211 13 2 5 gt 1 2 198 OLAP Intelligence 1 2 3
194. 7 1 2 ORDER UNIQUE __CRYSTAL SET_ON_AXIS_1 2 40 ASC ON ROWS MDX CD WITH MEMBER AS IIf NULL NULL 100 SET CRYSTAL_SET_ON _AXIS_ 0 _ AS CROSSJOIN 40 MEMBERS SET CRYSTAL _SET_ON_AXIS_ 1 AS CHILDREN 1 SELECT __CRYSTAL_ SET_ON_AXIS_0 ON COLUMNS ORDER UNIQUE CRYSTAL_SET_ON_AXIS_1 40 ASC ON ROWS FROM WHERE 105 MDX
195. LinRegPoint 3 LinRegPoint LinRegSlope y 1 2 LinRegPoint 3 LinRegPoint LinRegIntercept vor 252 OLAP Intelligence 2 LinRegPoint 3 LinRegPoint LinRegVariance gt R 1 2 LinRegPoint 3 LinRegPoint LinRegR2 17 3 0LAP CMC Web
196. 0LAP 0LAP Crystal Web Web CGI HTML OLAP 92 OLAP Intelligence URL HTML URL Web URL HTML Web HTML 0LAP Intelligence 0LAP Intelligence 5 2 1 2 29 1 2 3
197. 2 3 211 4 211 13 3 13 3 1 Ll 5
198. 211 1 i Mt BE 196 OLAP Intelligence 13 2 4 x 800000 700000 600000 S00000 400000 300000 200000 100000 0 1 2 3
199. 4 OO Oo 2 0 a A 211 13 2 6 OLAP ee
200. KPI KPI KPI Web IP 84 OLAP Intelligence OLAP 1 Web 2 3 OLAP CAR Business0bjects Enterprise Web CAR 0LAP Intelligence
201. 8 3 7 6 0LAP OLAP 0LAP OLAP 22 OLAP 1 0LAP Intelligence 2 0LAP Intelligence 0LAP 44 OLAP Intelligence 3 4 0LAP 5 Worksheet 6 7 Worksheet Measures 31 589 476 80 170 888 357 64 0LAP 1 2
202. Nane 8 t 7 8 Worksheet OLAP 1 2 3 4 5 URL C My Documents report3 car 6 7 37 4 OLAP Intelligence 1 0LAP
203. Worksheet Worksheet 134 143 8 4 1 Worksheet Worksheet 0LAP
204. 1 2 3 4 GD YY FE Hi amp 1 6 0 JY VY 5 175 yy 6
205. G OO 0 46 OLAP Intelligence 7 8 9 ProductsNembers 10 29 1 2 YearSlice 3 YearSlice 4 5 ProductsMembers 6 ProductsMembers 0LAP 3 8 7 6 6 0LAP 0OLAP Intelligence Web
206. YearSlice 6 0LAP CEEEEE J amp 0 4 3 co 0 oo Yearslice 0LAP 1 2 ProductsMembers
207. 3 2 8 AAA i 108 5 4 6 Worksheet Worksheet 2 1 2
208. Analysis Services msdn microsoft com 1ibrary Analysis Serv 17 1 2 Essbase DB2 0LAP Essbase DB2 0LAP Hyperion Essbase Runtime Client Excel Microsoft 0LAP Microsoft MSDN Web http ices OLAP Intelligence Essbase DB2 0LAP OLAP 1 2 G OO DB2 0LAP Hyperion Essba
209. li0 5 6 10 1 3 Pareto n n 10 1 a 2 n 3 4 i 5 6 10 1 4 1 2
210. 0LAP OLAP OLAP OLAP 1 CMC 2 0LAP 3 BusinessObjects Central Management Console test02 car DLAP CUB HTTP URL Micrasoft OLE DB Provide ER ER 4 5 6 OLAP 256 OLAP Intelligence A Business 0Ob jects A 1 Business 0bjects
211. 1 0LAP 23 OLAP 0LAP Intelligence 1 0LAP Intelligence 0LAP 0LAP Bor S amp 0LAP 0LAP 57 CD Worksheet pl OLAP Intelligence 61 Worksheet
212. 3 E 8 3 4 8 3 5
213. D7 DHTML 222 0OLAP Intelligence 221 a 219 ge 41 nn 220 Excel 125 216 192 ne 147 oe on 60 or 143 0 OLAP RA TE Te 216 ee 54 1 56 E 126 215 Microsoft Excel ee 125 80 73 ee 255 ee 78 74 AB a 126 ED A 82 217 7 D1 72 Web 118 216 es 117 Ed 73 OLAP 59 59 De 57 DC ee Vo Re 58 OLAP Intelligence 43 OLAP Intelligence i 56 O08AP 57 OLAP ee 0LTP ee 17 P SMT eden 160 127 DTT DI ee 78 162 Business 0bjects 259 210 Q Tg 29 195 ee 149 148 nn 55 68 131 68 A 76 131 132 142 DU 68 Pe 68
214. FE Bn ey E 38 OLAP Intelligence 12 13 14 BEES amp Vi v v amp 15 16
215. Fxcel Excel Y 42 OLAP Intelligence 3 Microsoft Excel Excel 0LAP Intelligence Excel A B ER D E 1 2 3 4 5 6 Ef a 9 2369643 216 2338115 4687 2255014 781 2099441 741 1919304 448 10 1928725 207 1899793 463 1835021 997 1705841 082 1560215 041 440917 9938 438322 0203 419992 7756 393600 6526 359089 395 12 Business 0bjects Microsoft Excel 0LAP Intelligence Excel 220
216. URL 102 OLAP Intelligence 5 3 MDX MDX Microsoft Analysis Services Worksheet MDX OLAP Intelligence MDX 0LAP Worksheet MDX MDX Web 0LAP Microsoft Analysis Services 0LAP MDX MDX SET _CRYSTAL SET_ON_AXIS_0__ AS DISTINCT Measures Weasures Weasures SET _CRYSTAL SFT_0N_AXKITS_1 MAS DISTINCT SELECT 7 MDX MDX
217. 105 2 3 4 109 5
218. 127 ee 189 re 258 H OLAP 57 Hyperion Essbase IBM DB2 0LAP 223 ee 79 2 237 236 Web 0LAP 118 237 Web OLAP 118 229 0 231 a 163 0LAP Intelligence 2 i 2 234 128 229 235 00nd 148 Ce 244 tn 227 264 OLAP Intelligence K KPI 83 vg Ss Ee eo ee 258 128 161 ne 2 css ssn 205 es 130 258 115 es 243 Essbase DB2 0LAP 244 Microsoft OLAP 243 0 199 155 0 197 M MDX 78 102 144 MDX nos 102 1 em 188 MiGEGSGE SG TREE ee a 101 Microsoft Excel ActiveX
219. 74 Worksheet ee Worksheet 0LAP a 85 OLAP a 91 _ OLAP 0LAP Intelligence Business0bjects Enterprise
220. x 4 m 2 3 4 5 URL 115 6 7 8 9 Web OLAP
221. Excel Intelligence gt 1 Microsoft Excel 29 3 Be 3 Business 0bjects 4 OLAP Intelligence 0LAP OLAP Intelligence ActiveX 221 15 3 0LAP Intelligence ActiveX Worksheet Excel 1 OLAP 2 OLAP Intelligence ActiveX Excel x Excel Excel 8 Freel QH Excel
222. gt 1 2 y 3 y 4 0LAP 197 1 2 a 1 2 3
223. 1 2 y 3 4 13 2 2 0 100000 200000 300000 400000 500000 600000 700000 800000 x 211 194 OLAP Intelligence 1 2
224. 8 0LAP 53 0LAP 0LAP CD sales Reports cub 3 2 1 OLAP Worksheet 0LAP FO oox CI CI 0 DD 9 BIND A Neasures 10 510 721 83 8 505 040 99 2 005 680 83 12 853 800 35 9 575 611 58 3 278 188 77 32 338 893 35 26 554 678 06 5 784 215 34 T6 376 769 52 63 676 754 16 12 700 015 30 33 436 399 40 26 261 723 40 7 174 676 02 NMeasures 80000000 T0000000 B0000000 50000000 40000000 UE 30000000 20000000 10000000
225. Product Caffeinated Caffeinated_True 1 Worksheet Proquct 2 Worksheet Ss 226 OLAP Intelligenee 3 No Measures Product Profit Product 105522 Root Beer 27954 27954 Cream Soda 25799 25799 Fruit Soda 21301 21301 Year Year Market Market
226. 139 298 880 85 31 589 476 80 26 OLAP Intelligence 4 5 6 GE Worksheet 03 04 i 1 928 725 21 1 899 793 46 1 835 022 00 440 917 99 438 322 02 419 992 78 1 0LAP 27 4 orAp Intelligence mlx CI XI DBI S I 93 GIN A 2 369 643 22 1 928 725 21 440 917 99 2 338 115 49 2 255 014 78 1 899 793 46
227. 147 8 6 2 OLAP Intelligence 1 2 3 Name 4 OLAP 1 2 e Name 8 7 Europe UK France Spain UK
228. OLAP 3 6 5 Microsoft Exc 0OLAP Intelligence el Microsoft Excel 0LAP Intelligence Microsoft Excel 0LAP Intelligence Excel Excel 220 Microsoft Excel 1 OLAP 0LAP Intelligence 22 1 OLAP Microsoft Excel 1 2 Excel Excel 8
229. TH 184 OLAP Intelligence 2 EEEIEEEERII IT gt RE EE ER x 1 2 n 3 4 5 6 12 3 2 ee 1
230. URL OLAP 115 7 47 OLAP 1 oo 0LAP EE gt sa MD003
231. i 183 12 3 2 i 184 12 3 3 185 186 12 4 1 i 187 12 4 2 MDX 188 12 4 3 i 189 12 4 4 i 189 12 4 5 i 189 13 TE OE TE YT ep 191 192 13 2 1 ee 192 193 195 2 196 9 20 197 EE 198 i897 199 es 200 0 201 10 OLAP Intelligence 19 2 9 0 202 ep 01 0 OOO OOOO ER 203 2 UE 0 205 13 2 12 0 207 13 2 13 ee 208 13 2 14 210 1 3 voiioo oi 13 3 1 9 211 13 3 2 i 211 13 3 3 4 519 13 3 4 i 212 19 8 0 212 13 3 6 ee 213 13 4 ss pa 14 a 215 216 14 2 1 ee 216 14 2 2 0LAP ee 216 430 OLAF OR 217 15 Microsoft Excel ns 219 2 oon eo
232. 230 OLAP Intelligence 4 Dimension Q_T_D Hyperion Q T D Logical Member Numeric Set String Tunle edd Ci mw mw mmw 5 lt lt 2 gt Ea C H_T_DI lt lt Base Member on Time Dimension gt gt 231 6 Ea C H_T_DI 3
233. 4 Tf OLAP 105 3 OLAP Intelligence 3 report2 co a SHIFT 8
234. 5 2 6 Web CGI Web CGI 1 92 URL 2 URL CGI g CGI URL http cgiprogram paraml valuelg amp param2 value2 amp paramN valueN cgiprogram CGI param pr value OLAP 99 5 2 7 FTP FTP FTP 1 92 2 URL ftp ftpdomain filename URL ftpdomain FTP filename 5 2 8 92 URL file path filename Ppath
235. 8 1 338 075 30 9 51 F 66 150 70 69 221 66 4 44 795 548 46 791 269 11 0 54 155 793 71 152 195 83 2 36 368 271 79 359 545 13 2 43 139 857 17 131 276 54 6 54 Measures 40 Worksheet 66 29 5 5 A FB xl gt 8 crErm ee a lo ee 160000000 120000000 80000000 U SS 40000000 95 v 80000000 5 ag 120000000 Li 160000000 200000000 5 0 FF gt gt 0
236. 87 5 1 2 0LAP i 7 2 3 5 1 3 OLAP 0LAP OLAP
237. OLAP 93 8 MDX OLAP Intelligence 9 MDX OLAP Intelligence MDX 102 MDX Microsoft SQL Server 0LAP Services 0LAP Intelligence 5 2 2 URL HTML URL HTML URL Web URL HTML Web HTML MDX 0LAP Intelligence URL HTML URL 0LAP 0LAP 0LAP MDX 102
238. HTML 0LAP 0LAP Crystal 0LAP Worksheet 1 2 Web OLAP 123 6 5 OLAP Intelligence Worksheet Worksheet
239. 0 9galING A Jeasures 200000000 160000000 120000000 80000000 40000000 Measures 65 1 2 EE x 0 IY 0 IY 0 E ER 3 191 0 66 OLAP Intelligence 1
240. 3 DJ Cf YY Ee 2 EE Wn C 0 4 5 6 7 8 12 2 3 LAH Ho 1 2
241. Analysis Services Windows 0LAP Intelligence Microsoft Analysis Services CUB CUB CUB HTTP icCube HTTP lt TRE 99 3939 244 OLAP Intelligence HTTP 8 URL http https URL 0LAP HTTP
242. 68 120 142 pn de 142 eeaeasaneeaaaana0aaaa 88 77 nt 183 251 a 249 NO ed I Ee 128 ope 166 265 S 0 126 Re 207 162 163 HR 59 161 nd 156 ee 162 ae 156 I RE RE 59 Bay Hyperion Essbase IBM DB2 OLAP Te Ee 115 OLAP 0P i os 76 cece 140 76 0LAP ee 82 217 T 148 147 148 Worksheet 0LAP D1 MDX 105 0LAP 72 OLAP SA 58 59 DE 68 137 ee 134 Ee 67 138 A A 193 Web 0LAP 118 Worksheet 2 Re 54 63 192 Microsoft Excel i 219 192 126 214 Worksheet 127 A ONC LAO tn ede ten 203 Worksheet ep EN A 119 OTT TT 191
243. UDA UDA 7 UDA gt gt 8 Worksheet 9 Worksheet 1 2 3
244. 03 04 2 338 115 49 2 255 014 78 1 928 725 21 1 899 793 46 1 835 022 00 440 917 99 438 322 02 419 992 78 0LAP 3 3 2 OLAP 0LAP Business0bjects Enterprise OLAP 2 3 1 0LAP Enterprise BusinessOb jects Enterprise 2 OLAP 23 8 2 3 4 C Enterprise x BUSINESS 9UVv4R4 RD CRYSTALD NET Administrator oe Root Folder testozl car
245. Measures 3 4 425 334 244 154 RE 7 Madsur es x 700 600 500 AN d00 SS se so0 1 2 Ws MDX Iif Count Filter Time currentmember level members IsEmpty Measures Actual Time currentmember gt 1 LinRegPoint rank Timel currentmember Timel currentmember level members Timel currentmember level members 1 0 Measures Actual rank Timel currentmember Timel currentmember level members NULL currentmember 1evel members NOT 248 OLAP Intelligence Except Time currentmember level members Time 1999 3 Ti me 1999 4 Iif Count Filter Time l currentmember level members NOT IsEmpty Measures Actual Timel currentmember gt 1 LinRegPoint rank Time curren
246. OLAP Worksheet SAP SAP BW SAP SAP Integration Kit Worksheet Worksheet Worksheet
247. 127 eb 198 ee 66 0LAP a 208 18 ee 205 0 199 248 197 123 ean 192 a 245 210 124 195 123 wearasasaaegaaasaaasaaedueaasandatagtaeaaasalsal 207 183 S414 185 65 184 64 124 et 193 ee 248 EM UO 212 le ee 183 Do 211 0 202 1 Ee 162 201 0 163 a 12 162 1 196 266 OLAP Intelligence Vornkehest mim 120 sea ee 146 2 Ue 76 ee DE en 142 214 133 0 165 Y 171 i 170 129 Enid i 73 168 91 166 0LAP wn 72 167
248. OLAP 5 1 5 OLAP 1 2 columnMembers 3 OLAP Intelligence URL
249. Worksheet 2 OLAP Intelligence 16 3 4 0LAP Intelligence 0LAP Intelligence 0LAP Intelligence 0LAP Intelligence 1 229 2 0LAP Intelligence
250. 0 91 saogansssnind nie 113 152 163 89 147 87 Ee 19 C Worksheet 74 CMC i 252 7 aawaeaaaareaiaiuaiwwueuuaamaae 7 CUB a 130 2 EE S60 20 133 0nd 89 80 128 177 i 88 76 ne 85 se 162 87 133 43 46 147 nn 120 a OO OO eg ee 133 8sssarsaansivineirisniiseii i 85 NS 146 262 OLAP Intelligence 140 121 ii 145 VR 87 I 140 121 Essbase Hyperion Essbase IBM DB2 7 89 OLAP 156 Bxcel Microsoft Excel RE OAD 80 1 jE ee en oe 133 A 28 lt DD EEO A TE EAT 258 I 121 Pr 76 88 0LAP ee 80 216 D NT ee
251. 0OLAP Intranet Extranet Business0bjects Enterprise Business0bjects Enterprise 0LAP Business0bjects Enterprise 3 A 1 OLAP 1 0LAP Intelligence 2 Enterprise EE x Ct Enterprise BUSINESS 9UV4R4 RD CRYSTALD NET IE3 Administrator Root Folder 00 testzlcr 3 Business0bjects Enterprise 4 0LAP 5
252. i 161 10 1 6 i 161 10 1 7 i 161 10 1 8 i 161 POD a a ee Ee 161 10 2 1 i 162 10 2 2 163 10 2 3 i 163 10 2 4 ee 163 10 2 5 9 164 11 165 11 2 ii 166 11 3 550 on Doli a 166 11 4 167 11 5 ood 168 i 170 11 7 si 170 9 11 8 oie hl 12 12 1 i 175 12 1 1 i 175 12 2 Worksheet i Lv 12 2 1 i 178 12 2 2 i 179 12 2 3 i 180 12 2 4 i 182 12 3 i 183 12 3 1
253. Essbase DB2 0LAP i 244 17 2 ooo 245 17 2 1 i 245 17 2 2 4 248 17 2 3 iii 249 17 2 4 249 17 2 5 i 250 17 2 6 i 251 17 3 252 17 3 1 OLAP i 252 17 3 2 0LAP i 253 17 3 3 i 253 17 3 4 i 254 12 0LAP Intelligence 17 3 5 i 255 A Business 0bjects A 1 i 257 A RD OR A 057 A 2 de 257 257 0 257 WO 257 Fa CD 258 X29 0 258 258 A 3 1 ee 258 7 258 A 3 2 258 A 3 3 i 259 Re 259 1 0OLAP Intelligence XI Release 2 1 1
254. OLAP Intelligence 192 OLAP Intelligence 13 2 OLAP 0LAP Intelligence 0LAP OLAP Worksheet OLAP gt
255. a 77 269 944 43 17 949 784 32 2 909 240 98 2 560 628 88 348 612 11 4 994 659 36 4 038 730 76 955 928 60 6 838 943 17 5 094 942 33 1 744 000 84 17 863 646 65 14 667 824 72 3 195 821 94 43 843 819 51 36 558 658 63 7 285 160 95 18 769 419 00 14 349 159 12 4 420 259 88 AL11 Products 133 120 OLAP Intelligence
256. i 113 5 4 7 i 114 115 6 OLAP Intelligence 6 OLAP L171 6 1 1 0LAP i 117 6 1 2 Web 0LAP i 118 DT Vorehes 119 3 0L 120 en 123 6 5 1 ee 123 6 5 2 i 124 7 Wl TE 125 7 1 1 Excel ae 125 7 1 2 i 126 7 1 3 SAP 4 126 A 2 126 7 1 5 127 7 1 6 i 128 7 1 7 ee 128 7 1 8 i 128 7 1 9 i 129 7 1 10 130 7 1 11 130 7 1 12 130 7 1 13 9 130 8 Bl So de a a 131 8 1 1 i 132 8 2 ST A EIR UR I pe TR 8 2 2 i 133 et 133 8 3 1 i 134 8 3 2 i 136 8
257. 1 0 4 4 Ot da a i 26 0 40 we 26 40 OLAP Intelligence EE Measures 60 2 Neasures i 15 16 95 02
258. 216 80 OLAP 5 0LAP 5 1 0LAP OLAP 0LAP URL 115 0LAP 120 OLAP 5 1 1 OLAP Intelligence 0LAP 1
259. Worksheet 2 Worksheet Worksheet 131 oLhP Intelligence x 93 BIIN A 139 298 880 85 31 589 476 80 4141p pL OLAP Intelligence VY 3 Worksheet Worksheet Worksheet 1 Worksheet 2 Workshee see et Jv 8 JY IY zz 3 Worksheet
260. ei 73 105 W ge ode 105 Web saan 60 0 ee en 118 Ne 257 EE 121 si 258 ee 91 259 Web Intelligence 15 Web 113 ET 259 ww 73 2 258 a 184 RT 132 ee 249 128 131 A 68 120 eo 151 119 77 143 133 pe 78 144 vs 82 No 78 144 Hyperion Essbase IBM DB2 OLAP es Worksheet i 62 140 Worksheet 119 OA mn LU gs CD ES DD ese 267 79 196 OLAP 84 82 175 sd 257 175 RL 149 0 124 268 OLAP Intelligence
261. 4 0LAP 205 211 A RW 3 fy SS 13 2 11 x JIeasures FE Measures
262. x En 6 lt SEE tL C EE 7 8 156
263. Adobe PDF A 2 3 documentation businessob jects com Business Objects http y www businessobjects com support A 3 Business 0bjects A 3 1 Business 0bjects A 3 1 1 Business Objects Web http www businessobjects com support A 3 2
264. mailto cc pcc subject body amp URL mailto cc amp subject URL MDX 0LAP Intelligence MDX mailto stock my_company com subject Name OLAP Intelligence mailto stock my_company com subject GetName
265. scotland England Wales Northern Ireland Worksheet 148 OLAP Intelligence Wine and Spirits bl EU 4l 50 8 7 1 A
266. 0LAP Intelligence 0LAP OLAP 0LAP Intelligence OLAP BusinessObjects Enterprise 0LAP Web OLAP CD aocs PDF 0OLAP Intelligence 1 1 1 OLAP Intelligence OLAP Intelligence OLAP Intelligence 0LAP Intelligence OLAP Intelligence OLAP Intelligence OLAP Intelligence Business0bjects Enterprise Microsoft Excel OLAP Intelligence SAP BW OLAP Intelligence
267. 2 369 643 22 2 338 115 49 2 255 014 78 1 928 725 21 1 899 793 46 1 835 022 00 440 91799 438 32202 419 992 78 amp 02 03 04 2400000 2000000 3600000 2200000 800000 400000 Fa 0 DHTML Business0bjects Enterprise ActiveX Intelligence ActiveX OLAP 0LAP Worksheet 0LAP Intelligence 0LAP Intelligence 0LAP Intelligence OLAP 3 4 3 80 OLAP 0LAP OLAP
268. Al 5371773 198 10510721 83 12853800 35 32338893 35 B6376769 52 33436399 4 0LAP Intelligence ActiveX Excel DHTML Excel Web HTML Excel Worksheet Excel Worksheet 0LAP Worksheet 220 OLAP Intelligence 15 2 0LAP Intelligence ActiveX 0LAP Intelligence OLAP Intelligence ActiveX Excel 0LAP I
269. MDX Microsoft SQL Server 0LAP Services 0LAP Intelligence 5 2 2 1 URL Web URL URL http www businessobjects com URL Web Business 0bjects Web MDX OLAP Intelligence URL MDX OLAP Intelligence URL URL MDX OLAP Intelligence MDX OLAP Intelligence URL MDX URL mailto stock my_company com subject Name 94 OLAP Intelligence OLAP Intelligence mailto stockemy_company com subject GetName MDX OLAP Intelligence 5 2 2 2 HTML lt HTML gt lt P gt Busin
270. 0LAP CAR 14 2 2 OLAP OLAP OLAP 1 2 3 0LAP 217 14 3 0LAP OLAP OLAP 0LAP 0LAP 1 or Iat e113 e202 eeeerr 2 OLAP 218 OLAP Intelligence 15 Microsoft Excel 15 1 OLAP Intelligence Worksheet Microsoft Excel Excel ol CI 0 CI OLAP Intelligence 0 St lz zla UI
271. 2 3 4 5 6 7 OLAP orhAp Intelligence I I 0 DB 93 BIN D A gt 199 567 968 31 ttt CIFIOCNEAY OLAP 4 OLAP 4 1 OLAP Worksheet Re
272. Measures store size Y X MDX Iif currentmember name mnul1l abs currentmember name sgn currentmember name tt Se rank 2
273. OLAP Intelligence Th 2 3 4 1 2 3 4 13 13 1 OLAP Intelligence 0LAP Intelligence
274. PI Es ES Wy 2 LAA AAA pp SS Ny N Ea 4 NS MDX MDX OLAP 8 4 2 1 0LAP Intelligence 0LAP Excel Worksheet 0LAP Excel 1 2 8 4 2 2 142
275. 1 1 1 3 Microsoft Excel OLAP Intelligence OLAP Intelligence Microsoft Excel OLAP 0 Microsoft Excel 0OLAP Intelligence 1 1 2 0LAP Intelligence OLAP Intelligence OLAP Intelligence CD docs PDF OLAP Intelligence 0LAP Intelligence OLAP 0LAP Intelligence OLAP 0LAP Intelligence OLAP Intelligence 0LAP
276. 170 OLAP Initelligenee 5 5 5 5 so gt gt ES 200000000 160000000 120000000 80000000 CI GO E zz Ri FE amp 1 ULL MLL 40000000 0 40000000 80000000 120000000 160000000 200000000 5 0 0 79 9 11 6
277. 3 4 1 Y 2 3 211 0LAP 207 13 2 12 x 1200000 1000000 800000 600000 2 090 200000 0 OK 200K 400K 600K BOOK 1000K 1200K XY 1
278. 4 MDX 0LAP Intelligence MDX OLAP Intelligence AS ASS 5 6 URL HTML URL Web URL HTML Web HTML 7 URL HTML URL HTML URL HTML 93 URL HTML
279. 06 5 784 215 34 T6 376 763 52 63 676 754 16 12 700 015 30 Jeasures Neasures 15 Worksheet 0LAP problems Worksheet 1 1 1 2 OLAP Intelligence BusinessObjects Enterprise BusinessObjects Enterprise OLAP Intelligence OLAP Intelligence Business0bjects Enterprise 0LAP Web BusinessOb jects Enterprise OLAP Intelligence Web InfoView OLAP OLAP OLAP Intelligence OLAP Intelligence
280. ES 9 2 ES 1 EK 123 456 00 4 155 156 9 2 Worksheet
281. Web BusinessOb jects Enterprise 0LAP 80 54 OLAP Intelligence 4 2 0LAP N Al 8 1 0LAP Intelligence OLAP Worksheet 0LAP Worksheet Worksheet Worksheet Worksheet
282. Worksheet 179 3 C Ee 0 4 5 6 12 2 2 Bakery 1 2 180 OLAP Intelligence
283. 3 185 933 47 182 897 07 151 740 06 150 640 01 148 588 54 43 284 06 35 293 46 34 308 54 2 Heasures 200000 i er sa 240000 160000 120000 3 report3 5 Microsoft E xcel 41
284. 55 69 DB2 0LAP Hyperion Essbase IBM 2 107 DB2 OLAP i 113 DHTML 118 105 0LAP ee 126 215 37 156 non 105 63 114 520 105 hctiveX sso 221 NS 108 DHIME gsrawisinbeni 222 0000 108 OLAP Intelligence 221 107 112 Microsoft Excel i 125 219 109 41 ee 111 219 ee 105 et 220 0LAP ho 68 0OLAP 00 73 dil 66 Worksheet 221 nn pA 1 Te 155 155 GG Hyperion Essbase 2 198 IBM DB2 OLAP 141 sneervinonninmni 145 ssessseseeessssssssssasaas 153 ee 132 pon 130 133 171 lt 133 2 18 pa i 255 255 59 000000 82 77 0LAP css 58 77 134 Ee 216 0LAP 0 130 263
285. Scenario Scenario Caffeinated Caffeinated inactive Dunces Dunces inactive Population Population inactive Intro Date Intro Date inactive PkgType Pkg Type linactive attibute Calculations Attribute Calculations DIENTEEEEE gt 4 5 sa Caffeinated Caffeinatedq_mTrue x 5 8 ty Caffeinated Dl Caffeinated Caffeinated True Caffeinated_False Caffeinated 227 16 2 2 Worksheet Measures Product Product 73510 Root Beer 19226
286. Worksheet Worksheet Worksheet Worksheet Worksheet i Worksheet OLAP 55
287. amp BusinessOb jects Enterprise OLAP Business0bjects Enterprise NET InfoView Web URL http webserver businessobjects enterprisel15 InfoView webserver Business0bjects Enterprise Web Web URL BusinessOb jects Enterprise InfoView 0LAP BUSINESS OBJECTS Iinfoview L OLAP Intelligence X X 6 0 2 test02 car Eo 0LAP 30 OLAP Intelligence
288. support http www businessobjects com Business 0bjects http www businessobjects com Business 0bjects services training services consulting Business 0bjects Business 0bjects http www businessobjects com 260 OLAP Intelligence A DT TA 91 ActiveX 118 85 56 91 122 B 100 Business Objects deg 92 259 WeB 97 258 a 99 258 259 0LAP 97 He 130 CO 101 J 115 CGI 98 D0 DN 2 216 a 100 i 59 48 59 101 192 99 ns 147 ED 95 203 114 ppp 97 santas 151 HNL ti 99 154 a 93 De 150 OE PMP WR 1 i 152
289. x East East East East Level 1 2 True 5 Server Provided User Defined Attributes Major Market 16 5 1 UDA UDA UDA 1 Worksheet 2 3 240 OLAP Intelligence 4 Mem 5 UDA lt gt UDA 6
290. x 700000 600000 500000 bd 400000 300000 S 2 200000 100000 0 Ok 100K 200K 300K 400K S00K 600K 700K 800K YY 2 2 2 3 2 3
291. 1 182 OLAP Intelligence 4 6 29 BAsc BDEsc 12 2 4 Budget Actual 4 5
292. 1 835 022 00 1 438 322 02 419 992 78 OLAP 0LAP 1 Weald 9 Wa a 2 gt Web 0LAP Business0bjects Enterprise 2 3 SSSSSSS 28 OLAP Intelligence 4 0LAP screen hot_pe46 car OLAP Intelligence Io x I al
293. 3 3 4 136 8 3 4 i 137 8 3 5 i 137 8 3 6 i 139 8 3 7 ee 139 8 3 8 iii 140 8 3 9 se 140 141 142 8 4 1 se 143 8 4 2 143 5 145 8 6 146 8 6 1 ee 146 8 6 2 i 147 EO 147 8 7 1 ee 148 8 7 2 9 148 OE 149 8 9 i 150 8 9 1 i 151 8 9 2 151 8 9 3 i 152 ys 152 152 8 OLAP Intelligence 9 01 Workeheet 153 9 2 i 155 a a a ed 155 6 on ee 156 10 a a ee ee et 157 10 1 1 i 158 10 1 2 0 159 10 1 3 Pareto iii 160 10 1 4 160 10 1 5
294. 4 6 5 0LAP 6 2 4 6 6 105 4 7 Worksheet Worksheet 0LAP Worksheet OLAP Worksheet 0LAP 4 7 1 Worksheet Worksheet
295. 6 2 OLAP A 1 i 18 ON We 19 3 EE eal 3 2 1 0LAP i 22 So A OI a 28 3 4 3 0LAP odie 30 Dd a dd a de 3 3 6 5 Microsoft Excel 41 3 7 6 0LAP i 43 Se 46 9 85 oseeeeOGOeeOoee OO 48 OLAP Intelligence 4 OLAP 4 4 4 4 4 SH I 0 53 2 0LAP i 54 SJ VLD Titel isante 0 56 4 3 1 57 ee en 60 DS ee a 61 4 5 1 Workeheet 3 es di a 61 4 6 9 oe cede en od i dd i ed en ed 63 4 5 3 i 66 OO 68 DT 69 4 5 6 ee 70 5 a i 71 6 0LAP i A OY DL a ee a ee ee 72 4 6 2 0 73 4 6 3 i 73 6 73 gD TH TE TE 74 4 6 6 ee 74 7 Wotkeleet sin 7 4 37 WOrkehee8t a ee a ee 74 4 7 2 se 75 7 3 3 76 4 7 4 0 77 4 7 5 i 79 rn OL AD RR Sood em de nme a ed en oe 80 9 VV 82 UE 2 82 11 82 5 5 OLAP
296. Cream 5oda 25799 Fruit Soda Null Year Year Market Market Scenario Scenario Caffeinated Caffeinated_True Dunces Dunces linactive Population Population nactivel Intro Date Intro Date inactivel Pkg Type Pkg Type inactivel attibute Calculations Attribute Calculations ke books 18 fiction 1 reference 5 history 6 Books fiction reference history books 228 OLAP teLligernea
297. Intelligence X X 250 251 17 2 4 3 5 7 3
298. OLAP Intelligence OLAP Intelligence XI Business Objects Business 0bjects 5 555 403 6 247 008 B1 6 578 027 B2 6 490 593 6 289 352 Business Objects Business 0bjects Crystal Reports Crystal Enterprise Business 0bjects SA Copyright C 2005 Business 0bjects Business 0bjects http www businessobjects com thirdparty 1 0LAP Intelligence XI Release 2 ee EO ATT 13 1 1 1 OLAP Intelligence 9 13 1 1 2 9 16 1 1 3 Business 0bjects i 1
299. cel 16 OLAP Intelligence Hyperion Essbase IBM DB2 0LAP 16 1 OLAP Intelligence XI R2 Essbase DB2 0LAP Hyperion Essbase IBM DB2 0LAP Essbase 0LAP Essbase Essbase block storage Esspase
300. cts Enterprise BusinessO0bjects Enterprise 0LAP 6 1 1 OLAP BusinessOb jects Enterprise OLAP OLAP 1 0LAP Intelligence FRUIT 0LAF Ll 0LAF fo Y 2 3 Enterprise Business0bjects Enterprise i8 OLAP Intelligence 4 5 0LAP OLAP 66 99 S 0LAP 3 6 1 2
301. e 2 3 4 Worksheet Worksheet Worksheet Worksheet
302. es MDX 187 12 4 1 gt 1 2 EI C 0LAP Intelligence MDX 3 4
303. ess Objects lt P gt lt HTML gt HTML Business Objects Web HTML MDX OLAP Intelligence HTML MDX OLAP Intelligence HTML MDX 0LAP Intelligence 0LAP Intelligence HTML lt HTML gt lt P gt Store Name GetName lt P gt lt HTML gt 5 2 2 3 MDX OLAP Intelligence URL HTML OLAP Intelligence GetName GetUniqueName GetCaption Getcaption MDX OLAP 95 EE Measures LL
304. n 220 15 3 OLAP Intelligence ActiveX 2 DHTWE oo 0209 16 0LAP Intelligence Hyperion Essbase IBM DB2 0LAP DO 2 ET 2 16 2 1 i 225 227 1 229 16 3 1 i 229 16 3 2 i 231 16 3 3 OLAP Intelligence 232 16 3 4 0LAP Intelligence 234 16 3 5 i 235 ee 236 16 4 1 i 236 16 4 2 ee 237 16 4 3 i 237 16 4 4 0LAP Intelligence 238 TO a a ed a 239 16 5 1 UDA i 239 17 A a 243 17 1 1 Microsoft OLAP 4 243 17 1 2
305. nce 5 4 5 36 36 1 105 2 3 4 5 6 22 8 3 2
306. ntelligence ActiveX Work Worksheet Excel Excel OLAP Intelligence sheet Excel Intelligence 1 Microsoft Excel 2 3 Business 0bjects 4 Microsoft OLAP Intelligence Excel 0LAP
307. se 7 0 7 1 IBM DB2 OLAP 8 2 IBM DB2 0LAP Server Essbase Hyperion Essbase 7 0 7 1 IBM DB2 OLAP 8 2 Hyperion Essbase 66 2 EE 245 8 BE 17 2 17 2 1 gt Worksheet Worksheet
308. sheet JMeasures 55 793 126 261 31 29 sz 66 150 70 58 034 54 8 116 305 913 51 269 256 53 36 656 795 548 46 662 276 42 133 272 8 lt 40 sures so0000 Tooo00 ooooo 00000 asul 00000 9 36 OLAP telligence 1 2 oo A co 09 6
309. tmember Except Time currentmember level members Time 1999 3 Time 1999 4 Except Time currentmember level members Time 1999 3 Time 1999 4 1 0 Measures Actual rank Time currentmember Except Time currentmember level members Time 1999 3 Time 1999 4 NULL Worksheet 1 2 17 2 2 Worksheet Worksheet Worksheet 251
310. usiness0bjects Enterprise ot Crystal Web Intelligence openDocument 0LAP Intelligence openDocument BusinessObjects Enterprise COM SDK Java SDK URL 5 2 4 Web OLAP Web Web a 92 URL URL Web URL MDX OLAP Intelligence e MDX http www google com search h1 en amp ie UTE 8 amp dq Name 0OLAP Intelligence http ww google com search hl en amp kie UTF 8 amp q GetName Web MDX 0LAP Intelligence 5 2 5

OLAP Intelligence user manual

Contents

Download Pdf Manuals

Related Search

Related Contents