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