Mapping Period/Date line item into module with Time Dimension
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.
Re: Mapping Period/Date line item into module with Time Dimension
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