autogenerate time dimension?

From: <rbook_at_my-dejanews.com>
Date: Mon, 13 Jul 1998 09:24:55 GMT
Message-ID: <6ocjp7$j55$1@nnrp1.dejanews.com>

Hi all,

i decided to automatically generate a "full" time dimension with attribut date as primary key. I thought this table is better to use in an galaxie invironment.
Is there an elegant way to automatically fill the time dimension table which looks like
dim_time(date_id date primary key,

         week_in_year number,
         month_in_year number,
         quarter_in_year number,
         year number)

without inserting the transaction dates from the legacy system?

Thanks for attention and help

Ralf Book

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Jul 13 1998 - 04:24:55 CDT