PAX connection to TM1 server

Post Reply
RonLat
Posts: 12
Joined: Tue May 02, 2017 7:49 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

PAX connection to TM1 server

Post by RonLat » Mon Mar 16, 2020 2:53 pm

Is it possible to establish a direct connection from Planning Analytics for Microsoft Excel (PAX) to a TM1 server in order to explore the TM1 cubes, or do I need Planning Analytics Workspace (PAW) installed first in order to use PAX with it?

This site claims that
PAX connects to the Planning Analytics Workspace (PAW) server (not the TM1 server). The address for this is http://pawserver.domain.local/.
https://exploringtm1.com/connecting-pla ... el-to-tm1/

ascheevel
Posts: 126
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: PA 2.0.8
Excel Version: 2016

Re: PAX connection to TM1 server

Post by ascheevel » Mon Mar 16, 2020 3:20 pm


HighKeys
Posts: 69
Joined: Fri Aug 09, 2019 10:11 am
OLAP Product: TM1 / TM1 Web / Perspectives
Version: Planning Analytics V2.0.9
Excel Version: Plus 2013

Re: PAX connection to TM1 server

Post by HighKeys » Tue Mar 17, 2020 11:19 am

Hello,

i checked the Link you posted, there is "Authentification over Cognos Security" and its deprecated in v 2.0.9, so is there no way to use the Cognos Security with PAX?

Its just an additional question cause i want to create a list what changes we would need to do if we want to upgrade to PAW and PAX.


Thanks!

User avatar
Steve Rowe
Site Admin
Posts: 2000
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: PAX connection to TM1 server

Post by Steve Rowe » Tue Mar 17, 2020 12:52 pm

If you follow the link you speak of it seems to relate specifically to the Ops Console (which is deprecated in v2.0.9).

I think that if IBM had decided to deprecate CAM security for TM1 there would be significant push back to say the least. It's a pretty significant component.

Granted the link to the document is worded in an inaccurate way, making no mention of the Ops Console.

I've not reviewed the whole page but some of the references may be cloud specific, i.e. the reference about using IBMid (which I don't think is true for the cloud anymore either).

This one is amusing.
Install TM1 Server
Some features of IBM Planning Analytics for Microsoft Excel require the use of TM1® Server. Install TM1 Server to ensure that you are getting the best experience with Planning Analytics for Microsoft Excel.
It's true you need a TM1 DB to get anything out of PAfE....so I guess it is a prerequisite....

HighKeys
Posts: 69
Joined: Fri Aug 09, 2019 10:11 am
OLAP Product: TM1 / TM1 Web / Perspectives
Version: Planning Analytics V2.0.9
Excel Version: Plus 2013

Re: PAX connection to TM1 server

Post by HighKeys » Tue Mar 17, 2020 1:17 pm

Steve Rowe wrote:
Tue Mar 17, 2020 12:52 pm
If you follow the link you speak of it seems to relate specifically to the Ops Console (which is deprecated in v2.0.9).

I think that if IBM had decided to deprecate CAM security for TM1 then would significant push back to say the least. It's a pretty significant component.

Granted the link to the document is worded in an inaccurate way, making no mention of the Ops Console.

I've not reviewed the whole page but some of the references may be cloud specific, i.e. the reference about using IBMid (which I don't think is true for the cloud anymore either).

This one is amusing.
Install TM1 Server
Some features of IBM Planning Analytics for Microsoft Excel require the use of TM1® Server. Install TM1 Server to ensure that you are getting the best experience with Planning Analytics for Microsoft Excel.
It's true you need a TM1 DB to get anything out of PAfE....so I guess it is a prerequisite....

Hi Steve!

Thanks for your answer, the doc is a lil bit weird.

The Requirement of the TM1 Server is funny :lol: seems logical :lol:

At the moment we use Cognos Analytics and PA 2.0.9, our CAM Security is working normally, if someone is interested in this.

I have no clue about PAW, is it using a totally other auth system? is there no "SSO" or "CAM" in PAW? (Just to complete this)


Thanks!

Post Reply