unable to load master data to cube

[Former Member]

Hi,

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

from /bi0/pacttype

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 ?

thanks,

KS

[Former Member]

Hi

You are just populating the internal table with the records using the select but no code to write the record to the part field of the cube. Im not very good in ABAP but you can try adding the below code and see if it works or not.

data: begin of i_acttype occurs 0,

0PART like /BI0/PACTTYPE-ACTTYPE,

end of i_acttype.

select ACTTYPE into table i_acttype

from /bi0/pacttype

for all entries in DATA_PACKAGE

where objvers = 'A' and

acttype = DATA_PACKAGE-PART.

loop at data_package where part = i_acttype-0part.

if sy-subrc eq 0.

datapackage-part = i_acttype-0part.

endif.

endloop.

Hope it helps.

Regards

Sadeesh

[Former Member]

Sandesh,

Still not working. Same thing process gets stuck with no error message.

Thanks,

KS

[Former Member]

Hi

As im not an abaper my code might have some problem. Would suggest you to debug the code while loading the data to cube and see where it fails or whether the code is working properly or not. If you are using 3.5 version then you can find the debug option in the monitor screen of the infopackage under details tab.

Hope it helps.

Regards

sadeesh