Alternative week List - How do i retreive

DeveloperCYT

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)

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 ????

 

 

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

 

Thank you

 

Jaakko

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

Jaakko

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

 

DavidSmith

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

DeveloperCYT

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....

 

 

DeveloperCYT

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