How to lookup a value from a source with no time

Chmacpherson

Context

1. My Destination module has the following dimensions: (1) Employee ID (2) Line Items (3) Time
2. 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)

Goal

1. In the destination module, populate an employee's job level on the effective date based on the Source module.

Challenge

1. 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!

 

Many thanks,

Chad

Chmacpherson

Thank you for your help solving this!

 

You were correct that the destination/target module which has the time dimension has the time scale set to day. I used the FIRSTNONBLANK formula just as prescribed and that worked like a charm.

 

Thank you again for the help and the quick reply!

 

All the best,

Chad

Chmacpherson

Thank you for your help trying to solve this! I am not sure why the above did not work, but I believe the Item(Time) portion wasnt working because the Destination/Target module had the time scale set to day.

All the best,
Chad

Chmacpherson

Ah no that is my bad. I did not mention not (I did not realize its importance. Thank you again!

harshini.gadam

what happens when you have a value instead of text . Firstnonblank will not work ?