IBM Cognos Metric Studio 10.2public.dhe.ibm.com/software/data/cognos/documentation/... · 2014. 11....

231
IBM Cognos Metric Studio 10.2.2 ΓU

Transcript of IBM Cognos Metric Studio 10.2public.dhe.ibm.com/software/data/cognos/documentation/... · 2014. 11....

  • IBM Cognos Metric Studio10.2.2 �

    ��ΓU

    ���

  • ��

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

    ú�ΩT

    �σ≤A�≤ IBM Cognos Business Intelligence 10.2.2 �A�B]iαA�≤ß≥���C

    Licensed Materials - Property of IBM

    © Copyright IBM Corporation 2002, 2014.

  • �²

    �� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ix

    � 1 � sW\α . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 110.2.2 �ñ�sWS� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 110.2.1 �ñ�sWS� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 110.1.1 �ñ�sWS� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1∩�@δ��U��ϕ�¼ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1@PpqΩ�°� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1ⁿwp≤Mw�s��í . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2

    10.1.0 �ñ�sWS� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2°i�¼[j\α . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2OⁿpqΩ��M½≤�≤s . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2IBM Cognos Business Insight �is�°iΘX . . . . . . . . . . . . . . . . . . . . . . . 2

    � 2 � �� Metric Studio iμ�α�z . . . . . . . . . . . . . . . . . . . . . 5p�d . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5pqΩ��¼ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6pqΩ� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6ªñ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7p�d�¼ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7M��¼ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7\α�¼ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9¡��¼ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9

    �m IBM Cognos Business Intelligence ��{í . . . . . . . . . . . . . . . . . . . . . . . 10Sample Outdoors �q . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11

    Sample Outdoors �q�� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12�u . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14½⌡μP . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14Sample Outdoors Ω�wB�¼MM≤ . . . . . . . . . . . . . . . . . . . . . . . . . . 14

    � 3 � W�p�d⌠� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17∩�Ω��� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17∩�NΩ�ⁿJ� Metric Studio �Φí . . . . . . . . . . . . . . . . . . . . . . . . . 18

    tmM�qu@y{ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19

    � 4 � �� Metric Studio ��{í. . . . . . . . . . . . . . . . . . . . . . . 21�� Metric Store . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21pqΩ�M≤ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21��μ�Σ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21��μ�Σ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22syμ�Σ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23�qμ�Σ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23

    ��pqΩ�M≤ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24�°��μ�Σ]w . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25��pΓ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25�≤e�¼��pΓ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28

    � 5 � �J��XΩ� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29ⁿw�J]w . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29wq�J�� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29�� Metric Designer �ΣL ETL uπ . . . . . . . . . . . . . . . . . . . . . . . . . 32

    © Copyright IBM Corp. 2002, 2014 iii

  • ��H���j��� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32NΩ�ⁿJ� SQL Server �ú¬w� . . . . . . . . . . . . . . . . . . . . . . . . . . 33ⁿwⁿJMΩ�pΓ∩� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33½���{í . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33NΩ�ⁿJ��mϕ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34Bz���Ω� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35

    �J²ew���Ω� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36NΩ�q�mϕñⁿJ� Metric Store . . . . . . . . . . . . . . . . . . . . . . . . . . . 36q Metric Store �XΩ� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36�w�JM�X . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37��H���j��� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37

    Microsoft Windows @�t� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38UNIX @�t� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38

    � 6 � ��Ω�Hiμ�m . . . . . . . . . . . . . . . . . . . . . . . . . . . 41H���j��� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41½≤ⁿJ�� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42��H���j���≤sp�d⌠� . . . . . . . . . . . . . . . . . . . . . . . . . 43sW�J��B���qμ�ΣH�]ww�\iv . . . . . . . . . . . . . . . . . . . . . 44��p�d�NpqΩ�sW�p�d . . . . . . . . . . . . . . . . . . . . . . . . . 46��pqΩ��¼MpqΩ� . . . . . . . . . . . . . . . . . . . . . . . . . . . . 47��ªñMªñ� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51���ϕ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52sW°i . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53

    � 7 � b Metric Studio ñ��p�d�c . . . . . . . . . . . . . . . . . . . . 55��p�d . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55��pqΩ��¼ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56ⁿw@δ]w . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57pΓpqΩ�� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58ⁿw�αμ� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59]wpqΩ��¼w� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60

    ��pqΩ� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60��l��pqΩ� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63��¡w . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64NpqΩ���sW�p�d . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65�°��∩pqΩ�Mp�d . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65b Metric Studio ñsW°i . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65{�� IBM Cognos BI °i . . . . . . . . . . . . . . . . . . . . . . . . . . . . 66s�D IBM Cognos BI °i . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67{��D IBM Cognos BI °i . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67

    �≤ IBM Cognos BI °i��e . . . . . . . . . . . . . . . . . . . . . . . . . . . . 68°i�� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 68�q�� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71ⁿw� IBM Cognos BI °iíJú���Φí . . . . . . . . . . . . . . . . . . . . . . . 71�∩ IBM Cognos BI °i . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72�ªñ��pqΩ� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72��ªñ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73��ªñ� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74NpqΩ�sW�ªñ� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 75N��sW�ªñ� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 75NM�sW�ªñ� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76

    �ϕ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76�∩vT�ϕ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78���q�ϕ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79N�q�ϕsW�p�dBpqΩ��¼�pqΩ� . . . . . . . . . . . . . . . . . . . . . . 80

    iv IBM Cognos Metric Studio 10.2.2 �G ��ΓU

  • b�ϕñsW�RúpqΩ� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81��I�v�� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81

    � 8 � w�M\iv . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 83½swq���\iv . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 84]wp�dBpqΩ��¼BpqΩ�Bªñ�ªñ���T\iv . . . . . . . . . . . . . . . . 84ⁿw Metric Store �z� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85

    � 9 � �q���Θτ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87¼Aⁿ�� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87]w¼Aⁿ���¼A� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 88ⁿw¼Aⁿ����í . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 89sW¼Aⁿ��� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 89]wªñ�¼A�I�CΓ . . . . . . . . . . . . . . . . . . . . . . . . . . . . 90

    wqOⁿ]w . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 90�≤��pΓ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 90ⁿwp≤Mw�s��í . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91ⁿw�q�qμ� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91ⁿw���i���q�μ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 92sWi��μ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 92�∩���wq��μ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93�����wq��μ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93]ww]π��μ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93ⁿw��C�Φí . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93

    �≤����a . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 94�≤pqΩ�W��μí . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 94�≤ Metric Store ��íd≥ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 94D�qμ�Σ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 95�qμ�Σ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 95

    ⁿw�{�ϕ�w]π�]w . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 95ⁿwμ�Σ�� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 96���q�O� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 97yk . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 99

    �≤����rΩ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 101yÑ�� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 101��μ@σrμ� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 101��h�σrμ� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 102

    � 10 � �R°i . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 103Framework Manager �¼ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 103p�dP¼⌡ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105M�P¼⌡ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 107pqΩ�P¼⌡ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 108M���P¼⌡ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 109pqΩ���P¼⌡ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 109�@P¼⌡ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 110�@��P¼⌡ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 111ú�vT�pqΩ�P¼⌡ . . . . . . . . . . . . . . . . . . . . . . . . . . . . 112ªñP¼⌡ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 113

    �R°i . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 114w]�R°i . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 114�q�R°i . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 115

    ���¼ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 116�°°� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 116�¼°� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 117��°� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 117

    ² v

  • pqΩ�τ� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 117�e�Ω�¿ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 117���°id�DD . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 118°i��h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 119

    � 11 � �°�α . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 121]w Metric Studio ��� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 122P��ϕ��{�ϕ� ID . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 122�°Mμ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 122NpqΩ�sW��°Mμ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 122sWpqΩ��qll≤q� . . . . . . . . . . . . . . . . . . . . . . . . . . . . 123q�°MμñRúpqΩ� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 123ⁿw�°Mμ�qll≤q�°≤ . . . . . . . . . . . . . . . . . . . . . . . . . . . 123

    ∩�n�°��q . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 123pqΩ��R . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 125p�dW�pqΩ� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 125�{�ϕ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 126pqΩ�vT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 127�ϕ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 127°i . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 129

    CLpqΩ�ΩT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 129WipqΩ���α . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 129sW�� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 130���@ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 130≤s�@ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 130

    l�M� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 131��M� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 131≤sM�¼A . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 132N@�sW�M� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 132≤s@�¼A . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 134bp�dW½s��M� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 134½s��M��@� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 135

    ≤spqΩ�� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 135≤spqΩ�� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 135bp�dW≤sh�pqΩ�� . . . . . . . . . . . . . . . . . . . . . . . . . . . 135

    �² A. �°�� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 137BCP �σr��J�� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 137Lk½spΓ Metric Store l�� . . . . . . . . . . . . . . . . . . . . . . . . . . . 137w∩pqΩ�π���s�ú�T . . . . . . . . . . . . . . . . . . . . . . . . . . . . 138NΩ�q�m��e� Metric Store ó� . . . . . . . . . . . . . . . . . . . . . . . . . 138NΩ�q���J��m�ó�A�π��� . . . . . . . . . . . . . . . . . . . . . . . . 138b IBM WebSphere U⌡μ IBM Cognos Metric Studio �ALkqpqΩ�M≤�XΩ� . . . . . . . . . 139��P Metric Store �Ω����AMetrics Management Service o��� . . . . . . . . . . . . . . 139�l]w Metric Store ó� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 140Lks��ⁿw�Ω��� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 140Ω���suúsb . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 141Lk�� IBM DB2 ��pqΩ�M≤ . . . . . . . . . . . . . . . . . . . . . . . . . . 141Lkb MS SQL Server 2005 W�l]w Metric Store . . . . . . . . . . . . . . . . . . . . . 142Metric Studio Θx� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 142OⁿpqΩ��M½≤�≤s . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 143��½≤≤sOⁿ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 143���≤sOⁿ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 143⌡μ½≤≤s°i . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 144⌡μ�≤s°i . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 144

    Metric Studio �n� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 144

    vi IBM Cognos Metric Studio 10.2.2 �G ��ΓU

  • ≤ Oracle �í����P Metric Studio °ió� . . . . . . . . . . . . . . . . . . . . . 145NΩ�ⁿJ� Oracle Ω�w�o� Metric Studio �� . . . . . . . . . . . . . . . . . . . . 145��b SQL Server 2005 W⌡μ Metric Studio �o��� . . . . . . . . . . . . . . . . . . . 146�π�÷píΩ�w����σr�Ω����Ω� . . . . . . . . . . . . . . . . . . . . . . 146Lk⌡μpqΩ��@@� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 146zS�s�pqΩ�M≤�\ivC�p�z�t��z� . . . . . . . . . . . . . . . . . . . 146�� DB2 8.2.3 �Lk�d Metrics Store w�¼A�� . . . . . . . . . . . . . . . . . . . . 147NH���j����J� DB2 Metric Store �o��� . . . . . . . . . . . . . . . . . . . . 147Metric Store Ω�w��n���\iv (Microsoft SQL Server). . . . . . . . . . . . . . . . . . 147pGb�� IBM Cognos BI Tomcat °A�ºe�Aϕa]w NLS_LANG ⌠���Ah�o� Oracle 9.2 M≤�l]w�� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 148IBM Cognos Workspace ���Lki}pqΩ� . . . . . . . . . . . . . . . . . . . . . . 148

    �² B. H���j��� . . . . . . . . . . . . . . . . . . . . . . . . . . . 149½≤�m� (.cmo) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 149pqΩ��¼�m� (.cmm). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 156½≤���m� (.cml) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 164��m� (.cmv) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 167�m�ϕ� (.cdo) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 170�m½≤�� (.cmn) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 176�m�q��� (.cmp) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 178�q�m� (.cal) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 179�mh� (.cms) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 181�J��f⌠�m� (.ccm) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 184�J�� Reportlet �m� (.crm) . . . . . . . . . . . . . . . . . . . . . . . . . . . . 184�J���íh��m� (.ctl) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 185�J���q�m� (.ctp) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 185�mM�� (.pro) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 186�íyÑσr�m� (.tlt) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 189�íh��m� (.lvl) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 190�mμ�� (.unt) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 191Cube d��m� (.ccq) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 192�m�°Mμ� (.cwl) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 194Φ{í (.equ) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 195Φ{í� (.eqi) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 195

    �² C. �mϕ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 197Object_stage ϕμ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 197Metric_type_stage ϕμ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 199Object_link_stage ϕμ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 201Kpi_value_stage ϕμ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 202Stage_diagram ϕμ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 202Stage_object_note ϕμ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 204Stage_custom_params ϕμ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 204Time_periods_stage ϕμ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 205Stage_policy ϕμ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 206Import_source_cu_stage ϕμ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 206Import_source_rp_stage ϕμ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 207Import_source_tl_stage ϕμ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 207Import_source_tp_stage ϕμ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 207Stage_project ϕμ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 208Time_language_text_stage ϕμ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 208Time_levels_stage ϕμ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 209Stage_unit ϕμ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 209Cube_query_stage ϕμ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 210Stage_watchlist ϕμ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 210

    ² vii

  • �N��. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 211

    Wⁿ��. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 215@ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 215T . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 215

    . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 215¡ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 215� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 216C . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 216K . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 216E . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 217Q . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 218Q@ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 218QG . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 218QT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 219Q . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 219Q¡ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 220Q� . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 220QC . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 220QK . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 220QE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 221GQ@ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 221GQG . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 221C . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 221G . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 221M . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 221P . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 221R . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 221

    viii IBM Cognos Metric Studio 10.2.2 �G ��ΓU

  • ��

    �σ≤A�≤ IBM® Cognos® Metric StudioCMetric Studio O@� Web ú�A��z

    L�°M�R��ñU�h��pqΩ�BM�MΣL�α�qA��z����

    αC

    A�∩H

    Yn���ΓUAz�⌠x

    v p�dº�v Ω�wMΩ�xº�v w��D

    ∩≤��{í@�A�σ≤]A����p�d⌠��I�ΩTMvB{�Cªí�

    Fp≤��p�dBpqΩ��¼MpqΩ�Ap≤NΩ�ⁿJ� Metric Studio H�

    p≤[jp�d⌠�C

    ∩≤��MaA�σ≤]A�� Metric Studio �z�α�I�ΩTMvB{�C

    MΣΩT

    Ynb Web WMΣú�σ≤]]A��w���σ≤�A�s� IBM ��ñ� (http://

    www.ibm.com/support/knowledgecenter)C

    e�n�

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

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

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

    Kdn�d�

    Sample Outdoors �qBGreat Outdoors �qBGO SalesB⌠≤ Sample Outdoors � Great

    Outdoors W����AH� Planning SampleAo�úyzΩc�°�B@AΣñ�d

    Ω�O��� IBM M IBM �ß}od��{íCo�Ωc�O²]APΓμ÷B

    ú�teB]��HOΩ��dΩ�CpPΩ�W�Ba}Bp��X�μ÷�p

    PA���XCΣLd��iα]tΓ��≈�ú��ΩcΩ�BqN��}�

    �s���Ω�A��o�@v��H\i���Ω�Ao�úO@�}od�

    �{í�dΩ�C���ú�W�iαOΣ�O�����C�g�vAúo�

    sC

    ≤UuπS�

    ú�{μúΣ�i�U�¡Θ�¬���� (pμ�úK�°��¬) ���ú�

    �≤UuπS�C

    © Copyright IBM Corp. 2002, 2014 ix

    http://www.ibm.com/support/knowledgecenter

  • x IBM Cognos Metric Studio 10.2.2 �G ��ΓU

  • � 1 � sW\α

    �]t���sWS�B�≤�S�Mw�úS��MμCªi≤UzW��

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

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

    UnC

    p����ΣLsWS���÷ΩTA��\ú��mIBM Cognos Business Intelli-

    gence sWS�nC

    zLs� IBM ��ñ� (http://www.ibm.com/support/knowledgecenter) ñ�σ≤AiH

    �o���usW\αvΩTC

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

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

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

    10.2.2 �ñ�sWS�o� IBM Cognos Analysis Studio S�sWS�C

    10.2.1 �ñ�sWS�o� IBM Cognos Metric Studio S�sWS�C

    10.1.1 �ñ�sWS�U�CX�W@�H��sWS�C

    ∩�@δ��U��ϕ�¼

    z{biH∩�us�/sΦ�¼v���u@δv��U��ϕ�¼C

    �÷u@:

    � 57��yⁿw@δ]wz

    ziHⁿw@δ]w���pqΩ��¼AHwq�÷pqΩ��X���MpΓC

    @PpqΩ�°�

    z{biH��pqΩ�Mμ°�MpqΩ�����Knμ°��@Pw]π�

    �μC

    �÷u@:

    � 93��y]ww]π��μz

    ziH]ww]π��μMμ�ú�@P�μ]]A�l�pqΩ�����wq�

    μM���μ�Cw]π��μMμú�@PpqΩ�MμMpqΩ������

    YΘXC

    © Copyright IBM Corp. 2002, 2014 1

    http://www.ibm.com/support/knowledgecenterhttp://www.ibm.com/software/data/cognos/customercenter/http://www.ibm.com/software/data/cognos/customercenter/

  • ⁿwp≤Mw�s��í

    z{biHⁿwp≤Mw�s�°���íC

    �÷u@:

    � 91��yⁿwp≤Mw�s��íz

    �@�∩�iHⁿwp≤Mw�s�°���íC

    10.1.0 �ñ�sWS�U�CX�W@�H��sWS�C

    °i�¼[j\α

    w[j IBM Cognos Metric Studio H�°i�¼AiH]A�ϕCoi²°i@�

    b°iñsW¼�íΩ�X��ϕC

    q°i�¼oG�M≤{b]AUCϕμ�Ω�¿ñ��ϕG

    v pqΩ�ϕμAΣ]t���s�qΩ���ϕAi�≤��D�pqΩ�Cv pqΩ��{ϕμAΣ]t���qS�Ω���ϕC

    ��GpqΩ��¼vT�ϕú]t�í¼ΩTFª�u]tpqΩ��¼ºí�

    ÷YC

    pGqpqΩ�M≤�upqΩ��{vϕμsW�ϕA��C��í�{�U�

    pqΩ�sW@��ϕC]Az�°iiα]tjq��ϕCYnWi°i��

    αA��qsWLo��¡ε�qC

    v �ϕΩ�¿AΣ]t�q�ϕC

    YnA�Y��ϕp≤]Ab°iñH�p≤b°iñ��A��\ Metric Studio H

    �upqΩ��αvMup�d�αv°iC

    p��¼��÷ΩTA��\� 116��y���¼zC

    p�b Report Studio °iñsW�ϕ��÷ΩTA��\mIBM Cognos Report Stu-

    dio ��ΓUnC

    OⁿpqΩ��M½≤�≤s

    ≤sOⁿe\�z�l�∩pqΩ��MpqΩ�½≤�iμ��≤C

    ϕz��≤sOⁿ�A�N∩pqΩ�MpqΩ�½≤�iμ��≤Oⁿ� Metric Store

    �ϕμñCupqΩ�v°i�¼ú�∩ Metric Store ñ≤sϕμ�s�vA�B��

    �w]≤s°iA�≤ú�o��≤�°iC�z�]iHq≤sϕμ���q°

    iC

    �÷º�:

    � 143��yOⁿpqΩ��M½≤�≤sz

    ≤sOⁿe\�z�l�∩pqΩ��MpqΩ�½≤�iμ��≤C

    IBM Cognos Business Insight �is�°iΘXb 10.1.0 �ñAziH��is�°iΘXCis�°i]t�p�NσrÑS�A�

    ¡��¬����iH���U�N]p�⌡\¬���s�°i�eC

    2 IBM Cognos Metric Studio 10.2.2 �G ��ΓU

  • ��≤UuπΣ�ºßAiHbΣ�≤UuπS�� IBM Cognos Business Insight ñ

    �� Metric Studio °iC

    p���is�°i��÷ΩTA��\mIBM Cognos�zPw�ΓUnC

    � 1 � sW\α 3

  • 4 IBM Cognos Metric Studio 10.2.2 �G ��ΓU

  • � 2 � �� Metric Studio iμ�α�z

    �� IBM Cognos Metric Studio ����qp�d⌠�AH�°M�Rπ�����

    pq�MM�C

    Metric Studio i≤UzN��ªñα½��÷�i�q�AH�C��u�μ�Pª

    ñpO�@PC

    I�p�d⌠�iH�t�zπ����¿\ºBMú¼ºBCMetric Studio iHw

    ∩�l��α�ⁿX{μ���¼AAHK��ñU�h��Mª�iH�X��

    �iμWC

    Q� Metric Studio �Fí�AiH�zwg���⌠≤���M�p�dM�zΦ

    kA���pqΩ��Σ÷Y��¼C

    p�d

    p�dO�αpqΩ�MM���XA]p���M���Y�μ��ªñ�C

    zL±�W�GPΩ��GAp�dW�ΩTiHiDz��Ω{{�Cp�d

    iH]tΣLp�dHπ���ñ���CzL��¼Aⁿ��]pyq�x

    O�Ap�d���iH�ta�⌠�αC

    ziH�úP�¬���p�dH[\úP��{�CYn∩z�pqΩ���{

    íΩI���zA������C�μ����O�p�dCMßiH�C�p�d

    M�w�AH�pqΩ�uαSw���Bs��ñΓiμs�C

    pGz�Y�Ω�����α≈Nϕp�d�c�@í�AhiH�� IBM Cognos

    Metric Designer �H���j���qΩ����XΩTA�b IBM Cognos Met-

    ric Studio ñ��p�d�cCpGúαNϕAhiHbH���j���ñ���cA

    MßNΣ�J� Metric StudioA]iH��b Metric Studio ñΓ����cC

    b��⌠≤pqΩ�ºeAz������@�p�dCC�pqΩ�π�b��@

    �p�d]W����p�d�WC]�bp�dh�WM�Fw�A�H��p�

    diHTO��pqΩ�úw�C

    M�

    M�O��pqΩ�bp�dWl��°�í�CpAziH��@�Xi�wP

    Γ���M�A�BiH��pqΩ�]p��¡�sPΓNϕ�W[��

    �l�M�C

    ��M�ºßA���iH�°M≤sM��¼AC

    b¡�p�d⌠�ñAziH��M��l�D�@�C

    © Copyright IBM Corp. 2002, 2014 5

  • pqΩ��¼

    pqΩ��¼iwqpqΩ��X���CqA@�pqΩ��¼i�OYΦ��

    �α]p¼J�C

    pA¼JpqΩ��¼iHPpqΩ�]pu¼J - Ωa���vBu¼J - a

    �vBu¼J - ½vÑ��÷pCpGz�°pqΩ��¼AIBM Cognos Metric Stu-

    dio ��zπ��≤pqΩ��¼�pqΩ�]ú�pqΩ����p�d�≤�C

    ]�pqΩ��¼wqqúxsb⌠≤{�Ω�wñA�Hziα�n��b Met-

    ric Studio ñ��pqΩ��¼C

    iH�pqΩ��¼ⁿú�ϕM°iAHKª�π�bpqΩ��¼�C�pqΩ

    ���ϕM°i��WC

    pqΩ��¼]iHwqpqΩ��¼AH�Ω�pqΩ��B�pqΩ��Me

    �pqΩ���pΓCiHQ����wq�Φ{ípΓ���wq��μCpqΩ

    ��¼�pΓA�≤�≤�¼���pqΩ�Cz]iH��OpqΩ�wqp

    ΓApΓNm½w∩pqΩ��¼wq�pΓC

    pqΩ��¼ú]tΣLpqΩ��¼C

    pq�

    pqΩ�iH�q��÷Σ��ñ��αA�N{μ�GP��iμ±�C

    b IBM Cognos Metric Studio ñApqΩ���°UC�G

    v Ω�

    ��ql��@��C

    v �

    ��iwqw��α�h�C

    v e�

    e��iwq�G�≈�]w��i�ⁿd≥C

    v ���wq��μ

    ���wq��μ�q��i±��pqΩ�]p��d≥�����q�

    ��qpqΩ���αC

    ���iH�pqΩ��¼AH�⌠D�@�O�¿\CpApGe�O�b

    wΓ�AhO�pqΩ�Nπ�±Γ¼Aⁿ��Hπ��G��VC

    @�pqΩ�uP@�pqΩ��¼�÷pCpqΩ��¼qNϕSw��q]

    pQϕv�AP�]wqpqΩ�í�@�μ�]p�α¼�M�n≤s��C

    pqΩ�iHπ�b⌠N��p�dWA²O��ⁿw@�p�d@�Σ��p�

    dC

    6 IBM Cognos Metric Studio 10.2.2 �G ��ΓU

  • wpΓ�pqΩ�

    ziH��l���ⁿJSw��pqΩ�Cz]iH��pΓ�pqΩ�A�pΓ

    �pqΩ�Ol��ΣLpqΩ��pΓ��pqΩ�C

    wpΓ�pqΩ�ú��ΣLpqΩ��¼AB��M�C

    ziH���wp�pq�G

    v l��

    v �í¼�wpΓpqΩ�

    ���z��b Metric Studio ñsW�Rú�í¼�wpΓpqΩ�Cz]iHq

    Metric Studio �X�ñ�Jo�pqΩ�A²Oú��z�∩Φ{í�X�C

    ªñ

    ziH��ªñAH∩�����Nq�Φí��pqΩ�C

    IBM Cognos Metric Studio ��{íiH]A²zHúPΦí��M�°pqΩ��@

    �ªñC@�pqΩ�iH�≤h�ªñC

    ªñ��Nϕyz�ñw�¿G���°��¡�p�d°�C��°��¼�

    ªñ�AiH≥�znF¿��G]p∩i�Φ����pqΩ�MM�CM

    ßAiHsWπ�zO��Ω{��pqΩ�]phfBsyσ½MπΘσ

    ½�C

    �iHN°iMM�Pªñ�÷pC��NAPªñ�÷p�M�M°iP��Pp

    �d�÷p�M�M°iL÷C

    ziH��H���j�����ªñMªñ�A]iH��b Metric Studio ñ�

    �C

    p�d�¼

    z�H��B�Nq�Φí���p�dMpqΩ��¼C

    ÷MC���ú�Σp�d�cΦ��WSnDA²�X�p�d�¼iHq�C

    Dn�

    v M��¼v \α�¼v ¡��¼

    M��¼

    M��¼���°π�����P�¼�pqΩ�C���@�iTO����C

    �μ�ú���P�¿\�qΦkC

    qAϕ�M��¼�p�d�cO�����{��cApaz�GC

    pABank International iH�Σ�°��d�≈μ÷�p�d�cHaz���≥ªC

    ªn�°�pqΩ��¼iαO�ß����d�≈iμ�ú�Bs�MαbC

    � 2 � �� Metric Studio iμ�α�z 7

  • p�d�c�\�z��°�ßbΣa������d�≈�ípA�VUvh�

    R�½h�HP���íp��M�t�aΦC

    � 1. π�h���d�≈μ÷�¼�Θ�p�d

    8 IBM Cognos Metric Studio 10.2.2 �G ��ΓU

  • \α�¼

    ≤[h�����∩���úPí�iα�úP��α�C

    b\α�¼ñApqΩ��¼Hp�d�p�d≡¼�c��Σ���C

    pAPΓΘ��≈�uSample Outdoors �qviH��q��\αs�]pP

    ΓBteBμPM]��c�Σp�dC

    p�d�c�\����°��vTΣs��α�pqΩ�CpAu]�vs�

    ÷�pQϕvMτBQϕvÑpqΩ�A�uPΓvs�h÷�p�≈Mμ�PΓÑ

    pq�C

    ¡��¼

    ¡��¼qPM��¼�\α�¼@���C

    � 2 � �� Metric Studio iμ�α�z 9

  • ziH��pqΩ�s�bM��¼�\α�¼ºW½�¡��¼AHú�pqΩ�

    �°�C

    Ω@¡��¼�t@�ΦkO�C�°���@�p�dCo∩}lΩ@¡�O�d

    @�����ÑD��C

    pAb±��¼�\α�¼WAiHNpqΩ�]pCμ�σ½�Bhf�qM

    l��q���b@�AHú�∩�ß�y¿vT�°�C

    o���q�¿°���s�½�¡�p�d�¼�\α�¼C

    �m IBM Cognos Business Intelligence ��{íziH�� IBM Cognos Business Intelligence ≤��m°iM�R��{íC

    IBM Cognos Business Intelligence ��{í��R�¡iHOX�δA��X�Cb

    q�í�AΩ�iα��≤A�BX{s��DCϕ≥ªΩ��≤�A@����∩

    {���e�}os�eC�z����H��í���≤s�¼MΩ���Cp�

    ��Ω�����÷ΩTA��\mIBM Cognos Business Intelligence �zPw�ΓUn

    MmIBM Cognos Framework Manager ��ΓUnC

    }lºe

    bu@ñ���{í�A�NMw�≥ª[cH�Jf⌠�w��NⁿA�B�≤�

    zBΩ��εÑ{�]w��NⁿCp�P�� IBM Cognos BI �e�÷p�u@y

    {��÷ΩTA��\mIBM Cognos Business Intelligence [cPípΓUnCp��

    ÷ΩTA��\ IBM Cognos Solutions Implementation Methodology uπcAΣñ]A

    Ω@�²�MΣ�σ≤CziHb IBM Σ�Jf⌠� (http://www.ibm.com/software/

    analytics/support/finding-answers) WΣ�uπc��÷ΩTC

    U�ú�p≤�� IBM Cognos BIAb�� IBM Cognos BI ≤W�m��{í�º

    [C

    10 IBM Cognos Metric Studio 10.2.2 �G ��ΓU

    http://www.ibm.com/software/analytics/support/finding-answers

  • {�

    1. MΣ���Ω���M�¼C

    IBM Cognos BI iHqU�Ω���]÷píM���ñ��°iCΩ�wsu�

    �b Web �z�ñA����BsgM⌡μ��{íC

    Yn��Ω�HiμsgM�°ABusiness Intelligence Studio �n Meta Ω���

    ¼l�]��M≤�CMeta Ω�iα�nb Framework Manager ñiμjW��

    ��@�C

    2. �m�oG�eC

    °iBp�dB�RBu@�ÑúOb IBM Cognos BI � Business Intelligence Stu-

    dio ñ��Czn��� Studio �M≤°i��eB���¡M¬�AH�Ω�O

    H��Φí���OH÷píΦí��CpA�Uí°iM�ROzL IBM

    Cognos Workspace AdvancedBIBM Cognos Query Studio M IBM Cognos Analysis

    Studio ��¿A�w�{°iOb IBM Cognos Report Studio ñ��CReport Stu-

    dio °iMp�dq���h¬���BoG� IBM Cognos Connection �ΣL

    Jf⌠�A�bΣñ�{Hiμ�tHoBteÑCz�iH�� Report Studio �

    �Uí°i��d�C

    3. �e��°ΩTC

    ziHq IBM Cognos Jf⌠��ΣLΣ��Jf⌠��e�eA�B�°wxs

    �Jf⌠��zLΣL≈ε�e�ΩTCz�iHb��F°iB�RBp�d�

    ΣL�� Business Intelligence Studio ñ⌡μª�C

    p��πM�α��÷ΩTA��\mIBM Cognos Business Intelligence �zPw�

    ΓUnM IBM Σ�Jf⌠� (http://www.ibm.com/software/analytics/support/finding-

    answers)C

    Sample Outdoors �quSample Outdoors �qvdí�ú�S�H��NM����@kC

    z]iHNª����τM@�°i]p�NAH��≤iμ�°��C��d

    �AziHs��ú�ñ�S�C

    p�úP�¼����÷dA��\ IBM ��ñ� (http://www.ibm.com/support/

    knowledgecenter) ñ�ú���C

    Sample Outdoors �qBGO Sales �⌠≤ Sample Outdoors W����AúOΩc�

    °�B@�W�AΣdΩ�O��� IBM � IBM �ß}od��{íCΣΩc

    �O²]APΓμ÷Bú�teB]��HOΩ��dΩ�CpPΩ�W�Ba

    }Bp��X�μ÷�pPA���XC�g�vAúo�sC

    � 2 � �� Metric Studio iμ�α�z 11

    http://www.ibm.com/software/analytics/support/finding-answershttp://www.ibm.com/support/knowledgecenter

  • d�ºz

    d]tUC�eG

    v ]t���qΩ�H��≤d�M�R��÷d�¼�Γ�Ω�wv d Cube ��÷�¼v @�]A�÷ppqΩ��pqΩ�Ω���B@�X��q�ªñ�AH�@��≤upqΩ�v���¼C

    v °iBd�Bd�d�Mu@�

    Yn⌡μ¼�í°iA�n ScriptCYnd�dM≤ñ]t���°iA�qd

    �ew�ñN���s�ípΩ�¿AMßNíp�J� IBM Cognos Business Intel-

    ligence ú�C

    w�

    �����úiH��dC

    YnΩ@w�A��\mIBM Cognos Business Intelligence �zPw�ΓUnC

    Sample Outdoors �q��Yn�]pd]SOO]�d��t�≤�AY�uSample Outdoors �qv�@

    δΩT���C

    YnMΣ��Swú�S��dA��\�ñ��Odí�C

    uSample Outdoors �qv�¼J���q

    MgPτBC¼JWΩl�q�¼J

    X��¿C���úP���AC���ú�U��í�MPΓ�CΣñ�¡��

    �O����qC

    ����q (GO Accessories)G

    v π�b�PBW�B�μBCΓMjpWPΣL GO �qúP�M�ú��XCv PΓd≥qμ@������MsΓCv JO�í�≤Θ���τB�qA]O�w�T� GO l�q�í����C

    �ϕí�X���q�c]]A GO ñ����v��±�≤�A�π�C�l�q�

    °if⌠M�br�C

    12 IBM Cognos Metric Studio 10.2.2 �G ��ΓU

  • C��qúπ��P�í��cM�P��b�cApϕμ��CU�íiαú�H

    �P�f⌠iμ°iCpAⁿwl�qHⁿiμ°iA²Ou�qv�í�ϕa

    f⌠�[�j⌠A�uτBv�í�ϕaf⌠���C

    ϕ 1. í��c

    �í]�b� í�]�b�

    �q (1700) PΓ (1720)

    μP (1750)

    IS&T (1760)

    HO� (1730)

    ]� (1740)

    �� (1710)

    τB (1800) �úPte (1820)

    �ßA� (1820)

    C��qú��π�bß�ϕCjí�bß]pDH�O�U�bß�ú�≤í�

    h�Au]tKn�qCpA¿�C�μPí�úπ�O�A²ObiμPP�μ

    ÷h�W��ⁿw¿�C

    � 2. X���q�c

    � 2 � �� Metric Studio iμ�α�z 13

  • �u

    Sample Outdoors Ω�]t���Bí�MaI��u�πMμC

    ú��÷≈]u�y≈v°i�MPΓ�≈]uñ�PΓ�≈v°i�B÷V

    ]u�u÷V]�≈�v°i�MZ��\H��uíN��d]2012 ��uíN

    ��Ñ°i�Ω�CpG�� Metric StudioAh]ú�HOΩ��dpqΩ�C

    buGO Ω�x]�R�vM≤ñA�qM�÷���s�����Ω�¿ñCH�

    �Mgz�Ñh����uAHPaw∩úP�¼�E�iμ°iCw�u�u�

    �Knv�qwqE�AHK�u��p�vMup���p�vbUCC��í

    h�W�TE�GCδBCu�C�Cp�dA��\pH�°iC

    �u]�Cbd LDIF ��ñA��O�≤iμ⌠≤ LDAP IBM ú��O]]A

    Tivoli®�C IBM Cognos Planning d�n�O²CΣLdíú�M≤w�]w

    �C

    ½⌡μP

    Sample Outdoors ������qíi��½⌡μP��÷Ω�C

    GO Accessories π�≤I����Σ��RdCpA�u½⌡μPvCube �

    d�u¼JPQϕv��±]ú��P�v�RCμPMPΓí�P Sample Out-

    doors ����q�s�C

    �Θ�ÑAGO �q�jí�ú�tC]v�PΓ¿°�b����]2011 � GO l

    �q¼J�í�¡w¿°AoO≤�p½���H�sú��∩}ú�]p¬Q

    ϕ��ºΦú�tC�Φ��¿°Ñ]��PCb¡�����q]GO Accessories ú

    �����q�PΓ�ú�tCñAPPwbhΦ�≥o¿\]PP¿\]í�B

    �XMu���CpG�� Metric StudioA]iHbdpqΩ�ñ���C

    �ßNú�d

    Ω��]t���ßNú�d�ΩTCpA]A�AGB�≈Ñb��ú�tC

    ���o¿\]ú�íN� - 2011 ß��@�≈�A�BsΓúíN�]iαO

    �ßA�⌠�A�úOhf]�ßhfMíN��CpG�� Metric StudioA]iHb

    pqΩ�ñ�°ΩTC

    PΓMμ�

    �qMμ�¼JiHbμ÷h�W�oCgPMμ�¼JuibX�h�W�o

    ]u½⌡μPvCube�CsΓ��÷pqΩ�π�AssΓMμ��bΩ�

    [\��q�wU�C

    GO Accessories b�yPΓA�BuPΓt≤CGO Accessories �μ÷Ω�O�PB

    CΓMjp�Rú��Dn��C�q���ΣL¡�l�qO����qA�VΣ

    �b���sΓPΓ���ú�tCCpAu2011 ��We 10 �sΓv°i�

    �½��MMμΩ���\sΓh��¼JC

    Sample Outdoors Ω�wB�¼MM≤Sample Outdoors Framework Manager �¼í����NABΣ�dC

    14 IBM Cognos Metric Studio 10.2.2 �G ��ΓU

  • �¼O� GO Ω�xM GO PΓμ÷Ω�wA�BOd°iMd��≥ªCC

    ��¼]tΓ���oGΩ��R]���Md�°��M≤C

    z��π� Framework Manager]IBM Cognos Business Intelligence ñ���uπ��

    s�vA�αd�d�¼Cziα��n]wdΩ�wMsuC

    GO ��x

    uGO Ω�xv�¼ great_outdoors_data_warehouse.cpf O�Ω�w

    GOSALESDWCª]tHOΩ�B½⌡μPH�]���÷Ω�Ao�Ω�����

    úP�����ñCbuΩ�wv°�ñAT�����w����O�W�í

    ñCuΩ�wv°�]t�≤@�ΩT���W�í]GO Ω��C

    uΩ�wv°�P≥ªΩ�w��cD�ⁿC��ϕμ]Ω�wd�DD�í��

    ≤Co�i² IBM Cognos BI bjí�ípU��qM≤� Meta Ω�A�ú��

    � Meta Ω�∩Ω�wiμIsCbuΩ�wv°�ñwiμUC�≤MsWG

    v w°�nsW�XCv �F�\búP�δ�h�iμE�Aw��Y��¼d�DDCpA��\u�ívPuPΓv�uPΓ�vºí�÷YC

    v �F�\b��ϕM��ñ�C�h�ºí��μ@�XAw�s��ϕCpA��\uú�v��ϕC

    u��v°�u]t�¼d�DDA�S�⌠≤�XCbu��v°�ñwiμUC

    �≤MsWG

    v �¼d�DDñwsWpΓCpA�í��]tyÑpΓCv w∩π�h�Ñh�Ω�wAw��s��H��C�ÑhCpA�uÑh���¿����Apgz���C

    GO PΓμ÷Ω�w

    uGO PΓv�¼ great_outdoors_sales.cpf O� GOSALES Ω�wAΣ�c�μ

    ÷Ω�wCªDn]tPΓΩ�C

    uΩ�wv°�P≥ªΩ�w�cD�ⁿCbuΩ�wv°�ñwiμUC�≤M

    sWG

    v �Fα≈N�ϕP�í���XAw���¼d�DDMh�≤�XCv w°�nsWΣL�XC

    u��v°�u]t�¼d�DDA�S�⌠≤�XCbu��v°�ñwiμUC

    �≤MsWG

    v �¼d�DDñwsWpΓCv wNuΩ�wv°�ñ����í��W��X�����¼d�DDA@�����iμ��C

    v w∩π�h�Ñh�Ω�wAw��s��H��C�ÑhCv uPΓH�vOwC�≤�u�uv���l�CbuGO PΓvñS��@�u�uv�ΣA]Lo�u��{μO²C�¼ú����{Ω�C

    � 2 � �� Metric Studio iμ�α�z 15

  • d� PowerCube

    UC Cube HσBkσBwσBΘσMñσ��H≤ Sample Outdoors dñG

    v sales_and_marketing.mdcv employee_expenses.mdcv go_accessories.mdcv go_americas.mdcv go_asia_pacific.mdcv great_outdoors_sales_en.mdcv great_outdoors_7.mdc

    d�M≤

    Sample Outdoors d]A��M≤CNú�C@�i�M≤��ní�C

    uGo Ω�x]�R�vO GOSALESDW Ω�w�����°�CM≤i�≤�

    � Studio]]A IBM Cognos Analysis Studio�C��M≤AziHiμVWvh�

    RMVUvh�RC

    uGo PΓ]�R�vO GOSALES Ω�w�����°�CM≤i�≤�� Stu-

    dio]]A Analysis Studio�C��M≤AziHiμVWvh�RMVUvh�RC

    uGo Ω�x]d��vO GOSALESDW Ω�w�D��°�CM≤i�≤úF

    Analysis Studio º���� StudioA�Bbú�iμVWvh�RMVUvh�R�∩

    °iD��C

    uGo PΓ]d��vO GOSALES Ω�w�D��°�CM≤i�≤úF Analy-

    sis Studio º���� StudioA�Bbú�iμVWvh�RMVUvh�R�∩°i

    D��C

    u½⌡μPv(Cube) O� sales_and_marketing.mdc Cube � OLAP M≤C

    uGreat Outdoor PΓv(Cube) O� great_outdoors_sales_en.mdc Cube � OLAP

    M≤C

    �GOLAP M≤BuGreat Outdoor PΓ (Cube)vMu½⌡μP (Cube)vúOhyÑ�

    �C IBM_Cognos_PowerCube.zip Os�]tC�M≤�¡���F�O�σBkσB

    wσBΘσMñσC

    16 IBM Cognos Metric Studio 10.2.2 �G ��ΓU

  • � 3 � W�p�d⌠�

    YnTO��ñ�AϕH���°Aϕ�pqΩ�A�n∩p�d⌠�iμJ�W

    C

    W]AMwUC�G

    v n�°��pqΩ�v n���≥p�d�cv n���≥ IBM Cognos Metric Studio ��{ív n���≥Ω���v p≤ⁿJΩ�

    pq�

    L�ON{���pqΩ��α� Metric StudioA�O��s�MpqΩ�½s}�

    ��AUC�Dúα≤Uz�On�°�pqΩ�G

    v ªñ��≤Hv �O�¬�Hv ��l���pqΩ��αP�o��O�wΩ{Hv znPΣ±�o�pqΩ����M≥�u�≤Hv znp≤�n≤siμñ�q�ΩTHv zO�nNh�pqΩ�J��μ@E��qñH

    p�d

    ziH�� Metric Studio NpqΩ����p�dñAo����KiHbμ@�⌡

    W∩�ΣpqΩ��d��αh�C]����úPí��M��pqΩ�iαú

    PA�HziHNpqΩ����úP¬��úPp�dñA�����i�M��

    �z�c�ÑhñCpAziH�@��≤¬h��q��p�dB@��≤�

    �ñU�\αμ��p�dAH�t@��≤U���μ��p�dCziα�QN

    �÷�pqΩ���AHπ�ª�Op≤�vTC

    UC�DNi≤UzWp�dG

    v ��¬���d���pqΩ�Hv ��pqΩ�O�÷�Hv C�¬��nh���H

    ∩�Ω���

    Mwn�q�pqΩ�ºßAz��ⁿwNΣ�o�pqΩ��Ω���C

    qA���NΩTxsbU�÷píΩ�wBOLAP ����ΓϕñCz���O

    o���AH≤UzP�p≤NΩTⁿJ� IBM Cognos Metric Studio ñC

    © Copyright IBM Corp. 2002, 2014 17

  • pGz�����ú��Ω�AhiHNΩT��ΘJ Metric Studio ñCQ����

    ����Ω�wH¼�Ω�AMß���J{�NΩ��� Metric Store ñCpG�

    í��ñS�ΩTA��u�@�XGú≤s��Ah������CpG

    ΩTg≤sAh��n��@�Ω�w�¼����ú��Ω�A²Oz���

    ⌠PΩ�w��M�@�÷p�}o¿�C

    z���qz∩Ω�π��s�v�¼AH�Ω��≤�WvCpApGzLv

    s� OLAP Cube ���Ω�wAhiα�n�� Cube @�Ω���Cbzn≤

    spqΩ��A²≤Ω�w�LúL�Lks��ACube P���C

    Wp�d�c�A�Mw@�Ω���O�iHNϕ�cCpGS�Aϕ�Ω��

    �AziHΓ����cC∩≤p�dÑhACube iHO@�n���C

    z]��Mw⌡μpqΩ�pΓ��mGb Metric StudioBIBM Cognos Metric

    DesignerBCube � IBM Cognos Framework Manager �¼ñCpGiα��A�nb

    Cube � Framework Manager �¼ñ⌡μpΓA]�o�pΓHßi�≤ΣL≤C�

    G���∩�Ob Metric Designer ñ⌡μpΓCpGS��� Metric DesignerA��

    Metric Studio O≤�@Psb��@�mAhziHb Metric Studio ñ⌡μpΓC

    ∩�NΩ�ⁿJ� Metric Studio �ΦíúF�Oz�Ω���º�A���Mw�Ω��NΣⁿJ� Metric Store ��n�

    ��ΦkCP��ⁿJ�mϕ�ΦkL÷AziH�� Metric Studio NΩ�MpqΩ

    ��� Metric StoreC

    Metric Designer

    IBM Cognos Metric Designer O@���∩MM�eΩT���{íAiHNΩTq÷

    píΩ���M��Ω���]p Framework Manager M≤BIBM Cognos Impromptu®

    d�wq��M Cube�∩MM�e��mϕñⁿJ��C

    ⁿJjqΩ�MpqΩ��¼�A��w�� IBM Cognos Performance Applications

    �A��z�� Metric DesignerCp��÷ΩTA��\mIBM Cognos Metric Designer

    ��ΓUnC

    Metric Studio MH���j���

    Metric Studio qH���j����JΩ�C∩≤ⁿJeOdb�Γϕ�Ω�wñ�

    Ω�Ao���CYn�JΩ�A�NΣq�Γϕ�Ω�wñxs�X Metric Stu-

    dio �D�H���j����AMßNo�H���j����J��mϕñC

    ��Bα½MⁿJ (ETL) uπ

    pGzw�� ETL uπAhiH��ª��J Metric Studio �mϕC

    Γ�ΘJ

    pGzu��qΩ�nΘJA��ΣL��ñúsbΩ�AhiHΓ�ΘJpqΩ

    �C

    18 IBM Cognos Metric Studio 10.2.2 �G ��ΓU

  • tmM�qu@y{

    w� IBM Cognos Metric Studio ºßA�ϕ�{��tmM�qp�d⌠�C

    v Wp�d⌠�Cv �� Metric Studio ��{íCv NΩ�ⁿJ��mϕCv NΩ�q�mϕñⁿJ� Metric Store �½spΓΩ�Cv wqp�d�cCv ⁿw\iv�]ww�h�Cv �@�[jz�p�dC

    ���iHd��v��M�td�pqΩ�AH�∩Σπ�¬�BgJ��z�\

    iv�ΣL�÷pqΩ�C

    � 3 � Wp�d⌠� 19

  • 20 IBM Cognos Metric Studio 10.2.2 �G ��ΓU

  • � 4 � �� Metric Studio ��{í

    IBM Cognos Metric Studio ��{íO@�p�dBpqΩ�MM�A���°SwΦ

    �����αCziH���v��h�����{íC

    ��{íq¬�iμwqA²���u�BzPL��÷�pqΩ�CpAz

    iH���ßΣ���{íA�Hl�C�q��Bz�íH��Bzq���C

    ziH��ws��{íA��l�½sifvM°ovCz]iH��t�≤\α

    pqΩ����{íA����ú��αΓ��πΘ°�C

    Yn����{íA�⌡μUC�@G

    v �� Metric StoreCv ��pqΩ�M≤C

    oiα]A��Ω���suM�l]w Metric StoreC

    �� Metric StoreMetric Store ]tp�dMpq�CMetric Store ]]t IBM Cognos Metric Studio

    ]w]p����n]w�CMetric Studio ��� Metric Store �xsB��M

    �ΩTC

    pG�sbAhz��²�� OracleBMicrosoft SQL Server � DB2® ���≤ Met-

    ric Store �Ω�wC

    p��� Metric Store ��÷ΩTA��\mIBM Cognos BI w�PtmΓUnC

    pqΩ�M≤

    pqΩ�M≤ObJf⌠� (IBM Cognos Connection) ñ�¿i�� IBM Cognos Met-

    ric Studio ��{í�e{CpqΩ�M≤]t��{í�suΩTB°iMpqΩ�

    �z@�C

    C�pqΩ�M≤��π��@W�C

    pqΩ�M≤�exsb Metric Store ñC@���pqΩ�M≤�@í�AziH�

    l]ws� Metric StoreA]iH��{�� Metric StoreCpGz�l]ws� Met-

    ric StoreAh]nⁿw��μ�Σ]wC

    pG��{�� Metric StoreA�B Metric Store OP�� Metric Studio ft��A

    ht�iα�ú�z∩ Metric Store iμ��C

    ��μ�Σ

    �l]w Metric Store ]Aú�ΩT]p�p�íH��p���}lM�⌠Θ��

    H��z���μ�ΣC

    © Copyright IBM Corp. 2002, 2014 21

  • zwq���h�NvTpqΩ��{Mμ�xsBKnH��[Cw]A��μ

    �Σ}l≤{μ�≈��@�A�≥�{μ�q[WN�� 12 ��qCpGb�JΩ

    �ß�≤F�p�íAh��RúΩ�AMßA½s�JC

    �l]w Metric Store �AziH∩�����μ�ΣBsyμ�ΣA�O�qμ�

    ΣC

    ��μ�Σ

    pG�����δMg��°�αA�����μ�ΣCμ�ΣiH]AΣLh�

    ]pu�MΘ�A²XG@�]Ag�δC

    �p��W�

    μ�Σ�}lΘ��vT�p���W�Cw]ApG�pμ�Σ��@�δúO 1

    δAh�p���W�N�U@�CpApGμ�Σ}l≤ 2006 �TδAh�p�

    �� 2007 �C

    ziHb�l]w Metric Store �∩��≤w]�CiH∩�N�p��RW�Σ}l

    ��≈C]iH∩����p��}l�μ�Σ�P�p���⌠�μ�Σ���

    XAp 2006/2007C

    g

    iHb��μ�Σñ]AgCPsyμ�ΣúPAo�giH}l≤@�δ≈Bu�

    ��≈A��⌠≤t@�δ≈Bu���≈C�iHvT IBM Cognos Metric Stu-

    dio ⁿJMNϕΩ��ΦíCLkzL�n≤sCg�p�pΓ≤¬h��q��pC

    ]ApGgbμ�ΣñB≤�Ch�Ah��NpqΩ��Ω�ⁿJh�]�gº

    ���Cz@�iHbgh�WⁿJΩ�A�L��{]wC

    C@gú�≤Y�δAHK���iH⌡�μ�Σñ�SwgC]wu�≤�²

    �A�út�iμqg�δ�⌠≤�n≤sC

    ��M≤�AiHNg]��≤UCδ≈G

    v g}l�δ≈v g�⌠�δ≈v g�jí������δ≈

    ]w�iH�ε@�ñ�g�C

    ϕμ�Σ]Ag�Az]iH∩�g�}lΘC

    �n≤s

    pGμ�Σ]AgA�FpΓ¬h���n≤sA��bUCΣñ@�h�WⁿJΩ

    �A]�gú�≤V≤¬h���qG

    v Θ

    b]AΘ�μ�ΣñAiHbCΘh�WⁿJΩ�AHK Metric Studio iHpΓgB

    δBu�M���n≤sC

    v gMδ]�bz�μ�Σñ��Ch��ΣL⌠≤h�Apu��

    22 IBM Cognos Metric Studio 10.2.2 �G ��ΓU

  • b�Ch��g�μ�ΣñA��b�¬h�]pδ�WⁿJΩ�AHK Metric

    Studio iHpΓu�M���n≤sC

    syμ�Σ

    pG��ú≤V�q�u��syg��°�αA�∩�syμ�ΣC

    g¼�

    pGz�syμ�Σ]Au�AhC�u�ú]tQTgC��ⁿwp≤b@�u�

    ñNo�g�t�U�δ≈ñCpApG∩� 4-5-4Ah�Ngtmu���@�δAN¡gtmu���G�δA�Ngtmu���T�δC

    ]�syμ�Σuα]tπgA�Hz���μ�ΣC�iαúe@��Γ�}lA

    �ßbπ��≈�ⁿ½C�F�εμ�ΣC�úúeAMetric Studio iα�nb�u

    ���T�δB�sW@gCpApGz�syμ�Σ}l≤ 1 δ 1 ΘAhsWB

    �@giO�b 1 δ 1 Θeß�T��C�� 4-4-5 �t�syμ�ΣhO@��AziHbμ�Σñ∩�NB�@gsW��G���T�syδC

    �qμ�Σ

    pG��μ�ΣMsyμ�Σúú]tz�n�μ�Σh�AhiH��@��qμ

    �ΣCN�p����Γ� 6 �δ��q�μ�ΣKO@�dC

    �qμ�Σ�n�J�q� (.cal)B�J�íh�� (.lvl) M�íyÑσr� (.tlt)Ao

    ����≤ installation_location/deployment/cmm ²ñCp�o�����÷ΩTA�

    �\� 149��² B, yH���j���zC

    p������qμ�Σ��μ�÷ΩTA��\� 44��ysW�J��B���

    qμ�ΣH�]ww�\ivzC

    pGn�����q�q}lΘ�M�⌠Θ�� IBM Cognos Metrics Manager 2.2 μ

    �ΣAh��b IBM Cognos BI ñ��@���μ�ΣAH¿qK��Mz��qμ

    �ΣCMßA���X��μ�Σ��∩�J�q� (.cal)B�J�íh�� (.lvl) M

    �íyÑσr� (.tlt)AHKμ�ΣP Metrics Manager 2.2 μ�Σ�C

    �� - ���qμ�Σ���@�}oAϕμí�H���j�������qμ�Σiα�°CLk���t�g

    ≤≤¬h��q��qμ�ΣCu�zLupqΩ�M≤vμ�ΣδFA�Σ�≤�

    q�gC

    �∩{���J�q� (.cal)B�J�íh�� (.lvl) M�íyÑσr� (.tlt) n±�μ

    ��o���e÷CYnq{���ñ���qμ�ΣA�⌡μUC�@G

    {�

    1. ��t���μ�Σ�M≤C

    2. �� IBM Cognos Connection ��X��μ�Σ��w��μ�Σ��X@�C

    p��XBz{���÷ΩTA��\mIBM Cognos �zPw�ΓUnC

    3. �∩w�X��J�q� (.cal)B�J�íh�� (.lvl) M�íyÑσr� (.tlt)AH

    �M�qμ�Σ��cC

    � 4 � �� Metric Studio ��{í 23

  • p�o�����÷ΩTA��\� 149��² B, yH���j���zCp�

    �����qμ�Σ��μ�÷ΩTA��\� 44��ysW�J��B���

    qμ�ΣH�]ww�\ivzC

    4. N�∩ß����� installation_location/deployment/cmm ²ñC

    5. ��M≤��� installation_location/deployment/cmm ²ñ�∩ß�����l]

    w Metric StoreAMß����μ�ΣC

    �� - �d�qμ�Σ��c���qμ�Σiα�°C��zb��t��qμ�Σ�M≤ºßA�dμ�

    Σ��cO�pw�@δC

    {�

    1. �°��μ�Σ]wA����q∩���τ�μ�Σ�cC

    2. pGμ�Σ�pw�@δA�⌡μUC�@G

    v �∩�J�q� (.cal)B�J�íh�� (.lvl) M�íyÑσr� (.tlt)A�No���A�xsb installation_location/deployment/cmm ²ñC

    v ��pqΩ��@ñ�MúpqΩ��{Mμ�ΣΩ�∩��Múμ�ΣΩTC

    ⌡μMúpqΩ��{Mμ�ΣΩ�@�A�q Metric Store ñRú���eC

    p��÷ΩTA��\mIBM Cognos �zPw�ΓUnC

    v zL÷@U Metric Studio ����½�μ�ΣC

    ]�wRúM≤�μ�ΣΩTA�HNπ���μ�ΣδFC�¿��μ�Σ

    δFC

    3. ½�@�A��μ�Σpw�@δC

    ��pqΩ�M≤

    ��pqΩ�M≤iH��T�ÑqCC�Ñqú���úP�δFC

    b�@ÑqñA�M≤RW�[Hí�Cb�GÑqñA∩����Ω���suC

    pGn�l]w Metric StoreA�b�TÑqñⁿw��μ�Σ]wC

    }lºe

    pGn�l]w Metric StoreAh��ⁿwUC��μ�Σ]wG

    v ��μ�Σ��¼Cv �p�íh��Cv �¡�p�í�}lΘ�C

    ��V∩�}lΘ�CpGn��z�μ�ΣH]A�¡��qAh���Xμ

    �ΣAMßNΣ@�sμ�Σ�JC

    v n]A��p�í�C

    pG�l]w Metric Store ���Θμ�Σh�A�TOw]wpqΩ��¼�eñ�

    ��ⁿJMΘJΩ����μ�Σh�]wAHP .cmv ���tCñwq��íh�

    ]2.2 �ñ� time_period_cd��C

    24 IBM Cognos Metric Studio 10.2.2 �G ��ΓU

  • p���μ�Σ��÷ΩTA��\� 94��y�≤ Metric Store ��íd≥zC

    {�

    1. b¬íμñA÷U�ΣC

    2. ÷@U��s�pqΩ�M≤C

    3. ϕ�s�M≤δFñ�ⁿ�C

    4. ∩�{��Ω���A�÷@Us�Ω����ϕ�s�Ω���δFñ�ⁿ�C

    p���Ω�����÷ΩTA��\mIBM Cognos BI �zPw�ΓUnC

    5. pGzn�l]ws� Metric StoreA�ϕ��l]w Metric Store δFñ�BJC

    �°��μ�Σ]w

    ziHd�M≤���μ�Σ]wCo∩≤τ��q��μ�ΣO�pw�δtm�

    íD��C

    p�sW��ú�q��÷ΩTA��\� 94��y�≤ Metric Store ��íd≥zC

    {�

    1. buπMμñA÷@U��μ�ΣC

    2. ÷@U�c��C

    ��pΓ

    b IBM Cognos Metric Studio ñApqΩ��¼AOΣ���MwC��O@��

    �ϕ�kA��P�pqΩ�OF�B¬≤��OC≤�AH�¬≤��C≤

    ��{�C

    pqΩ�¬≤��OC≤��pqΩ�]w�e��MwCpqΩ��w]

    e��¬≤��C≤� 10%C

    iHN��@�pqΩ���BΩ�Me���s�]wiμpΓC�hA]iH

    ���M���wq�μ�wq�{���pΓ��C

    e�¼��

    ��zún�≤e�¼��pΓ�w]�C²O�n��AiH�≤o�]wC

    ��GF���MC�e����]w]A�≤{��¼��C

    �� í�

    F� pqΩ�F��nⁿú���C

    w]�G0

    w]e� i�ⁿ��≈���±W¡C

    w]�G10%

    � 4 � �� Metric Studio ��{í 25

  • �� í�

    C�e���� Ω���≈�@�e������≤C

    w]�G1

    dGpG� = 100%B� = 120% �e

    � = 10%AhC�e����� 2]�]w]

    �� 1�C

    �C�� nⁿú��C��C

    w]�G-10

    �¬�� nⁿú��¬��C

    w]�G+10

    ��p��� p���n���p���C

    w]�G5

    F������d≥ (%) @�e���±�F�d≥�e�C

    w]�G50%

    dGpG��� 7Ahwq�uF����

    ��d≥v� 6.65 � 7.35C

    F��������� (%) �≈¬≤�e����±C

    w]�G100%

    dG��� 120% @�uF����v��

    WֱApG��� 7Ahwq�uF��

    ����d≥vN�� 6.65 � 7.42C

    F������d≥

    pGY�pqΩ�b¿≤Y��d≥]�úOμ@����F�AhiHNF��d

    ≥]�e�����±C�d≥b�I�Γ�Uπ��@°±ΓaCd≥w]�

    �e�� 50%C

    pGF���d≥V��WΦ�≈AhiH�F�d≥ⁿw@����CuF��

    �������vwⁿw�uF������d≥v���±C

    ��]w í�

    F������d≥ (%) @�e���±�F�d≥�e�C

    w]�G50%

    dGpGe�� 10% BuF������d

    ≥v� 60%Ah�Γ��±Γd≥í� 6%

    (10% x 60%)C

    26 IBM Cognos Metric Studio 10.2.2 �G ��ΓU

  • ��]w í�

    F��������� (%) �≈¬≤�d≥���±C

    w]�G100%

    dGpGe�� 10%AuF������d

    ≥v� 50%]w]��BuF�����v�

    WΦ±� 120%Ah�WΦ�±Γd≥�

    6% (10% x 50% x 120%)A�UΦ�±Γd

    ≥� 5% (10% x 50%)C

    d� - ��F������Wֱ�]w

    d�dFΓ�ΦkAboΓ�ΦkñAziH��uF���������v]

    wAN�NO�ñbpqΩ�π�e�ñ����mWC

    boΓ�ípUAe�í]� 10%]w]��Cb�@�ípUA¬≤��F�d≥

    �]WΦ±]� 40%�Cb�G�ípUA¬≤��d≥�e]WΦ±]�

    120%�C�OϕAboΓ�ípUAbw∩WΦ±]wiμ�πºeAuF���

    ���d≥v]� 50%]w]��A�N�d≥wq�b�WU¡í�C

    d≥�±Γí�ⁿXF����CΓí�ⁿX¿≤wwqe�����C

    d≥

    uF�����v�Wֱ�

    � 40%uF�����v�Wֱ�

    � 120%

    ¬≤��Γ]�≤wwq

    �e���

    4% (10% x 40%) 12% (10% x 120%)

    ¬≤��±Γ]F�� 2% (10% x 50% x 40%) 6% (10% x 50% x 120%)

    C≤��±Γ]F�� 5% (10% x 50%) 5% (10% x 50%)

    C≤��Γ]�≤wwq

    �e���

    10% (10%) 10% (10%)

    {��¼��

    ��{��pΓ���i²zNΩ�d≥∩M�¼Aⁿ��C�Nπ�e�ⁿú�

    ��wq�íjC��{��pΓ������Pw]��pΓΦk�P�±A�

    ú��P�¼Aⁿ��¼�C

    Metric Studio ú��≤¬�{���τ���AHTOª�π�≤¬��CpA

    Metric Studio ú�TO�j{��¬≤�p{��C≤�¬¼A@�π��¬�u²

    ��A]pGΩ��X±Γ¼A�°≤Ahª�O�XΓ¼A�°≤KL÷

    ≥nC

    ���wq��μ��i@�h�¼A�{����A²Oo�ú�π��C¼

    ACoi²z��π�¼Al��pqΩ�C

    {��¼��ú��{�CM�¬��]wC

    � 4 � �� Metric Studio ��{í 27

  • ��Gu�b�±��qñΩ��¿≤{��wq�úPd≥��]τYAu�b

    pqΩ�¼Aw�≤CΓ��ApqΩ����¼��]��{��¼������

    M�≤C

    �≤e�¼��pΓ

    ziH�≤]wA���≤δT�²z�oSwd≥�����C

    pGz�≤s���]wAh��b IBM Cognos Connection ñ��½spΓ MetricStore l��@��½spΓpqΩ��Cp��÷ΩTA��\mIBM Cognos BI �zPw�ΓUnC

    {�

    1. buπMμñA÷@U�JMΩ�pΓ]wC

    2. ÷@U��]w��C

    3. °�n�≤]wC

    28 IBM Cognos Metric Studio 10.2.2 �G ��ΓU

  • � 5 � �J��XΩ�

    ziHNΩ��J� Metric Store �q Metric Store �XΩ�AH�J��αpqΩ

    ���{íC

    �JΩ��AΩ��²���xsb�mϕñCziHq IBM Cognos Connection ⌡μ

    úP�{���JΩ�Cp� IBM Cognos Connection ñ�J{���÷ΩTA��\

    mIBM Cognos �zPw�ΓUnC

    iH�XΩ�Hb⌠�ºí��Ω�CpAziHNΩ�q}o⌠����í@�

    ⌠�A��q@�Ω�w¡x��t@�¡xCNΩ��X�H���j���º

    ßAiHNo���ⁿJ� IBM Cognos Metric Studio �P@�Ω�ΣLΩC

    ziHq IBM Cognos Connection ⌡μ�X{�Cp� IBM Cognos Connection ñ�

    X{���÷ΩTA��\mIBM Cognos�zPw�ΓUnC

    pGn�� Metric Studio �{���Bα½MⁿJ (ETL) uπ�JΩ�A�²�\

    � 41��� 6 �, y��Ω�Hiμ�mzAMßA�≥iμC

    ⁿw�J]w

    pqΩ�íp�mO{μ Metric Store ����J��²�Ω�¿��mC

    bμ@°A�⌠�ñA�≤w��Níp�m]�w]�Cb�JΩ��AzL�ⁿ

    wªCb�í⌠�ñ�JΩ��Az��qMμñ∩�íp�mC

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

    ]iH∩�pqΩ�M≤�����J��Cz��²wq�J��A�αiμ∩

    �C

    {�

    1. buπMμñA÷@U�J��C

    2. pGsb�≤íp�m��A�÷@U��AMß÷@U∩�ΣL�mA�qM

    μñ∩�íp�mC

    3. ÷@UTwC

    4. ∩�M≤��J��C

    v Yn]A�O�J��A�∩�W��μU��∩��∩Cv Yn]A���J��A�∩�W�Σ��∩Cv Yn�ú�O�J��A�∩�q�Jñ�ú�μU��∩Cv Yn�ú���J��A�∩�q�Jñ�úΣ��∩C

    wq�J��

    iHzLwq�J��]iHO÷píΩ�wA]iHOH���j����}lΩ

    �ⁿJ{�C�J��On�J� Metric Store �pqΩ���mC

    © Copyright IBM Corp. 2002, 2014 29

  • ÷píΩ�w

    \h��b÷píΩ�wñl�@��qCziHⁿw÷píΩ�w@��J��A

    Mß�� ETL uπNΩ���ⁿJ� IBM Cognos Metric Studio �mϕC

    pGⁿJ�≤ΣL�m]p÷píΩ�wBΩ�x� Cube��jqΩ�MpqΩ�

    �¼A��w�� IBM Cognos Performance ApplicationsAh��z�� IBM Cognos

    Metric DesignerCp��÷ΩTA��\mIBM Cognos Metric Designer ��ΓUnC

    H���j���

    pGeOb�Γϕñ�@Ω�AhiH��H���j����ⁿJ�mϕC

    �H���j���wqΩ����AznⁿwH���j����b��mH�o

    ��������μíC

    ��z��� Metric Studio 2.2 ��ß≥�������μíC

    iH�� Metric Studio ����N�qΩ�Γ�ΘJ� Metric Store ñC

    Metric Studio r�sXP SQL Server �∩Ñ÷YpUG

    Metric Studio SQL Server

    F� (Microsoft Windows 1250) Albanian_BIN

    ��σ (Windows 1251) Cyrillic_General_BIN

    ΦΦ (Windows 1252) Latin1_General_BIN

    �σ (Windows 1253) Greek_BIN

    g�Σσ (Windows 1254) Turkish_BIN

    B�σ (Windows 1255) Hebrew_BIN

    i�ⁿσ (Windows 1257) Latvian_BIN

    Vnσ (Windows 1258) Vietnamese_BIN

    �σ (MS949) Korean_BIN

    Θσ (Shift-JIS) Japanese_BIN

    ñσ]�Θ� Chinese_PRC_BI

    ñσ]cΘ� Chinese_Taiwan_Stroke_BIN

    ⌡σ THAI_BIN

    UTF16 SQL Server S� UTF16 �∩�W�C�Ob

    bcp ñ�� -w ∩�Σ� UTF16C

    ��G�J�A��� UTF16 w����

    ���OC

    Metric Studio r�sXP Oracle �∩Ñ÷YpUG

    Metric Studio Oracle

    F� (Windows 1250) EE8MSWIN1250

    ��σ (Windows 1251) CL8MSWIN1251

    ΦΦ (Windows 1252) WE8MSWIN1252

    30 IBM Cognos Metric Studio 10.2.2 �G ��ΓU

  • Metric Studio Oracle

    �σ (Windows 1253) EL8MSWIN1253

    g�Σσ (Windows 1254) TR8MSWIN1254

    B�σ (Windows 1255) IW8MSWIN1255

    i�ⁿσ (Windows 1257) BLT8MSWIN1257

    Vnσ (Windows 1258) VN8MSWIN1258

    ΦΦ (ISO) WE8ISO8859P1

    ñ� (ISO) EE8ISO8859P2

    ��σ (ISO) CL8ISO8859P5

    �σ (ISO) EL8ISO8859P7

    B�σ (ISO) IW8ISO8859P8

    g�Σσ (ISO) WE8ISO8859P9

    i�ⁿσ (ISO) BLT8ISO8859P13

    ΦΦ]�w� ISO� WE8ISO8859P15

    �σ (MS949) KO16MSWIN949

    Θσ (Shift-JIS) JA16SJIS

    ñσ]�Θ� ZHS16GBK

    ñσ]cΘ� ZHT16MSWIN950

    ⌡σ TH8TISASCII

    UTF8 UTF8

    UTF16 AL16UTF16

    ��G�J�A��� UTF16 w����

    ���OC

    Metric Studio r�sXP DB2 �∩Ñ÷YpUG

    Metric Studio DB2

    F� (Windows 1250) 1250

    ��σ (Windows 1251) 1251

    ΦΦ (Windows 1252) 1252

    �σ (Windows 1253) 1253

    g�Σσ (Windows 1254) 1254

    B�σ (Windows 1255) 1255

    i�ⁿσ (Windows 1257) 1257

    Vnσ (Windows 1258) 258

    ΦΦ (ISO) 819

    ñ� (ISO) 912

    ��σ (ISO) 915

    �σ (ISO) 813

    B�σ (ISO) 916

    g�Σσ (ISO) 920

    � 5 � �J��X� 31

  • Metric Studio DB2

    i�ⁿσ (ISO) 921

    ΦΦ]�w� ISO� 923

    �σ (MS949) 1363

    Θσ (Shift-JIS) 943

    ñσ]�Θ� 1386

    ñσ]cΘ� 950

    DB2 uΣ� IBM-950]P MS-950 úP�C

    ⌡σ 874

    UFT8 1208

    �� Metric Designer �ΣL ETL uπziH�� Metric Designer �ΣL ETL uπ�]w�J��C

    {�

    1. buπMμñA÷@U�J��C

    2. ÷@Us�C

    3. ÷@UY�yÑC

    4. bW�ΦñAΣJΩ����z�W�C

    5. ÷@U Metric Store �mϕC

    6. �n��Ab�OXΦñAΣJ�J���NXC

    pGNΦOd��Ah Metric Studio ���ú��OXC

    ��H���j���

    pGeOb�Γϕñ�@Ω�AhiH��H���j����ⁿJ�mϕC

    {�

    1. buπMμñA÷@U�J��C

    2. ÷@Us�C

    3. ÷@UY�yÑC

    4. bW�ΦñAΣJΩ����z�W�C

    5. ÷@UpqΩ��J�²C

    6. �n��Ab�OXΦñAΣJ�J���NXC

    pGNΦOd��Ah Metric Studio ���ú��OXC

    7. zL÷@UpqΩ�íp�mW�Σ�÷sA�ⁿwH���j�����

    mC

    p�ⁿwpqΩ�íp�m��÷ΩTA��\� 29��yⁿw�J]wzC

    8. �n��A�÷@U]Al�²C

    9. b��μíΦñA÷@UPH���j����e� Metric Studio ��C

    32 IBM Cognos Metric Studio 10.2.2 �G ��ΓU

  • 10. ÷@Un���r�W�A��bΣLΦñΣJΣW�C

    11. ÷@Un@�p�I���rA��bΣLΦñΣJrC

    ∩�ui�≤ Oracle M DB2 Ω�wC

    NΩ�ⁿJ� SQL Server �ú¬w�ziHzL}� UDA ⁿJA� UNIX @�t�W�Ω�wKXM��¡xW���

    ��AsW@�B��O@hC

    b UNIX WAUDA ⁿJ≤w�A]�Ω�wKXú�π�b{�MμñCb��¡x

    WAUDA ⁿJP�≤[w�A]��s�ú���xsΩ�Cϕ½spΓjqΩ��A

    UDA ⁿJiα��C�αC

    {�

    b installation_location\bin ²ñsΦ mmloader_sql.xml ��ApU��G

    Y

    ⁿwⁿJMΩ�pΓ∩�

    iHⁿws�J�Ω�p≤vT{�Ω�C

    úG÷@UuπMμU��JMΩ�pΓ]wAHs�o�∩�C

    ziH∩�UC�@G

    v ½sⁿJ²eD��²w���Ω�v Nw�mΩ���qNXq Period α½� Month � Weekv ⁿwn���O≤sU�½≤

    ziH∩�UC�@G

    v zL±�pqΩ����±��º���±��pΓ��v zLNΩ�Pe@��q�e@��P@�qiμ±��pΓ��

    pGz�≤���pΓΦí���]wAh��b IBM Cognos Connection ñ��½s

    pΓ Metric Store l��@��½spΓpqΩ��Cp��÷ΩTA��\mIBMCognos �zPw�ΓUnC

    ziHⁿwn��P����]wCp��÷ΩTA��\� 25��y��pΓzC

    ½���{í

    ���T{�ⁿJΩ�A�½sⁿJz²e�X� IBM Cognos Metric Studio ��{

    íC

    {�

    1. pG��H���j���A�P�C�½≤����μC

    2. ⁿw�J��]iHOH���j���A]iHO÷píΩ�w�C

    � 5 � �J��X� 33

  • 3. ∩Ω�iμ�mAMßⁿJΩ�A��Γ�ΘJΩ�C

    4. ��O�dW�pq�C

    5. qΣLpqΩ�ñ��pqΩ�C

    6. ��°iH�°wwq�pqΩ�C

    NΩ�ⁿJ��mϕ

    b IBM Cognos Metric Studio ñA�²NΩ���xs��m�AMßANª�e�

    Metric StoreC

    ziH�� IBM Cognos Metric DesignerBIBM Cognos Connection �{���Bα

    ½MⁿJ (ETL) uπANΩ�q�í��ⁿJ��m�CpGn�� ETL {��Γ�

    ��H���j���Ah��A��mϕ��cC

    �� Metric Designer iHⁿJ�≤ΣL�m]p÷píΩ�w�Ω�x��jq

    Ω�MpqΩ��¼C

    pGeOb�Γϕ�Ω�wñ�@Ω�Ah�� IBM Cognos Connection zLH��

    �j����ⁿJΩ�C

    pGw�� ETL uπAhiH��ⁿJ�mϕA]iHzL��H���j����

    ⁿJ�mϕC

    �iHQ�����NΩT��ΘJ Metric Studio ñCpApG�í��ñS�

    ΩTA��u�@�XGú≤s��AhziHo��C

    ��Uϕ�Mw����ΦkG

    ¼p Ω�ⁿJ��

    O�d�cMpqΩ�íπ��πwq�Ω�

    ��C

    Metric DesignerC

    Ω�����ΓϕMΩ�wC Metric Studio MH���j���C

    w�� ETL uπq��ñ��ⁿJ���

    Metric StudioC

    ETL uπC

    z��X�ME���\húPΩ����Ω

    �C

    ETL uπC

    pqΩ�úsb≤ΣL�mC �� Metric Studio ����Γ�⌡μC

    z��uΘJ�qpqΩ�C �� Metric Studio ����Γ�⌡μ

    pGzN Metric Studio P DB2 Metric Store w�bP@íqúWAh�����⌡μ

    DB2 ����bß�P�m��¬�vC�hA�mϕNú��QⁿJC

    34 IBM Cognos Metric Studio 10.2.2 �G ��ΓU

  • Bz���Ω�

    ⁿJ{��í�Γ��íIiαo���C

    ���íI ��iμ�°���uπ

    NΩ�ⁿJ��m� ��b i n s t a l l a t i o n _ l o c a t i o n \ l o g s \

    MetricMaintenance\databasename-timestamp ñΣ

    ��Θx�C

    bΘx²ñAC�ⁿJΩ��ú���@

    �²C²W�Ω�wW�M�íWO�

    ¿C

    o���CXH���j���ñμíúAϕ

    ��Ap��μ�ñ�rΩ�íC

    NΩ�q�m�ⁿJ� Metric Store ��Ω�w°��MΣ��C

    Ω�w°��W����mϕW����A

    p STAGE_ERR_staging_table_nameC

    pGⁿJ{��ío���A�Nw���C±mb��ϕñH��\B��M½s

    ⁿJCϕμW���mϕW�[W rejectsC

    pAz��F@�W��uΦní¼Jv�spqΩ�A��ⁿwf⌠NXCo�

    F��CMetric Studio N��uΦní¼JvA²���Ω�Ao�Ω�Nα�

    kpi_value_stage_rejects ϕμñCziHNf⌠NXsW�����½sⁿJΩ�C

    C���ϕú]tUCiú���¼A�ΣL�μC

    �μ í�

    reject_created_dt o����Θ�M�íC

    severity_cd ���Y½�C

    pG Metric Studio o{��°≤Aª��εB

    zCCpGuo{@���P�i�°≤A

    hª�BzCA²�]wY�w]�CMet-

    ric Studio CCu�oX@��i���C

    error_cd ��XC

    C���ϕú∩M�@�í����°�C°�W�� STAGE_ERR_Aß≥�mϕW

    �Cp STAGE_ERR_METRIC_TYPEC

    ziHd�°�HP���]CYn����α�u��z�yÑd�TºA��

    �yÑX¡wd�CpAP�ⁿJ��o����]�A�ΣJG

    select * from stage_err_metric_typewhere text_language_cd = ’EN’

    � 5 � �J��X� 35

  • pGúbd�ñⁿwyÑXAh∩≤C���ú�ú���yÑ���í�AoNj

    T�C�αC

    �J²ew���Ω�

    ⁿJ�mϕ�Aiα���Y�Ω�CP���]����DºßAiH�J²e

    w����C

    ½sⁿJ Meta Ω�MΩ�ºßAú���Mú��ϕCC�X{���Aú�N��

    ��esW�o�ϕμñAHKziH���D�½sⁿJC

    {�

    1. ���P�D����DC

    pApGⁿJFpqΩ�A²OpqΩ��¼úsbAh���pqΩ��¼C

    2. buπMμñA÷@U�JMΩ�pΓ]wC

    3. b�J]w��WA∩�½sⁿJw���Ω��∩C

    4. ÷@UTwC

    5. b IBM Cognos Connection ñA≤z�¿�°��ºßMϕμC

    p��÷ΩTA��\mIBM Cognos �zPw�ΓUnC

    NΩ�q�mϕñⁿJ� Metric Storeb IBM Cognos Connection ñAⁿJ{��NΩ�Cq�m��� Metric StoreAMß

    ½spΓΩ�C

    ��A]iHzLⁿOμⁿJ Metric StoreCb Microsoft Windows @�t�⌠�ñ�

    �σ���b UNIX @�t�⌠�ñ�� Shell ScriptA�í��{íiH�w�o

    ⁿJ@�C

    ϕⁿJ�Ω�π�����A�����PⁿJΩ��H��≤�P�W�íñC

    oO]��d�≤Ω�ⁿJ����\iv�njMW�íAYnjMW�íA

    z��²iμnJCpG���úsb≤W�íñAh����mhϕB�m½

    ≤�ϕM�°Mμ�mϕñ�Ω�C�ⁿJΣLϕμ]p½≤�mϕBpqΩ�

    �¼�mϕM�mM�ϕ�ñ�Ω�A²O�mO²Nπ�b��ϕñ�t�Lk�

    R�����iCp�w��Ω���÷ΩTA��\� 35 ��yBz���Ω

    �zC

    p��� IBM Cognos Connection ⁿJΩ��ⁿ�A��\mIBM Cognos �zPw�

    ΓUnC

    q Metric Store �XΩ�ziαnq Metric Store �XΩ�HN��{íq}o⌠����í@�⌠�A��q

    @�Ω�w¡x��t@�¡xC

    N��{í�X�H���j���ºßANiHNo���ⁿJ� IBM Cognos Met-

    ric Studio ñC

    36 IBM Cognos Metric Studio 10.2.2 �G ��ΓU

  • pGzOzLH���j���M����ΘJ��{í��÷Ω�A]iHq Met-

    ric Store �X�HPBz���C

    Metric Studio iNΦ{í�X�Γ�σr�].equ M .eqi�CbNo���ⁿJ� Met-

    ric Studio ºeAzúα�∩Φ{íC

    iHN Metric Studio ��{í�X�Os�COs�OH���j���C

    ziH�� IBM Cognos Connection �X�A���w���X@�Cp��X{

    ���÷ΩTA��\mIBM Cognos �zPw�ΓUnC

    pG�X���ΘJ��Ah Metric Studio �N��¼�≤����w�m��¼C

    UC�úO�J/�X{��@í�Az��Γ�½�ª�G

    v s�]wApyÑBf⌠Mμ�Σ]wv ����n]wv iHπ��i��μv w]π��μv �ϕr¼]wv ½≤�w]\ivv ¼Aⁿ��v P Cube �÷�ΩT].ccq ��ñ��ú��

    �w�JM�X

    ziHzL�w�JM�X�w�≤sM�≈Ω�C

    b IBM Cognos Connection ñ��q��s�pqΩ��JδFMs�pqΩ��Xδ

    FA�wΩ��JM�XCp�δF��÷ΩTA��\mIBM Cognos�zPw�Γ

    UnC

    ��H���j���

    ��NΩ�ⁿJ��{í�H���j���AΣμíbúP� IBM Cognos Metric Stu-

    dio ��ºíiαúPCziH�� cmm_convert_file ⁿOμ��{í���{�H�

    ��j���A�ΣP{μ��� Metric Studio �eC

    zLkq IBM Cognos Metrics Manager 2.2 ºe�����H���j���C

    UC��iHzLNΣ[�ⁿOiμ]wG

    �� í�

    --input ⁿwΘJ��²��πW�

    --format ⁿwH���j���� Metric Studio ��

    �G2.2, 8.1.1, 8.1.2MR1, 8.1.2MR2, 8.2.1, 8.3.1,

    8.42

    � 5 � �J��X� 37

  • �� í�

    --output ⁿwΘX��²��πW�

    --prefix MwsW�ΘX�W��r�

    pG�ú���AhΘX�W��w]r�

    � new_

    w]�Gnew_

    --subdirectories {�l²

    w]�GNOT

    --createdirectories ��ΘX²]pG²�sb�

    w]�GNOT

    --help ú�i²zτ����Tº

    Microsoft Windows @�t�ziHb Microsoft Windows @�t�W]wH���j���C

    {�

    bROú�rñA�½� installation_location\bin ²A�ΣJUCⁿOG

    cmm_convert_file.cmd

    HUO@�α½��{íyk�dG

    cmm_convert_file --input C:\flat_file\v2.2 --format 2.2 --subdirectories --output C:\flat_file\

    v8.1.1 --prefix v811_ --createdirectories

    diH

    v ⁿwn������mv q Metrics Manager 2.2 ��H���j���v ]ABz���m��l²v ⁿw��ΘX���mv ⁿwnsW�ΘX��r�v ��ΘX²]pG²�sb�

    UNIX @�t�ziHb UNIX @�t�W]wH���j���C

    {�

    bROú�rñA�½� installation_location\bin ²A�ΣJUCⁿOG

    cmm_convert_file.sh

    HUO@�α½��{íyk�dG

    38 IBM Cognos Metric Studio 10.2.2 �G ��ΓU

  • cmm_convert_file.sh --input /flat_file/v8.1.1 --format 8.1.1 --subdirectories --output /flat_file/

    v8.1.2 --prefix v812_ --createdirectories

    diH

    v ⁿwn������mv q Metric Studio 8.1.1 ��H���j���v ]ABz���m��l²v ⁿw��ΘX���mv ⁿwnsW�ΘX��r�v ��ΘX²]pG²�sb�

    � 5 � �J��X� 39

  • 40 IBM Cognos Metric Studio 10.2.2 �G ��ΓU

  • � 6 � ��Ω�Hiμ�m

    bzNΩ�ⁿJ� IBM Cognos Metric Studio Metric Store ºeAΩ��²ⁿJ��

    mϕC

    pGeOb�Γϕ�Ω�wñ�@Ω�A���H���j����ⁿJ�mϕC

    pGw���Bα½MⁿJ (ETL) uπAhiH��ⁿJ�mϕC

    �� IBM Cognos Metric Designer ⁿJΩ�AH��{� IBM Cognos ��]]A IBM

    Cognos PowerCubeBIBM Cognos Impromptu d�wq�M IBM Cognos Framework Man-

    ager �¼��tBPawqMⁿJ Metric Studio ��{íCp� Metric Designer �

    �÷ΩTA��\mIBM Cognos Metric Designer ��ΓUnC

    �iHQ�����NΩT��ΘJ Metric Studio ñCpG�í��ñS�ΩTA

    ��u�@�XGú≤s��AhΦk��C

    pGn�� ETL {��Γ���H���j���Ah��A��mϕ��cCz�

    �²TOΩ�μí�TAMßANΩ�ⁿJ��mϕñC

    H���j���

    IBM Cognos Business Intelligence iHNΩ�qH���j����J��mϕC

    oϕ�ziH�Jeb�Γϕ�Ω�wñiμ�@�Ω�CYn�JΩ�A�NΣ

    q�Γϕ�Ω�wñxs�H���j����AMß�Jo�H���j���C

    z]iHNpqΩ���{í�X�H���j���CMßAziHϕ�����

    {í������P{��½s�Jo���C

    IBM Cognos BI �qúP�¼�H���j���]C���]túP�¼�Ω��ñ

    �JΩ�CIBM Cognos BI w∩H���j���ú�@�W�� installation_directory/

    deployment/cmm �w]Ω���CúLAziHNo���xsb IBM Cognos Met-

    ric Studio iHs�A�Bzwwq��J���⌠≤²ñC

    YnbH���j���ñíJ TabA�ΣJ \tCYnbH���j���ñíJsμA�ΣJ \r\nCYnbH���j���ñíJ��uA�ΣJ \\C

    pGz�� UNIX @�t�Ah��⌠�úα]tμC

    ��μí

    ��z��� IBM Cognos Metric Studio 8.1 �Mß≥�������μíC

    C�H���j���úiH��⌠≤zQn�W�RWCúLAzuα∩ Meta Ω�

    MΩ����� IBM Cognos BI iδ����WCC���Wi�O@�Sw�¼�

    ��CIBM Cognos BI ��o���W�P�����eBⁿJ�e���H�nbΣ

    ñⁿJ�e�ϕμC

    © Copyright IBM Corp. 2002, 2014 41

  • ½≤ⁿJ��

    H���j���O�¼s��Co����ⁿJ��A�B@���ñ�½≤

    iα�M≤ΣL��ñ�½≤C

    IBM Cognos BI HSw��ⁿJ½≤A�ú����≤≤BC]AzbW���

    q½≤�¼�úO��Cb����ºßAziHP�NΣⁿJC

    IBM Cognos BI HUC��ⁿJ½≤�¼G

    ½≤�¼ �m�

    ���wq��μ ½≤�m (.cmo)

    ¡w ID ½≤�m (.cmo)

    ��m (.cmv)

    �ϕ ID]¡í�MW�� ½≤�m (.cmo)

    �D ID]¡�ϕM�Dσr� ½≤�m (.cmo)

    ��m (.cmv)

    �J�� ½≤�m (.cmo)

    pqΩ��¼ pqΩ��¼�m (.cmm)

    p�d ½≤�m (.cmo)

    ��m (.cmv)

    pqΩ� ½≤�m (.cmo)

    ��m (.cmv)

    ªñ ½≤�m (.cmo)

    ªñ� ½≤�m (.cmo)

    °i ½≤�m (.cmo)

    M� �mM� (.pro)

    μ� �mμ� (.unt)

    ½≤�m� (.cmo) MpqΩ��¼�m�

    (.cmm) ñ�½≤ºí���AH�½≤�m�

    (.cmo) ñ�½≤ºí���

    ½≤���m (.cml)

    w�h �mh (.cms)

    �q�� �m�q�� (.cmp)

    42 IBM Cognos Metric Studio 10.2.2 �G ��ΓU

  • ½≤�¼ �m�

    �J��∩M �J�� Reportlet �m (.ccm)

    �J��f⌠�m (.ccm)

    �J���íh� (.ctl)

    �J���q� (.ctp)

    �� �m½≤� (.cmn)

    �ϕ½≤ �m�ϕ (.cdo)

    Φ{í Φ{í�m].equB.eqi�

    Cube d� Cube d��m (.ccq)

    �°Mμ �°Mμ�m (.cwl)

    � ��m (.cmv)

    ��H���j���≤sp�d⌠�

    Yn≤sz�p�d⌠�Az�����N�M≤zn≤s��eC

    pApGz²eⁿJFpqΩ��B�∩o�pqΩ�iμ�≤Ahu�ⁿJ .cmv �

    �Czú�n½�MⁿJ .cmm ��C

    pGznNpqΩ��°isW�p�dAh��w�p�d��F .cmo ��CM

    ßAzKiHNpqΩ��°isW� .cmo ��A��� .cml �����C

    ��NAz��NH���j���HGi��íW�� UNIX @�t�C

    ��½≤

    ziH��H���j���A���z�n�≤p�d��{í�½≤C

    z���C�½≤ú]A��iμwq��n�μCt�A�sbΣLiαP���

    ½≤�÷��μCz���do��μAHTOª�]tAϕ�ΩTCpAY�

    �μiαπ�z���≤�w]�C

    Y��μ��A]nTOC�H���j���í]t�T��μCp�H���

    j���ñ�μ��÷ΩTA��\� 149��² B, yH���j���zC

    z����q½≤ºí����÷YCpA��²���p�dAMß����

    ≤p�d�pqΩ�C

    p� IBM Cognos BI ⁿJ½≤�¼���H�½≤�¼p≤∩M��÷ΩTA��\

    � 42��y½≤ⁿJ��zC

    � 6 � ��Ω�Hiμ�m 43

  • ��½≤

    ziH��½≤AHNpqΩ��s�p�dWANpqΩ�sW�ªñ�A��

    N�ϕsW�pqΩ�C

    pGzⁿw@�yÑXA]�Hz� Metric Studio wq�ΣLC�yÑ�����C

    pAσ�w]�A�BzwqFkσMwσCpGzNu¼JvpqΩ����

    uQϕvpqΩ�Ah���kσBwσH�σ����C

    L�p≤Azú��²��zn���½≤AMßA����C

    ziH��½≤���m� (.cml) �������C

    q Cube �J���J�

    �J��f⌠ (.ccm)B�J�� $eportlet (.crm)B�J���íh� (.ctl) M�J��

    �q (.ctp) ÑH���j���A��NΩTq Cube �J��∩M� Metric StoreC

    qAbznNΩ�qY�⌠��XAMßA�J�t@�⌠�ñ�A�NΩTq Cube

    �J��∩M� Metric StoreC

    Rú½≤

    ziH��H���j���]�úO���