Dana nedjelja, 15. veljaÄ   
   e 2015. u 18:02:34 UTC+1, korisnik Tony Johansson napisao je:   
   > Hello!   
   >    
   > Assume I have a table called Sales in the dataware house where we have the    
   > four columns Month, Ice cream, City and quantity.   
   > We have three dimensions where we have Month, Ice cream and City.   
   > It could look like this   
   > Sales table   
   > Month        Ice cream        City                Quantity   
   > January      Päronsplitt        Stockhomn       3   
   > January      Top hat            Göteborg           7   
   > January       Smugler           Malmö              13   
   >    
   >    
   > Now to my question. It is important to keep historic data in the dataware    
   > house.   
   > So assume that I want to keep history of the price that have been existing    
   > on different ice cream how   
   > would this be structured in the sales table   
      
   On my websites http://www.dbdesign10.com and http://www.dbdesign11.com you can   
   find a solution that keeps "history".   
   This is the first and only correct general solution that solves the "History".   
      
   Vladimir Odrljin   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)