Forum Discussion
Partially ignore dataset refresh
Hello I I'm looking for some advice,
I have a regular report with some fact and dimension tables which refreshes a couple of times a day.
Currently if for instance a brand of a product changes, it changes this for the entire dataset. So for all dates included in the report.
It acts retroactively.
Customer request that once a month has passed, no retroactivity is allowed. So the data has to look 100% the same as 10 years from now. I'm pretty clueless how to solve this. For some fact tables it is perhapse possible because of the presence of a [Date] field. Except non of the dimension tables have a [Date] field in the source.
Is there some way this can be achieved?
At the moment I'm just thinking about manually copying all tables and UNION them, together with a [Date] field. But this is far from ideal.
There are many different approaches to this, but the term you are looking for is "slowly changing dimensions". Have a read up on it and see which approach best suits your needs.
