Planning Analytics

Expand all | Collapse all

Exchange data between PA models

  • 1.  Exchange data between PA models

    Posted 17 days ago
    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
    ------------------------------


  • 2.  RE: Exchange data between PA models

    Posted 14 days ago
    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
    ------------------------------



  • 3.  RE: Exchange data between PA models

    Posted 13 days ago
    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
    ------------------------------



  • 4.  RE: Exchange data between PA models

    Posted 12 days ago
    Edited by STUART KING 11 days ago
    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
    ------------------------------



  • 5.  RE: Exchange data between PA models

    Posted 11 days ago
    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
    ------------------------------



  • 6.  RE: Exchange data between PA models

    Posted 11 days ago
    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
    ------------------------------