Dynamic Cell Access or line items with formula

debbie5154

I have a module with imported data. Some line items need to be editable and some do not.

to make a line item not editable It seems there are two ways to do this...

1. create extra line item that references, and then hide the line item i don't want to be editable

2. use dynamic cell access

I'm wondering folks opinions of which is best or have I missed another alternative.

Thanks.

Accepted answers

MarkWarren

Hi,
Dynamic cell access is the best option, it's the most flexible and obvious to other model builders in its purpose.
If this is for just an import module, then you may not need to build anything too complex to control the line items you want non-editable (if that status is not going to change). You could just have a single cell boolean value to mark those as read-only.

Here's a list to some tips to get startd with it...

https://community.anaplan.com/t5/Shared-Best-Practices/Dynamic-Cell-Access-Tips-and-Tricks/ta-p/33871

DavidSmith

Just to add, you will need to create a line item subset, and use that in an access driver module to apply the flag to

There is an example on the app hub that illustrates this

https://community.anaplan.com/t5/Learning/Dynamic-Cell-Access-Learning-App/ba-p/33869

Hope this helps

David

All comments

MarkWarren

https://community.anaplan.com/t5/Shared-Best-Practices/Dynamic-Cell-Access-Tips-and-Tricks/ta-p/33871

debbie5154

Thanks so much for taking the time to respond.

DavidSmith

Just to add, you will need to create a line item subset, and use that in an access driver module to apply the flag to

There is an example on the app hub that illustrates this

https://community.anaplan.com/t5/Learning/Dynamic-Cell-Access-Learning-App/ba-p/33869

Hope this helps

David

debbie5154

COOL! THANKS!

Quick Links

Can you help?

Unanswered questions

Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Importing from Data Hub: Incorrect or Missing Mappings in Target Model
When importing data from a Data Hub to another model, I'm seeing values in the target model that don't exist in the source. For example, seller assignments are being tagged with subregions that aren't present in the source data - some assignments are missing expected tags, while others are mapped to seemingly random…
ANAPLAN XL View
Hi, I need help in pulling a specific view in Anaplan XL. The first grid should display attributes of various projects, while the second grid should present the monthly financial data for these projects. Thanks in advance.