1

Design Table for WBS

Hi One consultan, I have a Database with some tables, ones of them are correspond with the structure of the project WBS Work Breakdown Structure I have four level.

Level 1 Project, Level 2 Area, Level 3 Subarea, and Level 4 Subtistem in each box Level are asociated documents by disciplines.

Now I Link Each level  to documents 1 to Many Level 1 to Documents, Level 2 to Documents etc. 

I don't sure if is the best options I trie too related Level 1, to Level 2 to Level 3 and Level 4 but these option is complicated.

Some Alternative help

I send image example 

62 replies

null
    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 yrs ago
    • Reported - view

    You can see 3 curve the planned curve, the earned value and the Actual Hours.

    The 3 hours are different.

    • Fred
    • 2 yrs ago
    • Reported - view
    Rafael Sanchis said:
    Horas Ganadas Real are the Earned value it reflects the amount of hours that has actually been accomplished to data date.

    I read this as Horas Ganadas Real should be a formula field that sums up the Horas Consumidas for each documentos/disciplinas/ or actividades. Currently you are using the same horas humbre to figure out Plan and Real Horas Ganadas. To me, hitos only make sense at the planning level. Once you need actual horas then you have to track horas spent in another field (or table).

    Take a look at the attached DB. I've made a few modifications:

    1) at the Documentos Hito tab

    2) FechaCorte table

    • Fred
    • 2 yrs ago
    • Reported - view

    Now that I've had a chance to play around more, I've modified:

    Avances

    Disciplinas

    Documentos

    FechaCorte

    Take a look to see what you can do when you have a horasconsumidas table tracking horas. You can see the charts change in Tablero Avances when you add horas in Documentos.

    FechaCorte, I've changed into a dashboard. I've added the ability to see horas consumidas real by Hito selected.

      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 yrs ago
      • Reported - view

      Fred Hi Fed 

      OK in first picture, in these view I linked the Responsable with Documents now I know who charges hous to a Documents, works perfect now I have the Horas Actuales (Actual Hours) for each document spended by responsable

      In the second view I have my 3 kind of hours totally different hours

      The Plan Hours (Plan Original) 

      The Earned Hours (Ganadas) I need to place the date to win the Milestone and earned the hours different to Actual Hours 

      The Horas Actuales ( Actual Hours) A Responsable spend on the document)

    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 yrs ago
    • Reported - view

    I send you my last modify 

    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 yrs ago
    • Reported - view

    Another diferent help. These WBS havec3 level 

    Level 2 and level 3 don't working 

    But level 4 and 4 working good you can review the Formula on level 3 if you can 

    Thanks

      • Fred
      • 2 yrs ago
      • Reported - view

      Rafael Sanchis You had too many "a" and "b" in your code. Try deleting the contraints and just use the selection of the fields in the left side of the window. So for Level 3 you would select a (Documents) > Level 2 and b (Level-3) > Main Category. Do the same for Level 4, of course changing the actual field names.

    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 yrs ago
    • Reported - view
    I can't do it with the formula
    • Fred
    • 2 yrs ago
    • Reported - view

    What are the formulas you are using?

    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 yrs ago
    • Reported - view

    (select Documents) > a.a.'Level-2' and a.a.'Level-2' > a.a.'Level-3'

    I use this, but imposible.

    Sorry Fred I don't to waste your time.

    • Fred
    • 2 yrs ago
    • Reported - view

    Hi Rafael -

    You are not wasting my time. Try this in Level 3:

    a.'Level-2' = b.mainCategory
    

    And this in Level 4:

    a.'Level-3' = b.'Level-3'
    

    Like I said earlier, you have too many "a"s and "b"s. In addition there is no name "Level-2" in Level-3 table it is called 'mainCategory'.

    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 yrs ago
    • Reported - view

    Yeah work great for these work Breakdown Structrue that is more complicated.

Content aside

  • Status Answered
  • 1 Likes
  • 2 yrs agoLast active
  • 62Replies
  • 887Views
  • 2 Following