cancel
Showing results for 
Search instead for 
Did you mean: 

Upload thru flat files - hierarchies

anitosh
Explorer
0 Kudos

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

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

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

anitosh
Explorer
0 Kudos

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

anitosh
Explorer
0 Kudos

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

Former Member
0 Kudos

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