SQL 多维数据集处理窗口
我有 Dim Tables、Fact Tables、ETL 和一个立方体。 我现在希望确保我的多维数据集仅保存前 2 个月的数据。 是否应该通过强制我的事实表仅保存 2 个月的数据并执行“完整过程”来完成此操作，或者是否有办法从我的多维数据集中删除过时的数据？
I've got Dim Tables, Fact Tables, ETL and a cube. I'm now looking to make sure my cube only holds the previous 2 months worth of data. Should this be done by forcing my fact table to hold only 2 months of data and doing a "full process", or is there a way to trim outdated data from my cube?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您的数据已经通过 ETL 进行了维度化，并且您在其之上构建了一个多维数据集？
您希望保留事实表中的数据，但不一定需要多维数据集中过去 2 个月以上的数据？
如果您甚至不想保留数据，我只需按日期清除事实表即可。 因为无论如何您可能都希望回收该空间。
但多维数据集构建中也有一些设置 - 或者根据仅公开最近两个月的动态视图构建多维数据集 - 然后可以在清除基础事实表之前完成多维数据集（重新）构建。
您还可以查看按日期分区：
http://www.mssqltips.com/tip .asp?tip=1549
http:// www.sqlmag.com/Articles/ArticleID/100645/100645.html?Ad=1
Your data is already dimensionalized through ETL and you have a cube built on top of it?
And you want to retain the data in the Fact table, but not necessarily need it in the cube for more than the last 2 months?
If you don't even want to retain the data, I would simply purge the fact table by date. Because you're probably going to want that space reclaimed anyway.
But there are also settings in the cube build - or build your cube off dynamic views that only expose the last two months - then the cube (re-)build can be done before you've even purged the underlying fact tables.
You can also look into partitioning by date:
http://www.mssqltips.com/tip.asp?tip=1549
http://www.sqlmag.com/Articles/ArticleID/100645/100645.html?Ad=1