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.
Translating reports with Analysis Services 2012 and MS-Excel 2013 in a multilingual environment
This tip looks at some of the questions around attribute relationships in SQL Server Analysis Services, including why you need them, how to create them, and the common data sets involved.