Time Dimension vs Measures in Minutes

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

Kimballs design Tip#51 - Time Dimension

This tip suggests that we can eliminate the minute dimension and have a full time stamp in the fact row.I need more clarification on how this could be implemented. For instance if I need a fact to be shown with 1/2 hour split down how could I do it withou

Measures as Dimensions: Banding Approach Help

I have a standard fact table with a number measures; several of which are in the form of time (e.g., minutes) and others in the form of integers. The fact table and related dimensions are exposed to users via BusinessObjects XI v2 Web Intelligence. One of

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,

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

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

A-Z Wholesale Terminations with Unbeatable Price

Hello, We offer A-Z Terminations with Unbeatable Price. We offer $1 free test as well. For more information please feel free to contact me on e-mail or msn messenger. Regards, Raj startvoip@live.com

How long time do you sleep everyday?

how long time do you sleep everyday? I feel tired and want to sleep now,I went to bed at 23 o'clock last night.

Funny comedy joke time!

We all could use a laugh now and again, so here's where to find one when you need one. If you have something funny from your fave comic that you want to share, post it here. I'll get the ball rolling with one of my favorites, the late great Bill

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.