Connect to different TM1 servers in different excel ...

西山红叶

Hi,

Need some urgent help in TM1 Perspectives:

Can I connect to different TM1 servers in different excel tabs/sheets on the same excel workbook. If yes, how ?
Can I connect to different TM1 cubes in different excel tabs/sheets on the same excel workbook. If yes, how ?
Can I connect to different 2 TM1 servers/cubes in 2 different open excel workbooks and analyse data. If yes, how ?
Can I connect a TM1 cube in same spreadsheet that has data from other sources like HFM (Smart View), Bloomberg etc. If yes, how ?

I am using Excel 2010 and TM1 10.1 Perspectives.

Any help is greatly appreciated.

Many thanks
jyotish84

wanglinyangling

jyotish84 wrote:Need some urgent help in TM1 Perspectives:
Can I connect to different TM1 servers in different excel tabs/sheets on the same excel workbook. If yes, how ?

By consulting the  (a link to which can also be found in the ) on the arguments to a  function.

jyotish84 wrote:Can I connect to different TM1 cubes in different excel tabs/sheets on the same excel workbook. If yes, how ?

Through the same method.

jyotish84 wrote:Can I connect to different 2 TM1 servers/cubes in 2 different open excel workbooks and analyse data. If yes, how ?

Also through the same method.

jyotish84 wrote:Can I connect a TM1 cube in same spreadsheet that has data from other sources like HFM (Smart View), Bloomberg etc. If yes, how ?

By searching the documentation for the expression "" (which will also refer to the aforementioned DBRW formulas), or "".

rampagews3

Thanks Alan.

fs111

jyotish84 wrote:....Can I connect a TM1 cube in same spreadsheet that has data from other sources like HFM (Smart View), Bloomberg etc. If yes, how ?

As Alan has pointed out the answer to all of your questions is "yes" using basic TM1 functionality.

However just one point on your last question.  If you use Excel with more than one add-in (TM1, HFM, Cartesis, Mokum etc) there may be some unexpected interactions.

fuanxx

Alan Kirk wrote:[quote]jyotish84 wrote:Need some urgent help in TM1 Perspectives:
Can I connect to different TM1 servers in different excel tabs/sheets on the same excel workbook. If yes, how ?

By consulting the  (a link to which can also be found in the ) on the arguments to a  function.
[/quote]

Alan, could you elaborate a little bit on your answer? How does the DBRW function know which server to look at? Can you put 'server:cube' for the first argument in the function, and be connected to both servers at the same time?

tianya369

Third paragraph of parent topic

hsszjw

OK thanks, that's what I thought.