![](https://cdn.prod.website-files.com/664339a221bf85f306dc48c9/66444c69f05692a7e0938dd2_sisense%20gold%20(1).webp)
M2M Designer Restrictions
A plugin that helps you to enforce dashboard restriction when you have a Many to Many By Design model.
![](https://cdn.prod.website-files.com/66435e7e4d5a6affbb7d350e/6643b7e826aeb0d0a6fa0c33_5049b9_03ea9d6463074aa188a3dfef43dbfae3~mv2.webp)
In some OEM cases, you need “Many to Many” by design.
This must be carefully handled to assure single selection in the dashboards. Otherwise, incorrect results & performance issues can arise.
The M2M Designer Restrictions plugin automatically forces single value selection, and offers a carefree environment, in which designers can design dashboards even without being familiar with the M2M connection arising from the cube modeling.
How does it work?
- An admin defines in the plugin config file the M2M fields:
- Set Cube, dimension, and default value.
- Supports multiple filter restrictions. Also over different cubes.
- The plugin automatically adds the filter to each new dashboard based on this cube:
- The filter is locked and cannot be deleted.
- Filter is set to the configured default member.
- Filter behavior:
- The filter forces the designer to Single Selection (multi selection is hidden).
- When a designer tries to click on the selected member (to exclude it for example) - click functionality is disabled, so one value will always be selected.
- Filter cannot be disabled/deleted: Neither in the dashboard filter pane or in the widget filters pane (“disable all filters" option is also hidden).
- Designer can lock the filter or set it as a background filter.
- When the designer tries to add a formula filter using the restricted filter - the plugin applies similar limitation to those he has when he tries to manipulate the filter from the dashboard.
- Groups settings:
- Option to completely hide the restricted filter from specific users groups.
- Option to disable the plugin's functionality for other specific user groups (like Admin).
- Works seamlessly with our Advanced Filters plugin as well.