Mapping Period/Date line item into module with Time Dimension

Highlighted
Occasional Contributor

Mapping Period/Date line item into module with Time Dimension

Hi all,

I'm stuck on something that seems like it should be relatively easy. 

I have a systems module that is used for mapping and is not dimensioned by time. I'm able to infer a month period/date based on the name of a line item value in this module. This is a 1:1 relationship, for each line item value in this model there is a corresponding month. 

I'd like to map one of the line items to another module that is only dimensioned by time. I thought I could do this with a simple LOOKUP on the period formatted line item in the source module, but it doesn't seem to work. 

The source module Line Item is formatted as a month period. The target module time scale is month based.

Any advice is appreciated.

1 REPLY 1
Highlighted
Master Anaplanner/Community Boss

Re: Mapping Period/Date line item into module with Time Dimension

Hi brookec,

Create a line item subset in your source module. Add all the line items that you want to map to this LIS. Create a third module, dimensioned by the LIS and one line item formatted by the time scale. Write a formula in this line item to do the mapping between the 2 modules

Let me know if this works

Regards,
Anirudh