SSAS

How to partition data in Tabular SSAS

  • Article

Partitioning data is a standard SQL Server administration practice. Partitions enable independent administration of different slices of data. When a SQL Server Analysis Services (SSAS) tabular data model is developed and processed, data is read from the source system and loaded into the tabular data model configured in In-Memory processing mode. Every time the model is processed, the entire data set may not require re-processing. Only certain slices of data containing changes may require re-processing which can be achieved by partitioning data into logical slices. In this post, Siddharth Mehta looks at how to partition tables in Tabular SSAS.

2017-06-08

2,832 reads

Blogs

Database Fundamentals #24: Filtering Data

By

If you’ve been reading these Database Fundamentals posts, you’ve already seen the WHERE clause...

#PowershellBasics: The Windows Powershell icon in the task bar also lets you run Powershell ISE.

By

I don’t know about you, but I like having the tools that I’m likely...

Launching SQL Compare with Context

By

Years ago Redgate Software started some work to link our tools together. I remember...

Read the latest Blogs

Forums

insert into permanent table using cte

By samirca007

Good morning all I would like to add the result of a multiple query...

Datetime data migration.

By Arjun

Hi All, We are loading data from one of our source table in that...

2012 - 17 Performance Issue

By Matthew24

  Good afternoon everyone, This may sound familiar, but we are yet to find...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Another Typo

See possible answers