Skip to Content
0
Former Member
Oct 13, 2005 at 07:39 PM

Hierachy Report

15 Views

Hi all,

I have a 3 level WBS Hierarchy wherein all my plan and actual costs are always posted to the 3rd level WBS Elements. They sum up to higher level WBS Elements.

Now I have a requirement to give the selection option for the WBS element for input. When I enter the values of either 2nd level or the 1st level WBS elements, as there are not available in the cube, I am getting 'No Applicable data'.

Is there anyway or any variable where in I can get the lower WBS elements values with the selection option.

Ex:

WBS1----


200

-WBS21----


120

-WBS31 ----70

-WBS32 ----50

-WBS22----


80

-WBS33 ----35

-WBS34 ----45

Now I need a variable such that if I entere WBS22, it should give me 80. Note that WBS1, WBS21, WBS22 are not avaialbe in the cube as it is.

Thank You

Ace

Message was edited by: Ace Base