Sum between Anaplan time and custom time

New Contributor

Sum between Anaplan time and custom time

I have a use case where I am trying to sum from Anaplan time (days) to a custom time dimension called Cohort Time which is in months. I have a module (Attachment 1) which has number of leads per day in Anaplan time with a Cohort Time line item coming from a separate module. Worth mentioning that the months in Anaplan time and Cohort time don't match up most of the time. I am summing to a new module that is dimensioned the same as the first except Cohort Time is now replacing Anaplan time. If I just do this the formula takes, but it only gives zero values. I can get it to work if I sum into Cohort Time but still include Anaplan time and then create a separate line item without Anaplan time and SELECT: TIME.All Periods on the first line item but it creates a ton of sparsity that I'd rather not have (blueprint in Attachment 2). Is there any way to get around this need to sum into both time dimensions and then select out anaplan time?

4 REPLIES 4
Occasional Contributor

Re: Sum between Anaplan time and custom time

Hi Chris,

 

Does your fake time dimension map 1:1 to Anaplan Time? If so I believe it would be sufficient to just do a LOOKUP instead of a SUM. If I am understanding the problem correctly you can add a Time (Anaplan Month) formatted Line Item that maps to the Cohort and use it as a Lookup in the Cohort dimensioned module. 

 

Thanks,

Griffin

Message 2 of 5
New Contributor

Re: Sum between Anaplan time and custom time

Unfortunately it's not 1:1. There are multiple Anaplan Days that map to a single cohort time day and the days don't align by month either. 

Message 3 of 5
Contributor

Re: Sum between Anaplan time and custom time

Chris,

 

Did you find a solution for your problem? 

 

I am doing a similar cohort modeling, and my question is here;

 

https://community.anaplan.com/t5/Best-Practices/Diagonal-sums-over-flat-list-dimension-on-Anaplan/m-...

 

I would appreciate any inputs you may have.

Message 4 of 5
Highlighted
Community Boss

Re: Sum between Anaplan time and custom time

@visivasa

@chris.friederic

@Griffink

Hi

This is a know issue of summing from a time dimension to a module without time, but the good news is that is can be solved

1. Create a fake list of days covering the timescale.

2. Create a module using 1. above and and map the real days to the fake days on a 1:1 (start is formatted as date)

3. You also map the Cohrt months here too

2019-01-16_09-47-42.png

4. Create a module also dimensioned by the 'fake days' (in my example I also need Products) and map the data from the real source into this module using a lookup from the above mapping module.2019-01-16_09-48-06.png

 

5. Map the data into you Cohrt Months target module using the first mapping module2019-01-16_09-38-04.png

I hope this helps

Good luck

David 

 

 

 

Message 5 of 5