Subsetting date/time Dimensions and Role Playing Date/Time Dimensio...

Too many Time Dimension Role Views?

I have a question about date fields and the time dimension. We have an Order Detail fact table that has about 10 date fields. We're not sure how best to handle these with regards to joining them to the "Time" dimension. If we strictly

Role playing Dimensions: When is it appropriate?

This issue has come up and I was curious what you would say. This stems out of differing interpretations of role playing a dimension in the Data Warehouse Toolkit. There are basically two faction where I work concerning when it is appropriate to role

Questions about Dimension Role-Playing

On page 110 of "The Data Warehouse Toolkit (2nd Edition)" it talks about basically creating a view for each "role" the time table might represent. Seems like you would end up with an excessive number of views. The 2nd paragraph state

Dates in many dimensions

Hello, I am new to DW. Currently, I am working on a Human Resource database. There are many tables in the source systems which stores dates e.g. dates about contract start, finish, Vacations of an employee, temporary service suspension and many more.

How to role playing dimensions in PostgreSQL

I am new in the DW/BI world but as far as I've learned, the Kimball approach is the best. I need to make use of "role playing dimensions", more specifically I need more than one date in my fact table. I've read in the Kimball's books that it can

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

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

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

Fact table with multiple date ?

Hi, I am modling a fact table for prisoners inscription in order to track historical changes. An admission is the hole stay comprise of one or many inscriptions usually separated by transferts between institutions. In the transactionnal system, it

How to improve battery life on the HTC Surround

Smartphones are well-known for their limited battery life and although the HTC Surround features an impressive 1500mAh battery, it won't last forever. Here are our top tips for maximizing battery life. 1. Reduce the time before the screen turns

SimBro_Release_v2.1.4_100131_TEST

rapidshare.com SimBro_Release_v2.1.4_100131_TEST.zip rapidshare.com SimBro_Release_v2.1.4_100131_TEST1.zip mediafire.com ymmnziitmow [Fix] Some typo, Style level bug [Codechange] Clean up some mess, [News] Nothing....

[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

online status time

An option where you can set the "who is online" time ... if your are inactive for 10 secunds you are already not online ... I think a setup option for this time would be great ... so users can read in a topic and be shown online on the botton of

Subsetting date/time Dimensions and Role Playing Date/Time Dimensions