Data Warehouses
All  |  Freeware

Stored Procedure used to determine the Linear Correlation between 2 variabes in a table of your database. This can also be used to determine the goodness of fit (Linear Regression) or best straight line between two columns of data in your database. The equation created will be of the form Y = A + BX, and finds the best straight line which...

Author: VISUAL-BASIC.NET   Category: Data Warehouses   License: freeware   Size: 3.0 KB

An access database, with a day table, and a script to generate de Date dimension used in any datawarehouse cube. Once generated, you can export to any DB Engine. File List: @PSC_ReadMe_509_5.txt 1Kb DateDimension.mdb 356Kb

Author: Javier Pichot   Category: Data Warehouses   License: freeware   Size: 70.0 KB

Calendar is a PL/SQL stored procedure that displays a 12-month calendar for the input year upon SQL*Plus execution. (This is a modified version of Sergio Rueda's 7/25/2002 "calproc.sql" Planet Source Code submission). File List: @PSC_ReadMe_1058_5.txt 1Kb calendar.sql 14Kb

Author: Andy Archer   Category: Data Warehouses   License: freeware   Size: 2.0 KB

All  |  Freeware