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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Analyzing an Accumulating Snapshot
Thanks for your reply, johnherman. Do you mean that I should join 4 times to the date dimension without using a separate view/synonym/alias for each one? Is that even possible? Currently I'm joining to 4 views of the date dimension. The problem is that then the BI tool sees it as 4 different...- Poster600
- Post #3
- Forum: Data Warehousing/Big Data
-
Analyzing an Accumulating Snapshot
I'm having some trouble figuring out how to do certain types of analysis on my Accumulating Snapshot fact table (using a BI tool, for example). Let's say I have a classic "Order Pipeline" fact table and it includes, say, Order Submitted Date, Order Received Date, Items Prepared For Shipping...- Poster600
- Thread
- Replies: 3
- Forum: Data Warehousing/Big Data
