Planning Analytics

 View Only

  • 1.  Exchange data between PA models

    Posted Wed October 14, 2020 05:17 AM
    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


  • 2.  RE: Exchange data between PA models

    Posted Sat October 17, 2020 07:18 AM
    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
    ------------------------------

    Original Message


  • 3.  RE: Exchange data between PA models

    Posted Sun October 18, 2020 05:30 AM
    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


  • 4.  RE: Exchange data between PA models

    Posted Mon October 19, 2020 08:31 AM
    Edited by System Fri January 20, 2023 04:36 PM
    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
    ------------------------------

    Original Message


  • 5.  RE: Exchange data between PA models

    Posted Tue October 20, 2020 04:36 AM
    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


  • 6.  RE: Exchange data between PA models

    Posted Tue October 20, 2020 06:50 AM
    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