3 Replies Latest reply: Mar 16, 2010 8:41 AM by MManders RSS

    Multiple dates and synthetic keys, the road to hell?



      I am apart of a group creating a DSS as a university assignment, we are having a problem. The system is currently linking Orders on Employee ID. From order we get the date variables year, month and week. When we want to calculate the yearly costs for a selected year we need to be able to get this information from hire date as well (in order to determine who was hired at the specific date (at the moment we only get the sales people since they are in Orders)). Creating more year variables creates synthetic keys and we are not allowed that. Is there a way to do this by creating a table or perhaps in the code for the graphs? We tried creating some tables but we got circular references. Any help is much appreciated.