XPost: comp.databases.olap, comp.databases   
   From: n_o_spa_mjoerg_narr@hotmail.com   
      
   "New Guy"  schrieb im Newsbeitrag   
   news:2e50789c.0405181514.11ee3328@posting.google.com...   
   > I am trying to create in my Oracle test database a "time" table that   
   > would have time buckets. What I mean is that, it would have some   
   > structure like this   
   >   
   > 0-5 minute bucket   
   > 10-15 minute bucket   
   > 15-20 minute bucket   
   > ...   
   > 55-60 minute bucket   
   > 0-2 hour bucket   
   > 2-4 hour bucket   
   > 4-6 hour bucket   
   > ...   
   > 22-24 hour bucket   
   > day number   
   > week number   
   > month number   
   > year number   
   >   
      
   A vendor neutral approach could be to create an additional bucket dimension   
   (with a key column in your fact table) if each fact has this dimensionality.   
   This would allow your users to see how the bucket usage developed over time.   
      
   Kind regards,   
      
   Joerg   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)