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.