Dynamic Cell Access or line items with formula

Contributor

Dynamic Cell Access or line items with formula

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.

Message 1 of 5
4 REPLIES 4
Highlighted
Expert

Re: Dynamic Cell Access or line items with formula

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/3387...

 

Message 2 of 5
Contributor

Re: Dynamic Cell Access or line items with formula

Thanks so much for taking the time to respond.  

Message 3 of 5
Community Boss

Re: Dynamic Cell Access or line items with formula

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

Tags (1)
Message 4 of 5
Contributor

Re: Dynamic Cell Access or line items with formula

COOL! THANKS!

Message 5 of 5