Time dimension confusion
neil phillips at 14h19
14
Jul
2009
Time dimension confusion
Hi, first post here so I hope someone can advise on this. I'm looking to remodel time dimensions to somehow combine monthly 'periods' and weekly 'periods'. The aim being similar to a fiscal calendar where each week is allocated into a month period (e.g. 4-4-5 repeated)
The issue is that my employer has two types of timeframe for managing the business income. We may charge our customers on a weekly or monthly basis depending on the agreement. Fis
Hi, first post here so I hope someone can advise on this. I'm looking to remodel time dimensions to somehow combine monthly 'periods' and weekly 'periods'. The aim being similar to a fiscal calendar where each week is allocated into a month period (e.g. 4-4-5 repeated)
The issue is that my employer has two types of timeframe for managing the business income. We may charge our customers on a weekly or monthly basis depending on the agreement. Fis
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
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
HmongThoobNtiajTeb. com/
LEGO Island Discussion, modding, news and more!
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
Search
See also
Informations
1 Replies For the topic :
"Time dimension confusion"
This topic has been viewed 1830 times.
Last message :
14/07/2009 at 14h19 by "neil phillips"
