Prior Year data Pull with diffrent time range

MadhabikaM

Hi All,

 

Need a function help here, I have 2 modules Module 1 and Module 2

 

both uses time dimension and different time range.

 

In my Lineitem A for Module 1 in (FY20) ,I want to Pull in previous year data value from module 2 lineitemB i,e (FY19) data.

 

Line Item A = Module 2.Line item B( but this should pick my prior year data value).

say I FY20 it should pull FY19 data.

 

I have tried creating a system module with current year and Prior year as FY20 and FY19 and do Lookup.

but this does not work.

 

Lag, Post and anysuch function doesnot work as my time range are diff in source and target.

 

 

 

 

Regards,

Madhu

Misbah

@MadhabikaM 

 

See if this helps

 

SYS Time Module

 

Source Module

 

 

Target Module

Misbah