Skip to Content
0

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

Sep 19, 2017 at 10:20 AM

76

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Vadim Kalinin Sep 19, 2017 at 10:52 AM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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.

0

Leading zero's can be removed using external option!

0