0 Replies Latest reply: Apr 15, 2011 12:38 PM by pscorca69 RSS

    Right data structure and load


      I need to manage the load from a SQL table that contains fe ProjectCode, ProjectDescription, Year, Month, ProjectAmount, ProjectCosts, ProjectInvoiced. I can have temporary data and in a second moment definitive data. I think to create a flag for my SQL table and alternatively an analogue SQL table. This choice depends from the load to implement in QV. I must show two charts, the first one with temporary data (first fact table) and the second one with definitive data.

      Which is the better solution? Managing a flag in the original SQL table, or managing two SQL tables and two different load (concatenated?) in QV?

      Any helps to me, please? Thanks