Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: To-Date Calculations
My solution with the views is using a time dimension table to place the weekly amounts within the appropriate month-to-date and year-to-date columns.
Does your solution use Oracle's Time Series support?
Does your solution generate multiple rows for each row in the table?
Does your solution use views?
Does your solution store the values in an aggregate table?
"Steven Hauser" <hause011_at_garnet.tc.umn.edu> wrote in message
news:8r91n4$k9$1_at_garnet.tc.umn.edu...
> Use what is known as a date dimension in datawarehouse lingo.
>
> That is the precalculated table of date values to join with
> the large fact table. One attribute of daily dates can be
> used to create the other attributes of weeks, months, quarters,
> business quarters, days of week, etc using the date functions
> in Oracle.
>
> Read the Data Warehouse Toolkit by Ralph Kimball for reasons
> you would do this.
> --
> ---------------------------------------------------------
> Steven Hauser
> email: hause011@tc.umn.edu URL: http://www.tc.umn.edu/~hause011
> ---------------------------------------------------------
Received on Fri Oct 06 2000 - 09:01:34 CDT