0 Replies Latest reply: Jan 16, 2012 12:06 PM by Marcos Herrera RSS

    Budget problem

    Marcos Herrera

      Hi dear Community I have a problem with my data model, the budeg table are not at the same level that fact table.


      The model contain this table


      DatosPyG --> This is the fact table with fields cuenta, value,date

      PUC-> This is a Dimention Table with fields cuenta,namePuc,budget

      Budget -> This is de fact table for Budget with fields  budget,valueBudget, dateBudget


      The PUC table group many cuenta rows in each group


      I need compare  the values of Sum per namePuc vs Budget.