Question Re: Hierarchy Node Variable not working in Technology Q&A

Hierarchy Node Variable not working

Former Member — Wed, 01 Nov 2006 20:59:33 GMT

Hello,

I created two variable one being Hierarchy Node variable and other Hierarchy variable.

I am using this for the Internal order hierarchy.

I amd also working on 2004s and not 3.5 version.

I restricted the Internal order and then selected the variable and then selected the nodes and before moving the Nodes variable, I also selected the Variable for the Hierarchy and then moved the Node variable to the right screen.

When I run the report, the option for the selecting the Hierarchy appears and I selected the correct Hierarchy, but when I go to the Hierarchy Node variable, I do not see the Nodes for that Hierarchy I selected in the first variable and it always like a fixed value Hierarchy defaults to the first Hierarchy. Hence I am unable to select the node to execute the report.

I would appreciate any ones feedback.

Thanks

Sundar

Re: Hierarchy Node Variable not working

Private_Member_9643 — Wed, 01 Nov 2006 21:20:12 GMT

Just cross check the Hierarchy which u selected for selection is the same hierarchy for which you created Hierarchy Node?

KJ!!!

Re: Hierarchy Node Variable not working

Former Member — Wed, 01 Nov 2006 23:01:52 GMT

Hi KJ,

Both the Variables are Variable and not fixed. I have to select the Hierarchy in the selection screen and depending on the Hierarchy I selected I need to get the appropriate Nodes for selection in the Hierarchy Node variable.

Regards

Sundar

Re: Hierarchy Node Variable not working

Private_Member_9643 — Wed, 01 Nov 2006 23:21:06 GMT

Let me try to clear you what i was trying to say:

Just open the Restrict Option of ur characterstics and go to Variable Selection Screen. If i am not wrong here only you created Hierarchy Node Variable? Now just switch-on Technical Names, and now you can see for which Hierarchy you created your Hirearchy Variable Node. Whenever you create Hierarchy Node Variable it creates for the hierarchy for which the option in drop down list of restrict option window is selected.

Is it clear what i am trying to say?

KJ!!!

Re: Hierarchy Node Variable not working

Former Member — Wed, 01 Nov 2006 23:49:53 GMT

Hi KJ,

Thanks for taking time to provide good suggestions.

I am not linking my Node Hiearchy to a specific Hierarchy. But I have linked it to a Hierarchy Variable. In 2004s you have the option to link to a Hierarchy or to a Hierarchy Variable.

So I have assigned this to a Hierarchy variable and still I am not gettint the correct result. I am not sure whether this happening becasue of SAP GUI or due to any program errors.

Thanks again for your reply.

Regards

Sundar

Re: Hierarchy Node Variable not working

Private_Member_9643 — Wed, 01 Nov 2006 23:54:56 GMT

Good to know about new feature...never noticed...even though i am also working on 2004s.

Thanks.

KJ!!!

Re: Hierarchy Node Variable not working

Former Member — Thu, 02 Nov 2006 00:01:17 GMT

I was able to do exactly what you did. What SPS are you on?

Thanks,

Jeff

Re: Hierarchy Node Variable not working

Former Member — Thu, 02 Nov 2006 00:54:31 GMT

Hello,

I am in SP7 and I would appreciate if you let me know on any note you applied.

Thanks for all the replies.

Regards

Sundar

Re: Hierarchy Node Variable not working

Private_Member_9643 — Thu, 02 Nov 2006 00:55:48 GMT

SP7 is having lot of issues...i would suggest you to go for SP9....its working fine for me in SP9.

Re: Hierarchy Node Variable not working

Former Member — Fri, 29 Feb 2008 17:51:11 GMT

I am working in 2004s as well (SP11) and I am trying to do the same type of thing.

I have multiple cost center hieriarchies that the user can choose from at run-time using the hierachy variable.

Then once the user chooses to the hierarchy they then should go choose a specific node that they want to run for in that hierarchy using the Cost Center Hierarchy Node variable (using the hierarchy variable, not fixed hierarchy).

When I run this in the web I am allowed to choose one of the multiple cost center hierarchies... this means that the hierarchy variable is working, however when i go to choose the specific cost center node for that hierarchy it uses the defult cost center hierarchy instead of the one selected in the selection screen.

If anyone can shed some light on this it would be greatly appreciated.

Aaron

Re: Hierarchy Node Variable not working

Former Member — Fri, 29 Feb 2008 18:54:36 GMT

All,

I tried this from scratch again and it worked. I think the issue is once you define a standard hierarchy and use the fixed value hierarchy node the query cache's that somehow.

I deleted all cost center variables within my report, and instead of defining the cost center hierarchy as a variable and then choosing to restrict my cost center by using the hierarchy node variable... I first restricted the cost center using the hierarchy and before using the right arrow to move it over as a restriction you change the node variable at the bottom of the pop-up window to use the hiearchy variable.

This method worked for me, yet was buggy if i did it any other way. Hope this helps.