Is DCA the right way to solve this?

I have module where I need to make the line item formula dependent on user defined criteria. For example, the user selects the material they wish to be use as part of a price quote and the formula for the line item cost calculation changes based on that material, as different materials have different yields. Should I use Dynamic Cell Access or is there a better way to do this?

Accepted answers

All comments

schulze

DCA is about security; I'm not clear how what you are describing requires security. This sounds more like a list of materials in a dropdown list that affects the numerical results of a line item formula.

rob_marshall

Michael,

This isn't DCA, but would something like this work for you?

I have a module of Products and the amounts:

I have another module, defined by Users as well as Products:

I have third module, which will some the data from what has been selected from the previous picture:

Place them on a dashboard:

Different Products selected:

Is this what you are looking for?

Rob

DavidSmith

As @schulze said, DCA is all about read / write / invisible access, and is not related to calculations

On a wider context of "different calculation for different elements (e.g. products), we often see multiple level IFs as and SELECTs as users change the logic for different list elements.

This is not a good appraoch as multiple level IFs are not good for performance. One should look at what actually changes for each element and model those using LOOKUPs and mapping modules.

In extreme cases where there is a complex formula, a good appraoch is the calculate the different variables for all products and then use a line item subset to pull those into the target module, again using a LOOKUP module. This is especially good when the usersd are able to choose the calculation method they want

Hope this helps

David

Chamanpreet

I think you should go with Dependent drop down list concept instead of DCA.DCA is more on particular cell access.

Quick Links

Can you help?

Unanswered questions

Cloud works on UX page
I am unable to see the cloudworks integration on the UX page. Can you advise what I am doing wrong
how to count how many times an action has run?
I want to create a line item which will increment by 1 every time an action is run manually. This action is an import which doesn't involve any file upload to anaplan. The module where I want this line item has users list & SKU list dimension. No time. So basically, I want to track how many users have selected an SKU and…
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…