Hello,
I'm new to Data Warehousing. I'm building an BI application and I'm having some problems. My fact table has records with no specific date but with date from date to period.
Let's say I have customers that come on a date and leave on another day
My fact table has records like this:
Customer DateFrom DateTo
1 01/01/2009 31/03/2009
2 01/02/2009 30/04/2009
I cannot connect these records with a Time Dimension.
So when I want to browse how many customers I have for each month, or week, I just cannot do it.
Worse, I could also have customer categories to browse.
What would be the solution to such a problem?
What would be the best solution?
Perhaps I could create another table with sum of customers per day?
Is this a correct way to solve such a problem.
Thanks, ilias K.
I'm new to Data Warehousing. I'm building an BI application and I'm having some problems. My fact table has records with no specific date but with date from date to period.
Let's say I have customers that come on a date and leave on another day
My fact table has records like this:
Customer DateFrom DateTo
1 01/01/2009 31/03/2009
2 01/02/2009 30/04/2009
I cannot connect these records with a Time Dimension.
So when I want to browse how many customers I have for each month, or week, I just cannot do it.
Worse, I could also have customer categories to browse.
What would be the solution to such a problem?
What would be the best solution?
Perhaps I could create another table with sum of customers per day?
Is this a correct way to solve such a problem.
Thanks, ilias K.