Up to now, for a selector, there was only the possibility to display all elements or only the active elements. However, I had the requirement in many projects that the selectable elements should be restricted depending on other filtering.
Reasons could be for example:
- Elements of entities are no longer valid, but should remain historically available (old accounts, old contracts, old rental objects, ...).
- Entities that are in an n:m relationship
- Entities where it does not make sense to pull them together in a tree because the relationship changes and the data has to be shown historically. (slowly changing dimensions)
Desired functionality:
- The selectable elements in a selector shall be restrictable by a cube.
- The display of the maximum elements should adapt accordingly, both for the counter (4/10) and for the percentage.
A comparable function can already be found in the suggested values part of data entry (See Picture).
Examples for desired functionality:
Situation:
- There are two entities: Rental Object and Contract.
- The entity rental object has 10 elements.
- The entity contract has 4 elements.
Case 1:
- Contract 1 and 2 have expired and are no longer active.
- On a screen, the selectable elements of the selector contract can be limited to the active contracts with a selection cube.
- When operating the selector, only contracts 3 and 4 are displayed. Contracts 1 and 2 are no longer selectable.
- The counter displays "2/2" (instead of the current "2/4") and the percentage "100%" (instead of the current 50%).
- If the user selects contract 3, contract 3 is displayed in white and contract 4 is greyed out (as before).
- The counter now displays "1/2" (instead of the current 1/4) and the percentage "50%" (instead of the current 25%).
Case 2:
- The user has filtered to contract 3.
- Contract 3 includes rental objects 1, 2, 3 and 4.
- A mapping cube (contract x rental object) is used to restrict the selectable elements for the rental objects selector to rental objects 1, 2, 3 and 4.
- The counter displays "4/4" (instead of "4/10") and the percentage "100%" (instead of 40%).
- If the user selects rental object 1, 2 and 3, rental object 1, 2 and 3 are displayed in white and rental object 4 is greyed out. The counter now shows "3/4" (instead of 3/10) and the percentage "75%" (instead of 30%).