Worksheets PROD vs TEST environments

Post Reply
Posts: 3
Joined: Tue Aug 29, 2017 7:14 am
OLAP Product: Architect / Perspectives
Version: 10.2
Excel Version: 2013

Worksheets PROD vs TEST environments

Post by teamkenji » Thu Oct 12, 2017 4:44 am


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.



Posts: 56
Joined: Mon Aug 15, 2016 8:48 am
OLAP Product: TM1 (Windows) & SSAS 2014 Ent.
Version: 10.2.0 FP3
Excel Version: Excel 2013
Location: Hamburg, DE, EU

Re: Worksheets PROD vs TEST environments

Post by st2000 » Thu Oct 19, 2017 4:11 pm

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...
Best regards,

Post Reply