使用SSIS增量处理Azure Analysis Services多维数据集 [英] Processing Azure Analysis services cube incrementally using SSIS

问题描述

我们有一个带有Azure Analysis Services处理任务的SSIS程序包，该任务从Azure数据工厂调用以处理多维数据集.目前，SSIS中的任务没有用于增量执行多维数据集处理的选项，并且我们已安排了完全刷新 这很费时间.是否有任何其他方法可用于从SSIS或使用任何其他工具对AAS多维数据集进行增量处理，然后再对多维数据集进行分区.当前，我们可以通过datetime列来区分每天加载的事实数据.请 建议.谢谢.

We have a SSIS package with Azure Analysis services Processing task which is called from Azure Data factory to process the cube. Currently the task in SSIS doesnt have an option for incrementally do the cube processing and We have full refresh scheduled which is time consuming. Is there any alternative available to process the AAS cube incrementally from SSIS or using any other tool, other then partitioning the cube. Currently we can differentiate the fact data loaded everyday by a datetime column. Please suggest. Thanks.

推荐答案

您可以参考此

You may refer this blog post and see if it helps.

这篇关于使用SSIS增量处理Azure Analysis Services多维数据集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！