Adding a user-specific selection to a calculation without using the User list?
Hello, i am trying to find a solution to the following user story:
There are a set of modules for a reporting page that currently consist of multiple dimensions (we cannot use a combined list of only possible combinations due to the users not liking the loss of flexibility). These modules return a calculation that needs to be affected by four user-driven booleans that change the underlying calculation.
The current setup's problem is the booleans are not user-specific and thus if one user makes a boolean selection to change the calculation, this will affect another user's work due to the numbers changing. If we want the calculations to be user-specifically changed, we need to add the user dimension to the modules (which will result in a massive explosion of space consumption which we cannot afford).
Is there a way we can make the booleans user-specific without exploding the model, without changing the current dimensionality of the modules to a combined list, etc? I've thought about replicating the KPIs in a separate module (that will work as a LISS) that has every possible combination of the tickboxes used, and to filter the metric we want to show based on the tickbox selection, but this has a similar space increase, so it's not a viable solution.
Thank you very much for the help in advance!