cancel
Showing results for 
Search instead for 
Did you mean: 

Hierarchy with External Characteristics

Former Member
0 Kudos

I have a request to create a hierarchy for a BEX query that is based on a combination of WBS Element and COORDER. I see that I can change either of these InfoObjects to allow External Characteristics and I have done this.

This hierarchy is to show costs by Project Manager. Each Project Manager can have many projects and each project can have many WBS Elements plus individual orders or nothing but individual orders. I've built the hierarchy and it works in the query as far as how the results are displayed. But I am only getting costs associated with WBS Elements not with orders. (I should add that we do not post to WBS Elements, we assign WBS Elements to orders and we post costs to orders so WBS Element is an attribute of COORDER).

For instance, one project manager could have 2 projects; Project 1 includes all orders associated with WBS Element 1 (so I assign the value for WBS Element 1 to a node); Project 2 includes all orders related to WBS Element 2 as well as Order 1 and Order 2 (which are assigned WBS Element 3 but I don't want all of the orders assigned to WBS Element 3 so I assing WBS Element 2 to a node, Order 1 to a node and Order 2 to a node).

Here is what it looks like:

1 0HIER_NODE PROGMGR1 (child ID = 2; next = 4)

2 0HIER_NODE PROJECT1 (parent ID = 1; child = 3)

3 0WBS_ELEMT 1 (parent ID = 2)

4 0HIER_NODE PROJECT2 (parent ID = 1; child = 5)

5 OWBS_ELEMT 2 (parent ID = 4, next = 6)

6 0COORDER 1 (parent ID = 4, next = 7)

7 0COORDER 2 (parent ID = 4)

I get all of the costs for both projects that are associated with WBS 1 and 2 but none of the costs for the two orders not related to a specific WBS Element.

I have created a selection variable to use the hieracrchy when selecting the query results. What is the point of assigning External Characteristics in a hierarchy? I understand logically why my query doesn't select the costs associated with the orders since my hierarchy is based on WBS Element not order. I've tried including the WBS Element associated with the individual orders in the hierarchy with the thought of restricting those particular nodes down to the specific orders in a structure in my query but I can't seem to figure that out either.

Can anyone give me any ideas on how to do this?

Thanks,

Barb Bunker

Puget Sound Energy

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello baRbaRa,

How r u ?

You have Kept the 0HIER_NODE for the PROJECT MANAGER. Will there be only one project manager !? Assuming you will have more Project Managers,

0HIER_NODE

|_ZPROJ_MGR

...|_ZPROJECT

......|_ZWBS_ELMT

......|_ZORDERS

If you assign the WBS Element & Orders to PROJECT it should give the costs based on the PROJECT & WBS Element / PROJECT & Orders combinations.

Is this you r looking for ?

Best Regards....

Sankar Kumar

+91 98403 47141