Great script! Quick question: I noticed
Great script!
Quick question: I noticed that you used SQL queries to partition the data by dates in the SSASPartitions table and cubes (e.g. PartitionFieldName between MinDateKey and MaxDateKey). Would using physical tables that are partitioned by dates process faster? E.g. FactSales_2001 or FactSales_200201, etc.
TIA,
Bruce.