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.

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

debbie5154

Thanks so much for taking the time to respond.  

debbie5154

COOL! THANKS!