'member XXX is invalid or is a calculated member' error while validating transformation

[NVChaitanya]

HI Gurus,

I am trying to load transaction data from BW. I am able to load data in infocube. When trying to load transaction data from infocube to BPC i am getting error for entire data records.

I have attached Transformation file error file and conversion file for your reference.

[former_member186338 · Accepted solution]

Sorry, but you have ABSOLUTELY clear message: RB_ACCOUNT 0410000 is invalid or is a calculated member.

Is it so hard to check if you have the same member in RB_ACCOUNT dimension???

I suspect that leading zero is incorrect ... May be you use internal option during import

[NVChaitanya · Accepted solution]

Hi Vadim,

Thanks for your valuable reply.

I was using incorrect conversion file which caused this issue.

0410000 = 410000. I am extracting transaction data from BW.

Zaccount1 info object was defined for 7 characters which was causing leading 0.

I have changed the conversion file and data is acceepted.

Thanks for your help.

[former_member186338 · Accepted solution]

Leading zero's can be removed using external option!