Problem in Hierarchy Report

[Former Member]

I am not getting the nodes in a hierarchy report which i tried from a flat file.

Can anyone help in this regards.

[former_member183334]

     Hi Parida,

please check the Hierarchy are activated are not ?

Regards,

Sathya.

[Former Member]

How to check if it is active or not

[Former Member]

How to check whether the Hierarchy is active or not?

[Loed]

Hi,

In RSH1 there is an ACTIVATE button, just reactivate your hierarchy..

Regards,

Loed

[Former Member]

After clicking active button iam getting an message as "There is no modified version for this Hierarchy".

[Loed]

Hi,

Can you do another hierarchy similar to what you are currently using then apply it in your query..Let's see if the new hierarchy will reflect..

Regards,

Loed

[Former Member]

Should I start it from Info Object level or Data Source Level ?

[Loed]

Hi,

Start in RSH1 already..You should only recreate a hierarchy similar to your current hierarchy using the same infoobject..

Regards,

Loed

[Former Member]

This was my Hierarchy data tht i have used. Is it right or need s any modification. Should only create Sales Region and Sales  Office as info object or any other Info Object should aslo be created.

[Loed]

Hi,

What I'm saying is to create another hierarchy similar to the current hierarchy you are using in your query now..From you screenshot I think you are using SID27_HIER..If that's correct, CREATE ANOTHER HIERARCHY similar to it then use it in your query..Let's see if the hierarchy will now be shown..

Regards,

Loed

[Former Member]

yes i have created below is the image

Still I am not getting  the report

DTP also turned to green

[Loed]

Hi,

Can you post your query where you applied this hierarchy? Also, are you sure that you have maintained the hierarchy in RSH1?

Regards,

Loed

[Former Member]

yes sure. Plz find the image file attached.

For query designer and RSH1

[Loed]

Hi,

Can you check tcode RSATTR if your hierarchy is available there in the HIERARCHY LIST?

Regards,

Loed

[Former Member]

[Loed]

Hi,

Check the HIERARCHY LIST..If you hierarchy is present, choose it then click EXECUTE button..

Regards,

Loed

[Former Member]

No its not present