October 23, 2025 at 2:07 pm
Hi. I hope someone can give some useful suggestions.
My workplace have a suite of SSAS tabular models. They used to be created in compatibility level 1103. We then used a free piece of software with them called Partition Manager (which was a free download from Codeplex, to show it's age!) to dynamically generate partitions at the start of a new month. Our cubes were partitioned by each month of the year. Partition Manager could also be controlled to process only a few partitions, by maintaining tables in it's own SQL Server database.
The tabular models have now been rewritten in compatibility level 1200, to allow us to process in parallel and generally give us a better build time performance. However, as we don't know of an equivalent to Partition Manager, i.e. a method to automatically generate partitions, we have created them as rolling window models, to match the time span of our data warehouse.
If we were to change our tabular models again to have incremental time partitions (i.e. not a rolling window) that are generated automatically, what methods exist for us to do this in compatibility level 1200 onwards? Are there scripts or software products to do this? Or anything else?
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply