Planning Analytics

 View Only
  • 1.  PAW Workbench: Saving rule without committing it

    Posted Thu September 14, 2023 10:42 AM

    Hi,

    To bring adoption of Workbench in my team, I connected with few developers to seek feedback on it. I got something interesting.

    They prefer writing code in notepad++ and then copy/paste to TM1. Since it is offline, it is flexible with all sorts of things. On the other hand, saving rule commits immediately. It could block them from further appending it. Once rules are being applied, it is difficult to stop. They want flexibility in writing rules so that they could save their work without committing, come back and change as they want. Something like, saving without committing. I have personally used Workbench and it is tremendously helpful with color coding, ability to comment/uncomment, snippets etc. This one option to save without commit, could make it even better. 

    I am seeking thoughts from other people in this. Thanks!



    ------------------------------
    Subhash Kumar
    ------------------------------


  • 2.  RE: PAW Workbench: Saving rule without committing it

    Posted Thu September 14, 2023 12:33 PM
    Edited by Mark Wragg Thu September 14, 2023 12:38 PM

    Hi,

    Sorry, I see you were asking to save a workbook, not the actual rule, which to my mind would be crazy. So I scrubbed my original reply.

    Still not convinced by the idea though.

    regards,

    Mark



    ------------------------------
    Mark Wragg
    ------------------------------



  • 3.  RE: PAW Workbench: Saving rule without committing it

    IBM Champion
    Posted Tue September 19, 2023 10:48 AM

    Hi,

    To be completely honest, I don't understand why developers would find it easier to write rules in notepad than in workbench. With syntax check, shortcuts to functions, elements and validations, I can't see that there would be an advantage in it. Writing in notepad there would be no checks, and the risk of errors with finally saving would be substantial. 

    If the need is code review before rules are committed, could a solution perhaps be to work on a test instance and then use git to move to production?

    The developers could also write rules in the workbench, and not save but instead copy to notepad. But again, I probably don't understand the need to work with rules over a long period of time, without saving (and validating) them.



    ------------------------------
    Emil Malmberg Fosdal
    Solution Architect
    CogniTech A/S
    ------------------------------



  • 4.  RE: PAW Workbench: Saving rule without committing it

    Posted Tue September 19, 2023 03:49 PM

    Hi all,

    I agree that Workbench should allow better code validation, 

    as it was mentioned above, the whole rule script could be commented/uncommented out with the one button click, so it won't have the impact on the data movements. The old compiled rule could work with the new commented out area.

    Additional bonus is that the object names from the data tree could be copy/paste into the rule script minimizing the errors with the elements carrying in the whole hierarchy expression with the correct syntax.

    However, I'd like to get the ideas still in case there is something productive what could be used further.



    ------------------------------
    Svetlana Pestsova
    IBM Planning Analytics Product Manager
    ------------------------------



  • 5.  RE: PAW Workbench: Saving rule without committing it

    IBM Champion
    Posted Wed September 20, 2023 07:45 AM
    Edited by Emil Malmberg Fosdal Wed September 20, 2023 10:10 AM

    @Svetlana Pestsova,

    In the old rule editor there where a "Validate" button, that would validate the rules, without saving. Getting that feature in the new editor, would address the risk of committing invalid rules.

    Would that be something that could be reintroduced?



    ------------------------------
    Emil Malmberg Fosdal
    Solution Architect
    CogniTech A/S
    ------------------------------



  • 6.  RE: PAW Workbench: Saving rule without committing it

    Posted Wed September 20, 2023 02:35 PM

    Hi Subhash, Mark, Emil!

    Developers do have a point, as usual;-), I see that they want.

    We'd investigate how we could implement something like "rule reservation" and keep it as some tentative rule file as a blob probably before tm1 executes it.

    P.S. With the "Validate" button we just were checking for errors in rule and notify the developer on the error and its line. Now the "Save" button is doing the same check/notification. 



    ------------------------------
    Svetlana Pestsova
    IBM Planning Analytics Product Manager
    ------------------------------



  • 7.  RE: PAW Workbench: Saving rule without committing it

    IBM Champion
    Posted Thu September 21, 2023 10:28 AM

    @Svetlana Pestsova the issue with validation being integrated int the save button, is that the invalid rules are saved, meaning at all rule calculations will be deactivated until the error is fixed. With "Validate" one could check for errors - > correct them -> validate again -> the save valid rules.

    It would be nice to get back :-)

    It could also be a "Error in rules, continue saving?" prompt, if errors was detected. Then you could abort saving the rules, correct and save again.

     



    ------------------------------
    Emil Malmberg Fosdal
    Solution Architect
    CogniTech A/S
    ------------------------------



  • 8.  RE: PAW Workbench: Saving rule without committing it

    Posted Fri September 22, 2023 01:49 PM
    Edited by Svetlana Pestsova Fri September 22, 2023 02:00 PM

    Hi Emil,

    We do have the prompt if the errors are found in the rule, so the developer could see that, say No, go back and correct errors that are indicated with the red marks on the left at the line.

    There is also the Undo shortcut keys while editing such as Ctrl+z and Ctrl+y.

    However, we will re-introduce the Validate button to make it clear separation indeed, also the idea of the developing pad for the rule on Dev environment and be able to compare side by side is the one that could be quite useful.

    Best regards,



    ------------------------------
    Svetlana Pestsova
    IBM Planning Analytics Product Manager
    ------------------------------