Skip to Content

How to load a BW hierarchy through flat file

A BW hierarchy can be loaded & maintained via a flat file. The approach is to maintain proper Child & Parent nodes in the file and upload the file in BW syatem.

See below the steps:-

1) Create a BW hierarchy data source and keep the fields like Node ID, Infoobject, Node name, Link name etc. See the below structure.

Untitled.jpg

2) Create the transformation between the Info object & this data source.

Untitled.jpg

3) Create a flat file and upload it.

Untitled.jpg

Hope this helps.

Be the first to leave a comment
You must be Logged on to comment or reply to a post.