Generating data for populating Date Dimension table using familiar Microsoft Excel
Generating Date Dimension data in Microsoft Excel
Oracle SQL script to generate Date Dimension data for use in Microsoft Excel Data Models
Date dimension is that one dimension or business perspective without which an Excel Data Model cannot ever exist. Here is an Oracle SQL script to generate the data for a Date Dimension. All that you have to do is change the start date and end date values in the in the last line of the... Continue Reading →
