Page 1 of 1

Worksheets PROD vs TEST environments

Posted: Thu Oct 12, 2017 4:44 am
by teamkenji

I am using Application MS Excel Worksheets that are linked to Perspective Cube Views & Processes.

I understand that to update a worksheet onto the server(action buttons etc), I click on the 'Update' icon in the TM1 toolbar within the MS Excel Ribbon. Similarly I must use the 'Upload' icon to upload a new worksheet to the server (that I am currently logged into)

My question:

If I create a new worksheet in the TEST environment, it is not available in the PROD environment. Is it that I must create it again for the PROD environment? (or have the worksheet open whilst in TEST, and then log onto the PROD Environment and then upload the worksheet to the PROD environment?

Would another way be to keep a copy of all worksheets on my local machine, make all necessary changes and then to update them into the relevant applications on both PROD & TEST servers.



Re: Worksheets PROD vs TEST environments

Posted: Thu Oct 19, 2017 4:11 pm
by st2000
Hello Ben,

if you are connected to TEST when developing the sheet and then upload it, it will only show up on TEST. To deploy it to PROD you need to open the sheets file (xlsx) using perspectives connected to PROD (possibly on the PROD machine) and then upload the well tested sheet again. This always works fine for me so I didn't figure out some more sophisticated method up to now.
Or you could try to transport it using TM1XFER ( ... 1xfer.html).
But I never used it, maybe there are pitfalls...