I have a data set I would like to open to end user with a line item (Cost Center) set as a list(also cost center) with Selective Access enabled. I would like the functionality to filter the data set so that end users will only gain access to their respective Cost Center(s).
I know the workaround for adding cost center as a dimension, however this greatly increases sparcity and due to the size of the cost center list is detrimental to system performance.
I'm open to other workarounds that don't impact performance.
Adding a list as a dimension only to be able to "filter" is often used. However it's good to know that this additional dimension is only necessary as the module dimension and on the filter line item, not all of the line items in the module.
For example if you are talking of an employee list in the cost center, not all the employee's data need to have that dimension: name, function, start date, annual salary need not to be applied the additionnal cost center dimension.
ps: "with a line item (Cost Center) set as a list(also cost center)" -> what do you mean by that ? It's unclear to me