Flat file transactional data load error

[former_member604676]

I am trying to load a flat into a BPC model. I am using a DM " Import transational data load from flat file" to load the data. The transformation file and data file are validated correctly.

However,when i am running the DM package, i am hitting the below message.

Task Name : Load

Cannot perform Read.

Model : Package Status : Error.

We have two secure dimension in the model. I have tried different combinations even with PRimary admin role and i am still getting the same error message.

Is this a secirity related error ? The model has been transported from DEV . In DEV, i am not facing any errors.

Any advise/ help?

[former_member193143]

Hi King,

I think in the back end you need check the option real time load behavior, Is it in planning mode or loading mode. If possible share your error message screen.

Goto RSA1 ---> select your cube--> Right click---> change real time load behavior--> Change it in to planning mode

Regards,

Saida Reddy Gogireddy

[former_member604676]

There is no issue with backend.  It is already in planning mode.

[former_member193143]

Hi king,

can you please share sample flat file and error screens

Regards,

Saida Reddy.G

[Former Member]

Hi,

Please show us your transformation file and sample upload file.

Andy