Connecting to TM1 Cube from Cognos Insight /TM1 Web?

Post Reply
mixim
Posts: 9
Joined: Thu Mar 27, 2014 8:35 am
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

Connecting to TM1 Cube from Cognos Insight /TM1 Web?

Post by mixim »

Hello Guys,

I have been trying to connect to a Cube i have created from Cognos Insight.
The issue I have is that I cannot see the TM1 server I have created.

Only the TM1 servers which came with the installation appear in the list of selections. And are successfully connected.

Is there somewhere where I need to add a new TM1 server (Like in Cognos BI?) as a datasource or something, for it to be visible both in TM1 web but also in e.g. Cognos Insight.
nick_leeson
Posts: 98
Joined: Sat Feb 11, 2012 11:13 am
OLAP Product: TM1 9x, BPC, Hyperion, HANA
Version: TM1 10
Excel Version: Excel 2003 - 2010

Re: Connecting to TM1 Cube from Cognos Insight /TM1 Web?

Post by nick_leeson »

There is a couple of things you would need to do to set this up but I rather you read and try this, rather than me giving you step by step instructions.

http://www-01.ibm.com/support/knowledge ... ib_strtlnk

Cheerio
mixim
Posts: 9
Joined: Thu Mar 27, 2014 8:35 am
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

Re: Connecting to TM1 Cube from Cognos Insight /TM1 Web?

Post by mixim »

nick_leeson wrote:There is a couple of things you would need to do to set this up but I rather you read and try this, rather than me giving you step by step instructions.

Cheerio
Hi Nick,

Thanks for your reply. Really appreciate the help!
I have reviewed the link briefly. But I am actually just after a High level anwser, before i could even deep dive.
Eg. Do I need to create an application before I could access it from outside?

A couple of high level steps could help me to then dig deeper on my own, any ideas?
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Connecting to TM1 Cube from Cognos Insight /TM1 Web?

Post by tomok »

I don't use Cognos Insight but I'm pretty sure you cannot create TM1 servers from inside this tool. You have to use Cognos Configuration, or alternatively, the command line program. If you have created a cube via Cognos Insight then that cube exists only on your local machine, what is otherwise known as a "in-process local server", to use old TM1 terminology. This is not to be confused with an actual TM1 server that can be accessed by others.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
declanr
MVP
Posts: 1831
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Connecting to TM1 Cube from Cognos Insight /TM1 Web?

Post by declanr »

tomok wrote:I don't use Cognos Insight but I'm pretty sure you cannot create TM1 servers from inside this tool. You have to use Cognos Configuration, or alternatively, the command line program. If you have created a cube via Cognos Insight then that cube exists only on your local machine, what is otherwise known as a "in-process local server", to use old TM1 terminology. This is not to be confused with an actual TM1 server that can be accessed by others.
Sadly you can publish your insight built model as a TM1 server for others to use... this is the way most presales tends to go; showing users how they can drag in an excel file and have a fully published contribution model available in under an hour...
Declan Rodger
Post Reply