I have dim tables, fact tables, ETLs and cube, I am now looking to make sure my cube only Is it worth the data of the last 2 months, should it be done by forcing my fact table to keep only 2 months of data and forcing "complete process", or is there any way to trint older data from my cube?
Your data is pre-dimensional through ETL and you have a cube built on it ?
And you want to retain the data in the fact table, but for the last two months it is not necessary in the cube?
If you do not want to retain the data, then I will just clean up the fact sheet till date. Because you probably want to get back to that place.
But there are also settings in the cube build - or create your cube with dynamic ideas that display in the last two months - then the cube (again -) build even before the underlying fact table. can be done.
You can also see the segment by date:
Comments
Post a Comment