Transaction Data load fail

[Former Member]

Hi Experts,

I have an issue when I was loading transaction data from flat file to BPC model. I am getting error "Task name LOAD: Cannot perform read". It was working fine in the development box. The transformation file are all ok. Any inputs on this?

Thank you.

[Former Member · Accepted solution]

Hi All,

Thank you for all the help. This is resolved by running the SE38 program "UJA_REFRESH_DIM_CACHE".

Thank you!!

[RamanKorrapati]

Hi Ng,

Please check your BPC cube properties. Please play with below options.

if you have selected option 2, then change to 1 and load the data or do it vice versa.

BPC cube(/CPMB/)-->right click-->Planing specific properties--> change real time load behavior

1.Real time data target can be loaded with data; planing not allowed

2.Real time data target can be planned; Data loading not allowed.

Thanks

[Former Member]

Hi,

BPC needs the cube to be in planning mode.

Thereby, whenever you are trying to load the data in the cube, keep the cube always in planning mode.

If you are not aware of this thing:

There is a FM (RSAPO_SWITCH_TRANS_TO_BATCH) which can be used to do the switch of an infocube from Transactional to Data load and another FM and another FM (RSAPOSWITCH_BATCH_TO_TRANS) to do vice versa.

Regards

NS