DATE OR DATE KEYS IN FACT TABLES
I've read different opinions about the usage of dates in fact tables. If a date is NEVER used to filter and only reported, what is the purpose of adding it as a date key instead of a plain date type? Aren't we wasting the resources to get to the date

SET2/Q.1 a. Analyse the role of in-house researcher in marketing research.
Q.1 a. Analyse the role of in-house researcher in marketing research. [3 marks] b. Discuss the purpose of research report with its important characteristics and functions. [7 marks]

SET1/Q.2 a. Outline the role of different types of retailers.
Q.2 a. Outline the role of different types of retailers. (8 marks) b. What is sales forecasting? (2 marks)

Inventory Snapshot - GMROI Calculation
We are developing a solution for our company. We currently have a sales cube and we are in the process of building an inventory cube. We are having a design problem in that we are not sure if we should include some of the measures which currently exist in

Band Camp is gonna start charging
Popular DIY music site, Bandcamp.com, has announced that it will soon begin charging a percentage of sales to artists who sell music through the service. They explained: In the past six months, you guys have used Bandcamp to sell over $1 million USD

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

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

Multiple facts in a fact table
One proposed model for our business (wholesale/retail) sales fact is to have every register ring in one fact. This causes refunds, voids, coupons and other 'facts' to be stored in a single fact entity. There is a column type dimension that then tells us

Trailer url's won't play in XBMC because they don't start with "http://"
I noticed recently that some of my trailers weren't playing. I checked the nfo's that media companion had made and there were url's, but the ones that wouldn't play didn't start with "http://" Here's an example of a nfo scraped with Media

Perfect Dates
As the title says, how would you describe a perfect date... with or without the nasty

US & Canada Tour Dates!!
Taken from the official Elbow facebook page: Quote:It's the news you've all been waiting for - Elbow have just confirmed a string of dates across the U.S.A. and Canada. This autumn the band will be playing shows in Atlanta, Washington, New York,

Null value for dates
All of my dimension tables have a value -1 that means there was no match to then dimension table. I try to put in some value such as "Unknown" or "Not available". Any suggestions for the -1 row in a Date dimension? Should I use some future date suc

Pulp Live dates
For the first time in 15 years, the classic Pulp lineup will re-form to play shows including London's Wireless festival and Spain's Primavera Sound. From the Guardian I would be so up for this. If it is anything like last year's Blur reunion gigs,

Preserving prior history for late arriving dimensions
Can't find much about this topic anywhere else so hopefully someone can help me. Our warehouse has late arriving dimensions for an Employee. Their department changes, for example, can be backdated in the systems and so we have to account for this and

how many dimensions is too many
If I have a fact table with too many dimensions --- over 30, does that mean I've created dimensions when they could have been attributes to another dimension table or possibly that I am trying to capture too many business processes within one fact table.