Planning Analytics

 View Only
Expand all | Collapse all

Migration to v12 instructions

  • 1.  Migration to v12 instructions

    Posted Tue February 04, 2025 02:36 PM

    Preparing to perform a migration to v12 from v11.  The instructions for actually running the migration script seem to be out of date with migration download tool.

    Has anyone recently run the migration utility to migrate v11 to v12 objects?  Is there an updated instruction set?  (IBM Bueller? IBM Bueller?)



    ------------------------------
    Ty Cardin
    ------------------------------


  • 2.  RE: Migration to v12 instructions

    Posted Wed February 05, 2025 10:39 AM

    Can you say a bit more? Would expect the main doc here to be kept up to date.



    ( https://www.ibm.com/docs/en/planning-analytics/2.1.0?topic=SSD29G_2.1.0/com.ibm.swg.ba.cognos.planning_analytics_engine.2.0.0.doc/pa_engine_migrating.htm )



    ------------------------------
    Ted Phillips
    IBM
    ------------------------------



  • 3.  RE: Migration to v12 instructions

    Posted Wed February 05, 2025 10:43 AM
      |   view attached

    Hello,

    I try and succed last day to try migration from V11 to V12.

    IBM doc is obsolete and you no more need git on windows.

    I write a doc for myself ( in french sorry), perhaps it will help you.

    Regards,

    Philippe



    ------------------------------
    Philippe CHAMPLEBOUX
    EPM Project director
    Next Decision
    NANTES
    ------------------------------



  • 4.  RE: Migration to v12 instructions

    Posted Thu February 06, 2025 03:36 AM

    Hi Philippe,

    You are correct, the docs referenced by Ted are out of date, I've seen an internal update from our doc writers dated the 25th of Jan but not sure when that version gets published and replaces the public one (hopefully soon, albeit I've not checked if that one is really up to date;-).

    Happy to see you work it out, a lot has indeed changed under the covers and the GIT dependency is indeed gone. If you run into any more issues or have any other questions wrt migrating don't hesitate to reach out to me directly.

    Cheers,



    ------------------------------
    Hubert Heijkers
    STSM, Program Director TM1 Functional Database Technology and OData Evangelist
    ------------------------------



  • 5.  RE: Migration to v12 instructions

    Posted Thu February 06, 2025 08:21 AM
      |   view attached

    UPDATE: Turns out those latest docs aren't up to date either, I've notified our information developer accordingly. 

    My French is far from perfect but I think you got the most important changes, most notably that it no longer is a bash script but rather an executable. I've attached a PDF version of the 'internal' version of the doc, the content we share with our information development as well, so you have the latest we have.

    Again, if you feel something is missing/lacking, let me know, I hate to admit that documentation often only gets improved when asked, so just ask;-! 



    ------------------------------
    Hubert Heijkers
    STSM, Program Director TM1 Functional Database Technology and OData Evangelist
    ------------------------------

    Attachment(s)



  • 6.  RE: Migration to v12 instructions

    Posted Thu February 06, 2025 08:31 AM

    Thanks Hubert,

    I'm now completely reassured about my ability to carry out this kind of migration in the future.
     
    Just one question: if I wanted to migrate from AWS to on premice (silly, isn't it), would I have a solution for doing so?
    Kind regards,
    Philippe


    ------------------------------
    Philippe CHAMPLEBOUX
    EPM Project director
    Next Decision
    NANTES
    ------------------------------



  • 7.  RE: Migration to v12 instructions

    Posted Thu February 06, 2025 09:54 AM

    Once you are on TM1 v12 you can simply create a backup of your TM1 database and restore it on any other TM1 v12 service instance (on-cloud, on premise, containerized or local, Windows or Linux).



    ------------------------------
    Hubert Heijkers
    STSM, Program Director TM1 Functional Database Technology and OData Evangelist
    ------------------------------



  • 8.  RE: Migration to v12 instructions

    Posted Tue February 11, 2025 09:11 AM

    Hello Hubert,

    I am sorry,  I meant to say migrate from V12 to V11  is it possible ?

    Regards,

    Philippe



    ------------------------------
    Philippe CHAMPLEBOUX
    EPM Project director
    Next Decision
    NANTES
    ------------------------------



  • 9.  RE: Migration to v12 instructions

    Posted Wed February 12, 2025 04:32 AM

    If you have an active v12 environment you can push and pull objects from any REST endpoints. 

    For IBM Planning Analytics this includes:

    v11 to v11

    v11 to v12

    v12 to v11

    It is not as clean cut as the migration utility but it does enable hot promotion between environments etc..



    ------------------------------
    Edward Stuart
    Solutions Director
    Spitfire Analytics Limited
    Manchester
    ------------------------------



  • 10.  RE: Migration to v12 instructions

    Posted Fri February 14, 2025 06:24 AM
    Edited by Hubert Heijkers Fri February 14, 2025 06:24 AM

    Hi Philippe,

    The short answer is 'No', despite what Edward is saying, unless you are using TM1's GIT integration and have a repo that has no dependencies on specific functionality in TM1 v12 or rather functionality that is no longer supported in TM1 v12 (typically still a 'No' as I'd expect everybody has to do some migration - same/similar limitations apply to what Edward proposes). 

    But the bigger question IMHO would be why would you ever would want to do that to begin with?

    Cheers, 



    ------------------------------
    Hubert Heijkers
    STSM, Program Director TM1 Functional Database Technology and OData Evangelist
    ------------------------------



  • 11.  RE: Migration to v12 instructions

    Posted Sun February 16, 2025 03:55 AM

    Hi Hubert,

    I know this may sound like a strange question, but when we're dealing with prospective customers, I'm often asked the following question: "What about reversibility? If I choose one type of implementation, can I change it later?"
    And then, in the jungle of prices .... Basically, AWS is more expensive than IBM Cloud, which is only authorized for 65 users or more....So I have to be very careful, and try to advise my customer on the best architecture for his needs, and the possibility of changing (or not changing) the architecture;
    In conclusion, I'd say that you can migrate from v11 to any environment/implementation, and that V12 is still V12, whether it's saas or hybrid; that there are ways of moving from saas to v11, but that it's complicated.
     
    Sincerely,
    Philippe
     


    ------------------------------
    Philippe CHAMPLEBOUX
    EPM Project director
    Next Decision
    NANTES
    ------------------------------



  • 12.  RE: Migration to v12 instructions

    Posted Mon February 17, 2025 07:48 AM
    Edited by Hubert Heijkers Tue February 18, 2025 04:04 AM

    Hi Philippe,

    Understand where you are coming from and agree nothing is impossible, I'd just be very curious to know if there was any TM1 specific technical/functional reason for moving back from a TM1 v12 based solution to TM1 v11 (I understand there is differences in clients/supported clients that might play a role as well). Keep in mind though TM1 v11 is in maintenance mode, and has effectively been for years now, all new development, and therefore all new functionality, goes into TM1 v12.

    Cheers,



    ------------------------------
    Hubert Heijkers
    STSM, Program Director TM1 Functional Database Technology and OData Evangelist
    ------------------------------



  • 13.  RE: Migration to v12 instructions

    Posted Thu February 06, 2025 06:41 AM

    I have used ExecuteHttpRequest in v12 to pull objects from v11

    Primarily I have used it for Dev to Prod hot promotion for v12 customers (and object difference checks) but another use case is to migrate from v11 to v12 in a staged and controlled manner

    Will run a live session at the UK Technical Forum in May (subject to confirmation) but will also run webinars on the topic.

    Happy to jump on a call to get you started or list out the steps if this is of interest



    ------------------------------
    Edward Stuart
    Solutions Director
    Spitfire Analytics Limited
    Manchester
    ------------------------------



  • 14.  RE: Migration to v12 instructions

    Posted Thu February 06, 2025 08:10 AM

    We figured out how to run it from the command line and it ran fine.  Had some object rejected that were expected (processes that use Cube...LogChanges & CubeSaveData).  A couple of other items were easily explained.

    Hubert, thanks for the update on the docs.  Kind of stopped us for a bit, but we got it and moved on.



    ------------------------------
    Ty Cardin
    ------------------------------



  • 15.  RE: Migration to v12 instructions

    Posted Sun March 23, 2025 09:20 AM

    Hello, 
    while migrating, I may had some issues with views being empty or "invalid" in terms of PAW, however, not in terms of Architect because Rows or Columns were empty. 
    After deleting such views, I could migrate without any issues to v12. 

    Is it a real issue or do I miss sth?

    What about your experience with migrating? 

    Thanks in advance. 



    ------------------------------
    Vitalij Rusakovskij
    ------------------------------