Connect to TM1 from Cognos Insight

Post Reply
User avatar
ioscat
Regular Participant
Posts: 209
Joined: Tue Jul 10, 2012 8:26 am
OLAP Product: Contributor
Version: 9.5.2 10.1.1 10.2
Excel Version: 07+10+13
Contact:

Connect to TM1 from Cognos Insight

Post by ioscat »

Hello, forum.

I got a problem that I cannot find how to solve.

Code: Select all

The planning server configuration settings could not be found. Initialize the planning server then press enter to try connectiong again.
Безымянный.png
Безымянный.png (17.37 KiB) Viewed 9753 times
I tried to put "localhost" to the string but with no success

Has anybody met this one?
Duncan P
MVP
Posts: 600
Joined: Wed Aug 17, 2011 1:19 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2
Excel Version: 2003 2007
Location: York, UK

Re: Connect to TM1 from Cognos Insight

Post by Duncan P »

Have you tried pasting that URL into a browser? If so then it might redirect you to the configuration page where it will create the file it is looking for.
User avatar
ioscat
Regular Participant
Posts: 209
Joined: Tue Jul 10, 2012 8:26 am
OLAP Product: Contributor
Version: 9.5.2 10.1.1 10.2
Excel Version: 07+10+13
Contact:

Re: Connect to TM1 from Cognos Insight

Post by ioscat »

http://localhost:9510/pmpsvc opens ok...

IntegratedSecurityMode = 1
is BI necessary to Insight work?
kaazimraza
Posts: 95
Joined: Mon Jun 25, 2012 6:58 am
OLAP Product: TM1, SSAS, Power BI
Version: 10.2.2
Excel Version: 2016

Re: Connect to TM1 from Cognos Insight

Post by kaazimraza »

ioscat wrote:http://localhost:9510/pmpsvc opens ok...

IntegratedSecurityMode = 1
is BI necessary to Insight work?
No, BI is not necessary to make Cognos Insight work. on my local machine I am able to access my local TM1 server from Cognos Insight only if I launch it from TM1 applications page. If I launch Cognos Insight stand alone, and then try to connect it to the URL, it keeps on prompting me with invalid credentials message.

Hope this helps.
Thanks,

Kaz
User avatar
ioscat
Regular Participant
Posts: 209
Joined: Tue Jul 10, 2012 8:26 am
OLAP Product: Contributor
Version: 9.5.2 10.1.1 10.2
Excel Version: 07+10+13
Contact:

Re: Connect to TM1 from Cognos Insight

Post by ioscat »

I got connected to the TM1 server, thaks for advice. But when I try to put a cube view to the workspace I got disconnected. Import data did not succeed too. I can't even google this error. =(

Code: Select all

Error connecting to the Cognos TM1 server: Cognos Insight will now close the connection to TM1
Безымянный.png
Безымянный.png (86.61 KiB) Viewed 9673 times
Last edited by ioscat on Fri Dec 20, 2013 9:13 am, edited 1 time in total.
User avatar
ioscat
Regular Participant
Posts: 209
Joined: Tue Jul 10, 2012 8:26 am
OLAP Product: Contributor
Version: 9.5.2 10.1.1 10.2
Excel Version: 07+10+13
Contact:

Re: Connect to TM1 from Cognos Insight

Post by ioscat »

The issue was caused by incorrect MDX that somehow passed to work in Architect, TM1Web, Contributor. I corrected it and finaly got Insight display my cube view.
kaazimraza
Posts: 95
Joined: Mon Jun 25, 2012 6:58 am
OLAP Product: TM1, SSAS, Power BI
Version: 10.2.2
Excel Version: 2016

Re: Connect to TM1 from Cognos Insight

Post by kaazimraza »

ioscat wrote:The issue was caused by incorrect MDX that somehow passed to work in Architect, TM1Web, Contributor. I corrected it and finaly got Insight display my cube view.
Glad to know that it's resolved. MDX bit is pretty interesting, maybe that's because Cognos Insight was expecting an MDX statement different than Architect/Contributor/Web?
Thanks,

Kaz
margauxbrand
Posts: 1
Joined: Tue Jun 24, 2014 7:36 pm
OLAP Product: TM1
Version: 10.2.1
Excel Version: 2010

Re: Connect to TM1 from Cognos Insight

Post by margauxbrand »

kaazimraza wrote:
ioscat wrote:The issue was caused by incorrect MDX that somehow passed to work in Architect, TM1Web, Contributor. I corrected it and finaly got Insight display my cube view.
Glad to know that it's resolved. MDX bit is pretty interesting, maybe that's because Cognos Insight was expecting an MDX statement different than Architect/Contributor/Web?
Please help... I get the same error message... I can open my cubeview and move a few dimensions around, but then after a few minutes it starts to 'hang' and ultimately pops up with the "Error connecting to the Cognos TM1 server: Cognos insight will now close." message.
I am pretty new at TM1 administration, so could anyone please advise where I go to amend "incorrect MDX"? Assuming that my error message is caused by the same problem. Thanks!
Post Reply