TM1 Forum

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

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.

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 replication.