Hierarchy issue

[Former Member]

Hello, i want to know if I am getting a custom hierarchy from ECC, but i do not want to use it as is. means i want to use some nodes of it and there is no consistency. is there a way for me to convert that hierarchy in to a flat file and then load it in BW in to my object on daily basis? Thanks,

[RamanKorrapati · Accepted solution]

Hi Venkat,

When you are not loading data from ecc to bw hierarchy, then you can create copy of that  hierarchy and load thru flat file(use flat file data source).

Thanks

[Former Member · Accepted solution]

Hello thanks, but i want to get this done automatically, see when ecc people make any change to their hierarchy they don't inform us. so what i want to do is take that hierarchy run it through some program, convert it into flat file format and then load it from app. server into bw automatically.

[former_member182470 · Accepted solution]

Your idea is top. But if you can write a program to convert into a Flat file(.csv) format, then you have to place this file in some application server(AL11 t-code). You can pick this file from your flat file infopackage.

You may take an ABAPer's help or google it.

Regards,

Suman

[RamanKorrapati · Accepted solution]

Hi Venkat,

When we load data from ECC to BW, Ecc team always need to keep bw team in loop mails to know the changes which reflects bw also. according to taht changes bw team will take care required actions. in hierarchy case must and should they need to inform, because bw hierarchy str is depend on ecc hierarchy str.

if your id was best one. keep output result file in application server then only we can load thru process chain otherwise not possible.

Thanks

[Former Member]

Hi Venkat,

Create a flat file data according to the custom hierarchy.Then load the file to BI by creating the data source and give the file path at info package and load the data.

-Padmaja

[former_member182470]

A custom hierarchy cannot be created in ECC in RSO2. You can modify the data in a Flat File and then load it to BW.

http://scn.sap.com/docs/DOC-24996

Regards,

Suman

[Former Member]

Hi,

Instead of creating a flat file out of custom hierarchy from ECC, you can perform a hierarchy enhancement and load it into BW.

Read this.

http://www.element61.be/e/resourc-detail.asp?ResourceId=189

Br,

H