Filter using Selective Access on Line Item Specified as a List
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.