Report Portal

SSIS: Dynamic Processing of SSAS Partitions

SSAS Partitions are primarily geared towards better query performance by narrowing the MDX query to a pre-defined subset of data. Each partition must be in processed state for the cube to be available for browsing. However in a delta ETL run, it is more than likely that only some partitions would be refreshed with data while the rest remain unchanged.

Read more...

Tags: partition, amo, process, ssis, xmla, script

 

2007-2015 VidasSoft Systems Inc.