Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Analyzing WIP through OLAP
Thanks Hans, I guess I can create a new fact table from a view with something like this : SELECT T0.ID, T1.FullDateAlternateKey FROM (SELECT * FROM DimTime WHERE DayNumberOfMonth = 1) T1 LEFT JOIN FactItems T0 ON T0.StartDate <= T1.FullDateAlternateKey AND T1.FullDateAlternateKey <=...- donbuz
- Post #3
- Forum: Data Warehousing/Big Data
-
Analyzing WIP through OLAP
Good Day everyone, I have an "item Fact table" that is comprised of two dates fields (pointing to a Time dimension table) StartDate and EndDate. I also have several other dimensions that I basically use to answer trivial questions such as "How many items were 'started' 'per customer 'per...- donbuz
- Thread
- Replies: 2
- Forum: Data Warehousing/Big Data
