BPC Hierarchy Load - Duplicate Error

[Former Member]

Dear Expert,

I am loading hierarchy from BW to BPC for 0GL_Account. I am facing the following error.

Detected duplicate member ID 'NaN'

I have checked the NODENAME and NODEID from BW for the hierarchy but there are no duplicate members.

Could you pls suggest what the error is?

[former_member186338 · Accepted solution]

The reason for the error is simple - you are using JavaScript function parseint! If external can’t be converted to a number it will return NaN.

P.S. Look on your BW members that are not numeric and add lines to conversion file before parseint to convert to something meaningful. Or check the result of parseint for NaN and use condition.