Upload infoobject from BW without hierarchy and create one automatic hierarchy in BPC

[Former Member]

Hi experts,

I upload one BW infoobject without hierarchy but I want to create one hierarchy in BPC that groups all the members in one parent (the same for all of them):

                TOT_EMP

                               EMP_1

                               EMP_2

                               EMP_3

I tried to add the instruction in the transformation file when uploading the master data as follows:

PARENTH1=*STR(TOT_EMP)

But it fails…

Do you have any idea?

Thank you in advanced.

[Former Member]

Hi,

You can use one of the following method.

1. create a hierarchy in BW with a top node.

2. use start/end routine to add a top node during hierarchy ETL.

Andy

[Former Member]

Hi Andy,

Thank you for your answer..

The problem is that I cannot create the hierarchy in BW. That's why I try to generate the hierarchy in BPC in the master data transformation file and not in the hierarchy transformation file.

Thanks,

[Former Member]

You need to use start and end routine in your hierarchy transformation file.

[Former Member]

Hello Andy.

I have the same problem.

Can you please explain what do you mean with an start end routine? Are you talking about implementing and ABAP code?

Thank you.

Alvaro.

[Former Member]

Hi Alvaro,

Yes, you need to use routine BADI in ABAP.

Have a look at this document.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/50c39fa1-6f95-2d10-2a95-b594de8e1...

Andy