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