Move data from a Periodic BPC Cube to a YTD BPC Cube
I Have a consolidation Cube which is a YTD Input cube. This Cube is used for pulling Actual data from ECC on YTD Basis for Consolidation.
I also have a Periodic Input Cube. This Planning Cube is used for Inputting Projection/ Budget Data on periodic Basis.
I need to send data from the Periodic Input Cube to the YTD Input cube for Consolidation, Comparison etc in category "Budget".
What is the best way to fetch the data from the Planning Periodic Cube in to Consolidation YTD cube?