Be Careful Partitioning Analysis Services (Tabular)
There are generally three reasons for partitioning an Analysis Services model:
- To improve processing time by running partitioning in parallel
- To improve processing time by allowing for incremental processing of some sort
- To improve query time where most queries only need a smaller slice of data - say a week or month. /ol> Read more...