Regnecentralen /
National Danish Center for Advanced Calculations (NDCAC)
Contact Us | Login | rcnet
 Search
   Home    Research    Products    Press    About  
  Publications
  Time Dimension Generator
  Legal information
Billetsystemet 2006 v2.1
Billetsystemet 2006 v2.1 has been released! Click here to learn more

Regnecentralen's History
The exciting history of Regnecentralen

People at Regnecentralen
Regnecentralen's main profiles

Kassesystemet at Work
"Kassesystemet" being used in a women's clothing store - click here to learn more

So Easy!
Anybody can use Billetsystemet!

Time Dimension Generator / Builder
Use this (free) service to generate a time dimension for data warehouse/OLAP applications. The generator outputs a relational table (as INSERT-statements or comma-separated values; 45+ columns) which can be loaded into your data warehouse time table. The generator builds the following hierarchies:


Each hierarchy level contains an integer key (defining navigational paths and chronological sorting), a name (e.g. "Q2"), a textual description (e.g. "Second Quarter"), and a number of different flags (e.g. isWorkday which "flags" work days). Use the keys for building and sorting the hierarchies, the name- and text columns for showing the member values and the flags for your specific reporting requirements (all flags are integer 0's or 1's allowing both COUNT and SUM aggregation). Use this dimension as a starting point for building a time dimension that suits the specific needs of your data warehouse.

To build the time dimension, please review the configuration settings below and press the "Generate Time Dimension"-button on the bottom of the page. To further configure the time dimension use UPDATE-statements after loading the table into the database.

Day-Level Configuration
Please review the configuration settings for the day-level.

Day name format   
Day text format

At the date/day level the following 12 columns are generated: Day_Key, Day_Timestamp, Day_Name, Day_Text, Day_WeekdayName, Day_IsWorkday, Day_NumberInWeek, Day_NumberInMonth, Day_NumberInYear, Day_NumberInFiscalYear, Day_NumberSinceBeginning, IsToday. NOTE: Day_Key is the primary key of the dimension (DWID in the figure above).

--> Note on the IsToday-column

Week-Level Configuration
The time dimension generator uses the ISO8601:1988 standard for week enumeration. The first week of the year is defined by ISO as the one which contains the fourth day of January. Please review the configuration settings for the week-level.

Week name format   
Week text format

At the week level the following 4 columns are generated: Week_Key, Week_Name, Week_Text, Week_NumberInYear.

Month-Level Configuration
Please review the configuration settings for the month-level.

Month name format   
Month text format

At the month level the following 5 columns are generated: Month_Key, Month_Name, Month_Text, Month_NumberInYear, Month_NumberInFiscalYear.

Season-Level Configuration
There are four seasons in one year (spring, summer, fall, and winter) each season four months long. Please select the month when spring begins.

Spring starts at   

At the season level the following 3 columns are generated: Season_Key, Season_Name, Season_Text.

Quarter-Level Configuration
The quarter divides the year (calendar and fiscal) into four parts, each consisting of three months. Please review the configuration settings for the quarter-level (calender- and fiscal hierarchies).

Quarter name format   
Quarter text format

At the quarter level the following 8 columns are generated: Quarter_Key, Quarter_Name, Quarter_Text, Quarter_NumberInYear, FiscalQuarter_Key, FiscalQuarter_Name, FiscalQuarter_Text, FiscalQuarter_NumberInFiscalYear.

Semester-Level Configuration
The semester divides the year (calendar and fiscal) into two parts, each consisting of two quarters. Please review the configuration settings for the semester-level (calendar- and fiscal hierarchies).

Semester name format   
Semester text format

At the semester level the following 8 columns are generated: Semester_Key, Semester_Name, Semester_Text, Semester_NumberInYear, FiscalSemester_Key, FiscalSemester_Name, FiscalSemester_Text, FiscalSemester_NumberInFiscalYear.

Year-Level Configuration
The year level is not configurable.

At the year level the following 3 columns are generated: Year_Key, Year_Name, Year_Text.

Fiscal Year-Level Configuration
A fiscal year spans 12 months like a "normal" (calendar) year. What differs is the date when a new year starts. A calendar year always starts at January 1st, a fiscal year can start at any month. As an example, Danish companies often use a fiscal year that starts at July 1st and ends at June 30th the following year. Select the calendar month that starts the fiscal year, i.e. the very first month in a new fiscal year.

Fiscal year starts at   
Fiscal year name format   
Fiscal year text format

At the fiscal year level the following 3 columns are generated: FiscalYear_Key, FiscalYear_Name, FiscalYear_Text.

Output Configuration
Configuration settings.

Years of data to generate   
Start from year   
Output format   

Generate and Download the Time Dimension
The time dimension will be printed in ASCII in this browser window when you press the "Generate Time Dimension"-button below. Select "Save As..." in the File menu to save the data to a local text file (REMEMBER: Select file type *.txt when saving!).



If you have comments regarding the Time Dimension Generator or ideas for improvements, please don't hesitate to send us your input! Please use the contact form and select the "General inquiry"-area-of-contact. Thank you.

DISCLAIMER
THE MATERIALS ARE PROVIDED "AS IS" WITHOUT ANY EXPRESS OR IMPLIED WARRANTY OF ANY KIND INCLUDING WARRANTIES OF MERCHANTABILITY, NONINFRINGEMENT OF INTELLECTUAL PROPERTY, OR FITNESS FOR ANY PARTICULAR PURPOSE. IN NO EVENT SHALL REGNECENTRALEN OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION, LOSS OF INFORMATION) ARISING OUT OF THE USE OF OR INABILITY TO USE THE MATERIALS, EVEN IF REGNECENTRALEN HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.

Provided by Gren & Holm ApS.

Most Downloaded Publications
Specifying OLAP Cubes On XML Data, Journal Edition (PDF)
Converting XML Data to UML Diagrams for Conceptual Data Integration (PDF)
Discovering Multidimensional Structure in Relational Data (PDF)


External References
DBLP Computer Science Bibliography
The OLAP Council
Datawarehouse Tools and Tutorials
DP Research Unit, Aalborg University
ACM SIGMOD
Scientific and Statistical Database Management (SSDBM)


External References Free Math Software
GNUPlot
Scilab
Octave
R Project


Popular Products
Billetsystemet Net
Billetsystemet 2006
Kassesystemet
Time Dimension Generator


Buy a Product
Request a phone call from the Sales Department


Legal Information | Privacy Policy | About Regnecentralen | Contact Regnecentralen
Regnecentralen's website is optimized for Internet Explorer 6+ @ 1024x768x24. Copyright Regnecentralen 2000-2008, all rights reserved. Material from the website (except press material) may not be copied or used in any way (including personal use) without prior permission. Please send questions and comments regarding the website to the webmaster. All activity is logged. Your IP: 54.225.47.94.