Selectors - Active Selection

Jordi Vilamajo · 2025-05-19T10:22:49+00:00

There was an error rendering this rich post.

Hi,

We have a Selector on a screen which shows the Active Counter and Active Percentage. The entity of this selector is previously prefiltered by a On Open Trigger procedure. This makes it display 20/50 elements even if the user has not Selected anything.

From the user point of view, he/she should only see 20 elements. And 20 should be 100% selection. The user may have no knowledge of all the elements in the DataBase beyond his 20 elements. He should only see the % of what he/she can access. Is there a way to show correctly the Active counter?

If no, we should hide the Active counter and Percentage as they are confusing. But in that case, is there a way to display that a filter is simply active, like the small icon we see in Excel or PowerBI when a field is filtered?

Thanks

Find more posts tagged with

Accepted answers

All comments

Samir Jones

Hi @Jordi Vilamajo,

If the User should never see more than the 20 elements, maybe you can use the Security Filter in the Database Security. That way, the user will only have access to the 20 elements regardless of where they navigate, associated with the same Data Model.

Jordi Vilamajo

Thanks Samir. That solves the issue.

But we have some particular cases where where we would need something extra. For exemple, we have the TopVendor entity, which shows the main vendors; this list varies from FY to FY. Therefore total available elements, always includes vendors of all FY. But we would like to have a list limited to the FY selected by default in the template. Is there a way to solve this?

Samir Jones

One way, but it will need to be setup on each screen, is to have a dynamic selection on the screen on entity TopVendor based on a cube with entities TopVendor and Fiscal Year.

It might not fulfill your requirements 100 %, because the TopVendor selector on the screen will only grey out the members that should not be available for the selected FY.
If you enable "Show only active members", the non-available members will no longer be greyd out. Instead you will only see the available members in the list until you make a TopVendor selection. Then you will only see the selected TopVendor. To return to all possible selections, the User need to reset the selector.

PS. I have tried to use the cube with TopVendor and Fiscal Year directly in the Security Filter, in hopes to create a dynamic solution, but it doesn't work.

Jordi Vilamajo

Yes, we have reached the same conclusions. No solution fulfils completes our situation. This makes the interface a bit unclear for the user.