Report Portal

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.

 

2007-2015 VidasSoft Systems Inc.