Prior Year data Pull with diffrent time range


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.







Best Answer