Time in fact or dimension? Accumulating snapshot

Modeling Question - Accumulating Snapshot vs. Event Transactions

I have a business process that has 6 distinct steps from start to conclusion for each instance of the process, we'll call it a case. Each case has two employees assigned to it, 1 owner and 1 co-owner. The owner and co-owner each have different

Accumulating Snap Shot Challenge

Hi, I'm working for a large Internet Service Provider (ISP) and have a DW modelling challenge which I hope people can help me out with. Their nature of business includes as a fact recording as an accumulating daily snapshot real time partition basic

Subscription as an Accumulating Snapshot Fact or a Dimension?

I am designing a data mart for a subscription based service (my first data modelling effort). Each customer can have multiple accounts and each account can have multiple subscriptions. I have added a Sales Fact table and a Monthly Subscription Snaphot

Accumulating snapshot with SCD?

Is it common to update dimension keys within an accumulating snapshot fact table if it contains some slowly changing dimensions? Or is good practice to leave the keys alone and only use a more current key for new rows? My inclination is to leave the

Conformed Dimension for Transaction Fact and Accumulating Snapshot Fact Table

I'm working on a new warehouse application for reporting against our IT Project database. I want to create both a transaction fact table and an accumulating snapshot fact table. The project database (source) consists of multiple normalized tables to

Montly Snapshot views with transactional Fact table w/SCD2

I am a new at working with Dimensional Database design. I am struggling with something that probley is real easy to do, but just can't find documentation that will explain it. I want to create a monthly snapshot view of my transactional Fact table with

Transactional detail fact table w/complimentary snapshot table. How do the two play together?

Take a detail daily banking transaction table with standard credit and debit level transactions. I want to build the accompanying snapshot that would present the higher level rollups of these lower transactions: There are about 250 daily transaction

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

MH Forum Help - How to take a "snapshot" or "screen shot"

How to take a "snapshot" or "screen shot" by revvinon To take a snapshot of your computer screen you need to bring up the image you want to capture on your computer monitor/screen. Say I want a picture of this post I am doing

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

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

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

Banning members from the chatbox for a time period

Hi everyone, I have this idea,when your a moderator of a chatbox on a forum,the mod can use a code to ban a member for a certain time period,instead of banning them,and having to unban them. Example: Code:/ban/{time limit for the ban}