Hierarchy

Thu, 28 Aug 2014 08:24:03 GMT

Hi All,

I display the country as tree in my report. But some thing is wrong.

If i click the higher order like "All Country" it is not working, i have to collapse the tree and then click again the "All Country" it works.

Appreciate if some one help me on this.

Tree:

Hierarchy (COUNTRY_ID, PARENT_ID, COUNTRY, Parent, COUNTRY, PathName)

Select COUNTRY_ID,

PARENT_ID,

NAME AS COUNTRY

From XX_JLR_MS_COUNTRY ;

Tree_rel:

HierarchyBelongsTo (COUNTRY_ID , PARENT_ID, REGION_ID, COUNTRY , Test2)

LOAD

COUNTRY_ID ,

PARENT_ID,

REGION_ID ;

SQL SELECT COUNTRY_ID, PARENT_ID, REGION_ID FROM XX_JLR_MS_COUNTRY;

Regions:

LOAD

REGION_ID,

REGION_NAME;

SQL SELECT REGION_ID,REGION_NAME FROM XX_JLR_MS_REGION;

Thanks,

Subramanian

Re: Hierarchy

whiteline — Thu, 28 Aug 2014 09:08:15 GMT

Hi.

Seems it works like it should.

When you select using collapsed tree, QV assumes that you want select all nodes that are connected.

When you select using expanded tree, QV assumes that you want select the parent node.