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.