Time dimension - update

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

Assitance with Time Dimension

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

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

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

Waddle Dee *Minor Update*

Stance- Walk- Run- Dash- Jump (start)- (loop)- Double jump- Falling- Land- Crouch- Specials Neutral Special- Spear throw- spear- How it works:Dee throws a spear, simple as that. Air - The Same Side Special- (repeat twice,

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.

NEW UPDATE : Mobile forums, Footer edit, and more inside!

NEW UPDATE : Mobile forums, Footer edit, and more inside! Hello, In order to continuously improve our services and to bring you the best in the world of forums, we offer you today a new update that will add three brand new features. Without