Cognos using TM1 DQM - unrecognizable metadata response?
- 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?
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
TM1 is 10.1 and FM, Cognos is 10.1.1
- 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?
Who can help me?
- 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?
anyone has any idea?
- 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?
Did you look at / try the suggestion on this page?macsir wrote:anyone has any idea?
"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
- 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?
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?
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.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
Check out my blog for some good information on TM1, SPSS
- 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?
Alan Kirk wrote:Did you look at / try the suggestion on this page?macsir wrote:anyone has any idea?
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.
- 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?
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?
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.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
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.
- 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?
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.
-
- 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?
Another possibly for this particular error msg is forgetting to set the measure and time dimension properties of the cube in TM1.
-
- 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?
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
Anyone else have this issue? and / or suggestions
GG
- 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?
it is not the case here as I checked it and set them up.tsw wrote:Another possibly for this particular error msg is forgetting to set the measure and time dimension properties of the cube in TM1.
- 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?
Yes, it is because of disabled query service as it is required by using DQM. CQM is not relevant.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
-
- 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?
Yes, I know... I put the reply here to help people researching this issue in the future.macsir wrote:it is not the case here as I checked it and set them up.tsw wrote:Another possibly for this particular error msg is forgetting to set the measure and time dimension properties of the cube in TM1.
-
- 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?
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
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