Best way to capture updates on line items and time of updates

Anaplanners,

what would be the best way to capture updates to line items and the date in which line item is updated:-

the ask is if line item is updated we have to capture the date on which it was updated.

So one way I thought of is that if I can replicate the line items with copy line items, and then an action to paste values from input screen to copy line items, while also taking a date of today copy.

But is there a better way to do this ? Or can use any new functionality/feature available ?

Accepted answers

All comments

rob_marshall

@Sachinsourav02

You aren't going to like my answer, but why do you need this? Anaplan is not an ERP or transactional system. What will that date tell you that doing an audit (Show History) of the cell can't give you? Are the requirements needing to know what day someone updated that cell? And what if multiple people updated that cell within the same day since our Date format doesn't go down to the hours/minutes?

If you create an action to "snapshot" the data with a date, you are running the potential of crushing the end-user experience because they will have to run an action which could be a concurrency issue for other users.

I guess at the end of the day, why is this requirement truly needed?

ryan_kohn

Per @rob_marshall, Anaplan is not a transactional system and you will run into issues trying to configure it to be so. It's best to leverage existing native functionality for this.

If you are looking to have a record of changes to data inputs, you can leverage the Anaplan model history to do this.
If you are looking to have a record of changes to the model structure (including formula changes, for example), then you can use the Comparison Report that is generated when you do a model synchronization via Application Lifecycle Management (ALM).

Sachinsourav02

I agree with your fundamental point, Anaplan isn't that kind of a system. However, the use case did make demand such logic, 'end user A' does his or her action in the system based on the inputs from 'end user B'.

Now this is where i wanted to capture the time at which 'End user B' updated the field, so that 'End user A' is aware that field X is updated on XX/XX/XXXX End user A is also not a workspace admin to be able to check model history.

Sachinsourav02

ryan_kohn

Ah, the added context on what you're trying to accomplish certainly helps! It sounds like you're trying to build out a lightweight version of workflow capabilities. A couple suggestions that may offer some inspiration.

You can include a Boolean or a list-formatted status line item that users can set when they are done their work. You can further enhance the usability of this by using a Data Write Action to allow them to date-stamp their completion with a button press, or to populate a specific completion status into that field. @MikhilA also has a nice article on using the data write action in Anaplan.
You can take the above one step further by allowing end users to send notifications to a target recipient using a Notify Action.
You may also be interested to know that end-users can view the history for a specific cell via the UX, in case they want to see the specific date/time the status of an item was changed.

Quick Links

Can you help?

Unanswered questions

Introducing Anaplan Python API SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…