企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 1128|回复: 2

how to use TM1 solution?

[复制链接]

89

主题

395

帖子

598

积分

高级会员

Rank: 4

积分
598
QQ
发表于 2014-6-25 01:17:03 | 显示全部楼层 |阅读模式
Recellently, I will work on a TM1 project, we have identified that the data source is from relational database(operational database), the datasource is very messy. My question is that do we need to create a data warehouse(Data mart) as a data source for TM1 or TI is powerful enough to do the ETL work?
回复

使用道具 举报

87

主题

428

帖子

615

积分

高级会员

Rank: 4

积分
615
QQ
发表于 2014-6-25 03:09:02 | 显示全部楼层
Sean wrote:Recellently, I will work on a TM1 project, we have identified that the data source is from relational database(operational database), the datasource is very messy.  My question is that do we need to create a data warehouse(Data mart) as a data source for TM1 or TI is powerful enough to do the ETL work?

TI is, by definition, an ETL tool.

That having been said, I do recommend that you try to "unmess" the data source first and get as much done on the server side as possible to reduce your load times. I'd be looking at creating views, and using the views (as opposed to direct queries against the tables) as the data source via ODBC. If the relational database is really badly designed (meaning long query times), and you don't need real time interfaces, you may want to even look at doing an export from it to text files, and loading the files.

Cleaning up the database would of course be the optimal solution, but I'm assuming that that isn't an option.
回复 支持 反对

使用道具 举报

62

主题

411

帖子

557

积分

高级会员

Rank: 4

积分
557
QQ
发表于 2014-6-25 03:20:45 | 显示全部楼层
Alan Kirk wrote:[quote]Sean wrote:Recellently, I will work on a TM1 project, we have identified that the data source is from relational database(operational database), the datasource is very messy.  My question is that do we need to create a data warehouse(Data mart) as a data source for TM1 or TI is powerful enough to do the ETL work?

TI is, by definition, an ETL tool.

That having been said, I do recommend that you try to "unmess" the data source first and get as much done on the server side as possible to reduce your load times. I'd be looking at creating views, and using the views (as opposed to direct queries against the tables) as the data source via ODBC. If the relational database is really badly designed (meaning long query times), and you don't need real time interfaces, you may want to even look at doing an export from it to text files, and loading the files.

Cleaning up the database would of course be the optimal solution, but I'm assuming that that isn't an option.
[/quote]


Many thanks for your suggestion, it is really helpful.
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2021-9-17 21:55 , Processed in 0.095542 second(s), 12 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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