Read access and write access driver query.

Hi,

I used read access driver and write access for a line item to get the dynamic cell access. (calculation formula is used to get the data for this line item) .

1)It is not working though I used DAC concept

2)Quaterly data is also not displaying for that line item though I changed summary items to ALL or ANY from None.

Accepted answers

DavidSmith

If I'm have understood correctly, you wanting to edit the line item that has a formula?

If that is true then you can't do that (with or without DCA)

DCA allows editing line items that do not have a formula

line items with formulas cannot be edited

If this is not the case you outline the whole process, as I suspect you may have (or need to have) a manual entry line item to account for the rejected lines.

In terms of the quarter no showing, try setting the summary option to ANY for the drivers

David

All comments

DavidSmith

@pradeep

I think this is a duplicate of your post yesterday

David

pradeep

Nope David, Yesterday what you said is true it worked for line item which is generated by not using calculation formula. One straight thing will Dynamic cell access work for line item which is generated by using calculation formula.

DavidSmith

DCA works for all line items whether manually entered data or calculated through a formula

Are you having a specific issue?

If so, could you post some screen shots?

David

pradeep

hi @DavidSmith ,

I am attaching shots to this body

here i rejected july data so it is showing as zero, if it got rejected then it should be editable in units sold.

I am not able to edit this one and quaterly data is also not showing .

DavidSmith

If I'm have understood correctly, you wanting to edit the line item that has a formula?

If that is true then you can't do that (with or without DCA)

DCA allows editing line items that do not have a formula

line items with formulas cannot be edited

If this is not the case you outline the whole process, as I suspect you may have (or need to have) a manual entry line item to account for the rejected lines.

In terms of the quarter no showing, try setting the summary option to ANY for the drivers

David

Quick Links

Can you help?

Unanswered questions

OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385