Publishing a TM1 Websheet on another report

[rodrigo]

Hello guys,

Does anyone knows if it is possible to view a report of tm1 websheet on another physical server.

We have two tm1 servers (Costing and Finance) on a Server A and a single tm1 reporting server on a Server B for web purposes.

For example a Cost Report.xls is pointing to the Cost Cube on the TM1 Cost Server. A Finance Report.xls is pointing to the Finance Cube on the TM1 Finance Server. Both are on Server A.

On a TM1 "Report Server" located on another physical server (Server B), is there a way have an application folder that handles Cost Report.xls and Finance Report.xls and display data? We tried to publish this and the cells on the reports are blank. We also tried putting the three tm1 servers on the same physical server the report works with data.

I was thinking in something like "serverA:finance:finance cube" on the report, but i feel this is not possible, any option?

We are tring this on 9.1.4, please if it is not clear, say so, so i can explain with other words or a diagram.

Thanks in advance...

[rodrigo]

Made a mistake, the title is Publishing a TM1 Websheet on another server

[kangkc]

I don't know how are you going to bypass the authentication as TM1 Web require to authenticate to "a" TM1 server before you gain access to any of the published websheets.
By logging on to your "TM1 Report Server", it doesn't mean you will have access to the Cost Server as well as Finance Server. Technically I do not see how you can make it work without moving the relevant cubes to the "TM1 Report Server".

You can however play around with the TM1 Web URL API with hard-coded user id and password which will allow you to open up different websheets referencing different servers, with a high risk on security exposure.

[rodrigo]

The cost manager should be a user in both Cost and Report Server, as wellt he finance manager.

What we saw is that this only work if Cost and Report TM1 Servers are in Server A.
We are just testing.

Thanks kangkc