on 12-03-2004 4:06 PM
We have a custom infocube with custom infoobjects. One of the infoobject, I have to upload the hierarchy by flat file (CSV)
The hierarchy with be like this
Hierachy Name: Geography
Level 1 - Node name : Home
Level 2 - Infooject : Centre 1
Level 2 - Infobject : Centre 2
Level 1 - Node name : Overseas
Level 2 - Infobject : Centre 3
Level 2 - Infobject : Centre 4
I have a file structure which is same as shown in graphic in http://help.sap.com/saphelp_bw32/helpdata/en/ad/6b023b6069d22ee10000000a11402f/frameset.htm
I am able to upload the file till PSA, however when i do a further update, the system does not process it further ie. status is yellow traffic light.
The transfer structure for hierarchy is
Segment Hierarchy header
0HIENM Name of hierarchy
0HIER_VERS Hierarchy version
0DATETO Valid to
0DATEFROM Valid from
0NORESTNODE Suppres.Unassgnd Nds
0STARTLEVEL Start-Drilldown Levl
0NODEPOSIT Node position
0ALEAFNODSP Do Not Display Nodes
0ALEAFNODCH Changeable Display
Segment Hierarchy Node:
0HIER_NODE Hierarchy Node(s)
ZCENTRE CENTRE
Maintain Hierachy in transfer structure for 'GEOGRAPHY'
Node ID NODEID NUMC 8
InfoObject Name INFOOBJECT CHAR 30
Node Name NODENAME CHAR 32
Link Name LINK CHAR 1
Parent Node PARENTID NUMC 8
First Subnode CHILDID NUMC 8
Next Node Along NEXTID NUMC 8
Language Key LANGU CHAR 1
Description - Short TXTSH CHAR 20
Description - Medium TXTMD CHAR 40
Description - Long TXTLG CHAR 60
The data that I am uploading in following file format:
InfoObject Name Node Name Link Name Parent Node First Subnode Next Node Along Language Key Description - Short Description - Medium Description - Long
INFOOBJECT NODENAME LINK PARENTID CHILDID NEXTID LANGU TXTSH TXTMD TXTLG
CHAR CHAR CHAR NUMC NUMC NUMC CHAR CHAR CHAR CHAR
30 32 1 8 8 8 1 20 40 60
0HIER_NODE HOME 0 2 0 D HOME HOME HOME
ZCENTRE 0001006 1 0 0 D
ZCENTRE 0001017 1 0 0 D
ZCENTRE 0001019 1 0 0 D
The data upload in PSA is
STATUS: DATA PACKET: DATA RECORD: ID:INFOOBJECT: HIERARCHY NODES: LEVEL: LINK: PARENT ID: CHILD ID: NEXT ID: VALID FM: VALID TO: INDICATOR: CENTRE
@5B@ 1 3 1 0HIER_NODE HOME 1 2
@5B@ 1 4 2 ZCENTRE 00000000000000000000000000001006 2 1 0001006
@5B@ 1 5 3 ZCENTRE 00000000000000000000000000001017 2 1 0001017
@5B@ 1 6 4 ZCENTRE 00000000000000000000000000001019 2 1 0001019
Can some one assist me how to load hierachy thru' flat file in infobject hierarchy. Also guide me if the data i am giving wrong which can be set right.
Regards,
Santosh Puthran
Santosh,
Have you tried using the hierarrchy DL tool
https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sapportals.km.docs/documents/a1-8-4/how to download a hierarchy to a flat file.pdf
Maintain the hierarchy in BW, export it and import it to your other environments. This way your flat file is always correct.
Rgds,
Guillermo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
problem solved.
As pointed out in the discussion, it was correctly mapping the Parent, Child and next id.
Thanks for the help.
Regards,
Santosh Puthran
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for reply. I am unable to load the data from PSA to the infoobject.
I am trying to load it in CSV file in this format:(: indicates they are separate)
NODEID: INFOOBJECT: NODENAME: LINK: PARENTID: CHILDID: NEXTID: LANGU: TXTSH: TXTMD: TXTLG:
1 0HIER_NODE HOME 1 0 0 2 D HOME HOME HOME
2 ZCENTRE 1006 2 1 0 3 D CENTRE1 CENTRE1 CENTRE1
3 ZCENTRE 1017 3 1 0 4 D CENTRE2 CENTRE2 CENTRE2
4 ZCENTRE 1019 4 1 0 0 D CENTRE3 CENTRE3 CENTRE3
Can you advise me, whether Parent, Child, Link is correct.
What does "NODENAME" refer to in the file format.
Thanks in advance.
Santosh Puthran
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Santosh Putran,
from the data you've sent it looks like the link node is missing. This may be an HTML problem, but do you fill the link node? Other things I can see that might be a problem:
- You fill Child-ID but not Next-ID. If your hierarchy is a sorted one you may need it. Maybe you need it anyway.
You can try the following file:
0HIER_NODE;HOME;;0;2;0;D;HOME;HOME;HOME
ZCENTRE;0001006;;1;0;3;D;;;
ZCENTRE;0001017;;1;0;4;D;;;
ZCENTRE;0001019;;1;0;0;D;;;
You should also check for error messages in the Detail display of the monitor.
Best regards
Dirk
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.