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.

Thank you,

Mark P

Accepted answers

All comments

nathan_rudman

Hi,

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

AvnishGoel

Hey, did you get answer to your question. If yes, I will appreciate if you can share answer. I need similar functionality

CommunityMember126793

@AvnishGoel , I am unsure if original post got the work around or not but if u stuck in the same situation then u may probably use "List Subset" to shrink the list size (as dimension) in the module and have only selected employees.

Now, refreshing the ListSubset can be achieved through the process (as and when employees data refreshed / imported OR through dashboard who is permitted to control such data) so that u always get the latest mapping.

Share screen - print if above not answered the query

DaanishSoomar

Hello all! Yes there is a way to accomplish this @mpeck. If you go to blueprint view, find the line item format, and open the pop up with the line item format, you can enable the filter via Selective Access option here. You don’t need to enable the Dependent feature for this purpose just Selective Access. This method also assumes you have Selective Access setup in the General Lists and in the Users tab for the list formatted line item.

Let me know if this helps! https://help.anaplan.com/en/8c73d9b8-414b-4c71-a262-c0c464d1e7ab-Selective-Access-and-Dependent-Relationships

DaanishSoomar

See my reply below! Let me know if this helps @Pelicancan @CommunityMember126793

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…