Dynamic Selection

Samir Jones · 2023-12-12T14:59:56+00:00

There was an error rendering this rich post.

Cloud Version: 12.6 0288217

In a Procedure, I use a Dynamic Selection within a Selection (see screenshot 1).

The cube, the selection is referring to has one entity (DustinUser). But no DustinUser is ticked in the cube. The cube is totally empty.

When running the Procedure (Step 12), all members get selected (see screenshot 2).

When I instead use the Procedure step (Step 13) Select Entity Based on Cube, I get the correct selection, which is None (see screenshot 3).

Is this expected behavior?

Screenshot 1

Screenshot 2

Screenshot 3

Find more posts tagged with

Procedures

Accepted answers

All comments

Leone Scaburri

Hi @Samir Jones,

indeed Dynamic Select translates an empty select into a full selection while the step Select Entity Based on Cube can handle an empty selection. That's why we suggest to use the second option in most of the cases and to use the dynamic approach only when it’s strictly required that the selection is recalculated at every following step by the nature of the calculation.

You can find additional best practices in our article:

https://community.board.com/discussion/16258/selection-options-in-procedures

Samir Jones

Hi @Leone Scaburri,

Thank you for the confirmation.

The Best Practice article you refer to is great, and we use the information when creating our Procedures.

However, the article does not describe that all members get selected with one method, but no members with the other method. That can have a major impact.

Also, one reason we want to use the Dynamic Selection is when we have an Interactive Selection.
If you use the Dynamic Selection prior to an Interactive, the possible members the user can select are not pre-selected.
When using Select Entity Based on Cube prior to an Interactive, all possible members are pre-selected. In some cases we set the option that the user can only select one member, but unfortunately, all members get pre-selected.

Mirela Simion

Hi Samir, for the latter there might be a simple solution helping you
if you add a step - Select entity based on - and after - Interactive selection - there is an option to allow the user to select only one member which would implicitly eliminate the situation when all the members are selected

Hope this helps you