m_ug_cr_qstd_ibmbook.ps

Transcription

1 IBM Cognos Query Studio

2 119 IBM Cognos Business Intelligence IBM Cognos Query Studio Version User Guide Licensed Materials - Property of IBM Copyright IBM Corporation 2005, 2014.

3 Microsoft Excel Lifecycle Manager Excel 2000 Excel Query Studio IBM Cognos Business Intelligence Web PDF CSV XML Microsoft Excel IBM Cognos Report Authoring Copyright IBM Corp. 2005, 2014 iii

4 "" IBM Cognos Business Intelligence A QE-DEF _make_timestamp "HRESULT= DB_E_CANTCONVERTVALUE" RQP-DEF-0177 'sqlpreparewithoptions' ='-69' UDA-SQL Content Store ( QE-DEF-0288) Safari HTML PDF Oracle Essbase Studio/Authoring OLAP SSAS TM1 TM1 Executive Viewer IBM Cognos Business Intelligence iv IBM Cognos Query Studio :

5 TM SSAS B Sample Outdoors Sample Outdoors Sample Outdoors "GO ()" "GO ()" C % D. Microsoft Excel IBM Cognos Business Intelligence Content Store Excel IBM Cognos Business Intelligence XLS Netscape 7.01 Excel IBM Cognos BI # Excel SSL (Secure Socket Layer) Excel Excel Excel E Excel Excel Excel E v

6 A B C D E F G H I J L M N O P Q R S T U W vi IBM Cognos Query Studio :

7 1 IBM Cognos Query Studio Query Studio Web Web IBM Knowledge Center ( IBM Cognos Query Studio IBM Sample Outdoors Company Great Outdoors Company GO Sample Outdoors Great Outdoors Planning IBM IBM Copyright IBM Corp. 2005,

8 2 IBM Cognos Query Studio :

9 2 IBM Cognos Business Intelligence IBM Cognos Business Intelligence IBM Knowledge Center ( support/knowledgecenter) Web IBM Cognos IBM Cognos Customer Center ( IBM Cognos Query Studio IBM Cognos Query Studio 66 Microsoft Excel 2007 IBM Cognos Business Intelligence Microsoft Excel 2007 Copyright IBM Corp. 2005,

10 IBM Cognos Business Intelligence Microsoft Excel ,000 ( 16,384 1,048,576 ) Microsoft Excel 2007 IBM Cognos Business Intelligence Administration and Security Guide Web IBM Cognos : 21 Microsoft Excel Microsoft Excel Lifecycle Manager Lifecycle Manager IBM Cognos Lifecycle Manager Lifecycle Manager IBM Cognos ReportNet 1.1 MR3 MR4 IBM Cognos IBM Cognos Business Intelligence Windows 2 IBM Cognos Business Intelligence Lifecycle Manager IBM Cognos Lifecycle Manager User Guide 4 IBM Cognos Query Studio :

11 PDF CSV ( ) Microsoft Excel (XLS) IBM Cognos 16 PDF {} () " (2004)" "" "(2004)" Excel 2000 Excel 2000 Microsoft Excel 2000 Excel

12 6 IBM Cognos Query Studio :

13 3 Query Studio IBM Cognos Query Studio IBM Cognos Business Intelligence Query Studio v v v v Query Studio IBM Cognos Business Intelligence IBM Cognos Report Authoring IBM Cognos Report Authoring IBM Cognos Business Intelligence Report Authoring Report Authoring Report Authoring Query Studio IBM Cognos Report Authoring Report Authoring ( ) IBM Cognos Workspace IBM Cognos Workspace Web IBM Cognos Copyright IBM Corp. 2005,

14 IBM Cognos Workspace Advanced IBM Cognos Workspace Advanced IBM Cognos Workspace IBM Cognos Workspace Advanced IBM Cognos Report Authoring Express Cognos Connection IBM Cognos Connection IBM Cognos Business Intelligence Web Framework Manager IBM Cognos Framework Manager IBM Cognos Business Intelligence IBM Cognos Framework Manager IBM Cognos Business Intelligence Analysis Studio IBM Cognos Analysis Studio IBM Cognos Business Intelligence Analysis Studio Metric Studio IBM Cognos Metric Studio IBM Cognos Business Intelligence 8 IBM Cognos Query Studio :

15 Event Studio IBM Cognos Event Studio IBM Cognos Business Intelligence Event Studio IBM Cognos Business Intelligence IBM Cognos Business Intelligence IBM Cognos Business Intelligence IBM Cognos Business Intelligence IBM Cognos Framework Manager IBM Cognos BI IBM Cognos Business Intelligence IBM Cognos Solutions Implementation Methodology IBM Support Portal ( finding-answers) IBM Cognos BI IBM Cognos BI 1. 3 Query Studio 9

16 IBM Cognos BI Web Business Intelligence Studio/Authoring () Framework Manager 2. IBM Cognos BI Studio/Authoring Studio/Authoring IBM Cognos Workspace Advanced IBM Cognos Query Studio IBM Cognos Analysis Studio IBM Cognos Report Authoring Report Authoring IBM Cognos Connection Report Authoring 3. IBM Cognos Business Intelligence Studio/Authoring IBM Cognos Business Intelligence IBM Support Portal ( software/analytics/support/finding-answers) Web IBM Cognos Connection Web IBM Cognos Business Intelligence IBM Cognos Connection Web 2. URL Enter 10 IBM Cognos Query Studio :

17 : IBM Cognos Query Studio Query Studio v v v v IBM Cognos Framework Manager IBM Cognos Connection Query Studio 1. IBM Cognos Connection 3 Query Studio 11

18 2. Query Studio Query Studio : Query Studio IBM Cognos Connection OK Query Studio / IBM Cognos Query Studio 12 IBM Cognos Query Studio :

19 IBM Cognos Viewer v v HTML IBM Cognos Connection IBM Cognos Framework Manager v v () v ( ) v Query Studio 13

20 1. IBM Cognos Query Studio 2. : Ctrl IBM Cognos Query Studio :

21 v v v 2 v 3 IBM Cognos Query Studio OK 3 Query Studio 15

22 OK IBM Cognos Query Studio : PDF CSV ( ) Microsoft Excel (XLS) IBM Cognos Query Studio 60 IBM Cognos Connection 1. Query Studio 2. v 16 IBM Cognos Query Studio :

23 v v Framework Manager 1 : IBM Cognos Query Studio Framework Manager IBM Cognos Framework Manager 3 Query Studio 17

24 18 IBM Cognos Query Studio :

25 : 1. IBM Cognos Query Studio v v v 4. OK PDF PDF 3 Query Studio 19

26 : PDF PDF Adobe Acrobat Reader 1. IBM Cognos Query Studio 2. PDF PDF : PDF PDF CSV CSV ( ) Excel Excel Excel CSV CSV Excel CSV CSV 1. IBM Cognos Query Studio 2. CSV 3. XML XML 20 IBM Cognos Query Studio :

27 1. IBM Cognos Query Studio 2. XML XML Microsoft Excel Microsoft Excel Excel 2007 Excel 2007 Excel XML (XLSX ) Excel Microsoft Excel 2002 Microsoft Excel 2003 Microsoft Excel 2007 Microsoft Excel 2002 Microsoft Excel 2003 Microsoft Office Compatibility Pack Excel 2007 Microsoft Excel 2007 Excel v v v Microsoft Excel 2007 v v 65, IBM Cognos 16,384 1,048,576 IBM Cognos Business Intelligence Excel 2007 Microsoft Excel 2007 Excel v v v Microsoft Excel 3 Query Studio 21

28 v v v Excel 2002 Microsoft Excel 2007 Excel 2002 v v 1 65, Excel 2007 Excel 2007 Excel 2002 : 111 D. Microsoft Excel Microsoft Excel IBM Cognos Report Authoring IBM Cognos Query Studio IBM Cognos Report Authoring Report Authoring Query Studio Report Authoring Query Studio Report Authoring PDF IBM Cognos Connection IBM Cognos Connection 1. IBM Cognos Query Studio 2. PDF PDF 3. Acrobat Reader 22 IBM Cognos Query Studio :

29 4. OK 1. IBM Cognos Query Studio 2. : 3. 1 IBM Cognos 25 IBM Cognos Business Intelligence Administration and Security Guide v v IBM Cognos Business Intelligence Framework Manager OLAP 3 Query Studio 23

30 v IBM Cognos Framework Manager Map Manager Microsoft Windows IBM Cognos Report Authoring v IBM Cognos Map Manager Installation and User Guide Report Authoring v IBM Cognos Report Authoring IBM Cognos Connection : IBM Cognos Connection v Web v v IBM Cognos Connection 24 IBM Cognos Query Studio :

31 IBM Cognos Query Studio IBM Cognos Query Studio : 66 IBM Cognos Query Studio - Sample Outdoors 3 Query Studio 25

32 IBM Cognos Business Intelligence IBM Cognos Business Intelligence Administration and Security Guide 1. IBM Cognos Connection 2. "GO ()" 3. Query Studio Query Studio "GO ( )" 4. " ()" 5. " ()" 6. "" 7. " " 8. " " 9. "" OK OK 26 IBM Cognos Query Studio :

33 3 Query Studio 27

34 " " v " " v v 64 - Sample Outdoors 3 1 IBM Cognos Business Intelligence IBM Cognos Business Intelligence Administration and Security Guide IBM Cognos Query Studio :

35 1. "" 2. "" " ()" 5. " ()" 6. "" 7. " " """ " 3 8. " " " " "" " "OK " " 11. " " 12. " " OK 3 Query Studio 29

36 30 IBM Cognos Query Studio :

37 1 " "" " 1. Query Studio : - Sample Outdoors 3 IBM Cognos Business Intelligence IBM Cognos Business Intelligence Administration and Security Guide " " 2. " " 3. " " 3 Query Studio 31

38 OK IBM Cognos Query Studio 101 C. 32 IBM Cognos Query Studio :

39 1. Query Studio OK : - Sample Outdoors "" IBM Cognos Business Intelligence IBM Cognos Business Intelligence Administration and Security Guide "" % OK Query Studio 33

40 9. OK 1. IBM Cognos Connection HTML HTML 4. IBM Cognos Viewer IBM Cognos Query Studio :

41 Portable Network Graphics (.png) IBM Cognos Query Studio Query Studio IBM Cognos Business Intelligence Administration and Security Guide Query Studio IBM Cognos Report Authoring IBM Cognos Report Authoring 1. Query Studio OK OK 3 Query Studio 35

42 1. IBM Cognos Query Studio OK IBM Cognos Connection IBM Cognos Connection : 1. IBM Cognos Query Studio 2. : OK 1. IBM Cognos Query Studio IBM Cognos Query Studio :

43 3. v v v 4. OK v v v v v v IBM Cognos Query Studio 2. : Ctrl Shift 3. : Query Studio 37

44 v v v Web 216 Web v v Web 216 Web v : 8. OK : : 1. IBM Cognos Query Studio 38 IBM Cognos Query Studio :

45 v v Web 216 Web v : 6. OK : 1. IBM Cognos Query Studio : 3 Query Studio 39

46 "" "" 1. IBM Cognos Query Studio : ISO_3_Letter_Code : 1. IBM Cognos Query Studio OK 40 IBM Cognos Query Studio :

47 : 1. IBM Cognos Query Studio 2. 1 IBM Cognos Query Studio Query Studio 2. Web 3. 1 : 4. OK 5,000,000 1,000, IBM Cognos Query Studio 2. 3 Query Studio 41

48 3. 4. v v v 2 2 v IBM Cognos Business Intelligence Administration and Security Guide : v 5,000,000 1,000,000 5,000,000 "1,000,000 5,000,000 " 5,000,000 "5,000,000 " 5. v v v v ( ) 6. OK 42 IBM Cognos Query Studio :

49 - Sample Outdoors IBM Cognos Business Intelligence IBM Cognos Business Intelligence Administration and Security Guide "" 2. "" OK "" 3 Query Studio 43

50 OK IBM Cognos Query Studio PDF Microsoft Excel HTML 1 HTML 44 IBM Cognos Query Studio :

51 Web v v v v v IBM Cognos Business Intelligence Administration and Security Guide 3 Query Studio 45

52 46 IBM Cognos Query Studio :

53 4 IBM Cognos Query Studio v v v v v v v v v ( ) v ( ) Copyright IBM Corp. 2005,

54 " " "" 3 48 IBM Cognos Query Studio :

55 ""

56 GO () """" "" "" Null 1 50 Q Null IBM Cognos Business Intelligence SAP BW IBM Cognos Framework Manager 50 IBM Cognos Query Studio :

57 " " " " "" 1 " " Q ,320 Null "" " " 4 51

58 Null "" Q Q Null Null " " 52 IBM Cognos Query Studio :

59 8,043 2 Null 1. IBM Cognos Query Studio 2. : 4 53

60 3. 4. v v v [ ] 5. v v (NOT) v v v v 54 IBM Cognos Query Studio :

61 v SQL SQL SQL %( ) 1 _ () v 8. v 2 v n 9. v v v v v v ( ) 12. OK : 4 55

62 63 1. IBM Cognos Query Studio v v v v 4. OK " """ """ " Advanced Query Studio IBM Cognos Business Intelligence Administration and Security Guide 1. IBM Cognos Query Studio IBM Cognos Query Studio :

63 3. 4. Shift Ctrl 5. : 6. AND OR 7. NOT NOT : NOT NOT NOT NOT NOT 8. OK : 63 -"" Sample Outdoors """" "" " " 1 IBM Cognos Business Intelligence IBM Cognos Business Intelligence Administration and Security Guide "" " ()" 4. " ()" 5. "" 4 57

64 6. " " " " "" Mozilla Web """ " " " "" " "OK 10. " " 7 9 "" "" 11. Shift OK "" "" "" " " """" " "" " 12. " : "" " OK 13. " : " " " OK 14. " " " "OK 18. " " 19. ""OK 20. Shift " : " " : " 58 IBM Cognos Query Studio :

65 2 AND 21. ANDOR OK """" """ " OK 1. IBM Cognos Query Studio 2. : v v (NOT) 5. v v 6. OK 4 59

66 IBM Cognos Query Studio v v 1. IBM Cognos Query Studio OK IBM Cognos Framework Manager : Query Studio IBM Cognos Report Authoring Query Studio Query Studio 60 IBM Cognos Query Studio :

67 v v 1. IBM Cognos Query Studio 2. : v : v ( ) ( ) v v

68 : v 7. OK - Sample Outdoors 1 IBM Cognos Business Intelligence IBM Cognos Business Intelligence Administration and Security Guide " " 2. " " " " "" "" : Ctrl 9. ( ) "" " " 12. OK 62 IBM Cognos Query Studio :

69 "" " ()" OK sortlist Report Authoring 1. sortlist list 2. sortitem sortlist refdataitem sortorder XML 4 63

70 <list name="list1" refquery="query1">... <listcolumns>... </listcolumns> <sortlist> <sortitem refdataitem="revenue" sortorder="descending"/> </sortlist> </list> 2 " """ OP-ERR-0199: 64 IBM Cognos Query Studio :

71 1 4 65

72 () 1. IBM Cognos Query Studio v v IBM Cognos Query Studio " " "" " " " " " " "" 1 Query Studio " " "" "" 66 IBM Cognos Query Studio :

73 : Query Studio 4 67

74 v v 4. OK : Query Studio Cookie Query Studio 68 IBM Cognos Query Studio :

75 SAP BW 1 IBM Cognos Business Intelligence IBM Cognos Query Studio (*) IBM Cognos SAP BW v v v v EUR 2 (%) % 224, E

76 Query Studio v v v 4. OK IBM Cognos Query Studio 1 2 Query Studio : Query Studio 1 70 IBM Cognos Query Studio :

77 v v IBM Cognos Query Studio : : 4 71

78 Null 1. Query Studio OK : ( ) () : : : : 72 IBM Cognos Query Studio :

79 :OLAP (DMR:Dimensionally Modeled Relational) :OLAP DMR : : : : : : 1 2 ()* () "" 2 ()* () "" 2 1 " " DMR count distinct median standard-deviation variance DMR ( ) v v

80 % IBM Cognos Report Authoring Report Authoring IBM Cognos Query Studio IBM Cognos Report Authoring IBM Cognos Framework Manager +( ) -( ) *( ) /( ) ^() 74 IBM Cognos Query Studio :

81 1. Query Studio v v

82 1 Query Studio 117 E. IBM Cognos Business Intelligence Null Null IBM Cognos BI Null Null Null A B C B NULL A C IBM Cognos Report Authoring IBM Cognos Query Studio Cost*Cost * - Sample Outdoors % IBM Cognos Business Intelligence IBM Cognos Business Intelligence Administration and Security Guide " " 2. "" 76 IBM Cognos Query Studio :

83 "% of total ()" OK 1 " " "2005" 2 " " "2005" IBM Cognos Connection IBM Cognos Connection IBM Cognos Viewer 4 77

84 IBM Cognos Connection HTML 1 13 : 1. IBM Cognos Query Studio 2. : IBM Cognos Query Studio v Query Studio v IBM Cognos Report Authoring v IBM Cognos Analysis Studio v IBM Cognos Series 7 v Microsoft Analysis Query Studio : 1. Query Studio IBM Cognos Query Studio :

85 1 IBM Cognos Viewer 3. IBM Cognos Viewer IBM Cognos Business Intelligence IBM Cognos Administration URL URL IBM Cognos BI IBM Cognos BI IBM Metadata Workbench IBM Cognos Business Intelligence IBM Cognos Administration IBM Cognos Business Intelligence Administration and Security Guide IBM Cognos BI 4 79

86 1. 2. IBM Cognos Business Intelligence IBM Cognos Business Intelligence 2 IBM Cognos Connection IBM Cognos Framework Manager 1. IBM Cognos Business Intelligence 80 IBM Cognos Query Studio :

87 IBM Cognos Viewer IBM Cognos Viewer IBM Cognos BI Null 1 IBM Cognos Transformer IBM Cognos Framework Manager IBM Cognos Administration PowerCube IBM Cognos Transformer SAP BW Null IBM Cognos Framework Manager 4 81

88 82 IBM Cognos Query Studio :

89 A. : IBM Cognos Business Intelligence IBM Cognos Report Authoring <datasource> IBM Cognos Query Studio <dataitemvalue> " = " " = " Query Studio <membercaption> = Report Authoring <membercaption> QE-DEF-0260 IBM Cognos Query Studio 1 Query Studio IBM Cognos Framework Manager Report Authoring Query Studio HTML PDF Copyright IBM Corp. 2005,

90 Query Studio Report Authoring Query Studio v Report Authoring (CSS) v Query Studio v IBM Cognos PowerCube 2 _make_timestamp "HRESULT= DB_E_CANTCONVERTVALUE" _make_timestamp UDA-SQL-0114 sqlopenresult UDA-SQL-0206 OLEDB : HRESULT= DB_E_CANTCONVERTVALUE RSV-SRV-0025 RQP-DEF-0177 'sqlpreparewithoptions' ='-69' UDA-SQL-0043 IBM Cognos Report Authoring IBM Cognos Query Studio RQP-DEF-0177 'sqlpreparewithoptions' ='-69' UDA-SQL-0043 SQL [NCR][ODBC Teradata Driver][Teradata Database] Partial string matching requires character operands IBM Cognos Application Firewall 84 IBM Cognos Query Studio :

91 IBM Cognos Business Intelligence Content Store ( QE-DEF-0288) IBM Cognos Query Studio IBM Cognos Connection Report Authoring QE-DEF ReportNet IBM Cognos Business Intelligence Oracle cast_date IBM Cognos MR1 Oracle Oracle cast_date c10_location configuration qfs_config.xml IBM Cognos Business Intelligence 1 MUN ( ) MUN MUN A. 85

92 IBM Cognos Connection Content Store 1 Safari Macintosh Safari PDF Macintosh Safari Adobe Acrobat Safari HTML HTML HTML PDF PDF PDF PDF PDF Adobe Acrobat Reader Acrobat Reader PDF PDF v Acrobat Reader v Acrobat Acrobat Reader IBM Cognos Query Studio :

93 3. OK PDF OK Adobe Web IBM Cognos Framework Manager Regular Aggregate Oracle Essbase Studio/Authoring Oracle Essbase Studio/Authoring IBM Cognos Content Manager A. 87

94 " " " " " " OP-ERR-0201 () ([].[B1], [ ].[]) X Y v X Y v Y X v X Y 1 1 OLAP OLAP substring (!) OLAP IBM Cognos Business Intelligence " " " " IBM Cognos Query Studio " " 3 concatenation IBM Cognos Query Studio :

95 OLAP v filter v v v v 1 v 1 1 v v 3 IBM Cognos Framework Manager SSAS 2005 Microsoft SQL Server 2005 Analysis Services (SSAS) 2 AutoExists A. 89

96 1 Microsoft ( (Adventure Works ) v :Generate([Adventure_Works].[Account].[Accounts],set([Balance Sheet],[Units])) nested with v v children([adventure_works].[department].[departments]- >:[YK].[[Department]].[Departments]].&[1]]]) :[Adventure_Works].[Account].[Account Number].[Account Number] :[Adventure_Works].[Measures].[Amount] [Amount]>1 Adventure Works [Account].[Accounts] [Net Income] GENERATE SSAS [Account] [Account][Account Type].&[] [Account].[Accounts].[Net Income] 2 SSAS SSAS OLAP Null Null IBM Cognos Report Authoring 90 IBM Cognos Query Studio :

97 Transformer IBM Cognos Transformer TM1 TM1 Executive Viewer IBM Cognos Business Intelligence IBM Cognos TM1 IBM Cognos Business Intelligence Studio/Authoring TM1 Executive Viewer TM1 Executive Viewer OLAP IBM Cognos Business Intelligence Studio/Authoring Executive Viewer IBM Cognos Business Intelligence Executive Viewer TM1 IBM Cognos TM1 IBM Cognos Business Intelligence Studio/Authoring TM1 Architect TM1 Architect IBM Cognos BI IBM Cognos BI TM1 IBM Cognos BI Studio/Authoring TM1 Architect SSAS 2005 Microsoft SQL Server 2005 Analysis Services (SSAS) IBM Cognos Microsoft SSAS () () ( ) 1 ( ) 1 >1 A. 91

98 IBM Cognos Business Intelligence MDX SSAS MDX 92 IBM Cognos Query Studio :

99 B. IBM Cognos Business Intelligence IBM Cognos Connection Query Studio IBM Cognos Report Authoring Sample Outdoors Sample Outdoors IBM Knowledge Center ( Sample Outdoors GO Sample Outdoors IBM IBM v 2 v v ( ) v IBM Cognos Business Intelligence Copyright IBM Corp. 2005,

100 IBM Cognos Business Intelligence Sample Outdoors Sample Outdoors Sample Outdoors GO Accessories v GO v 1 v 3 GO "GO " GL 94 IBM Cognos Query Studio :

101 Sample Outdoors Consolidated ( 持ち株会社 ) 米ドル GO Americas (AMX 1099) 米ドル GO Asia Pacific (EAX 4199) 円 GO Accessories (EUX 8199) ユーロ 年 1 60% 年 3 50% 年 1 40% 年 3 50% GO Central Europe (CEU 6199) ユーロ GO Southern Europe (SEU 7199) ユーロ GO Northern Europe (NEU 5199) ユーロ 3. GL 1. (GL) (GL) (1700) (1720) (1750) / (1760) (1730) (1740) (1710) (1800) (1820) (1820) B. 95

102 Sample Outdoors () ( ) ( ) (2012 ) Metric Studio "GO ()" " " " " () " "" " Tivoli LDAP IBM LDIF IBM Cognos Planning Sample Outdoors GO Accessories "" " " Sample Outdoors GO (2011 GO ) ( ) 5 (GO Accessories ) ( ) Metric Studio ( ) () Metric Studio 96 IBM Cognos Query Studio :

103 ("") GO Accessories GO Accessories Sample Outdoors Sample Outdoors Framework Manager GO GO 2 IBM Cognos Business Intelligence Framework Manager GO GO (great_outdoors_data_warehouse.cpf) GOSALESDW 3 4 "GO " () IBM Cognos BI v v v "" "" "" " " "" B. 97

104 v v GO GO (great_outdoors_sales.cpf) GOSALES v v v v v v " ""GO " PowerCube Sample Outdoors v sales_and_marketing.mdc v employee_expenses.mdc v go_accessories.mdc v go_americas.mdc v go_asia_pacific.mdc v great_outdoors_sales_ja.mdc v great_outdoors_7.mdc 98 IBM Cognos Query Studio :

105 Sample Outdoors 6 "GO ()" GOSALESDW IBM Cognos Analysis Studio Studio/Authoring "GO ()"GOSALES Analysis Studio Studio/Authoring "GO ()" GOSALESDW Analysis Studio Studio/Authoring "GO ()" GOSALES Analysis Studio Studio/Authoring () sales_and_marketing.mdc OLAP Great Outdoor Sales () great_outdoors_sales_en.mdc OLAP : OLAP Great Outdoors () ()IBM_Cognos_PowerCube.zip 5 ( ) "GO ()" "GO ()" B. 99

106 "GO ()" "GO ()" 100 IBM Cognos Query Studio :

107 C. IBM Cognos Query Studio ( ) ( 3 ) Microsoft Excel Excel 111 D. Microsoft Excel 100% % Copyright IBM Corp. 2005,

108 PDF HTML 16 Excel 2 100% IBM Cognos Query Studio :

109 100% 3 100% C. 103

110 100% IBM Cognos Query Studio :

111 100% 3 2 C. 105

112 % ( ) 106 IBM Cognos Query Studio :

113 5. C. 107

114 6. 100% 100% 100% 100% 100% 108 IBM Cognos Query Studio :

115 7. 100% C. 109

116 IBM Cognos Query Studio :

117 D. Microsoft Excel Microsoft Excel IBM Cognos Business Intelligence Content Store URL IBM Cognos Business Intelligence Content Store Microsoft Excel Microsoft Microsoft Excel 2002 Microsoft Excel Excel IBM Cognos Business Intelligence Microsoft Excel IBM Cognos Business Intelligence Web Web? HTML/XML Excel "filelist.xml"ibm Cognos BI URL Excel IBM Cognos BI XLS XLS XLS Web Copyright IBM Corp. 2005,

118 Microsoft Office 2000 HTML Microsoft Excel URL XLS Netscape 7.01 Excel IBM Cognos Business Intelligence Netscape 7.01 Microsoft Excel IBM Cognos BI Microsoft Excel IBM Cognos Business Intelligence 3 Excel v v v v v v v v v v v Excel v v v v (Excel ) v v v v v (Excel IBM Cognos BI ) v (Excel ) v v v 112 IBM Cognos Query Studio :

119 # Microsoft Excel "######" Microsoft Excel 1 Table Excel Excel 1 Excel SSL (Secure Socket Layer) SSL Microsoft Excel 2002 Microsoft Excel 2003 Microsoft Excel 2002 Excel Microsoft Excel Microsoft Excel Excel Excel 5 5 Excel Microsoft Excel Excel 1 64K D. Microsoft Excel 113

120 Microsoft Excel URI"localhost" IP IBM Cognos Configuration Excel IBM Cognos Business Intelligence Microsoft Excel IBM Cognos BI v v Excel v v v v Excel HTML PDF Excel Microsoft Excel E Excel IBM Cognos Business Intelligence HTML XML Microsoft Excel E E E Excel X Microsoft Excel 2002 Excel 2002 Excel 2007 Excel IBM Cognos Query Studio :

121 Excel Microsoft Excel {} () Microsoft Excel IBM Cognos Business Intelligence D. Microsoft Excel 115

122 116 IBM Cognos Query Studio :

123 E. v v v : v v v v v v v v v v 2 v v Copyright IBM Corp. 2005,

124 v v v v v 2 v 3 v v v 2 v v 2 v v v v () 118 IBM Cognos Query Studio :

125 IBM IBM IBM IBM IBM IBM IBM IBM ( ) IBM IBM IBM Web Web Web IBM Web Copyright IBM Corp. 2005,

126 IBM (i) ( ) (ii) IBM Software Group Attention: Licensing 3755 Riverside Dr. Ottawa, ON K1V 1B7 Canada IBM IBM IBM IBM IBM IBM IBM v 120 IBM Cognos Query Studio :

127 v v v v v v v Cookie Cookie Cookie Cookie Cookie IBM IBM ( IBM Software Products and Software-as-a-Service Privacy Statement ( IBM IBM ibm.com International Business Machines Corporation IBM IBM Copyright and trademark information v Adobe Adobe PostScript PostScript Adobe Systems Incorporated v Microsoft Windows Windows NT Windows Microsoft Corporation 121

128 122 IBM Cognos Query Studio :

129 IBM Cognos Business Intelligence v v IBM ( ) A B 124 C 125 D 126 E 126 F 126 G 126 H 126 I 127 J 127 L 127 M 128 N 128 O 128 P 129 Q 129 R 130 S 130 T 131 U 131 W A (access permission) (accountability scorecard) Metric Studio (agent) (alias) (anonymous access) 1 (application tier component) PDF HTML Content Manager Content Manager Content Store (attribute) BI ID (authentication) ID (authentication provider) B (burst) 1 1 Copyright IBM Corp. 2005,

130 (burst key) () C CA (certificate authority) (calculated member) (canvas) (capability) (cardinality) OLAP (cascading prompt) (certificate) ID (certificate authority) (certificate authority) (CA) CGI (Common Gateway Interface) (cipher suite) Secure Sockets Layer (SSL) (class style) CM Content Manager (Common Gateway Interface) (CGI) HTTP Web (condition) (constraint) (contact) E E 124 IBM Cognos Query Studio :

131 (content locale) Content Manager (CM) Content Store Content Store Content Store ( ) (credential) (cube) (custom set) Analysis Studio (predefined set) (set) D (dashboard) 1 Web (data source) ( XML ) (data source connection) (data tree) Studio/Authoring (deployment) () (deployment archive) Content Store (deployment specification) ( ) (derived index) (details-based set) (set) (dimension) 1 (dimensional data source) OLAP 125

132 (drill down) E (event) (event key) ( ) (event list) F (fact) (measure) G (gateway) Web Web CGI ISAPI Apache (glyph) ( ) A A 2 2 ( ) (Unicode 1.0) (group) (grouping) H (hierarchy) () 1 I (information card) ( ) (information pane) Analysis Studio (initiative) (item) (member) 126 IBM Cognos Query Studio :

133 J (job) (job step) L (layout) (level) 1 (locale) / M MDX (Multidimensional Expression Language) (measure) (member) 4 (metric) (metric extract) Cognos Metric Studio () Metric Studio (metric package) Cognos Connection Metric Studio (package) Metric Store Metric Store Metric Studio (metric type) (model) 1 Cognos BI Framework Manager Cognos (multidimensional data source) (dimensional data source) 127

134 (Multidimensional Expression Language) (MDX) (SQL) N (named set) (predefined set) (namespace) (news item) RSS (Really Simple Syndication) Cognos Connection O (object) Report Authoring (object extract) Metric Studio ( ) P (package) Cognos (metric package) (page set) Report Authoring 1 (set) Passport Content Manager Cognos 8 (portlet) Web (predefined set) OLAP (custom set) (set) (product locale) (project) 1. Metric Studio 2. Metric Designer Metric Studio (prompt) 128 IBM Cognos Query Studio :

135 (properties pane) Studio/Authoring (publish) Cognos BI Framework Manager Transformer PowerCube Cognos Q (query) Query Studio (query item) (query subject) Framework Manager Query Studio Report Authoring R Really Simple Syndication (RSS) Really Simple Syndication (RSS 2.0) Web XML RSS XML RSS Web Rich Site Summary (repeater) Report Authoring (repeater table) Report Authoring (report) (report output) (report specification) (report view) (response file) ASCII Rich Site Summary (RSS) RSS 0.91 Web XML RSS XML RSS Web 129

136 RSS S Really Simple Syndication 1. Really Simple Syndication 2. Rich Site Summary (score) (scorecard) 1 (scorecard structure) (security provider) (authentication provider) (selection-based set) 1 (set) (session) (set) 1 (custom set) (details-based set) (page set) (predefined set) (selection-based set) (stacked set) (stacked set) (set) (strategy) ( ) 1 (strategy map) Metric Studio (summary) T (task) E (task execution rule) (template) (thumbnail) (tuple) tuple 130 IBM Cognos Query Studio :

137 U (2007,, ) (union set) (stacked set) (user) (user-defined column) ( ) W (watch list) Metric Studio E IBM Cognos Connection (watch rule) E Web (Web Services for Remote Portlets) Web Web Web (widget) Web (work area) Studio/Authoring (workspace) (dashboard) 131