Change structure List

Hi Teams,

 

I have data using List L3 but in next month(Feb 20) the structure will be change, but structure and data in previous month(Jan 20) not impact, like a picture bellow

 

Panji_0-1590567919893.png

 

can we do that in anapan?

 

Thank,

 

Panji

Tagged:

Best Answers

  • Misbah
    Answer ✓

    @Panji 

     

    It is a typical example of Effective Dating use case where in you store the history for the change. Please go thru this video tutorial - 311 and see if this helps

     

    Effective Dating - Anaplan Community

  • rob_marshall
    Answer ✓

    @Misbah ,

     

    It can be done with filters, but you are also correct it can be done using effective dating, it depends on the use can and what is moving as in what level.  If you want to use filters it can be done in the below manner:

     

    I have a hierarchy that is theoretically 9 levels deep, L1->L9, but in this case, I want my hierarchy to stop at L8 and then by "L9" is actually all detailed members in a flat list.

     

    2020-05-28_07-06-11.png 

     

    Create a module (Assigning Parent) that is dimensionalized by L9 Flat and Time as this will show the "movement" of the L9 member.  In this module, I have two input line items, Parent and Data.

     

    2020-05-28_07-10-17.png

     

    In a 2nd module, I have what could be a fairly large module which is dimensionalized by L8, L9 Flat, and Time with the following line items:

    Data: Assigning Parent.Data

    Filter?: CODE(ITEM('CC L8')) = Assigning Parent.Parent Code

     

    Note, if this was done according to best practice, I would have created the code in a SYS L8 Properties module instead of doing the code here and just referenced that line item.  Reason being, "figuring" out the code of L8 as I have it is actually over dimensionalized as the code of L8 will not change over time nor CC L9 Flat.

     

     

    2020-05-28_07-12-39.png

     

    Create a 3rd module named Time Dependent - Summary dimensionalized by CC L8 and Time with one line item Data.

    Data= Assigning Parent.Data[SUM: Assigning Parent.Parent]

     

    2020-05-28_07-18-41.png

     

    Now on the old UI, you can publish the all three

    2020-05-28_07-20-27.png

     

    On the Time Dependent Data module, create a view based on Filter?

    2020-05-28_07-21-55.png 

     

    So now, the only data that will be shown and calculated will be based on the "input" of the parent information entered in the Assigning Parent module.

    2020-05-28_07-23-45.png2020-05-28_07-24-09.png

     

    So, what is so slick about this, there are no actions created at all, just filtering on data that has been entered as the "parent".  This won't work for every instance of effective dating, but it will work on most.

     

    You can then get "fancy" and create an action at the beginning of the month to copy the previous months assignments to the new month, and then if there are changes, you just modify the changes.

     

    2020-05-28_07-28-40.png

     

    So after I run it:

    2020-05-28_07-29-37.png

     

    Hope this helps,

     

    Rob

Answers

  • Hi @Panji ,

     

    This can be easily handled by Filters. You can put a filter with Value <>0 , So in January since the value is 0, your view would show the desired result, whereas in Feb once the data comes, it will automatically update.

     

    Let me know if this helps.

     

    Thanks,

    Yash

  • @Yash1 

     

    It is not about the filters, it is about changing the list structure. How are you going to update the list month over month (meaning a child item has one parent in one month and another parent in next month)  and retain the list structure for the previous month. 

     

    Go thru 311 Video Tutorial. I am sure it will be helpful to you as well

     

  • Hi,

     

    Thankyou @Misbah and @Misbah to answer

     

    now i have 2 option to create like my problem