cancel
Showing results for 
Search instead for 
Did you mean: 

Loading Hierarchies using flat file

former_member190390
Participant
0 Kudos

Hi experts,

I have requirement to load hierarchies using flat file.

I have to create hier on Person Responsible, sub nodes are Sales Office, Project Definition, Project Type and Project Definition Description. I have file, i need to load into BW.

I dont know much about hier loading, can you tell me what are the Attributes to be inserted and how to prepare the hier loading file which contains HIENM, VERSION, HCLASS, DATEFROM and DATETO.

I dont know these fields are enough to load my hier.

I have created one hier, when i try to activate it's giving error like ' no data exists'.

Can anyone tell me how to prepare file to load into hierarchy?

Thanks in advance,

Venky

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Hi,

Please refer to this blog:-

/people/prakash.bagali/blog/2006/02/07/hierarchy-upload-from-flat-files

Former Member
0 Kudos
Former Member
0 Kudos

HI Venkatesh,

U can go loading Hierarchies through Flat File by maintaining the Flat File Structure as

1. Node ID

2. InfoObject

3. InfoObject Name

4. Link

5. Parent ID

6. Language

7. Short Description

8. Medium Description

9. Long Description

Thanks & Regards

Ramakrishna Kamurthy

Former Member
0 Kudos

HI Venkatesh,

U can go loading Hierarchies through Flat File by maintaining the Flat File Structure as

1. Node ID

2. InfoObject

3. InfoObject Name

4. Link

5. Parent ID

6. Short Description

7. Medium Description

8. Long Description

Thanks & Regards

Ramakrishna Kamurthy

former_member190390
Participant
0 Kudos

any help?

Former Member
0 Kudos

Hi Venkatesh,

There are several formats to load a hierarchy via file. The following two are the commonly used formats.

1) Default

Node ID NODEID

InfoObject Name INFOOBJECT

Node Name NODENAME

Link Name LINK

HghrLvlNode PARENTID

Language Key LANGU

Description - Short TXTSH

Description - Medium TXTMD

Description - Long TXTLG

2) Sorted

Node ID NODEID

InfoObject Name INFOOBJECT

Node Name NODENAME

Link Name LINK

HghrLvlNode PARENTID

First Subnode CHILDID

Next Node Along NEXTID

Language Key LANGU

Description - Short TXTSH

Description - Medium TXTMD

Description - Long TXTLG

If Default format is used, the sequence of node IDs appeared in the flat file determines the structure of the hierarchy. Whereas the sorted hierarchy format defines the structure via PARENTID, CHILDID, NEXTID relationship.

You make the selection in DataSource/Tran.Structure tab of InfoSource Page by clicking on the "Hier. Structure button.

Good luck!

Bill