I want to use AMDP for Planning function that reads from one cube (of a multiprovider) and writes to another cube (of the same multi provider) . Thus the aggregation level is same for both cubes .
How can I do this
Method 1 : I can use the generated analytical view to read from CUBE 1 and then write to CUBE 2 . ( I want to avoid this method )
Method 2 : ( Would be below approach work ) ?
E_VIEW = SELECT DIM1, DIM2 , 'CUBE1' as INFOPROV , KF1
FROM :I_VIEW where INFOPROV = 'CUBE2'
The INFOPROV has been defined TYPE RSINFOPROV in the declaration .