Hierarchy Struggle ...

[simonb2013]

So my first attempt at managing hierarchies is turning out to be a headache.

Though this is 'day 1' of QV for me.

Wondered if anyone could help me work out what I'd doing wrong ?

Script, tab 'Main':

--------------------------------------------------------------

ODBC CONNECT TO [myDatabasse];

SQL SELECT *

FROM "myDB"."mySchema"."Meta_QV_Hier_RollDomain";

objectType	objectName	UID	parentId
DM	KUNNR	4441105	0
RL	KUNNR_CPD	5021332	4441105

-----------------------------------------------------------

Script, tab 'Hier'

[Hier_RD]:

Hierarchy(UID,parentID,objectName,,objectName,[objectnamePath],|,objectDepth)

load

    UID,parentId,objectName

Resident

Meta_QV_Hier_RollDomain;

Result:

The good part, is that for the second line, 1st 2 columns, I can see a relationship.

But the obvious bad part, is that I cannot see 'KUNNR_CPD' has a parent 'KUNNR'  as far as the textual values are concerned.

I was expecting objectName="KUNNR", objectname1="KUNNR_CPD"  ??

Any ideas what I'm doing wrong ?

Any help muchly appreciated ... going around in circles here

[hic · Accepted solution]

You're almost there... You need to use parentId instead of parentID - it's case sensitive. So the Load should be

[Hier_RD]:

Hierarchy(UID,parentId,objectName,parentName,objectName,objectnamePath,'|',objectDepth)

load

    UID,parentId,objectName

Resident

Meta_QV_Hier_RollDomain;

HIC

[simonb2013]

Henric,

Oh my, thank you - what a relief !

I am curious now, as to what is happening behind the scenes when I had parentID in there.

Does it just 'make up' an empty column with the name ?

I'm suprised it did not throw an error

But yes, the practical provlem is solved !

Thank you.