How do I change my DW Retention to 7 years?

Raul_Noa

Currently fact tables are set to 3 years by default. I am being asked to set the retention period for everything to a minimum of 7 years. How would I go about this?

Conner_Wood

@Raul_Noa I got your back son!  It is truly horrendous how much goes wrong if you don't make the retention last, cubes get corrupted (if you don't perfect the SSAS Cubes) when data is no longer there among other things like reporting becoming inaccurate and unreliable!

Part Un:  SCSM Data Warehouse: Fact Groom Retention - Prevent Relationships Getting Marked As Deleted
Part Duex:  SCSM Data Warehouse: Fact Groom Retention - Recover Tickets Latest Relationships Marked Deleted

You may be wondering why I used French..... cause you're in for a hell of a time and Le Français est la langue du diable!!!

ಊ(╰・‿^╯)Ψ

Michael_Aidinovich

Hello Raul,

I haven't made that change before, however there is a blog post describing that procedure.  https://blogs.technet.microsoft.com/thomase/2014/08/21/change-the-data-warehouse-retention-period/

Again I haven't tried this, so do test in your dev/test env first.

Hope that helps.
Mike 

Conner_Wood

@Raul_Noa I got your back son!  It is truly horrendous how much goes wrong if you don't make the retention last, cubes get corrupted (if you don't perfect the SSAS Cubes) when data is no longer there among other things like reporting becoming inaccurate and unreliable!

Part Un:  SCSM Data Warehouse: Fact Groom Retention - Prevent Relationships Getting Marked As Deleted
Part Duex:  SCSM Data Warehouse: Fact Groom Retention - Recover Tickets Latest Relationships Marked Deleted

You may be wondering why I used French..... cause you're in for a hell of a time and Le Français est la langue du diable!!!

ಊ(╰・‿^╯)Ψ