Skip to Content
0
Mar 08, 2017 at 06:53 AM

Planning function AMDP read from one CUBE and write to a different CUBE

1640 Views

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 .