Cognos Analytics 12.0 新機能 Interactive Performance Assistant

# 概要
レポート&ダッシュボードの実行を解析する新機能 Interactive Performance Assistant (IPA)を紹介します。
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/d009ad79-760e-1660-7878-23bd348c1312.png)

# 参考情報
**Interactive Performance Assistant (IPA)**
https://www.ibm.com/docs/en/cognos-analytics/12.0.0?topic=components-interactive-performance-assistant-ipa
**Setting up Interactive Performance Assistant (IPA)**
https://www.ibm.com/docs/en/cognos-analytics/12.0.0?topic=settings-setting-up-interactive-performance-assistant-ipa
**Collecting and analyzing performance data about a report**
https://www.ibm.com/docs/en/cognos-analytics/12.0.0?topic=reports-collecting-analyzing-performance-data-about-report
**Collecting and analyzing performance data about a dashboard**
https://www.ibm.com/docs/en/SSEP7J_12.0.0/com.ibm.swg.ba.cognos.ug_ca_dshb.doc/t_ca_ippa_dashboard.html

# セットアップ手順
管理→構成→システムを選択
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/d21d5dbc-f993-9c14-7c9f-0e72806ebb64.png)

キーに「DISP.zipi.IPAEnabled」、値に「true」を入力して適用。
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/d70af45c-b423-93e8-061e-ec61a7c38239.png)

※マニュアルに記載の上記だけでは動作しないので以下を実施
Cognos AdministrationのAdvanced settingsから設定
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/966f8c34-93ed-cae0-528b-6ce84998a3ae.png)

Cognos ConfigurationでNotificationを作成
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/b2d56629-258c-3e3e-c6f6-95ee086d0b0f.png)
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/8f24397f-3053-5d77-d596-09eaf4257c29.png)
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/911d56c0-9716-79d6-6f4c-0726b78038a3.png)

Cognos Configurationを保存して再起動
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/9fb4db99-cb7c-e8e8-bf42-e13c225bffd1.png)

IPAテーブルが作成される
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/aa1f87a2-d615-14dc-15b7-8880a4d5c46a.png)

データソース作成
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/d76961bd-245d-7395-1a04-d94f7557e6fc.png)
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/846eb281-7e19-4ae6-cd5a-af51706a2f50.png)
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/6f9c1aec-a794-5730-d772-b3243bdfeab6.png)
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/f34691f1-3126-db51-bcc5-07431721f61a.png)
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/feaa0ba3-e25c-174b-b067-3fdef74bb749.png)

IPPAインポート
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/6939ec49-10ef-da72-2f7e-f680fd7fcad7.png)
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/a5fe928b-7e52-fd34-16ea-7e61c0cd5a7e.png)
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/ff727e33-609d-b251-5886-1f3301d3df62.png)
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/7344cde2-5ef3-e08f-a032-26dea13df0ee.png)

# レポート実行と解析
Show run options を選択
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/2cded7cf-e0de-3683-00e8-e50db40fba35.png)

「Include performance details」をEnable
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/63af4a2e-cbd8-91e8-14ac-258230ccb4d0.png)

レポート実行で以下のイメージが出力される。

「Total Execution Time～」の文字をクリック
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/d4f45ffc-dcb7-a390-dbeb-3d2a83c7730d.png)

「Request sequence chart」を選択
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/a0f62399-e175-73a0-5731-0da809b9967f.png)

各処理の実行時間がひと目で見れる
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/361568ba-048e-2338-d138-c09a4e3dbecb.png)

Process timeに戻り、Process Nameのリンクを選択
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/0c971e7f-26a2-f534-3b42-06dd64385954.png)

さらにService Nameを選択
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/d55d6d99-b466-02f1-45ff-5250a60d1084.png)

さらにAction Nameを選択
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/15c51f7f-c478-ee5a-0f83-2e2019d6ee0c.png)

さらに詳細が確認できる
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/02238303-7353-4b41-68fb-d8fc71bb4d0a.png)

ZIPIサンプルレポートを実行。「Request sequence chart」を実行。
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/5feb0aa3-0ed3-9529-c954-9b60ad34d8f1.png)

ZIPI IDを選択しFinish
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/8ee0ca67-c906-bd42-eee9-13b65548ae25.png)
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/147246/fc330165-2990-88b8-2603-80c3a09f1506.png)