logic4fun at 19h59
13
May
2010
Time Dimension with Day Light Savings
I know time dimension has been adressed here in many threads but what i didnt find is dimension which takes care of the DST changes.
I have a time dimension table that has 86400 rows which represent each second of the day. But my question is how do i handle the DST day which has 25 hours or more seconds than 86400 ?
Thanks for your time and looking at this
Prasad
I know time dimension has been adressed here in many threads but what i didnt find is dimension which takes care of the DST changes.
I have a time dimension table that has 86400 rows which represent each second of the day. But my question is how do i handle the DST day which has 25 hours or more seconds than 86400 ?
Thanks for your time and looking at this
Prasad
About
This topic belongs to the forum
Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.
- Numbers of topics : 1858
- Numbers of messages : 8714
- Numbers of users : 3801
- Numbers of points : 1672
Similar topics
Hello,
I am building my first DataWarehouse and I got stuck on how to handle the time of day and my business hours.
I am trying to evaluate response times for support cases and I have multiple time zones with different business hours. I only need to
Hi
I have to create a time dimension to cater to the reporting needs. With the current database structure which is not a dimensional model we need to create reports that are period based.
How do we create a time dimension table (we need year, quarter,
Hi All,
I would like to design the time in a multidimensional model.
The classic calendar date dimension (day, week, month, year) should be applied here. Besides that, I have a fine grain: the minute.
More specifically, let's suppose I have 10.000
Hello all
I am in the process of trying to build a database that will allow for effective reporting on the performance of an automated task scheduling system. This system can perform a number of tasks that take less than a second up to tasks that take
I need to build an accumulating snapshot where not only do I need to track the many dates I need, but also the specific times of when things occur. Role playing and using a date dimension is not enough because it doesn't track the specific time of the day
Forums from same category
LEGO Island Discussion, modding, news and more!
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
HmongThoobNtiajTeb. com/
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
Search
Informations
3 Replies For the topic :
"Time Dimension with Day Light Savings"
This topic has been viewed 1568 times.
Last message :
13/05/2010 at 19h59 by "logic4fun"






