Modeling goals which may slowly change over time

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

Hi, I was not sure if this question was for ETL or here ;-) This is the situation : I have created a DW and a cube for statistic for Paramedic events. I'm working for the governement of canada and they are using some unusual financial period (13

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

Handling different Time Zones

I have SSAS 2008 with sql server 2005 database as a source. Currently, we store all dates in UTC time and use system generated Time dimension in the cube. Up until recently the granularity of a day was just fine for our needs. Now ( I've been doing

Type 3 Slowly Changing Dimension

I am trying to find a best example / scenario where a type 3 scd would make more sense than a type 2. In my understanding type 3 can easily be derived from type 2. If anybody has used type 3 dimension instead of type 2, please let me know the scenario an

Dynamic KPI goals

Hi All, We have a fact table where we collect some details (e.g. A, B, C, D ...) and on our reports we show KPIs based on these details. Let say KPI_1 is based on A and B, KPI_2 is based on A and D and so on. We have some dimensions like Departments,

Dimensional modeling on HospitalStay

a different question on The Data Warehouse Toolkit, 2nd Ed. The complete guide to Dimensional Modeling. In Chapter 13 page 265 "In a hospital stay situation, however, the diagnosis group probably should be unique to the patient because it is

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

2 sources using Dimensional Modeling Workbook

We are using Kimballs Generic Dimensional Modeling Workbook and it is really great! But now we have 2 sources to the same target and are not sure about how to document that. Anyone now about a best practice for how to document this in the Generic

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

[WALLPAPERS CONTEST] Time to vote for the best one!

Dear users! First of all thanks to all participants! We had 150 wallpapers submitted, which is by far our must successful contest! It's now time to vote for the best wallpapers. Only 5 will win! Ready? All you have to do is to pick your favorite

Want a Username Change?

Username Change Hello Forumotion Members Do you Want to change your Username? Just reply to this topic with the following details. Code: Last username: New username: Reason (If

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