How to make a user-accessible history

versilva · 2023-10-25T09:28:49+00:00

There was an error rendering this rich post.

Hello! :)

Is it feasible for the user to store and access previous versions of a module directly in Anaplan?

This concerns the module SKU details that the end user uploads at the start of the year. There are usually a few errors or corrections made in the first few weeks, and I would like to offer the user the opportunity to review those changes he makes

Although I am aware that the user can export the module each time he makes a change, I would prefer for him to view them right away in Anaplan.

Accepted answers

Vamsi_Kaki

Hello @versilva , as per understanding, you would like to show the changes (errors/corrections) made by the user.

Compare the user uploaded data and apply Conditional Formatting.
For this you require 2 line items (Data staging, Data final)
When Users uploads data, Run 2 actions. One to load data from Data Final to Data Staging and another to Load data from file to Data Final.
Now compare both line items data and apply CF on Data Final.
User can easily identify the records that are changed

Thanks,

Vamsi

All comments

Vamsi_Kaki

Hello @versilva , as per understanding, you would like to show the changes (errors/corrections) made by the user.

Compare the user uploaded data and apply Conditional Formatting.
For this you require 2 line items (Data staging, Data final)
When Users uploads data, Run 2 actions. One to load data from Data Final to Data Staging and another to Load data from file to Data Final.
Now compare both line items data and apply CF on Data Final.
User can easily identify the records that are changed

Thanks,

Vamsi

versilva

Hi @Vamsi_Kaki , thenk you very so much for your answer, it was very helpful for my model.

This lead me to 2 more questions:

Is that process still feasible or is it too inefficient if I want the user to access a greater number of iterations?

example:
Version -3 » Imports data from Version -2
Version -2 » Imports data from Version -1
Version -1 » mports data from Final Version
Final Version » Imports data from file
Is it feasible for the user to have both actions run simultaneously with one button only?

Thank you so much :)

Vamsi_Kaki

Hello @versilva , yes it is feasible. Consider you have module dimensioned by Versions, Line items( Data Staging, Data final).

Action1.1 Load data from Data final to Data staging for all line items

Action1.2 Load data from Version2 (Data Final) to Version3 Data Final)

and similarly other actions too.

Hope u understood.

Thanks,

Vamsi

Quick Links

Can you help?

Unanswered questions

How to extract Previous Column Ending Balance as Current Opening Balance (without time dimension)
I want to track the Opening balance, drawdown, and ending balance for the following specific dates. I created the following dates in General List. Then I created the following module to track the balance, which there is a line item called Beginning balance which is the previous value of the Ending Balance. Draw/Repayment…
Has anyone taken a stab at Master Anaplanner Recertification exam yet?
Just curious :)…
Solution for indent diabled for hierarchical list when the page has more than two axis
Hello fellow Anaplaners, I have a question about the UX for Anaplan for hierarchical list. If I have a list with multiple layers, say P1, P2, P3, and P4, and the workpage had 2 axis, list and line items, in its vertical axis and time in its horizontal axis (see figure below) The list is shown without indentations, and may…