Troubleshooting
Problem
In Cognos Analytics, when creating a Planning Analytics data server using the REST connector, if a cube contains many Subsets then users may experience poor performance when navigating cube metadata or running reports against the cube. Intermittent connection errors may be thrown when loading the metadata tree for the cube in Reporting or Dashboard, or when attempting to create a Data Module from the cube. Using a Cognos TM1 connection type does not show the same performance issues.
Cause
A new feature to validate Subsets was enabled by default in 11.1.1 which may perform poorly for large volumes of subset objects. APAR PI98556 was logged to have this default behavior addressed, but the feature can also be disabled with a configuration setting to improve performance.
Resolving The Problem
1. Navigate to the <install_home>/configuration directory and make a backup of the file xqe.config.xml, then open it in a text editor
2. Locate the <queryExecution> section
3. Add the following setting:
<!-- The TM1 REST PA subset validation is disabled by default. -->
<validateTM1RESTPASubsets enabled="false"/>
4. Save the change, then restart the service.
5. Test again.
Related Information
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"11.1.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
27 March 2019
UID
ibm10878811