Planning Analytics

 View Only
  • 1.  Display Attributes and/or Drill Through result in a dedicated window/widget/sheet in PAW

    Posted Wed September 22, 2021 11:28 AM
    Hello Community,
    We're building an assessment application for the business and on the main data entry screen we've got a grid with on rows all the customers.
    Ideally, what we would like to have is the ability, when you're entering data on a specific row for a dedicated customer, to have a widget on top of the screen displaying a bunch of attributes linked to the customer (name, address, number of employees, average income...).

    AFAIK, synchronization mechanism in PAW only works with selector, not with row selected elements and there no way to trigger an event on a mouse click?

    The best solution I've found at this time is to have a "drill through" which works pretty well except that the "drill trhough" result cannot populate a PAW widget/view or be on a separated browser window. It's just display a modal popup .
    Anyone had the same kind of need ? What kind of solution could you propose ?

    Thanks in advance.

    ------------------------------
    Bob
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: Display Attributes and/or Drill Through result in a dedicated window/widget/sheet in PAW

    Posted Wed September 22, 2021 02:10 PM
    Hi Robert,
    I have been looking into that possibility and I do find  the ability to add the drill results to the book would be beneficial, the drill through view would need to be synchronized with the row selected indeed, it is not available yet - correct.
    I have not been thinking about the possibility to open  the drill through view in a different browser, do you see it as multiple browser opened per each row being selected?

    Best Regards,

    ------------------------------
    Svetlana Pestsova
    ------------------------------



  • 3.  RE: Display Attributes and/or Drill Through result in a dedicated window/widget/sheet in PAW

    Posted Wed September 22, 2021 02:45 PM
    Edited by System Fri January 20, 2023 04:34 PM
    Hi Svetlana,
    Thanks for your answer. 
    I totally agree with you, a synchronized Drill view will be far more convenient. BTW, a while ago we were using an old TM1 Web heavy client called Executive Viewer, which Hubert Heijkers knows quite well, which was working like this: each time you were clicking on a cell, the drill through process was fired and the display was refreshed :-)
    Having the drill opened in a separate window will at least allow to enter the assessment with the customer information visible. The way it works actually will force you to close the drill window in order to be able to enter data in the grid beneath so the only way to be able to do both (have the detailed customer information and filled in the assessment) is to take a screen shot, close the drill window and start typing.
    Regards,

    ------------------------------
    Bob
    ------------------------------



  • 4.  RE: Display Attributes and/or Drill Through result in a dedicated window/widget/sheet in PAW

    Posted Thu September 23, 2021 02:45 AM

    Not an all the way solution but......

     

     

    Using a websheet you can use the CELL function to pickup the currently active cell.  From there an action button can set a hidden subnm equal to the selected cell.  From there you can synchronize that hidden subnm to your widgets in PAW.

     

    While there is likely no way to hook into the mouse click this would get the same results as a drill but would require an action button click instead of a right click and drill through.  And yes would require a websheet vs a PAW Grid View.

     

     






  • 5.  RE: Display Attributes and/or Drill Through result in a dedicated window/widget/sheet in PAW

    Posted Thu September 23, 2021 04:03 AM
    Thanks Robby for your answer,
    I've already tried to follow the CELL function path in a websheet used in PAW but didn't have the idea of the "hidden subnm" stuff. 
    Maybe I'll give a try in order to see if the rendering is better from the solutions I've already tested (drill, synchronized views...).
    The point is users are so used to have clear, straight forward web interface that it's hard for them to understand why we can't reproduce such a "classic" behavior (master/slave display) in PAW !
    Regards,

    ------------------------------
    Bob
    ------------------------------