IBM Support

"DIM-ERR-1007 Failed to query cube information for data source" when using a Planning Analytics data server connection

Troubleshooting


Problem

Connection to Planning Analytics shows the below error when the user tries to create a dashboard from the PA dataserver:
"MSR-GEN-0002 Error: "XQE-PLN-0001 Internal error. The query could not be planned by the Query Service: DIM-ERR-1007 Failed to query cube information for data source "HLXPA_Server". Please check the connection string and ensure the server availability.""
Other accounts such as admin accounts work fine.

Symptom

Along with this, if a data set using the connection is made, the same error is received:
DIM-ERR-1007
If trying to use a TM1 cube as the source for say a dashboard, you get:
The metadata for '...' did not load. Please contact your administrator for details.

Cause

Users in Cognos trying to access a TM1 Cube in Planning Analytics need to have Data Admin rights on the Cube, even if the the Admin Account is embedded in the connection object.

Resolving The Problem

Give the Cognos users data admin rights in the security model for the TM1 cube which is being accessed.

Document Location

Worldwide

[{"Business Unit":{"code":"BU002","label":"Business Analytics"},"Product":{"code":"SSTSF6","label":"Cognos Analytics"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0.x","Edition":""}]

Document Information

Modified date:
19 March 2019

UID

ibm10875650