Problems with load of hierarchy from InfoObject

[Former Member]

Hello,all

We are on BPC 10.1 SP04 with BW 7.4 SP 09 and EPM SP 20.

We have the environment Planung_FI.

We try to load master data from the InfoObject 0SEGMENT into the dimension SEGMENT_CUR of the environment .

The master data in the infoobject 0SEGMENT looks like this:

This is the hierarchy in BW

Our Segments in BPC have 4 digits

We have a transformation file to load the segments.

When I validate this transformation file I get the following error message:

I cannot understand this because in this case the validation process only check whether a transformation file is valid or not.

Furthermore we cannot load text knots and so we cannot load the hierarchy REGION.

We configure everything according to the paper “How to Import Master Data and Hierarchies into SAP BusinessObjects BPC 7.5 from SAP NetWeaver BW”

We stuck to the description of this paper.

http://a248.g.akamai.net/n/248/420835/723dca89543c7edc07268524a0b09dece2e15dd467871bfcc2c61836a6a795...

OSS Note 2036716 - Loading hierarchy fails with error "Detected duplicate member ID" - BPC NW

I also refreshed the meta data and refreshed the cache.

Can you please help us?

Thanks in advance and best regards

Gerd Trautwein

[Former Member]

Excuse me. Here is the transformation file

When I validate this transformation file I get the following error message:

[former_member186338]

Ups, but the message is very clear:

You are extracting 4 characters - from 7 to 10. But it can result in duplicates:

For example:

0000001008

00000010081

or

0000001008

0000011008

Vadim

[Former Member]

Completely agree with Vadim. Please update your mapping within the transformation file or redefine your master data structure. Otherwise you will always get duplicate errors. Fixing this error by deleting the duplicates may lead into missing master data elements after extracting.

[Former Member]

Hello, Vadim, thanks for your answer. In our case this cannot result in duplicates because our master data is like this:

0000001000

0000001002

0000001009

We have no segments like

0000011009

There are 6 leading zeros that have to be removed.

After that you have the segment.

My other problem is that I cannot extract the text knots of the hierarchy in BW.

The text knots are like North, South, West.

I can' t extract them although I have chosen Extract text knots in the selection screen in the data manager package.

Could you please help me?

Thanks in advance and best regards

Gerd

[former_member186338]

"We have no segments like..." - sorry but the error message is absolutely clear, please check your master data and selection including language etc...!

[Former Member]

Hello Gerd,

"master data is like this:

0000001000

0000001002

0000001009"------To overcome this use java script in conversion

i.e External  *

     Internal   js:parseInt(%external%)

[harsha_jalakam]

Hi,

You could use a conversion file to trim up the leading zero's instead, which would rule out the possibility of forming duplicates as stated above.

Formula in conversion file would be as follows,

js:%external%.toString().replace(/^0+/, ‘’)

Regards,

Harsha

[Former Member]

Hi Gerd,

I am not able to see the error message. Please provide it align with the Points, Vadim mentioned.

TY, Karsten

[former_member186338]

Sorry,

But where are your transformation and may be conversion files?

Vadim