Aggregated Date Dimension

Loading Data Aggregated to Date into Fact Table

I have following source table: Source Table ID App_Version Os_Version Date 9123305 2.5.2.60 Windows NT 5.1 2/15/2009 9123306 2.5.2.60 Windows NT 5.1 2/15/2009 9123307 2.5.2.60 Windows NT

Conformance of Dimension for facts aggregated at different levels

I am a newbie to Data Modeling. I am modeling a warehouse for Global reporting solution for a business operating in 3 countries. 2 business processes involved are "Sales" and "shipment Expenses" The input is sumarized excel files

1 Dimension used multiple times in 1 fact table?

Hello, I have a dimension used to store several types of 'bands' like monthly income bands, available income bands, risk bands, settlement bands etc. If I leave out all the lineage columns this is what the dimension looks like: DimBandID BandType

Date Dimension or DateTime Field

Hi, I'm working on a project where dimensions have dates in them. An example is for a client where we have date of birth, joining date, date of death, etc. In fact i have about 6 different date columns. Now, I'm trying to find out what the best

Date Dimension refresh for all data marts nightly ??

We are working at client site where we recommended using the BUS architecture and we are using PPS Monitoring for dashboards. Our client has been re-building each data mart nightly for now and they are re-building each data mart dimdate dimension with row

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

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

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

SSIS SCD Component

We are using (or attempting to use) the Kimball Method SSIS Slowly Changing Dimension Component for SSIS from Todd McDermid (http://kimballscd.codeplex.com/). We have run into a few issues and would appreciate some advice if anyone has used this SSIS

Supplier Dimension to include Customers & Employees

We are in the process of finalising Dimensions /Facts to be used in Datawarehouse. Already finalised separate dimensions (eg Customer,Supplier,Employee) to handle requirements of Sales,Purchace and Human resourses. During designing Accounts Payable Fact

bad date stories

For the period i was on the dating scene i had several bad dates. I'm gonna summarize here and would love to hear yours!! #1 Tracksuit Guy He showed up to an upscale bar/restaraunt in a poufy nylon tracksuit (and no he had not been running) He

Survivor: Redemption Island

This was a CBS Tweet from today: CBS ANNOUNCES 16 OF THE 18 CASTAWAYS FOR "SURVIVOR: REDEMPTION ISLAND" Two Former Castaways (to Be Announced Later this Week) Will Return to Seek Redemption I think we all know who they are by now Hit

'The Bones Of You' - Release Date and Video Premiere

The next single to be taken from the Mercury Prize nominated album 'The Seldom Seen Kid' is flawless epic 'The Bones Of You'. The single - released on September 29th - will be exclusively available as an iTunes download bundle featuring the album