If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Unable to reference a level

Started by cognos05, 31 Jul 2014 01:09:23 PM

Previous topic - Next topic

cognos05

Hi ,

I am getting this error when I run my cognos report.

Found an internal error: 'XQERuntimeException':
XTM-ERR-0003 The MDX query submitted to TM1 server failed during execution. The TM1 error code is: InvalidMDXExpression. The TM1 error message is: "MDX Adaptor:TM1-ERR-0020 An attempt was made to reference a level ("Location") that does not exist.".

I am using cognos 10.2.1 version.

I tried to add the named hierarchy in TM 1 cube and publish the package in Framework manager. I then created a report and getting this error when using these levels along with the measures .

Please let me know what could be the issue.



Thanks,
Nithya

cognos05

Hi ,

I tried republishing the package in FM . The levels are present in TM1 cube but I dont understand why its still throwing an error. I deleted the contents in the cognos installation folder  \data\mfw4j\PMCs .

when i run only with levels without measures I dont get a error.

Thanks,
Nithya