Planning Analytics

 View Only
  • 1.  TM1 Java API or TM1 REST API

    Posted Wed September 15, 2021 03:51 AM
    Edited by System Fri January 20, 2023 04:14 PM

    ------ Sorry, this post was sent twice -----

    ---- Please follow to the "original post" --> Link

    Hi all,

    in our current project we have the technical requirement to consume TM1 data.

    One part of the requirement is about handling big data, like an export / import scenario (TM1 -> target system). The other part of the requirement is consuming data "on-the-fly", like in a dashboard scenario, where not much data will be retrieved from TM1.

    We started with the "TM1 Rest API" and made good results for the "on-the-fly" scenario, but quickly realize that for the export/import scenario our approach came to a limit.

    From technical point of view, we have a complete "JAVA" stack, which means, that all data requested via the Rest API is handled in some kind of a servlet container and proccesed.

    After "googling" around, we found the TM1 Java API and after a spike solution (Link) we are wondering, which way we should go, should not go or maybe use both APIs?


    We had not much luck asking Google, so maybe someone could give us a little bit more insights or link for more information for questions like:

    • Does the "TM1 Java API" uses internally the "TM1 Rest API"?
    • Is "TM1 Java API" deprecated?
    • For big data import/export and from developemnt point of view: Could there be another approach to "move" data from TM1 to a target system?


    Thank you very much in advance,

    Marco

    ------------------------------
    Marco Spyker
    ------------------------------
    #PlanningAnalyticswithWatson


  • 2.  RE: TM1 Java API or TM1 REST API

    Posted Thu September 16, 2021 03:27 AM
    Hello,

    I have work with java and I think that it use the REST API. But the best way today is to use Python and TM1py. You can easly create view and for big extract, cut the requests in multiples MDX call. Very good product, easy tu use and very powefull

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



  • 3.  RE: TM1 Java API or TM1 REST API

    Posted Thu September 16, 2021 08:04 AM
    Hi Frederic,

    many thanks for your reply.

    Unfortunately, being in a group environment with restriction from IT security and IT landscape, we are not able to use different technologies other than Java.
    And yes,cutting requests in multiples MDX calls is now our big challenge. :-)

    Best regards,

    Marco

    ------------------------------
    Marco Spyker
    ------------------------------



  • 4.  RE: TM1 Java API or TM1 REST API

    Posted Thu September 16, 2021 07:28 AM
    Hi Marco,

    I would recommend using the REST (ODATA) API instead of the Java API.  While the Java API is not deprecated, we do not plan to carry it forward to the next major version of TM1 Server.

    If you are developing in Java you might want to consider investigating something like​ HttpClient (https://hc.apache.org/httpcomponents-client-5.1.x/).

    In regards to moving big data, the best option today is still TI processes.  Note that you can create, update, delete, and execute TI processes with the REST API.

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



  • 5.  RE: TM1 Java API or TM1 REST API

    Posted Thu September 16, 2021 08:17 AM
    Hi Stuart,

    thanks a lot for your answer.

    So, we will stay with the TM1 Rest API and will have an look into the httpcomponents.

    Sorry, for my newbie question, but we have not so much experience with TM1, yet. So, what are TI processes doing and how can we get the results (structure, CellSet). Are they stored in a view, which we can adress via Rest API?

    And for gaining more basic knowledge about TI Processes, could you recommend a link for getting more insights?

    Best regards,

    Marco

    ------------------------------
    Marco Spyker
    ------------------------------