Time Dimension Generator / Builder
Use this (free) service to generate a time dimension for data
warehouse/OLAP applications. The generator outputs a relational
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
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
1's allowing both
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
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.
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.