Custom Time Mapping

Options
sonpatel
sonpatel Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor
in Extensibility

Hi Community, 

 

If the client has a custom time dimension file how would you go about mapping this file into Anaplan and then dynamically sum the sales by region by account by product by month? 

 

Find example data set below. I would normally do a custom time mapping to map from the clients time to Anaplan inherent time period but the fact that there are two years in the file is throwing me off. In my mapping I would only be able to choose Jan 19 OR Jan 20 to map to the custom JAN. How would I sum this without hardcoding anything? 

 

Thank you! 

 

 

Tagged:

Comments

  • sonpatel
    sonpatel Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor

    Hi Rob,

    Thank you for the suggestion! Unfortunately they are not able to rearrange the file. I've created a mapping module so far that maps the dummy time list to the Anaplan time list but I've having a difficult time summing. Any ideas? I've added screenshots for your reference 

     

Categories