Reset a line item

Hello all,

I do not find the corresponding course, but during training for MB certification, it was said that the best practice to reset values of a line item (numeric or boolean for example) was to create a line item with no data as format, and to import this line item into the first one.

I would like to reset a user validation boolean, on a module dimensioned by 2 subsets: POS and products. I noticed that reset action on line item dimensioned by full lists works correctly, but as soon as a subset is involved, the reset does not work anymore. Can anyone please confirm this, or at least tell me how to make it work with subsets?

It is annoying for me to use a boolean line item with FALSE value to reset the validation boolean, since each line item has more than 70 millions cells (and this value could grow up).

Thanks a lot for your help 🙂

Accepted answers

EmmelineM

hello @KirillKuznetsov

There is no error but my boolean is still true.
I just selected "clear target prior to import" instead of "only update imported cells" and it seems to reset the boolean line item correctly now. I suppose this was the reason why the reset didn't work before (which I don't fully understand, since in each dimension I select to clear matched items in source prior to import).

Thanks for your time 🙂

All comments

KirillKuznetsov

@EmmelineM

Could you please show what error you get saying that "the reset does not work"? Or there is no error and it's just not loading any value?

Have you tried to load from a line item with subsidary view (w/ no dimensions) using saved view on all dimensions of this module?

EmmelineM

hello @KirillKuznetsov

Thanks for your time 🙂

Quick Links

Can you help?

Unanswered questions

Curious Comparison: Forecast Modeling for Unusual Products
I've been experimenting with some forecast modeling techniques in Anaplan recently and decided to test them on a few quirky, offbeat product categories just for fun. One of the categories I played around with was love dolls—yes, you read that right. It actually turned out to be more interesting than expected. Unlike…
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.…