0

Multi Select (All) parameters

  Multi Select (ALL) parameters.

 

If you have this selected to all for a dashboard, after a while new elements are added however the (ALL) selection now only selects the elements which were there when the parameter was created. 

 

is it possible that (all) also includes new elements added after model runs.

 

For example since building this dashboard below (and have team selected as all in the parameter selection), a new team has added but by default is not included (transactional liability), to counter this we need to go and edit the dashboard, go into the parameter and select all again.

 

Thanks

 

Nick

1 reply

null
    • Senior Director of Product
    • Ian_Macdonald
    • 2 yrs ago
    • Reported - view

    Hi Nick,

    Best way to accomplish this would be to construct a dynamic List of the items in your Hierarchy thus:

    Then use this list, M List in this case, to populate the slicer or parameter. If you look at the PQL code behind the scenes, you will see that creating a dynamic list in this way uses the PQL function AllMembers(). At run time, this function will be called to return all the members of the specified hierarchy, including any that have been added over time. In this case the PQL is:

     

    Hope that helps.

    Ian

Login to reply

Content aside

  • Status Answered
  • 2 yrs agoLast active
  • 1Replies
  • 29Views
  • 2 Following