Websheets Displaying Data from multiple TM1 servers

mce · Post by **mce** » Wed Mar 30, 2016 9:15 am

Hi,

If you have a Perspectives reports that pulls numbers from more than one TM1 server;
- In Perspectives; You needs to connect to each of the TM1 servers when using this report.
- In TM1Web;
- - If you are using native TM1 security with mode 1 and if your user id and password is the same in all TM1 servers, then it works. The websheet automatically connects to each of them and displays numbers from all of the TM1 servers. This is a very nice feature. So far so good.
- - However, if you do not use TM1 native security and if you use CAM security in Mode 5 in all of the TM1 servers, then it does not work in TM1 Web. Websheet simply errors.

Question: Do you know how to make this work in security mode 5 with Cognos BI security? How can I make my websheet pulling data from multiple TM1 servers in security mode 5?

Thanks in advance.

Regards