Date Dimension Creation

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

Hi All, I understood Kimball way of implementation Date Dimension table. In a way, the lowest granularity date represent each record, with the following month, quarter and year attribute. However, what happen if the lowest grain of certain fact are at

SET1/ Q.3 How assignment is different from other methods of charge creation?

Q.3 How assignment is different from other methods of charge creation? What is right to set-off?

program-creation

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

Who would you say would make a good husband for Samus Aran?

I'm sure we're all aware of how people like to joke that Metroid's Samus Aran is married to Halo's John 117, (Master Chief) but if you had to choose a husband for Samus, who would it be? Rules: 1.) It cannot be You (sorry, guys...) 2.) It can't be

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

Welcome to teh Silly board!

WELCOME, LIVE LONG, AND TIDDLYWINKS Following the trend of "welcome" boards, I welcome all of you to the Silly board, the main hideaway of the Beecat. Everyone is welcomed to kick off your shoes and grab a pint of whiskey an' gin and let th