unable to load master data to cube
I have one master data 0PART which is referenced by 0Activity Type master data.
I have added 0PART chara into one infocube. and wrote abap code in update rule as below:
data: begin of i_acttype occurs 0,
0PART like /BI0/PACTTYPE-ACTTYPE,
end of i_acttype.
select ACTTYPE into table i_acttype
for all entries in DATA_PACKAGE
where objvers = 'A' and
acttype = DATA_PACKAGE-PART.
The reason behind adding this code is,
Cube is populating from ODS and in ODS data comes from R/3 but standard extractor dont populate this field so i am trying to load it from master data.
when i try to load data into info cube it gets stuck in update rule. it reads the data but not transfering it to cube. so i believe that there is some problem in my code. in monitor i can see that it starts processing update for cube and ends immediately without any error message. process status ends but shows request is still running.
can someone correct it for me ?