IBM Support

DIM-ERR-1007 Failed to query cube information for data source "TM1"

Troubleshooting


Problem

Trying to run a report connecting to a TM1 datasource in Cognos Connection

Symptom

XQE-MD-0007 UNABLE TO ESTABLISH A METADATA CONNECTION TO DATA SOURCE
DIM-ERR-1007 Failed to query cube information for data source "TM1".
Please check the connection string and ensure the server availability

Cause

permissions

Diagnosing The Problem

Try with administrator account

Try connecting to the cube as the user from TM1 perspectives (outside Cognos Connection)

Resolving The Problem

Verify cube security assignments
With security mode 5, the logged in Cognos user will need rights to the Tm1 cube such that they can query the metadata of the cube.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU002","label":"Business Analytics"},"Component":"Cognos Connection","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.1","Edition":""}]

Document Information

Modified date:
15 June 2018

UID

swg21965323