Model available time per day in timesheet data warehouse: fact or d...

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

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 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

Using a dimension in multiple fact tables with different grain and support SCD

Hello users, i've a question about using a dimension in fact tables with different granularity and at the same time retain support for SCD. My scenario: I have one Dimension called Apartment. This Dimension cosists of the following related

Data Warehouse for survey data

Hi All, Working with a company which uses Salesforce.com heavily. They have a large number of custom fields, and great volatility in them - frequently adding and deleting them when they cease being relevant (They collect survey data for their clients).

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

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

Dimensional Model Vs Views as Structure for BOBJ Universe

I have a fairly complex data mart (multiple fact tables: 5 at the moment and several more coming; 4 shared dimensions across the 5 facts, 26 total dimensions and several bridge tables). I used standard best practices for building the Business Objects

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

Questionnaire for medical record entries

Good afternoon, I am currently working on a data warehouse in the health care sector and I currently facing this problem: The aim of this warehouse is to have an overview of a cancer therapy. So, I have created the following fact table

[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

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

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....

Model available time per day in timesheet data warehouse: fact or dimension or neither?