Cognos using TM1 DQM - unrecognizable metadata response?

Post Reply
User avatar
macsir
MVP
Posts: 782
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Cognos using TM1 DQM - unrecognizable metadata response?

Post by macsir »

Hi, I have created a DQM package based on TM1 cube and published it into Cognos connection successfully. But when i tried to open the package in RS, it saying that "The server returned an unrecognizable metadata response". I can't open them in QS and AS also. Does any have any idea?
TM1 is 10.1 and FM, Cognos is 10.1.1
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
User avatar
macsir
MVP
Posts: 782
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Cognos using TM1 DQM - unrecognizable metadata response?

Post by macsir »

Who can help me? :cry:
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
User avatar
macsir
MVP
Posts: 782
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Cognos using TM1 DQM - unrecognizable metadata response?

Post by macsir »

anyone has any idea?
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Cognos using TM1 DQM - unrecognizable metadata response?

Post by Alan Kirk »

macsir wrote:anyone has any idea?
Did you look at / try the suggestion on this page?
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
User avatar
sachin
Posts: 92
Joined: Fri Jan 15, 2010 9:54 pm
OLAP Product: Transformer,SSAS, EP, TM1
Version: 7.3 2005 10.1 10.1.1
Excel Version: 2013
Contact:

Re: Cognos using TM1 DQM - unrecognizable metadata response?

Post by sachin »

Have you had luck before? Or is this the 1st time you publishing a package using TM1 as data source? CQM/DQM should not matter at this stage since you are just getting started with report building. Is there any dimension security present in any of the cubes that you published?
macsir wrote:"The server returned an unrecognizable metadata response". I can't open them in QS and AS also. Does any have any idea?
TM1 is 10.1 and FM, Cognos is 10.1.1
This is very generic error. Perform the operation once more and then open your Cognos server log file (BI side), scroll to end and start searching up from there. You will see more detailed explanation in the log file. Hopefully the log file will tell you what is the error.
Check out my blog for some good information on TM1, SPSS
User avatar
macsir
MVP
Posts: 782
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Cognos using TM1 DQM - unrecognizable metadata response?

Post by macsir »

Alan Kirk wrote:
macsir wrote:anyone has any idea?
Did you look at / try the suggestion on this page?

Thanks, Alan. I have tried but no luck. No message pops up and just a empty interface to wait for you to add a rule. Nothing special.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
User avatar
macsir
MVP
Posts: 782
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Cognos using TM1 DQM - unrecognizable metadata response?

Post by macsir »

sachin wrote:Have you had luck before? Or is this the 1st time you publishing a package using TM1 as data source? CQM/DQM should not matter at this stage since you are just getting started with report building. Is there any dimension security present in any of the cubes that you published?
macsir wrote:"The server returned an unrecognizable metadata response". I can't open them in QS and AS also. Does any have any idea?
TM1 is 10.1 and FM, Cognos is 10.1.1
This is very generic error. Perform the operation once more and then open your Cognos server log file (BI side), scroll to end and start searching up from there. You will see more detailed explanation in the log file. Hopefully the log file will tell you what is the error.

Thanks, sachin. I don't have any problem by using TM1 as source. The DQM package is published successfully without any issue. But this error only appears with DQM package when I try to open it with any tool. It looks like something wrong with server-side configuration. I don't have permission to check server log. Maybe next time I will involve admin to check it.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
User avatar
macsir
MVP
Posts: 782
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Cognos using TM1 DQM - unrecognizable metadata response?

Post by macsir »

Just get update from our cognos admin guy. He disabled query service last time coz it wasn't used and was causing stability issues in the previous Cognos version. I think that is the root cause. I will keep update in this thread. :D
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
tsw
Posts: 47
Joined: Tue Nov 12, 2013 12:14 am
OLAP Product: TM1, PowerPlay, Transformer
Version: PA 2.0.4
Excel Version: Office 365

Re: Cognos using TM1 DQM - unrecognizable metadata response?

Post by tsw »

Another possibly for this particular error msg is forgetting to set the measure and time dimension properties of the cube in TM1.
BigG
Community Contributor
Posts: 211
Joined: Tue Sep 15, 2009 11:13 pm
OLAP Product: IBMPA
Version: PA 2.0 Cloud
Excel Version: 2010

Re: Cognos using TM1 DQM - unrecognizable metadata response?

Post by BigG »

Hi Macsir, did you resolve this with those changes,m we have the exact same issue with DQM packages only (not CQM)

Anyone else have this issue? and / or suggestions
GG
User avatar
macsir
MVP
Posts: 782
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Cognos using TM1 DQM - unrecognizable metadata response?

Post by macsir »

tsw wrote:Another possibly for this particular error msg is forgetting to set the measure and time dimension properties of the cube in TM1.
it is not the case here as I checked it and set them up.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
User avatar
macsir
MVP
Posts: 782
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Cognos using TM1 DQM - unrecognizable metadata response?

Post by macsir »

BigG wrote:Hi Macsir, did you resolve this with those changes,m we have the exact same issue with DQM packages only (not CQM)

Anyone else have this issue? and / or suggestions
Yes, it is because of disabled query service as it is required by using DQM. CQM is not relevant.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
tsw
Posts: 47
Joined: Tue Nov 12, 2013 12:14 am
OLAP Product: TM1, PowerPlay, Transformer
Version: PA 2.0.4
Excel Version: Office 365

Re: Cognos using TM1 DQM - unrecognizable metadata response?

Post by tsw »

macsir wrote:
tsw wrote:Another possibly for this particular error msg is forgetting to set the measure and time dimension properties of the cube in TM1.
it is not the case here as I checked it and set them up.
Yes, I know... I put the reply here to help people researching this issue in the future.
BigG
Community Contributor
Posts: 211
Joined: Tue Sep 15, 2009 11:13 pm
OLAP Product: IBMPA
Version: PA 2.0 Cloud
Excel Version: 2010

Re: Cognos using TM1 DQM - unrecognizable metadata response?

Post by BigG »

Was a version bug for Cognos 10.2 GA ( 10.2.1003.1075-0 ).
PM70160: XQE-QRY-0406 WHEN TRYING TO EXPAND A TM1 HIERARCHY DIMENSION CONTAINING AN & SYMBOL IN DYNAMIC MODE.
https://www-304.ibm.com/support/entdocv ... wg1PM70160
GG
Post Reply