Hi All,
We are upgrading from 2.0.9 to 2.1 and need help in getting the server requirements right.
We currently have 3 servers in 2.0.9 and use contributor for data entry. PAW for reporting and analysis.
Current Landscape:
1. App server --> where the TM1 admin server and all the databases (TM1 servers) reside
2. Web server --> where "IBM Cognos TM1" and "IBM Planning Analytics Spreadsheet Services" run.
3. PAW server --> Docker and PAW services reside
With this in mind, when we upgrade to 2.1, do we still need a web server? A web server is required for external facing users and have doubts here.
I installed a PAW server and App server in the new 2.1 server instance and it seems to be working without a webserver. The spreadsheet services are also on the App server. Is this correct install? Can you guide and inform the issues you faced and how it was fixed? Is there anything I am missing?
Thanks,
Paul.
Help on Creating a new landscape
-
- MVP
- Posts: 2835
- 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: Help on Creating a new landscape
The Web Server (IBM Planning Analytics Spreadsheet Services) is optional. If you are going to publish all your reports either in PAW or PAFE then you don't need TM1Web.
-
- Regular Participant
- Posts: 432
- Joined: Sat Jun 08, 2019 9:55 am
- OLAP Product: Planning Analytics
- Version: Planning Analytics 2.0
- Excel Version: Excel 2016
Re: Help on Creating a new landscape
Don't you need IBM Planning Analytics Spreadsheet Services to run websheets in PAW? For example, if I want to change the proxy timeout for websheets in PAW I need to tweak the Tm1web_config file and restart Spreadsheet Services?The Web Server (IBM Planning Analytics Spreadsheet Services) is optional. If you are going to publish all your reports either in PAW or PAFE then you don't need TM1Web.
-
- Regular Participant
- Posts: 226
- Joined: Wed May 06, 2020 2:58 pm
- OLAP Product: Planning Analytics
- Version: 2.0.9
- Excel Version: 2016
Re: Help on Creating a new landscape
Both PAW and PASS have endpoints for users to access through. Strictly speaking it doesn't matter how you choose to split out these components over which servers but if you want external users to be able to connect those endpoints will need to be exposed to the web meaning firewalls opened, SSL implemented etc...
Typically a dedicated web server would be set up which provides an endpoint for those external users. This can be done by either having paw/pass installed on that server and configured with SSL or a load balancer / proxy is set up with say is is setup on this web server which would then connect to internal servers containing paw or PASS.
An independent web server isn't strictly necessary but it can serve as an extra layer of protection.
Typically a dedicated web server would be set up which provides an endpoint for those external users. This can be done by either having paw/pass installed on that server and configured with SSL or a load balancer / proxy is set up with say is is setup on this web server which would then connect to internal servers containing paw or PASS.
An independent web server isn't strictly necessary but it can serve as an extra layer of protection.
-
- Posts: 139
- Joined: Tue Jun 13, 2017 3:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: Help on Creating a new landscape
Thanks for your inputs Tomok and Burnstripe.
Let's say we have a web server what components can we put on it to add PAW server configuration?
Thanks,
Paul.
Let's say we have a web server what components can we put on it to add PAW server configuration?
Thanks,
Paul.
- Steve Rowe
- Site Admin
- Posts: 2455
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Help on Creating a new landscape
Hi,
Just to point out that PASS is required for some PAfE functionality, Universal Reports.
In my experience people don't tend to run a web server. The TM1 DB and PASS goes on the windows box and PAW goes on the RHEL box.
My understanding is that in the medium term there is an expectation that PASS will become part of PAW.
The only reasons that I know of for running a separate Web server would be in heavy usage environments where you want to keep the PASS activity and your TM1 DB activity separate with their own resources. This becomes more significant if you are licenced by PVU and so paying for the resources that are allocated to the TM1 DB.
Just to point out that PASS is required for some PAfE functionality, Universal Reports.
In my experience people don't tend to run a web server. The TM1 DB and PASS goes on the windows box and PAW goes on the RHEL box.
My understanding is that in the medium term there is an expectation that PASS will become part of PAW.
The only reasons that I know of for running a separate Web server would be in heavy usage environments where you want to keep the PASS activity and your TM1 DB activity separate with their own resources. This becomes more significant if you are licenced by PVU and so paying for the resources that are allocated to the TM1 DB.
Technical Director
www.infocat.co.uk
www.infocat.co.uk
- gtonkin
- MVP
- Posts: 1254
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: Help on Creating a new landscape
My understanding is the TM1Web, the UI to PASS will fall away and websheets will need to be embedded into PAW.Steve Rowe wrote: ↑Wed Mar 05, 2025 9:32 am ...
My understanding is that in the medium term there is an expectation that PASS will become part of PAW.
...
To allow PAW to render these websheets, you will need PASS running as the "evaluation service".
Maybe something to clarify on the next AMA as people have a different understanding.
- Steve Rowe
- Site Admin
- Posts: 2455
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Help on Creating a new landscape
Sure, that might also fit what we've been told...gtonkin wrote: ↑Wed Mar 05, 2025 1:38 pmMy understanding is the TM1Web, the UI to PASS will fall away and websheets will need to be embedded into PAW.Steve Rowe wrote: ↑Wed Mar 05, 2025 9:32 am ...
My understanding is that in the medium term there is an expectation that PASS will become part of PAW.
...
To allow PAW to render these websheets, you will need PASS running as the "evaluation service".
Maybe something to clarify on the next AMA as people have a different understanding.
Technical Director
www.infocat.co.uk
www.infocat.co.uk