How to compress leafs of the hierarchy

[Former Member]

Hi guys

I have a hierarchy for some levels.

Level 1

Level2

Level3

i want to show the results for the Nodes. I dont want to show up the leafs. How to compress leafs

and how to achive this

Regards

AK

[former_member184494 · Accepted solution]

If your hierarchy is like this

Level1 --> level2 --> level 3

with level 3 being the leaf then set the hierarchy level to 2 to see only upto level 2. Attach the hierarchy to the characteristic and then select properties - there you will have a drop down for expand upto level available to you.

[Former Member · Accepted solution]

Hi Arun,

Sorry for the delay in reply..

Actually i dont want to see any leafs of the hirarchy... i just want to see the nodes.

for example : i have a region heirarchy .. and the nodes are : E, N , S, W.

under each node i have city offices as my leafs. here i need to see only the values for E, N, S, W. i dont want to see any leafs.

So how gonna achive this

Regards

AK

[Former Member · Accepted solution]

So, how come your hierarchy has 3 levels?

Are you considering ROOT as level 1, and you want to display only regions E, W, N, S?

if you wan to hide the root and display regions, then why dont you remove the office city hierarchy and InfoObject and add region characteristic into the report.

You dont have to necessarily show the hierarchy.

- Danny

[Former Member · Accepted solution]

Hi matt,

Root is also required.

I cannot remove office city, coz the same hierarchy is required for some other reports.

I want see only

North - 25

-City1 - 15

-City 2 - 10

South -30

-City3 -15

-City4 -15

West -40

- city 5 -20

- City 6 -20

East -80

-City 7 -40

-City8 -40

I want to show the north, west, south, east . values. i dont want to see the leafs

Regards

AK

[Former Member · Accepted solution]

Hi,

Your hierarchy is like this:

ROOT

__Region (N)

____City1N

____City2N

__Region (E)

____City1E

____City2E

__Region (S)

____City1S

____City2S

__Region (W)

____City1W

____City2W

If you want to hide city display, then go to the characteristic property and set the property expand the node and set it to 2.

I was suggesting that If you are not intersted in knowing the number aggregation at ROOT level, remove (disablel the hierarchy for City in query and add Region in the query designer inplace of city.

That would show your result like as follows:

Region (N) .....

Region (E) .....

Region (S) .....

Region (W) .....

- Danny