How to connect TM1 Perspective from client to the Server

Post Reply
roy2087
Posts: 40
Joined: Wed Feb 06, 2013 9:53 am
OLAP Product: cognos tm1
Version: 10.1.1
Excel Version: 2007
Location: Bangalore,India

How to connect TM1 Perspective from client to the Server

Post by roy2087 » Wed Aug 19, 2015 6:57 am

Hi ,

I have a TM1 Perspective (tm1p.xla file) in the server.
How do I connect this file from the client ?

Like in Architect , we write the IP in Admin Host.
Is there something similar in TM1 Perspective also.

Please Note : I am not talking about the "Connect" Button in the TM1 Perspective file.
I have developed the TM1 Perspective file in the Server and I want the End Users to use it now.

Am just guessing , should I give access to the "Path" in the Server to the Users or is there
any other better way.

Regards,
Roy.

Paul Segal
Community Contributor
Posts: 261
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: How to connect TM1 Perspective from client to the Server

Post by Paul Segal » Wed Aug 19, 2015 7:37 am

Are your users all connecting to the Server via RDP or something similar?
Paul

roy2087
Posts: 40
Joined: Wed Feb 06, 2013 9:53 am
OLAP Product: cognos tm1
Version: 10.1.1
Excel Version: 2007
Location: Bangalore,India

Re: How to connect TM1 Perspective from client to the Server

Post by roy2087 » Wed Aug 19, 2015 7:40 am

Hi Paul ,

We will not give any Server access to the End - Users.
Hence, no RDP.

Regards,
Roy.

Paul Segal
Community Contributor
Posts: 261
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: How to connect TM1 Perspective from client to the Server

Post by Paul Segal » Wed Aug 19, 2015 8:02 am

OK, so the normal way to do this is to install TM1 Perspectives as an add-in on each client (user) PC, which is then loaded in Excel, rather than access the add-in from a server. Is there a particular reason you want to load the add-in from the server?
Paul

roy2087
Posts: 40
Joined: Wed Feb 06, 2013 9:53 am
OLAP Product: cognos tm1
Version: 10.1.1
Excel Version: 2007
Location: Bangalore,India

Re: How to connect TM1 Perspective from client to the Server

Post by roy2087 » Wed Aug 19, 2015 8:14 am

Hi Paul ,

I have installed TM1 Perspectives as an add-in on each client (user) PC.
Now , how will the client (user) connect to the TM1 Perspective sheet that I have developed in the Server.

Regards,
Roy.

Wim Gielis
MVP
Posts: 2196
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: How to connect TM1 Perspective from client to the Server

Post by Wim Gielis » Wed Aug 19, 2015 8:27 am

Hi Roy,

Users will Connect themselves in TM1 Perspectives Excel add-in, and then click on the Explorer icon in the TM1 ribbon. This will take them to the Server Explorer.
Or, they click first on teh Explorer icon, and log on in the Server Explorer.

Either way, they will be able to go to Applications in the Server Explorer, select the correct folder and double click on the uploaded sheet.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 model with AutoHotKey as a service or application

User avatar
Michel Zijlema
Site Admin
Posts: 705
Joined: Wed May 14, 2008 5:22 am
OLAP Product: TM1, PALO
Version: both 2.5 and higher
Excel Version: 2003-2007-2010
Location: Netherlands
Contact:

Re: How to connect TM1 Perspective from client to the Server

Post by Michel Zijlema » Wed Aug 19, 2015 7:47 pm

Hi Roy,

If you've installed Perspectives on a client machine you can start the add-in from the Perspectives shortcut in the start menu. You can also create your own shortcut to the tm1p.xla file and double-click that to start Perspectives (or you can setup Perspectives to auto load when starting Excel).
When Perspectives is loaded in Excel, you can click the Explorer button on the TM1 ribbon to open Server Explorer and see what TM1 servers are available. Server Explorer is basically the same thing as TM1 Architect. Here you can add an Admin Host IP address just like you do in Architect.

Michel

roy2087
Posts: 40
Joined: Wed Feb 06, 2013 9:53 am
OLAP Product: cognos tm1
Version: 10.1.1
Excel Version: 2007
Location: Bangalore,India

Re: How to connect TM1 Perspective from client to the Server

Post by roy2087 » Fri Aug 21, 2015 6:05 am

Thanks Michel and Wim.

Regards,
Roy.

roy2087
Posts: 40
Joined: Wed Feb 06, 2013 9:53 am
OLAP Product: cognos tm1
Version: 10.1.1
Excel Version: 2007
Location: Bangalore,India

Re: How to connect TM1 Perspective from client to the Server

Post by roy2087 » Fri Aug 21, 2015 10:02 am

There is another way of giving the Perspective Views to the client (End Users).

You can upload the Perspective View to the TM1 Application Web.

Regards,
Roy.
Attachments
Upload.jpg
Upload.jpg (69.46 KiB) Viewed 2453 times

Post Reply