Master Data Hierarchy Load Part1 - Only Top Node Loaded.

[Former Member]

Hi All,

I am facing a situation where when I load Account Master Data from BW to BPC, all Master Data members are loaded fine but when it comes to Hierarchy, only Parent (Top Node) is loaded. I went through the Master Data guide. Find further information below.

=> BPC NW Version 10.1 SP02

BW Dimension : 0GL_ACCOUNT

BPC Dimension: ACCOUNT

Transformation file attached.

Thanks for your help

[former_member186338]

Hi David,

But where is the transformation file for hierarchy load? It's different then transformation file for master data load... Has to include conversion for hierarchy etc...

Vadim

[Former Member]

Vadim,

I understand your point but I need to clear part1 before going to part2. When loading Master Data /Hierarchy Part1, all hierarchy text nodes must be populated. In my case, only top node i.e. parent is loaded and nothing under the parent node, therefore cannot proceed to part 2.

[former_member186338]

Sorry, but you don't show your master data sample... How can I help you?

[Former Member]

Vadim,

Thank you for following up.

Find sample master data attached. BW side and BPC side.

[former_member186338]

What do you have in conversion file for ID?

[Former Member]

Hi David,

Please show transformation and conversion files.

also selection screen captures.

Andy

[Former Member]

Vadim.

My conversion file is generic java script to remove space and special characters.

EXTERNA                                                          INTERNAL

*                                                                 js:%external%.toString().replace(/^0+/"")

[Former Member]

[former_member186338]

Sorry, but what do you mean by this: replace(/^0+/"")??? Incorrect syntax!

[former_member186338]

replace(/^0+/,"")

Will replace first sequence of 0's (0, 00, 000...) with nothing...

It will not remove spaces or special characters!

[Former Member]

Vadim,

The conversion file is ok as it is and I have other hierarchies they use the same conversion file. I even tried to remove it but I'm getting same results. i.e. only parent node is loaded.

[former_member186338]

The conversion file is not OK, you have to understand what it's doing

But I see that you have this ID range:

How 6, 77 and 14 will be in this range?

Vadim