Sum between Anaplan time and custom time

chris.friederic

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?

chris.friederic

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.