Import (Upload) Action on Break Back line items

Hi - I have a module with three dimensions and have a line item activated with break-back functionality. A specific team from the business will always update the data at a higher level in the hierarchy across three dimensions - and to make it easy, let's presume - we know the higher level at which business updates the data. Even if this is a higher level in the hierarchy, it is not an easy option to update as there are many list members at that level as well. And the COPY-PASTE functionality in NUX is too slow to operate with those many list members - not practically possible, it is consuming a lot of time.

I am thinking of creating an action to upload the data at a higher level in this module on this break-back line item. Is there a way I can achieve this?

Thanks for any kind of help in this regard that will help deal with this smartly.

-Guru

Accepted answers

All comments

Jitendra.Vishnolia

Hey @GuruAP ,

You cannot import data at a higher level in this module on this break-back line item.

Rather you can take the export of all the lower level items (that needs to be updated) and import it back.

Hope it helps.

~Jitendra

GuruAP

Hi Jitendra - this, unfortunately, is not an option because the business stakeholders can't update the data at the granular level. The system is bound to update the data at the lower level based on the break-back functionality as the team has visibility only at a higher level. There is a specific logic of how the data has to be disaggregated to the lower level and that is facilitated in the break-back line item if the team updates the data at a higher level.

Thanks,

Jitendra.Vishnolia

@GuruAP Since its a break back enabled line item and user can't import at a lower granular level, In that case I'm afraid the user needs to update the data manually for each and every combination he wish to update.

GuruAP

@DavidSmith, can you please suggest if you have any ideas here?

Thanks,

DavidSmith

Alternatives to break back is to actually model it - You could have the users import into a module at the higher level and then use the existing data as logic to distribute the data down to the lower level. Depending on how dynamic you need it, you could run an action to copy the "base" each day, or at the beginning of the cycle.

If the end users then need to adjust the "broken back" number you could have an adjustment line item to facilitate that

Hope that helps

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