TM1 Cafe and Different Environments

Post Reply
tomsugden
Posts: 7
Joined: Wed Mar 23, 2011 11:26 am
OLAP Product: TM1
Version: Various
Excel Version: Various

TM1 Cafe and Different Environments

Post by tomsugden »

TM1 Version 10.2.2 FP5
Excel 2016

Has anyone found a way to create a report in Café in one environment (say Development) and then amend the same report to open in another environment (say PreProd)? No matter what I do, the report reverts back to the environment in which it was created, even if I delete the connection to that environment. I know there are some hidden rows at the top of the Café report that include the environment, but it doesn't appear to be as simple as just changing the name 'System' cell to the new environment.

Any help appreciated. Thanks.
Edward Stuart
Community Contributor
Posts: 247
Joined: Tue Nov 01, 2011 10:31 am
OLAP Product: TM1
Version: All
Excel Version: All
Location: Manchester
Contact:

Re: TM1 Cafe and Different Environments

Post by Edward Stuart »

Hi Tom,

Are you changing an exploration, flex view or formula based report?

Have you selected "Show system and package information in crosstab or list sheet" in the options? Have you tried double clicking this cell as opposed to overwriting with the new servername?

I'm working from 10.3 so it may differ
tomsugden
Posts: 7
Joined: Wed Mar 23, 2011 11:26 am
OLAP Product: TM1
Version: Various
Excel Version: Various

Re: TM1 Cafe and Different Environments

Post by tomsugden »

Hi Ed,

Thanks for that, seems to have done the trick. I can at least now see the 'Show system and package information in crosstab or list sheet' cell changing, and by double clicking am able to switch environments. Many thanks.

Cheers

Tom
silw
Posts: 15
Joined: Wed May 25, 2011 12:39 pm
OLAP Product: TM1
Version: 1022-FP*
Excel Version: 2010-2016

Re: TM1 Cafe and Different Environments

Post by silw »

Hi Tom,

One more dirty but more effective way when you have complex FLEX reports:
  1. Rename excel file to *.zip
  2. Unzip all content to a temp folder
  3. Make a massive Search/Replace for all folder with new/old server parameters (you can do it in notepad++)
  4. Zip it back and restore original name
Post Reply