"Perfect" design vs. Time to Implement
How difficult would it be to implement a new dimension on an existing fact table? I have a situation where the time I have to launch a business process is shorter than the time I need to get a new dimension designed and pushed. I'm thinking about

Overlapping Dates in a dimension
Hi, I am wondering if someone could advise me on how to deal with this design problem. I have a promotion dimension keyed to a sales fact table. Initially, we thought that only one promotion could be active at one time for a sale, but it is actually th

Current and Historic Dimensions (one table or two?)
Hello all, I have a situation where I have modeled an Item Dimension as per business requirements to be SCD type 2. It is a conformed dimension. Our first business process dimensional model is customer grocery sales. The grain is one fact line

Dimensional model
Hey All In a Star schema, can a Fact table in one data mart be a Dimensional table in another data mart or can we connect two fact tables or what can we do if we need to connect a column (primary key) from one fact table to another fact table? Thank

If you haven't noticed, I've been playing a lot of Indie games recently.
I love them! With games like Cave Story, Spelunky, VVVVVV, Audiosurf, World of Goo, Eversion, and Minecraft, I'm learning that some of the best things in life are not made or enjoyed with a butt-ton of money. All these games I've listed, you should try

Installed every rom.
I spend 4 hours flashing every rom for my epad. All these roms and either the screen wouldn't work or the wifi was unable to start. I am at a loss anyone have any suggestions?

Insert <actor> and as role (show) as keyword IPTCs into actor images
Hi Being playing with image and face recognition in picasa, and so thought it'd be interesting to "face match' the images that are downloaded. Then I thought this could be extended to displaying within MC... So first off I parsed (hackily) the

TIMELINE:The past and present of China's yuan
09.04.2010 10:55 TIMELINE:The past and present of China's yuan BEIJING, April 9 (Reuters) - Chinese President Hu Jintao will probably talk about the yuan with U.S. President Barack Obama when he visits Washington for nuclear talks on April

rollup fact table
If creating a roll up fact table would you consider using something other than the surrogate key for your date dimension join? I would not but my colleagues think we should be using month_id for example if we are creating a monthly roll up table from a

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

2001 Reading Festival set
Up now on iplayer: http://www.bbc.co.uk/iplayer/episode/b00z2ppv/The_Live_Music_Hour_Elbow_Women_and_The_State_Broadcasters/

Application Sugestion - epNamer
He guys Media Companion rules!!! Though how could it rule more??!!! With a episode renamer for TV collections.... . . Wana take some of teh pressure off the Dev Gods? Stop hassling them to add a feature ot MC.. just try out this app....

Migraines & Dreams
Okay this may seem very strange to some, but I have always experienced some very intense dreams from time to time. They can be traumatic or joyful, fast moving or peaceful, either way they are very deep and memorable. We're talking Alice in Wonderland

trailer problem
Hi, First of all, great piece of software! Now to my problem. I've checked the "Include IMDB Movie Trailer url within the nfo file" option but when I do a scrape and create nfo's for my movies there never exists a trailer link. I see

Start Learning CSS
Start Learning CSS CSS tutorial for absolute beginners Hello Everyone This tutorial is for absolute beginners who want to start off learning CSS. Please note that it is required to have basic knowledge of HTML before you start learning CSS. If you