Planning Analytics

 View Only

  • 1.  PAW - Ho to determine the preselected element in the selector widget?

    Posted Thu August 29, 2024 08:26 AM

    Hi,

    I am looking for a way to set the preselected element of a selector widget in a PAW book. 
     
    Specifically, in this case I want the selector widget for the version dimension to show the current plan version when the report gets opened. Originally, only the current version was stored in the subset of the selector widget so it has never been a problem. Now the user should also have the option of selecting a different version.
     
    My approach was to set up the subset in such a way that the current version is always on position 1 in the subset, followed by all other dimension elements. 
    Unfortunately, when the report is opened, the selection remains on the element that was selected when the report was last saved.
    Is there a way to explicitly set the preselected element? Or a workaround to achieve the described behavior?
    Kind regards
    Philipp Gies


    ------------------------------
    Philipp Gies
    ------------------------------


  • 2.  RE: PAW - Ho to determine the preselected element in the selector widget?

    Posted Fri August 30, 2024 12:51 AM

    I have a use case where I want the default selected element to always be the Monday of whatever week it is, but then I want users to be able to select from a list of relevant Past and Future Mondays.

    My incredibly lame work-around involves having two selectors.

    The first is a subset selector where you can choose between two subsets: the default is a subset which contains ONLY the element I want to be the default, and the second is the subset that actually has all of the elements I want.

    The second selector is an element selector that contains all of the elements in whichever subset is selected in selector 1.

    Would love it if something more elegant were possible.



    ------------------------------
    Tom Cook
    tom.cook@actionkpi.com
    ------------------------------

    Original Message


  • 3.  RE: PAW - Ho to determine the preselected element in the selector widget?

    Posted Fri August 30, 2024 04:54 AM

    Same issue with the Year dimension. It's a tricky issue: while PAW allows you to define dynamic sets, the selected value is saved as an hardcoded value within the book (it's something that you'll find in the .json of the book). However if PAW doesn't find the saved value within the set, it will fetch the 1rst member of the set (so that's something you can exploit).

    Ideally we should have a field to define the default selected value with a dynamic MDX expression.



    ------------------------------
    Paul C
    ------------------------------

    Original Message


  • 4.  RE: PAW - Ho to determine the preselected element in the selector widget?

    Posted Fri August 30, 2024 09:05 AM

    I agree that there should be a way to dynamically assign the selected element in the selector widget.  This is something that we will investigate as a possible product enhancement.  



    ------------------------------
    Stuart King
    Product Manager
    IBM Planning Analytics
    ------------------------------

    Original Message


  • 5.  RE: PAW - Ho to determine the preselected element in the selector widget?

    Posted Mon October 07, 2024 10:45 AM
    Edited by Matthias Schmidt Tue October 08, 2024 06:51 AM

    Hi @STUART KING

    Is there an enhance request in the Ideasportal that we could vote for? I have only found this one, which is not under consideration anymore. The possibility to define the preselected element in the selector widget (via MDX) would improve the usability a lot. I really miss this feature. 

    Kind Regards 
    Matthias Schmidt



    ------------------------------
    Matthias Schmidt
    ------------------------------

    Original Message


  • 6.  RE: PAW - Ho to determine the preselected element in the selector widget?

    Posted Tue September 03, 2024 11:18 AM

    Another way I've handled things like this is creative use of aliases.

    Again, mostly date-dimension-based use cases for this in my experience, but I'll have a process that runs nightly as part of the housekeeping chores that, once the current date is ticked over, it will update a specific, dedicated alias and name whatever date it is 'Töday' (with the umlaut on the O so it won't conflict with the reserved word Today), and then set 'Töday' as the default selection in a subset.

    Appreciate that Stuart & team are going to investigate something more elegant for this problem.



    ------------------------------
    Tom Cook
    tom.cook@actionkpi.com
    ------------------------------

    Original Message


  • 7.  RE: PAW - Ho to determine the preselected element in the selector widget?

    Posted Fri September 06, 2024 03:53 AM

    Thank you Tom and Paul for sharing your experience! 

    These are all great workarounds and have been helpful to me.

    Still I'm glad to hear that Stuart wants to investigate this topic with his team!



    ------------------------------
    Philipp Gies
    ------------------------------

    Original Message


  • 8.  RE: PAW - Ho to determine the preselected element in the selector widget?

    Posted Fri September 06, 2024 06:46 AM

    Hi,

    Another possibility, though not fully tested and instinctively not something I like, is to save the book with a version and then delete the version. This will then force the book to look at the first element in the subset.

    But I agree that there should be a way to dynamically assign the selected element in the selector widget, hopefully this will be a feature coming soon to the product!

    regards,

    Mark



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

    Original Message