Assitance with Time Dimension

Store Business Hours in Time Of Day dimension?

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

time dimension

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,

Time Dimension vs Measures in Minutes

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

Time in fact or dimension? Accumulating snapshot

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

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

Real time datawarehouse replacing operational reporting

Hi, As I was reading through articles I came across one of the advantages in real time datawarehouse that it can replace the operational reporting so there is no need for reports to go across 2 reporting DB there can be one centralised Real time DW and

Sparse dimensions, how to handle?

I've purchased the book "The Microsoft Data Warehouse Toolkit" and have reviewed it in order to build out a data warehouse solution I am currently designing. I am stuck in a spot that I don't seem to find any examples of , or am not abl

Demyx Time

Have you ever heard of Demyx Time??? I SO hope you have. It is the greatest TV show EVER. (Although, it isn't on TV, so I guess it's not really a TV show...) If you don't know what it is, here's a quick descrciption. Demyx Time is a youtube show that

Time Frame & Estimate

I am new BI learner and currently studying kimball datawarehouse toolkit. I have question, How can i estimate a time frame and estimate in terms of working hours for Data Warehouse project. I know we have to go through whole Business dimensional lifecycle

Audit Dimension Help

Hello all. I'm at the stage now where im building the audit dimension for my warehouse. I am having a little trouble figuring out a few things though. How do you aggregate the data from the error event fact table into the audit dimension? Some records

Adding smilies in more than 1 at a time

Well I've found lots of brilliant smilies I want to use but I can't because I have to manually go through all the other smilies deleting them, then I have to add the new smilies one by one, annoying right? Well I want to have an option added to add more

[NEW CONTEST] Time to get creative for Christmas!

Hello We're now near XMAS! And to celebrate the event, ForumOtion is offering you loads of credits with this new contest of XMAS themes ! Let's see a flashback of last year winners: 1st, with 65 votes : Christmas magics 2nd, with 62

What's the current time in your country?

well this is simple Just tell us what's the current time on your country everytime you log or so on It's 9:15 pm here.