Source Code Online Home Categories Top Code New Code Submit Code
Search
New Code
Data Correlation o
Calendar 0
Olap Date Dimension Builder o
Top Code
Calendar 0
Data Correlation o
Olap Date Dimension Builder o
SQL > Data Warehouses
Source List

Code 1-3 of 3   


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. T



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).



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...