BW Hierarchy

[Former Member]

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.

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

[Former Member]

Hi guys,

does anybody know/ have a hint about my question?

Thanks in advance!!

[Former Member]

Hi Shivaram,

When you create any variable then there is a tab called hierarchy.

There you have set Expand to level properties.

Try with this option, hope your issue will bw resolved.

Thnaks,

Jitendra

[Former Member]

Are the hierarchy nodes which are available for selection displayed automatically or is an adjustment necessary?

Edited by: saplaz on Jun 22, 2011 1:31 PM