The MDX query submitted to TM1 server failed duringexecution

[niharika]

Hello Memebers,

I have facing an unusual error while running a report in Report Studio of Cognos BI 8

Error Stating:

TM1-ERR-0061

The MDX query submitted to TM1 server failed during execution


If any one have any idea about this error or any fixes or solutions for this error please assist with information.
Error Screen shot is attached with the Note

Thanks in advance

[declanr]

Niharika,

Did you check out this known issue for using BI (circa version 8) to report on TM1? Could be what you are experiencing:
http://publib.boulder.ibm.com/infocente ... error.html

[niharika]

Hi declanr

Thanks for the reply.
But Ya tired the solution given in the link too..
a. Kept the Level names and dimension as different.
b.The dimension values doesn't have any special characters.
c. Cube name is also simple without any special character.
d. Declared the measure n period in the Properties while creating the Cube in TM1.

Still we facing the same problem..

The Error comes up when we actually keep a filter of measure>0 within a query with the Data item of respective dimension which has Values more than 500 -1000.

You have any idea about the above condition, If yes Please let me know the fix for it.

Thks