Skip to Content

Upload thru flat files - hierarchies

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2004 at 09:08 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 06, 2004 at 04:30 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 07, 2004 at 12:04 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2004 at 03:37 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.