Hi All,

What is the best approach to exchange data between PA/TM1 models? 
Can I read a cube from another model using sql?

thanks, Asgeir

------------------------------
Asgeir Thorgeirsson
------------------------------

#PlanningAnalyticswithWatson

Hello,

To me, the more simple is to extract from one model and then use excutecommande to run Tm1RunTi on the other model with a process that read the file. It will be the fastest. 

Regards

For high volume, that's probably the best approach. To be clear, as TM1 is not a relational database, it does not support SQL queries.
I did experiment with using MDX/ODBO some time ago and the results weren't usable. 
TM1PY is also another option. A single script can be written to do the reading and writing.

------------------------------
David Usherwood
------------------------------

Original Message:
Sent: Sat October 17, 2020 07:17 AM
From: Frederic Arevian
Subject: Exchange data between PA models

Hello,

To me, the more simple is to extract from one model and then use excutecommande to run Tm1RunTi on the other model with a process that read the file. It will be the fastest. 

Regards

------------------------------
Frederic Arevian
------------------------------

We no longer recommend using ODBO or Rep/Sync.  Currently, the proven and fastest way to move data and metadata between TM1 models is by exporting the metadata/data to a flat file with a TI process, moving the flat file (e.g FTP or have a common file share between models), and import the data/metadata using a TI in the target TM1 model.  

The Planning Analytics team is considering enhancements to modernize how data is moved between TM1 models.  


------------------------------
Stuart King
IBM Planning Analytics Offering Manager
------------------------------

Stuart​, can you confirm you meant ODBO not ODBC? (I didn't mention Rep/Sync as this had many issues - interesting to be reminded of it.)

------------------------------
David Usherwood
------------------------------

Original Message:
Sent: Mon October 19, 2020 08:30 AM
From: STUART KING
Subject: Exchange data between PA models

We no longer recommend using ODBC or Rep/Sync.  Currently, the proven and fastest way to move data and metadata between TM1 models is by exporting the metadata/data to a flat file with a TI process, moving the flat file (e.g FTP or have a common file share between models), and import the data/metadata using a TI in the target TM1 model.  

The Planning Analytics team is considering enhancements to modernize how data is moved between TM1 models.  


------------------------------
Stuart King
IBM Planning Analytics Offering Manager
------------------------------

HI David,

Yes, I meant ODBO (not ODBC) and corrected my original post.  Thanks for pointing that out.

------------------------------
Stuart King
IBM Planning Analytics Offering Manager
------------------------------

Original Message:
Sent: Tue October 20, 2020 04:35 AM
From: David Usherwood
Subject: Exchange data between PA models

Stuart​, can you confirm you meant ODBO not ODBC? (I didn't mention Rep/Sync as this had many issues - interesting to be reminded of it.)

------------------------------
David Usherwood
------------------------------


Original Message:
Sent: Mon October 19, 2020 08:30 AM
From: STUART KING
Subject: Exchange data between PA models

We no longer recommend using ODBC or Rep/Sync.  Currently, the proven and fastest way to move data and metadata between TM1 models is by exporting the metadata/data to a flat file with a TI process, moving the flat file (e.g FTP or have a common file share between models), and import the data/metadata using a TI in the target TM1 model.  

The Planning Analytics team is considering enhancements to modernize how data is moved between TM1 models.  


------------------------------
Stuart King
IBM Planning Analytics Offering Manager