Alternative week List - How do i retreive

Hi,

 

We have a customer who have an alternative week description, their year runs from March to March, so their week 1 is ANAPLAN's week 9 for example.

I have created a list 'Weeks' and this has the 'Reak week' and also the alternative week (currently in text)

image.png

Then in my module i want the Alt Week to show... but i do not know how to LOOKUP this using the period , time, week ????

 

image.png

 

Any help or guidance would be appreciated, even if it is a simpe,as it seems...

 

Thank you

 

Best Answer

  • Jaakko
    Answer ✓

    Hi,


    If there is a logical way to conclude the correct member from alt weeks list, you could use finditem-function to automate the mapping. If there is no formula for that, I would probably build the mapping in excel, save that as csv or txt and would import it to module. If imported data includes the exact names or codes of your alt weeks list, Anaplan will populate the dropdown lists with the values. You can also use the weeks list as a source for the import action.

     

    If you want to sum the alternative weeks to a higher level, build a parent hierarchy for alt weeks list or create additional list formatted line items to the mapping module that you can use with SUM: in your formulas.

     

    Br,

    Jaakko

Answers

  • Hi,

     

    How about moving the mapping to module instead of a list? Create a module with week time scale, add a line item and format it with alt weeks list. Then use the drop down to map real weeks to alt weeks. Then your formula would look like: new module.alt week.

     

    Br,

    Jaakko

     

  • Hi

    Agreed with the previous post, it is best practice to use modules rather than list properties

     

    Also ensure that the line item to show the alternate week should only be dimensioned by time, not the lists as the alternate week won't change by list item.  Doing that will save a lot of space and calculation time

     

     

    David

  • Thank you i built the module with time dimension, and line item formatted as list from Alt List

    Please bare with me i am quite new, but does this mean i have to go through each week for 3 years and select from a  dropdown?

     

    Also in an ideal world i would like to be able to Show totals for the Alt year, but Year, Qtr, Month....

     

     

  • Thanks for responses, i have built this succesfully now using your help and some new found skills.

    Appreciate the time people take to repsond to these questions

     

    Thank you