Planning Analytics

 View Only
  • 1.  Move code from generated area in TI process

    Posted Mon July 06, 2020 03:57 PM
    Hi,

    By mistake some processes have been programmed in TI within the generated area. This was not a problem until after latest update of TM1 and PAW.  The code within the "#****Begin: Generated Statements***  AND #****End: Generated Statements****"  is now locked for change and can not be changed or moved out of this area. Do you know if this is a setting in the latest versions that can be changed or a good way to fix this?

    ------------------------------
    Habbi
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: Move code from generated area in TI process

    Posted Mon July 06, 2020 07:12 PM
    Regarding product versions (if it matters). In this case the PA version is 2.0.9 IF2 and PAW version is 2.0.52.

    ------------------------------
    Hallbjorn Bjornsson
    ------------------------------



  • 3.  RE: Move code from generated area in TI process

    Posted Tue July 07, 2020 11:04 PM
    Hi, 
    as far as I know, the code between

    #****Begin: Generated Statements***  AND #****End: Generated Statements****

    cannot be changed manually. It is written by system when you do something (by wizard). You have to back to how you create it and do correction there. 
    For example

    #****Begin: Generated Statements***
    DIMENSIONSORTORDER('Areal_Type','BYINPUT','ASCENDING','BYINPUT','ASCENDING');
    #****End: Generated Statements****

    above code formed by system when I set a variable as consolidation

    Regards,
    Veronika

    ------------------------------
    Veronika Gultom
    ------------------------------



  • 4.  RE: Move code from generated area in TI process

    Posted Wed July 08, 2020 05:43 AM
    There is an established way to handle this:
    if(1=0);
    #****Begin: Generated Statements***
    DIMENSIONSORTORDER('Areal_Type','BYINPUT','ASCENDING','BYINPUT','ASCENDING');
    #****End: Generated Statements****
    endif;

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



  • 5.  RE: Move code from generated area in TI process

    Posted Wed July 08, 2020 05:55 AM
    Hi Veronika.
    It is true that this section can not be changed in Architect. But in previous versions of PAW this section has unfortunately been open for editing, until latest release that we upgraded to. In this new release this section is locked as should be.

    ------------------------------
    Hallbjorn Bjornsson
    ------------------------------



  • 6.  RE: Move code from generated area in TI process

    Posted Wed July 08, 2020 06:00 AM
    The workaround that I found and used was to go into the .PRO file in the DATA folder and move the #****End: Generated Statements**** in notepad. When I did this and got the TI code out of the generated area then everything is editable.

    Thanks for your attention and responses Veronica and David.

    Habbi


    ------------------------------
    Hallbjorn Bjornsson
    ------------------------------



  • 7.  RE: Move code from generated area in TI process

    Posted Wed July 08, 2020 10:06 AM
    Just be careful on that approach. All of those seemingly random numbers serve as markers and settings tm1 needs. In some cases they indicate line numbers.

    I would look at using a safer tool like Arc for TM1.

    Ryan Clapp
    AWS Business Systems
    Sr. Manager

    Sent from my mobile device