on 2012 May 25 11:07 AM
Hi Friends,
We are creating flat file to upload hierarchies from flat file source systems. The source file is like below.
Child | Node 1 | Node 2 | Node 3 | Node 4 | Node 5 | Node 6 | Node 7 |
311000 | 311220NET-HAW | NTWK-HAWA-REV | TTL-NWHW-REV | TTL-REVENUE | PRE-OH-MARGIN | PBA | PBIT |
311000 | 311220NET-HAW | NTWK-HAWA-REV | TTL-NWHW-REV | TTL-REVENUE | PRE-OH-MARGIN | PBA | PBT |
Node 7 is the highest node.
Here for GL account we have same parents and highest level we have different parents values. If we see node 6—we have PBA value; for this we have two parent values PBT and PBIT.
I have created flat file in the below format.
Node ID | InfoObject | Node Name | Link | Parent ID | Language | Short Description | Medium Text | Long Text |
1 | 0HIER_NODE | TEST_TWO_PARENTS | EN | |||||
2 | ZCSEVENTH | PBIT | 1 | EN | ||||
3 | ZCSEVENTH | PBT | 1 | EN | ||||
4 | ZCSIXTHLE | PBA | 3 | EN | ||||
5 | ZCNINTHLE | PBA | 2 | EN | ||||
6 | ZCFIFTHLE | PRE-OH-MARGIN | 5 | EN | ||||
7 | ZCFOURTHN | TTL-REVENUE | 6 | EN | ||||
8 | ZCTHIRDLE | TTL-NWHW-REV | 7 | EN | ||||
9 | ZCSECONDN | NTWK-HAWA-REV | 8 | EN | ||||
10 | ZCTOPNODE | 311220NET-HAW | 9 | EN | ||||
11 | YCOGNOSGL | 311000 | 10 | EN |
And the output came as like below attched file.
We are expecting same GL account to be assigned with another node as well.
Please guide me how we can configure hierarchy file to get the same GL account values to be assigned to two nodes.
Hi Anand
Have you checked the following document?
Maybe you can find what you want with a reverse action, create the hierarchy in the way you want, download it and check how is constructed with the program.
Then use the same logic to build your file and upload it in the system.
Thank you
Yiannis
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.