企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 436|回复: 6

Connect to different TM1 servers in different excel ...

[复制链接]

85

主题

433

帖子

616

积分

高级会员

Rank: 4

积分
616
QQ
发表于 2014-3-15 17:38:33 | 显示全部楼层 |阅读模式
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
回复

使用道具 举报

83

主题

418

帖子

603

积分

高级会员

Rank: 4

积分
603
QQ
发表于 2014-3-15 18:38:55 | 显示全部楼层
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 "".

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
回复 支持 反对

使用道具 举报

73

主题

397

帖子

567

积分

高级会员

Rank: 4

积分
567
QQ
发表于 2014-3-15 19:26:17 | 显示全部楼层
Thanks Alan.
回复 支持 反对

使用道具 举报

81

主题

424

帖子

616

积分

高级会员

Rank: 4

积分
616
QQ
发表于 2014-3-15 19:32:37 | 显示全部楼层
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.
回复 支持 反对

使用道具 举报

87

主题

373

帖子

564

积分

高级会员

Rank: 4

积分
564
QQ
发表于 2014-3-15 19:39:41 | 显示全部楼层
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?

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
回复 支持 反对

使用道具 举报

70

主题

357

帖子

523

积分

高级会员

Rank: 4

积分
523
QQ
发表于 2014-3-15 20:01:26 | 显示全部楼层
Third paragraph of parent topic

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
回复 支持 反对

使用道具 举报

66

主题

382

帖子

540

积分

高级会员

Rank: 4

积分
540
发表于 2014-3-15 20:39:41 | 显示全部楼层
OK thanks, that's what I thought.
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|小黑屋|企业绩效管理网 ( 京ICP备14007298号   

GMT+8, 2020-9-21 14:35 , Processed in 0.142482 second(s), 12 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表