IBM Cognos Metric Studio 10.2public.dhe.ibm.com/software/data/cognos/documentation/... · 2014. 11....
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���