I have created multi planning area with two planning areas each containing one infocube. Now i have to read data from planning area 1 infocube for characteristics cycle,version and data type = 10. and key figure global currency.
I should also read data from the second planning area 2 infocube with the same characterstics except data type and should do calculation on rate keyfigure and store the value for the data type = 20 of the second cube.
I mean read data for cycle, version,data type = 10, kf global currency from 1st cube and read data for cycle, version from 2nd cube and calculate global currency * rate and store this value for the data type = 20 in the 2nd cube.
rate kf is in 2nd cube and global currency in 1st cube. In the 2nd cube there is kf local currency and the calculated value should be placed in the kf local currency of the second cube for the data type = 20.
Any suggestions will be appreciated.