May 26, 2015 at 9:04 pm
I have created a fact table carrying the total number of members in each membership class. When I look at the data its adding the numbers together but I want to see more of the addition/subtraction day to day YoY. Stuff like that but since the numbers are totaled before putting in dw is that possible? It's the only way I have to work with the data going back 5 years?
Any input is appreciated
May 26, 2015 at 9:12 pm
Do you have a copy of the datawarehouse toolkit? You likely want to investigate the accumulating snapshot fact table.
Steve.
May 26, 2015 at 9:19 pm
Where do I get that at? The tool kit?
May 26, 2015 at 10:03 pm
Amazon usually stocks it. http://www.amazon.com/The-Data-Warehouse-Toolkit-Dimensional/dp/0471200247%5B/url%5D
Steve.
May 27, 2015 at 3:40 pm
Awesome, thanks.:-D Much appreciated
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply