IBM Cognos Dynamic Query Analyzer 1020 Gn...

23
IBM Cognos Dynamic Query Analyzer 10.2.0 ΓU

Transcript of IBM Cognos Dynamic Query Analyzer 1020 Gn...

Page 1: IBM Cognos Dynamic Query Analyzer 1020 Gn Upublic.dhe.ibm.com/software/data/cognos/documentation/docs/zh-t… · ]to IBM Cognos Dynamic Query Analyzer sWS MμCªi≤UzW M {íípªñAH

IBM Cognos Dynamic Query Analyzer10.2.0 �

��ΓU

���

Page 2: IBM Cognos Dynamic Query Analyzer 1020 Gn Upublic.dhe.ibm.com/software/data/cognos/documentation/docs/zh-t… · ]to IBM Cognos Dynamic Query Analyzer sWS MμCªi≤UzW M {íípªñAH

��

���ΩT�ΣΣ��ú�ºeA�²\¬� 15��y�N��zñ�ΩTC

ú�ΩT

�σ≤A�≤ IBM Cognos Business Intelligence 10.2.0 �A�B]iαA�≤ß≥���CYn�d�σ≤�s��A�yXuIBM Cognos ΩTñ�v(http://publib.boulder.ibm.com/infocenter/cogic/v1r0m0/index.jsp)C

Licensed Materials - Property of IBM

© Copyright IBM Corporation 2012.

Page 3: IBM Cognos Dynamic Query Analyzer 1020 Gn Upublic.dhe.ibm.com/software/data/cognos/documentation/docs/zh-t… · ]to IBM Cognos Dynamic Query Analyzer sWS MμCªi≤UzW M {íípªñAH

�²

�� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . v

� 1 � sW\α . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 110.2.0 �sWS� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1

� 2 � }l�� Cognos Dynamic Query Analyzer . . . . . . . . . . . . . . . . 3Cognos Dynamic Query Analyzer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3�Rd�Θx� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3⌡μ���Ad��í�°i . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4}�d�Θx� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4��d�Θx� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6

DQM °A�Θx . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7��E��i�����A Cube �α . . . . . . . . . . . . . . . . . . . . . . . . . . . 8⌡μE��i� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9

� 3 � �°�� Cognos Dynamic Query Analyzer . . . . . . . . . . . . . . . . 11Lks�d�Θx� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11

�². Cognos Dynamic Query Analyzer ñ�≤UuπS� . . . . . . . . . . . . . 13IBM M≤Uuπ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13

�N�� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15

�� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17

© Copyright IBM Corp. 2012 iii

Page 4: IBM Cognos Dynamic Query Analyzer 1020 Gn Upublic.dhe.ibm.com/software/data/cognos/documentation/docs/zh-t… · ]to IBM Cognos Dynamic Query Analyzer sWS MμCªi≤UzW M {íípªñAH

iv IBM Cognos Dynamic Query Analyzer 10.2.0 �G ��ΓU

Page 5: IBM Cognos Dynamic Query Analyzer 1020 Gn Upublic.dhe.ibm.com/software/data/cognos/documentation/docs/zh-t… · ]to IBM Cognos Dynamic Query Analyzer sWS MμCªi≤UzW M {íípªñAH

��

IBM® Cognos® Dynamic Query Analyzer Od�°��uπC��ªAziH°��M

�°��b IBM Cognos Business Intelligence ñ⌡μ�Ad�°i��ú��d�Θ

xC��ACognos Dynamic Query Analyzer ]AuE��i�vAªO@�uπAi

�R�A Cube ��αM�cAú��E�H∩� Cube �α���C

¬�

�σ≤«b≤U°i�z��� Cognos Dynamic Query Analyzer ��R°iAH�M

Σ�Ad�°iñ��α�VC

��A�¼���M�z��iH��uE��i�v�����A CubeC

MΣΩT

Ynb Web WMΣ IBM Cognos ú�σ≤]]A��w���σ≤�A�s�Σñ@

�uIBM Cognos ΩTñ�v (http://publib.boulder.ibm.com/infocenter/cogic/v1r0m0/

index.jsp)Cu���N��v���oG�uΩTñ�vA]A�s TechNotes M

APAR ���C

z]iHq IBM Cognos ú���ñA��¬� PDF ���ú����N��Mw�

ΓUC

eñ�°i

�σ≤í�ú��{μ\αCiα�]AeLk������Cúo���ú

���iα�C��o���Dϕ�μI⌠≤�@½B{íX�\α���B

O��kwq�C IBM o�μMwS��\α�}oBoμ��≈C

Kdn�d�

Great Outdoors qBGO PΓB⌠≤ Great Outdoors W����H� Planning SampleA

o�úyzΩc�°�B@AΣñ�d Ω�O��� IBM M IBM �ß}od �

�{íCo�ΩcO²]APΓμ÷Bú�teB]��HOΩ�Ñd Ω�CYP

Ω�W�Ba}Bp�q��μ÷�pPA�� XCΣLd ��iα]tΓ��

≈�ú��ΩcΩ�BzL�N�����s��Ω�Ω�B�P�@v���v

¡ft���Ω�Ai�@}od ��{í�d Ω�C���ú�W�iαOΣ

�O������Cg\iAúo�sC

≤UuπS�

≤UuπS�i≤U��Hh] pμ�úK�°Oú}����ΩT�Nú�C IBM

Cognos Dynamic Query Analyzer π�≤UuπS�Cp�o�S���÷ΩTA��

\� 13��yCognos Dynamic Query Analyzer ñ�≤UuπS�zC

© Copyright IBM Corp. 2012 v

Page 6: IBM Cognos Dynamic Query Analyzer 1020 Gn Upublic.dhe.ibm.com/software/data/cognos/documentation/docs/zh-t… · ]to IBM Cognos Dynamic Query Analyzer sWS MμCªi≤UzW M {íípªñAH

vi IBM Cognos Dynamic Query Analyzer 10.2.0 �G ��ΓU

Page 7: IBM Cognos Dynamic Query Analyzer 1020 Gn Upublic.dhe.ibm.com/software/data/cognos/documentation/docs/zh-t… · ]to IBM Cognos Dynamic Query Analyzer sWS MμCªi≤UzW M {íípªñAH

� 1 � sW\α

��]to� IBM Cognos Dynamic Query Analyzer �sWS�MμCªi≤UzW

���M��{íípªñAH�∩����÷V�DC

p�����÷ΩTA��\mIBM Cognos Business Intelligence w�PtmΓUnC

p���sWS���÷ΩTA��\mIBM Cognos Business Intelligence sWS�Γ

UnC

Yn�\ IBM Cognos ú��Σ�⌠���sMμ] p@�t�B�{íBs²

�BWeb °A�B²°A�BΩ�w°A�M��{í°A��A�yX Cognos

Customer Center (http://www.ibm.com/software/data/cognos/customercenter/)C

10.2.0 �sWS�

��\UCDDAH�o�W@��H��sWS�C]A���÷DD���C

E��i�

uE��i�vO@�uπAi�R�A Cube ��αM�cAú��E�H∩�

Cube �α���Cp��÷ΩTA��\� 8��y��E��i�����A Cube

�αzC

p��A Cube ME���÷ΩTA��\mIBM Cognos Dynamic Cubes ��ΓUnC

°i� DQM °A�Oⁿ

z{biHb IBM Cognos Dynamic Query Analyzer ñ�� DQM °A�OⁿCu�

w∩b Dynamic Query Analyzer ñ⌡μ�°iAú�°A�ΘxCºeA��w∩b

IBM Cognos Business Intelligence °A�W⌡μ���°iA��l�OⁿCp��÷

ΩTA��\� 7��yDQM °A�ΘxzC

© Copyright IBM Corp. 2012 1

Page 8: IBM Cognos Dynamic Query Analyzer 1020 Gn Upublic.dhe.ibm.com/software/data/cognos/documentation/docs/zh-t… · ]to IBM Cognos Dynamic Query Analyzer sWS MμCªi≤UzW M {íípªñAH

2 IBM Cognos Dynamic Query Analyzer 10.2.0 �G ��ΓU

Page 9: IBM Cognos Dynamic Query Analyzer 1020 Gn Upublic.dhe.ibm.com/software/data/cognos/documentation/docs/zh-t… · ]to IBM Cognos Dynamic Query Analyzer sWS MμCªi≤UzW M {íípªñAH

� 2 � }l�� Cognos Dynamic Query Analyzer

IBM Cognos Dynamic Query Analyzer O@�uπAiú�Ad��íd��ú�d

�Θx���ϕ�kC��ACognos Dynamic Query Analyzer π�uE��i�vA

ªO@�uπAi�R�A Cube ��i∩� Cube �α�E�]Ω@��C

½nGz��²tm Cognos Dynamic Query AnalyzerA�αs� IBM Cognos Busi-

ness Intelligence °A�� Content Store Md�ΘxCp�tmⁿ�A��\mIBM

Cognos Dynamic Query Analyzer w�PtmΓUnC

Cognos Dynamic Query AnalyzerIBM Cognos Dynamic Query Analyzer ]A Eclipse ¼�ß���� �CΩ��H@

tC�°���≤]��°��e{CziH∩@�ñ°�ñ�t�Ω�⌡μ@�C

o�@���G�vTΣL°���eA��P��}�s�°�C

°�O]tb��s��C�π�����s�C

��s�]t�p�M�j�÷sAP�]te@�ñ°����÷sC��s�

�jp�πΦíO��t@���s��Σ�@�C

°�b}���π�be}����PmAúDO�@}�Ab�ípUAh

�bw]m}�C°�iHqY���s���t@���s�A��≈��O°

íC

YnN°���úP���s�A�N�DC���s���s�A�±��D

CCYnN°��≈�s�°íA�b�DCW÷@U�½kΣAMß÷@U�≈

�CYnNπ���s����s�mA�b�DCW÷@U�½kΣAMß÷@

U��M��s�C

�Rd�Θx�

ziHb IBM Cognos Dynamic Query Analyzer ñ�°�Rd�Θx�CΘx��

��ϕ�ki²zd��α�VC

� 1. ����s�

© Copyright IBM Corp. 2012 3

Page 10: IBM Cognos Dynamic Query Analyzer 1020 Gn Upublic.dhe.ibm.com/software/data/cognos/documentation/docs/zh-t… · ]to IBM Cognos Dynamic Query Analyzer sWS MμCªi≤UzW M {íípªñAH

{�

1. ⌡μ���Ad��í�°iC

2. b Cognos Dynamic Query Analyzer ñ}�d�Θx�C

3. ��d�Θx�AHMΣ�α�VC

⌡μ���Ad��í�°i

ziH�� IBM Cognos Business Intelligence Web �⌡μ°iA]iH�� IBM

Cognos Dynamic Query Analyzer ⌡μ°iC

}lºe

⌡μ°iºeA����ud�A�v�d�⌡μl�∩�CziH��UCΓ�Φ

í����∩�C

v z��z�iHb IBM Cognos Administration ñ��d�⌡μl�∩�Cw∩zL

Cognos BI Web ��zL Cognos Dynamic Query Analyzer ⌡μ���°iA�

���∩�Cp��÷ΩTA��\mIBM Cognos Business Intelligence �zPw�

ΓUnñ�÷d�A��z�DDC

v ziHw∩zL Cognos Dynamic Query Analyzer ⌡μ�°i��d�⌡μl�CY

n���∩�A�÷@U°íM�n]wCb@δ��WA�∩d�⌡μl�Cp

GzL Cognos Dynamic Query Analyzer ��OⁿAht��z�ú�nbπ�°A

�W��ªC

pGzOzL Cognos Dynamic Query Analyzer ⌡μ°iAh Cognos Dynamic Query

Analyzer P Cognos BI °A�������PC�hAiαú�⌡μ°iC

{�

��UCΣñ@�ΦíA⌡μi���Ad��°iC

v ��izL Cognos BI Web ����⌠≤ΦkCp��÷ΩTA��\mIBM

Cognos Report Studio ��ΓUnC

v b Cognos Dynamic Query Analyzer ñA�²� Content Store °�ñ�°iCb°iW÷@U�½kΣAMß÷@U⌡μ°iCϕz�� Cognos Dynamic Query Ana-

lyzer ⌡μ°i�ALk]w°i�ú�C

�G

z{biHb Cognos Dynamic Query Analyzer ñ}��RΘx�C

}�d�Θx�

ϕz⌡μ°i�ApG��d�⌡μl�∩�Ah���d�Θx�CΘx�O XML

��Ao�����b°i⌡μ�í⌡μ��� MDX d�AH�d��c�⌡μMÑ

��ípqΩ�C

d�Θx�]tb XQE logs Ω�¿�W� <time-stamp>_<report_name> �Ω�¿ñC

�Ω�¿]t@�HWW� profilingLog-0.xmlBprofilingLog-1.xml Ñ�]w�C

pG°i⌡μ�n⌡μld�Ah��W� subqueries �lΩ�¿A�tπ�C@�

ld��]w��Ω�¿C

4 IBM Cognos Dynamic Query Analyzer 10.2.0 �G ��ΓU

Page 11: IBM Cognos Dynamic Query Analyzer 1020 Gn Upublic.dhe.ibm.com/software/data/cognos/documentation/docs/zh-t… · ]to IBM Cognos Dynamic Query Analyzer sWS MμCªi≤UzW M {íípªñAH

⌡μ°iºßAziHb IBM Cognos Dynamic Query Analyzer ñ}�d�Θx�C

ziH��T�Φkñ�⌠≤@�A�s²}�Θx�C

q Content Store °�}�d�Θx�

ziH�� Content Store °�A�s²}�d�Θx�C

{�

1. pG}� Content Store °�A�÷@U°íMπ�°�AMß∩� ContentStore °�C

2. b Content Store °�ñA�²����°iAMß÷@Uª�Σ�bYC �i}°i�AHπ�°i�]w�Θx�Mld�Ω�¿C

3. ÷ΓU]w��H}���A�÷@Uld�Ω�¿�Σ�bYAMß÷ΓU]

w��H}���C

�G

w∩C@�}��d�Θx�A���π�]w�C]�}�KnBd�M�e°

�AΣñπ�P@�ñ���÷�Ω�C

q��\αϕ}�d�Θx�

ziH����\αϕA�s²}�d�Θx�C

{�

1. ÷@U��M}�ΘxC

2. ziH��UCΦí�s²d�Θx�C

v ∩�²e}����AHd� IBM Cognos Dynamic Query Analyzer ²e}�

�����Θx�MμC

v ∩����²AHd�iHqY���ms��Θx�MμC

v ∩��� URLAHd�iH�� http:// � file:// Web s²�qT≤ws

��Θx�MμC

3. ÷@U°iΩ�¿�Σ�bYAHπ�°i�]w�Θx�Mld�Ω�¿C

v ∩�]w�Θx��Σ��∩�AH}��d�ΘxC

v ∩�°iΩ�¿�Σ��∩�AH}�Ω�¿ñ�t���d�Θx�C

v ∩�h��∩�AH}�h�d�Θx�C

P�}�h�d�Θx�Aiα��P Cognos Dynamic Query Analyzer ño�O

�Θú¼��C

�G

w∩C@�}��d�Θx�A���π�]w�C]�}�KnBd�M�e°

�AΣñπ�P@�ñ���÷�Ω�C

q°iΘx°�}�d�Θx�

ziH��°iΘx°�A�s²}�d�Θx�C

{�

1. pG}�°iΘx°�A�÷@U°íMπ�°�AMß∩�°iΘx°�C

� 2 � }l�� Cognos Dynamic Query Analyzer 5

Page 12: IBM Cognos Dynamic Query Analyzer 1020 Gn Upublic.dhe.ibm.com/software/data/cognos/documentation/docs/zh-t… · ]to IBM Cognos Dynamic Query Analyzer sWS MμCªi≤UzW M {íípªñAH

2. b°iΘx°�ñA÷@U��°i�Σ�bYC �i}°i�AHπ�°i�

]w�Θx�Mld�Ω�¿C

3. ÷ΓU]w��H}���A�÷@Uld�Ω�¿�Σ�bYAMß÷ΓU]

w��H}���C

�G

w∩C@�}��d�Θx�A���π�]w�C]�}�KnBd�M�e°

�AΣñπ�P@�ñ���÷�Ω�C

��d�Θx�

ϕzb IBM Cognos Dynamic Query Analyzer ñ}�d�Θx��AiH����Φ

í��°M�RΩ�C

��

}�d�Θx���π�����π�@tC�w���ICC@��IúNϕ°i

⌡μ�iμ�@�A�Nϕ@����] p�Bz�Ω��CUϕwqúP�Ie

{�NqC

ϕ 1. �Ie{

�I í�

Nϕ°i⌡μ�iμ�@�C

Nϕ@����] p�Bz�Ω��C��ñw]�ϕεΣ

ñ�jí��ICYn�íπ�A�÷@U°íM�n]wA

Mß∩�°��M�ILoC

Nϕ¼X��ICYnπ�⌠���IA�÷ΓU��IA�

b��IW÷@U�½kΣAMß÷@Uπ�l≡¼�cC

Nϕt�]�ILo]w�⌠��l���ICYnπ�⌠�

��IA�b��IW÷@U�½kΣAMß÷@Ui}Lo

���C

Nϕe∩���IC��I��e�π�b�e°�ñC÷

@U�IAYiH∩���IC

Nϕπ�ibt@���ñ}��ld���ICYnπ�l

d���A�b�IW÷@U�½kΣAMß÷@U}�ld

�CY�ld�b��l�ñS�÷p�IAª�iH���

∩�iμ}�C

6 IBM Cognos Dynamic Query Analyzer 10.2.0 �G ��ΓU

Page 13: IBM Cognos Dynamic Query Analyzer 1020 Gn Upublic.dhe.ibm.com/software/data/cognos/documentation/docs/zh-t… · ]to IBM Cognos Dynamic Query Analyzer sWS MμCªi≤UzW M {íípªñAH

ϕ 1. �Ie{ (≥)

�I í�

Nϕ�I�p�ΩTC⌡ΓNϕ�≤�Iñ°i��íC�Γ

Nϕ�≤�Il���í± C�ΓNϕ�≤�IMΣl��

í��íCpG∩��IAh�í]�π�b�e°�ñC

Kn°�

Kn°�ú@�ñ����÷ΩTC

Knqπ�d��W�BM≤M�íWOCª]ⁿXΩ����¼O÷píBOLAP

�O DMR]����÷pí�C

p�qπ�p�ΩTCª�H�ε�í�π�C@��I�u@�íMÑ��

íA�o��Iπ�[�p�ΩTCpGz÷@U⌠≤�IAh�∩���ñ�∩

��ICpG��p�ΩTúO]tbld�ñAhú�π�d��p�ΩTC

pG��d�W�l�∩�Ah�Rq�π�ΩTC

�I�¼MCΓqú�I�¼MCΓ�NqC

d�°�

d�°�π��°iñ��� MDX � SQL d�C

ziH��N MDX ������� A���d�°�ñ� MDX ⁿOP��ñ

��ICpGz∩�d�°�ñ� MDX ⁿOAMß÷@UN MDX �������A

h�∩���ñ⌡μ MDX ⁿO��IC

pGd�O SQL d�AhziH÷@U⌡μ SQL d��� AH½s⌡μ°iC

�e°�

�e°�π�e�∩����I��eC

�²°�

�²°��N��π��≡¼�cCYn}�@�ñ����²°�A�÷@U��

Mπ�≤�²ñCziH}�h��²°�]@���@�°��C

Yn�t�²�²°�P∩����A�÷@Uπ�sΦ������ C÷@U

�²°�ñ��AY�∩���ñ�∩��IA�ºτMC

DQM °A�Θx

DQM °A�Θx°�π��Ad��í°A�ΘxCo�Θx]td�°A�¼A�

�÷ΩTCpGz�� SAP Ω���Aho�Θx�NIsOⁿ�Ω���C��

Cube �A]�π��A Cube OⁿΩTC

� 2 � }l�� Cognos Dynamic Query Analyzer 7

Page 14: IBM Cognos Dynamic Query Analyzer 1020 Gn Upublic.dhe.ibm.com/software/data/cognos/documentation/docs/zh-t… · ]to IBM Cognos Dynamic Query Analyzer sWS MμCªi≤UzW M {íípªñAH

ziHw∩b IBM Cognos Dynamic Query Analyzer ñ⌡μ�°i���Ad��í

°A�ΘxAΦkOb�n]w�@δ��ñ���Ad�OⁿCYn�°@�ñ°

i�°A�Θx�A�÷@U��Mπ�≤°A�ΘxñC

°A�ΘxO�°A�Ñq@�iμ��C÷@U°A�Ñq@��Σ�bYAH

d���OⁿΩTC

��E��i�����A Cube �α

uE��i�viH�R�A CubeA��i∩� Cube �α�E�]Ω@��CuE

��i�v]iH�R²e⌡μ�°iA����∩��o�°i�E�C

uE��i�v�s@Γ��¼���C

v O�Θ���O IBM Cognos Business Intelligence °A�iHbU�� Cube �

M��E���Co�E�xsb Content Store ñC

v Ω�w���OΩ�w�z�iH��M��Ω�w�E���C≤sΩ�wº

ßA�¼�����w∩Ω�wñ�C@�w��E�ϕμ��E� CubeA N�

A Cube ½síp� Content StoreC

uE��i�v���O�Θ�E���AΣw⌠i±Jw∩O�Θ�E�∩��j

p¡εCª]���Ω�w�E���AΣw⌠i±Jw∩Ω�w�E�∩��jp

¡εC

ϕz⌡μuE��i�v�AiH��UC∩�C

ϕ 2. E��i�@δ∩�

∩� í�

d�u@qΩT pG∩�Ahbiμ���AuE��i�v��qu@qΘ

xñ�ΩTC

O�Θ�E� pG∩�AuE��i�v�iμ Cognos BI °A�ib½s

���A Cube �M��E���C]�úO�Θ�E��

jp¡εC

Ω�w�E� pG∩�AuE��i�v�iμΩ�w�z�iHM��E

���C]�úΩ�w�E��jp¡εCΩ�w�E��

��jp¡εⁿ�OΩ�w�gúYjpC

�i�⌡μ��¡ε pG∩�AhuE��i�v�bⁿw��íºß�⌠A�

�bϕ�iμ�E���CpG�S�i����AhuE�

�i�v�≥⌡μA��ªπ�@�l��A�¿C

ϕ 3. E��i�Lo�u@q∩�

∩� í�

u�qPUC⌠@���÷�

u@qΩT

pG∩�⌠≤°≤Ahu���°iñí¼�∩�°≤�u@

y{ΩTCpG∩�h�°≤Ah���°iñí¼⌠≤�∩

�°≤�u@y{ΩTC

�Bu�qUC�í�u@q

ΩT

pG∩�⌠≤D�í�°≤Ahu���b�ⁿw�q⌡μ�

°iñ�u@y{ΩTC

8 IBM Cognos Dynamic Query Analyzer 10.2.0 �G ��ΓU

Page 15: IBM Cognos Dynamic Query Analyzer 1020 Gn Upublic.dhe.ibm.com/software/data/cognos/documentation/docs/zh-t… · ]to IBM Cognos Dynamic Query Analyzer sWS MμCªi≤UzW M {íípªñAH

p�E���÷ΩTAH�Σ��p≤∩��A Cube ��αA��\mIBM Cognos

Dynamic Cubes ��ΓUnC

⌡μE��i�

ziHb IBM Cognos Dynamic Query Analyzer ñ⌡μuE��i�vAHú��A

Cube �E���C

{�

1. ⌡μπ��A Cube �Nϕ�u@q�@tC°iC ��∩�BJCpGzO]p

�A CubeAhiα�Qn⌡μuE��i�vA�ú��u@qΩTC

a. ���A Cube �u@qOⁿCp�ⁿ�A��\mIBM Cognos Dynamic Cubes

��ΓUnñ�÷�A Cube tm]w�DDC

b. ⌡μπ��A Cube �Nϕ�u@q�@tC°iAH¼�°i⌡μ�Φ�Ω�C

c. ∩��aAb⌡μ°iºß��u@qOⁿC

2. b Cognos Dynamic Query Analyzer ñA÷@U��M⌡μE��i�C

a. b∩ Cube e�ñA∩�nbuE��i�vñ⌡μ� CubeC

b. bⁿw@δ∩�e�ñAⁿw� 8��ϕ 2ñ�z�@δ∩�C

c. pGzwbⁿw@δ∩�e�W∩�d�u@qΩTAhiHbLou@qΩ

Te�WⁿwLo∩�]p� 8��ϕ 3�z�CpGzⁿwLo�Ahu�b

iμE����A���{P�ⁿw°iBM≤M����÷B¿b�ⁿw�

q��u@q�C

⌡μuE��i�v�A���π�B@�í�i�C��Ω����π��ΩT

Pσr�PC÷@UbI�ñ⌡μ÷súπ�i�π�AbI�≥⌡μuE�

�i�vCziH÷@U�⌠ ÷sA��⌠uE��i�v⌡μ�¼�e�ε

���C÷@U°÷sH�⌠⌡μA�ú�¼⌠≤��C

ϕ���d≥}liμíÑ��ANS��núi@B���Ai�⌠uE�

�i�v�⌡μC

uE��i�v�¿�A�i��G°�π�uE��i�v���KnCpG�

e@�uE��i�v�GAh�be@��G�ß�π�s�GC

3. ÷@U�i��G°�ñ�s�G��DC �D]tw[�íWO� Cube W�C

π���íμABπ�uE��i�v�G�≤h��Ω�C@δ��]tuE�

�i�v�G�KnCΩ�w�����í�Ω�w���C∩���CX�≤

uE��i�vδF⌡μ�∩�C

4. YnMú²exs�O�Θ���A�÷@U��MMúxs�O�Θ���C

ziHyß½sM�²eMú�O�Θ���C

5. YnxsO�Θ���A�÷@U��MxsO�Θ���C ½s���A Cube

�A���M���C

6. YnxsΩ�w���A�÷@U��MxsΩ�w���AMß∩����xs

mC ���]tΩ�w���ñ�π��ΩTCΩ�w�z����E�ϕμA

�B�¼����w∩Ω�w�E����E� CubeA½síp�A CubeC

� 2 � }l�� Cognos Dynamic Query Analyzer 9

Page 16: IBM Cognos Dynamic Query Analyzer 1020 Gn Upublic.dhe.ibm.com/software/data/cognos/documentation/docs/zh-t… · ]to IBM Cognos Dynamic Query Analyzer sWS MμCªi≤UzW M {íípªñAH

U@B

pGP�π�O�Θ�MΩ�w���AhYn�o��O�Θ�ⁿJ�αA�²�

�Ω�wE�ϕμwqE� CubeAAxsO�Θ�E��� Cube �E� CubeC

UCo�BJe\O�Θ�ⁿJd�Q�[\�Ω�w�E�iHú�nBC

10 IBM Cognos Dynamic Query Analyzer 10.2.0 �G ��ΓU

Page 17: IBM Cognos Dynamic Query Analyzer 1020 Gn Upublic.dhe.ibm.com/software/data/cognos/documentation/docs/zh-t… · ]to IBM Cognos Dynamic Query Analyzer sWS MμCªi≤UzW M {íípªñAH

� 3 � �°�� Cognos Dynamic Query Analyzer

��úb�� IBM Cognos Dynamic Query Analyzer �iαo��τb�D��÷

ΩTAH�ú�MΦ�M�μ�MΦkC

p�D Cognos Dynamic Query Analyzer S���°��ΩTA��\mIBM Cognos

Business Intelligence �zPw�ΓUnñ�y�°��zp�Cz]iH�\�≤S�

σ≤C

Lks�d�Θx�

pGzLks� IBM Cognos Business Intelligence °A�W�xs�d�Θx�Ah

°A��z�iα��Θx�m�Ω�²C

��Ω�²Hs�Θx�]pmIBM Cognos Dynamic Query Analyzer w�PtmΓ

Un�z�C

© Copyright IBM Corp. 2012 11

Page 18: IBM Cognos Dynamic Query Analyzer 1020 Gn Upublic.dhe.ibm.com/software/data/cognos/documentation/docs/zh-t… · ]to IBM Cognos Dynamic Query Analyzer sWS MμCªi≤UzW M {íípªñAH

12 IBM Cognos Dynamic Query Analyzer 10.2.0 �G ��ΓU

Page 19: IBM Cognos Dynamic Query Analyzer 1020 Gn Upublic.dhe.ibm.com/software/data/cognos/documentation/docs/zh-t… · ]to IBM Cognos Dynamic Query Analyzer sWS MμCªi≤UzW M {íípªñAH

�². Cognos Dynamic Query Analyzer ñ�≤UuπS�

≤UuπS�i≤U��Hh] pμ�úK�°Oú}����ΩT�Nú�C

Dn≤UuπS�Oi���² IBM Cognos Dynamic Query Analyzer ��tΣMⁿ

OΣCz]iH��ΣL�tΣ�����P°�C

v ziH��ⁿOΣ��tΣ��² Cognos Dynamic Query AnalyzerC�tΣ���

o�@Aq���� Ctrl ΣC

v ����CΓ�π�p�ΩTCúLApGz∩��IAh]�b�e°�ñπ�

p�ΩTC

v uE��i�vi�ⁿ�����Ω����N�i�i�π��σrC

v b�n]w°í�CΓMr¼��WAiH�∩ Cognos Dynamic Query Analyzer �

���CΓMr¼C

ΣL�tΣ

�ú���UCΣL�tΣC

ϕ 4. Cognos Dynamic Query Analyzer �ΣL�tΣ

�@ ΣL�tΣ

π�w}����MμC Ctrl+F6

π�@�ñ���Σ�°�MμC Ctrl+F7

MX��M�²°�ñ��IC ΦVΣ

ⁿy∩����°��MμC ΦVΣ

ⁿy∩�s uπCⁿOP@�ñ°��uπCⁿOC Tab Σ

}�°�����⌠�wq�÷\αϕC Alt+-

}��I�⌠�wq�÷\αϕC Shift+F10

IBM M≤Uuπ

p� IBM ∩≤Uuπ�����÷ΩTA��\ IBM Accessibility Center (http://

www.ibm.com/able)C

© Copyright IBM Corp. 2012 13

Page 20: IBM Cognos Dynamic Query Analyzer 1020 Gn Upublic.dhe.ibm.com/software/data/cognos/documentation/docs/zh-t… · ]to IBM Cognos Dynamic Query Analyzer sWS MμCªi≤UzW M {íípªñAH

14 IBM Cognos Dynamic Query Analyzer 10.2.0 �G ��ΓU

Page 21: IBM Cognos Dynamic Query Analyzer 1020 Gn Upublic.dhe.ibm.com/software/data/cognos/documentation/docs/zh-t… · ]to IBM Cognos Dynamic Query Analyzer sWS MμCªi≤UzW M {íípªñAH

�N��

�ΩTYw∩b�y�úºú�PA��}oC

bΣLΩañAIBM iαú�ú��ñ�ú�U�ú�BA��\αCnDz�b

O�i��o�ú�PA��A�Vϕa� IBM A�Nϕd�C��bú� IBM

ú�B{í�A��Aúϕ��t�uα�� IBM �ú�B{í�A�CunI

IBM ��z]úvA⌠≤\α�ϕ�ú�B{í�A�úiH�N IBM �ú�B{í

�A�CúLAΣªD IBM ú�B{íB�A�bB@W���Pτ�AΣd⌠�≤

���C�σ≤iαí�u{ív��R��vñ]A�ú�BA��S�C

bo���σ≤ñiα]t� IBM ���ºMQ�MQ���C�����ú��

ezMQº⌠≤�vCziHQ���Φí�d��vA�τ�H�G

IBM Director of Licensing

IBM Corporation

North Castle Drive

Armonk, NY 10504-1785

U.S.A.

Ynd��÷�� (DBCS) ΩT��v�yA�ó��bΩa�a� IBM �z

]úí�A���úX�vd�A�τ�H�G

Intellectual Property Licensing

Legal and Intellectual Property Law

IBM Japan Ltd.

1623-14, Shimotsuruma, Yamato-shi

Kanagawa 242-8502 Japan

UCq¿YP�Ωºk�°�ΦAY°�úA�GIBM �Hu{¼vú��A�ú

ú⌠≤���q�ºO�]]A²ú¡≤iΓ���XSw���O��C��a

bSwμ÷WAú�\�ú���t��O�A]�Ao�n�ú@wAXzC

��ñiα���NW���LΩW���C�∩�ñ]t�ΩTw�iμ�≤Fo

��≤N�]tboG½�s��ñCP�AIBM oH�∩i (�) ����ñ�ú

��ú�� (�) {íC

�ΩTñ⌠≤∩D IBM ⌠�º���≥≤ΦKtGúA �úNϕ∩o�⌠�º⌠≤

�íI�C��⌠�W��eD� IBM ú��e�@í≈A�ß���⌠����

μ�ßIC

ϕzúΩT� IBM �AzY�v� IBM HΣ{�Aϕ�Φí����teΩTA

�ú�∩zt⌠≤d⌠C

�{íº≥�v�Y μ�o�{íº�÷ΩTAHKF�UC�G (i) bW���

�{íPΣL{í (]A�{í) ºíμ½ΩTFH� (ii) �¼��wμ½ºΩTCh

�P≤UCa}ºHp�G

© Copyright IBM Corp. 2012 15

Page 22: IBM Cognos Dynamic Query Analyzer 1020 Gn Upublic.dhe.ibm.com/software/data/cognos/documentation/docs/zh-t… · ]to IBM Cognos Dynamic Query Analyzer sWS MμCªi≤UzW M {íípªñAH

IBM Software Group

Attention: Licensing

3755 Riverside Dr

Ottawa, ON K1V 1B7

Canada

o�ΩTiα�Aϕ�°�úAbY�ípUiα�nIOC

IBM ≥≤ΦºuIBM �ßX�vBuIBM Ω�{í�vX�]�⌠≤PÑX��°

�Aú�σ≤�ú���v{íPΣ��A���vΩ�C

⌠≤b�]t��αΩ�Obε�⌠�Uú�C]�AbΣL@�⌠�ñ≥o��

Giα��π�tºCb}oh�t�Wiα��L@�qA²úO�o�q

be@δt�W��P��GCA�A��wiαOzL�Φí��⌠CΩ�

��GiαúPC�σ≤�������v�Sw⌠�Ad�A��Ω�C

���ú�ºD IBM ú�ΩT��ú����BΣoG�n��ΣL}�DCIBM

�Lo�ú�A]LkT{o�D IBM ú��⌡μ�αB�e�B�⌠≤∩ú

��ΣLDiO���L�CpGz∩D IBM ú���α�⌠≤���A �wV�ú

����d�C

�÷ IBM ��V�⌠≤»zA�Nϕ IBM ���wAiα≤�²n��í

pU�����M�C

�ΩT]t�≤Θ���τB�Ω��°id C�F�iαa[H�πí�Ad

ñt��HBqB�P�ú��W�C��o�W�úOΩc�Ap�⌠≤�ⁿΩ

�°����W��a}ºBA�� XC

YQ�ß�b\¬��ΩT�ql�Aiαú����MmΓí�C

��

IBMBIBM �xBibm.com � Cognos O International Business Machines Corp. ��

��U��Awb�y\hΩa�qk��UCΣLú�MA�W�iαO IBM

�ΣLq���Cu�@vP��ΩTv⌠�Wú�s� IBM ��MμA⌠}�

www.ibm.com/legal/copytrade.shtmlC

UCNyOΣLq����U��G

v Java ��� Java ¼��M�xO Oracle �]��Σlq����U��C

16 IBM Cognos Dynamic Query Analyzer 10.2.0 �G ��ΓU

Page 23: IBM Cognos Dynamic Query Analyzer 1020 Gn Upublic.dhe.ibm.com/software/data/cognos/documentation/docs/zh-t… · ]to IBM Cognos Dynamic Query Analyzer sWS MμCªi≤UzW M {íípªñAH

��

���HñσrA�σrA�Sϕ� º�

CC

e��f�e°� 7

e��fb BI °A�ñ⌡μ 4

eK�f≤UuπS� 13

eE�fd�Θx�

�R 4

m 4

�� Content Store °�}� 5

��°iΘx°�}� 5

����\αϕ}� 5

Lks² 11

�° 6

d�⌡μl�

b Cognos Administration ñ�� 4

d�°� 7

eQ�fS�

sW 1

eQ@�f�A Cube

��� 8

�Ad��i�

�² 3

eQG�f°i 4

°� 3

°� (≥)

�e 7

�≈ 3

d� 7

�� 3

Kn 7

�² 7

�i��G 9

DQM °A�Θx 8

eQT�fs\α

E��i� 1

sWS� 1

°i� DQM °A�Oⁿ 1

eQ��f�� 6

Kn°� 7

�°�� 11

Lks²d�Θx� 11

E��i� 8, 9

eQ¡�f��s� 3

eQ��f�²°� 7

eGQ�f�i��G°� 9

DDQM °A�Θx°� 8

© Copyright IBM Corp. 2012 17