Date Dimension | mark.tan

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

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

Aggregated Date Dimension

In my dimensional model, I have a Date dimension that plays many different roles in multiple fact tables. I will also have a fact table that store metrics aggregated at the Month level and one that stores metrics aggregated at the Quarter level. How

Date Dimension Creation

I've read several of the Kimball Group Books and each time I read about a Date Dimension it is recommended that it be built in a Spreadsheet. Is this still the accepted method? I'm generating mine in SQL Script and I wondered if most were still using

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

Known Issues with MID7015-4G

"Wakes up" every few minutes when in standby mode Pictures stretch and I look fat in landscape mode (don't know if this is fixable by software or not) Sometimes web pages zoom in or out when I don't want them to (others have attested to this, it is

Celebrity Apprentice 4

If this is a sample of the cast....yikes. Is this their best??? Celebrity Apprentice 4 cast names leak out The Celebrity Apprentice 4 starts filming next week, and several cast members names have been leaked to various

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