variable hierarchy doesn't work

[Former Member]

Hi Friends,

Please let me expalin my problem.

Case 1

Iu2019ve defined a hierarchy as variable in a query and a variable for herarchy nodes to

restrict the characteristic as well (characteristic displayed in rows)

Calling the query, I can select required hierarchy and then in a separate selection the nodes assigned to this hierarchy. So far it works as designed.

Case2.

But when I use the variable for a hierarchy node to restrict key figures, system doesnu2019t change the selection of nodes according to selected hierarchy.

Example.

Case 1

Selecting hierarchy H1 provides nodes HN11 HN12 HN13 ,

selecting hierarchy H2 provides nodes HN21 HN22 HN23

Case 2

Nodes HN11, HN12 HN13 are provided, irrespective of selection of H1 or H2

Any suggestions?

Thanks in Advance & Regards

Joe

[Former Member · Accepted solution]

I am not sure I understood your problem correctly but:

likely, in your hierarchy node variable definition, you have based it on static hierarchy H1 and so you get options from H1 only.

[Former Member · Accepted solution]

Hi,

For this issue two types of variables are important:

Hierarchy selection of hierarchy to be used for a particular characterietic)

e.g. H1

Hierarchy node (selection of nodes within a defined hierarchy)

e.g.. HN11, HN12, HN13 in dependency of input in variable for hierachy

Defining hierarchy as variable and assigning a variable will craete a field for input on the selection screenn.

Restricting characteristics with a variable for hierarchy nodes creates a second one.

In case 1, where caharacteristic is allocated to rows, variable for hierarchy nodes offers nodes dependend on settings of variable for hierarchy, i.e. changing selection for hierarchy causes display of different nodes in selection for hierearchy nodes. That's exactly what system should do.

In case 2, when I use characterietic to restrict a keyfigure with vthe same variable for hierarchy nodes , this variation doesn't take place, offered nodes in selction screen are always the same

I know it's a little confusing, but I hope I could clearify my issue.

Regards

Joe

[Former Member · Accepted solution]

Hi again,

to make it easier (hopefully),

Is there any option to restrict hierarchy in a selection of a keyfigure?

If several hierarchies exist for the same caharacteristic, I don't have any chance to

take inkuence on hierarchy selected by system.

Dis anybody face this issue also?

Regards

Joe

[Former Member · Accepted solution]

>>

Edited by: J.F.B. on Feb 21, 2011 3:31 PM

[Former Member · Accepted solution]

Finally found what I missed.

Setting hierarchy as variable at IO Level is not the right way for my requirement.

What I've overlooked, is the option to select a specific hierarchy or a hierarchy variable

within the window for selecting the hierarchy node variable (left lower section of selection screen)

Regards

Joe

[Former Member · Accepted solution]

I have both the Cost Center and Cost Element Hierarchy in my Query, i have many cost center Hierarhcy and Cost Element Hierarchy , when i create Hierachy Varaible and try to display both i am not getting the right variable slection and cost element is also not getting displayed correctly can you help me on this...

I have installed standard CO Query 0CCA_C11_Q0062, 0CCA_C11_Q0052,

The Query has Cost Center Hierarchy, Cost Element Hierarchy, Cost Center and Cost Element Nodes as ranges in the selection criteria..user can enter any one of the above for the Plan/Actual data.

Hierarchy Variable seems not working, it fetches all data from the CUBE as Flat List ignoring the selection when i give only the Hierarchy Nodes,

I am also not able to view the data in Tree Format, the data is displyed as flat from the CUBE with Cost Center and Cost Element..

My Requirement:

User can select any of the above selection which should not be manadatory:

Cost Center Hierarchy or

Cost Element Hierarchy or

Cost Center Nodes or

Cost Element Nodes.

or i want the Result output to be displayed by both Cost Center Hierarchy, Cost Element Hierarchy only not Nodes or with Both..