DCA Logic on selection line item

Hi Anaplanners,

I have a module where I want to apply DCA on "a" line item. The logic should be that if no region is checked, all regions should have write access, but if any region is checked, only that selected region should have write access, and the other regions should only have read access. The "Region" list used in this module has no top level.

Any suggestions would be helpful.

Thanks in Advance!

Accepted answers

andrewtye

Hi @Saisri8568

It would be substantially easier to have a parent level on the list then could use that to drive the final boolean for the DCA.

Otherwise would need to have a "fake" single list item and have a module that does something like the below blueprint (but alligning better to Planual)

which then gives these outputs

All comments

rishabh01

Hi @Saisri8568

To do this create a line item for DCA Write driver. The logic for that should be the "if a then true else if a[select:region.all] then false else true"

Make sure to keep the summary of "a" line item as ANY. This should work fine.

Thanks,

Rishabh.

Saisri8568

Thanks @rishabh01 for the answer.

But, what if the list doesn't have any top-level? What should we do in that case?

andrewtye

Hi @Saisri8568

It would be substantially easier to have a parent level on the list then could use that to drive the final boolean for the DCA.

Otherwise would need to have a "fake" single list item and have a module that does something like the below blueprint (but alligning better to Planual)

which then gives these outputs

Quick Links

Can you help?

Unanswered questions

Total Figures for shop based on list item mapped to other lists
Hello I have a calc module (CALC1) structured around a dummy list 1-20, plus a series of dimensions such as Region (1-3) and Shop Type (A-C), plus a timeline. This dummy list lays out a series of revenue adjustments over time based on the dimension categories, such as [+5% revenue for region 1, shop type c across periods…
Data Split between Many to Many Relationship Mappings
Hello Anaplan Community, I am encountering an issue with one of my development work and would be greatly appreciated your assistance. There are 2 different modules involved in my model: 1) INP01 Percentage Input by Product (Applies To: P3 List) 2) REP01 Percentage Split by Department (Applies To: Departments List) The…
Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?