企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 396|回复: 2

ODBO

[复制链接]

81

主题

424

帖子

606

积分

中级会员

Rank: 3Rank: 3

积分
606
QQ
发表于 2014-3-20 12:02:19 | 显示全部楼层 |阅读模式
Hello All,
I'm stuck up while moving the data from one cube to another.
TM1 Version: 10.1.1

I have two cubes Cube A & Cube B both these cube have same dimension structure. Cube A and Cube B are availbel on the same physical server but available in two different TM1 Servers/Instances. I have created a new TI process in the TM1 server which has Cube B, I have opted the datasource type as ODBO - Cube, selected the TM1 Dimension action as Update only for the dimensions which has elements for measures dimension I 'm selecting data load load only. When I run the process , I get error message cell type is real.

Is this approach correct ot move the data from a cube of one instance to a cube of different instance.
Can I edit the MDX query which is generated in , I'm unable to filter the level 0 elements from the filetr tab under ODBO
Or else I can do the same activity using OBO - MDX query, though I type the MDX query the preview is not available

Please help me

Thank You,
Radhika
回复

使用道具 举报

75

主题

385

帖子

530

积分

中级会员

Rank: 3Rank: 3

积分
530
QQ
发表于 2014-3-20 13:28:57 | 显示全部楼层
We looked at this some years ago and found (at the time) that it didn't scale. I am aware of others who recommend it though. I'd go the flat file route myself.
回复 支持 反对

使用道具 举报

81

主题

411

帖子

594

积分

中级会员

Rank: 3Rank: 3

积分
594
QQ
发表于 2014-3-20 13:31:43 | 显示全部楼层
Radhika wrote:I have two cubes Cube A & Cube B both these cube have same dimension structure. Cube A and Cube B are availbel on the same physical server but available in two different TM1 Servers/Instances. I have created a new TI process in the TM1 server which has  Cube B, I have opted the datasource type as ODBO - Cube, selected the TM1 Dimension action as Update only for the dimensions which has elements for measures dimension I 'm selecting data load load only. When I run the process , I get error message cell type is real.

Is this approach correct ot move the data from a cube of one instance to a cube of different instance.
I agree with David that flat files are the way to go. Export data from Cube A to flat file. Import data from that flat file to Cube B. As they are on the same physical server then they both ought to be able to see the filesystem location where you are writing/ reading the file. This is the most reliable method and probably the quickest.

In my experience, ODBO can be flakey, subject to locking/ hanging issues and also a technical standard that doesn't appear to be high up on the agenda for IBM in terms of maintenance.

Another other option is to use .

本帖子中包含更多资源

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

x
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2018-7-23 06:07 , Processed in 0.152346 second(s), 12 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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