How to lookup a value from a source with no time
- My Destination module has the following dimensions: (1) Employee ID (2) Line Items (3) Time
- My Source module has the following dimensions: (1) Movement Code (2) Line Items
- Employee ID is a line item (List)
- Effective Date is a line item (Date)
- In the destination module, populate an employee's job level on the effective date based on the Source module.
- Source module has the effective date as a line item and not a dimension, so I am struggling to make the connection between the source and the destination.
- Destination module (time as dimension)
- Source module (time as line item)
Any guidance on this would be greatly appreciated!