flowing data from one particular year to another particular year ?

Ravichandra Aj

Scenario : i have a database . its time range is 2016-2024.

                  have a history data for 2016,2017,2018 in source cube.

                  i want to flow  2016 year data to 2023  in target cube

                  how to achieve this ?

 

Björn Reuber

Pietro Ferrari

Alexander Kappes

 

please give me your inputs.

 

 

Thanks & Regards,

Ravi

Björn Reuber

Hi Ravi,

 

you can easily achive this using a dynamic offset:

The DataFlow process 

Please keep in mind, that the offset is based on the time entiy of the target cube, so if its month you have to use a multiplier of 12

 

regards

Björn