Displaying Line items by user or role

Hi,

I have an issue I'm trying to solve. I have a module that multiple users have access to. I don't want all the users to see all the line items. I need to hide 2-3 line items for certain users or roles.

Another module without those line items is not an option.

Is there a way to this?

Thank you
Ronit

Accepted answers

helennie

Hi, unfortunately as you mentioned above, line item subset filter is not an option for you since this is text, and that's the only way I know of to create the type of dynamic line item filtering that you're looking for.

As a workaround, you can publish the module to different dashboards, which you can give to the different roles. Disable the option to open the source module so that users can only access on the assigned dashboard. It's not an elegant solution, but it works, at least within Anaplan. (Please note that users would still be able to back into the full module via the Excel Add-in.)

All comments

Tiffany.Rice

Have you considered creating a user dimensioned filter module based on a line item subset? You can create the line item subset based on the target module and then create Boolean based user filters which then get applied to that target. See the following article (Filters section) for more info: https://community.anaplan.com/t5/Best-Practices/Line-Item-Subsets-Demystified/ta-p/54309

CommunityMember127578

Some of the line items are text formatted so I can't use line item subset

Misbah

@CommunityMember127578

As @Tiffany.Rice suggested, it is definitely possible. Please go through the article and hover Filter section of the article. You should be able to develop it.

Thanks,

Misbah

CommunityMember127578

Some of the line items are text formatted so I can't use line item subset

Harsha

@CommunityMember127578

Just a thought on this, I think you can use DCA.

1. You can create a separate module with users as dimension

2. Create Boolean line items

3. If you want use user role for the condition then please import users data into module.

4. write a logic to check boolean line items as per your requirement.

5. use these line items as DCAs.

For DCA: https://community.anaplan.com/t5/Videos/Dynamic-Cell-Access/ba-p/46517

Hope this helpful.

Thanks,

Harsha

CommunityMember127578

thank you for the replay. I tired this but it doesn't make the headline invisible to the users, just the cell content.

I have project names as a numbered list and the Description and Division are line items. I don't want some users to see the Description column at all.

helennie

Quick Links

Can you help?

Unanswered questions

RANKCUMULATE not working when adding additional dimensions to module
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
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…